# Problem adding channels

**URL:** https://forums.suse.com/t/problem-adding-channels/24165
**Category:** SUSE Multi Linux Manager
**Created:** [July 17, 2013, 4:32am UTC](https://forums.suse.com/t/problem-adding-channels/24165 "2013-07-17T04:32:33Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![sysengPS](https://avatars.discourse-cdn.com/v4/letter/s/f475e1/32.png) [@sysengPS](https://forums.suse.com/u/sysengPS)
#### Post date: [July 17, 2013, 4:32am UTC](https://forums.suse.com/t/problem-adding-channels/24165/1 "2013-07-17T04:32:33Z")

</div>

I’ve had an interesting time getting Suse Manager configured:  
Was having troubles registering Suse Manager with NCC through yast. It would say contacting server for a minute, then go back to the main yast screen. I finally had to run suse\_register -i and complete the process interactively. Once that was done, I could do a zypper up.  
Now I’m attempting to add channels to suse manager. I run mgr-ncc-sync -l and get back

[CODE]  
Listing channels …

Status:

- P - channel is installed (provided)
- . - channel is not installed, but is available
- X - channel is not available

[.] sles11-sp1-vmware-pool-i586  
[.] sles11-sp1-vmware-pool-x86\_64  
[.] sles11-sp3-vmware-pool-i586  
[.] sles11-sp3-vmware-pool-x86\_64[/CODE]

I figure I should get more of those, but anyways, when I run mgr-ncc-sync -c sles11-sp1-vmware-pool-x86\_64, I get:

`Traceback (most recent call last):
  File "/usr/sbin/mgr-ncc-sync", line 231, in <module>
    main()
  File "/usr/sbin/mgr-ncc-sync", line 99, in main
    syncer.add_channel(options.channel)
  File "/usr/lib64/python2.6/site-packages/spacewalk/susemanager/mgr_ncc_sync_lib.py", line 1579, in add_channel
    self.map_channel_to_products(channel, channel_id, product_id)
  File "/usr/lib64/python2.6/site-packages/spacewalk/susemanager/mgr_ncc_sync_lib.py", line 947, in map_channel_to_products
    channel_label=channel_label)
  File "/usr/lib64/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 156, in execute
    return self._execute_wrapper(self._execute, *p, **kw)
  File "/usr/lib64/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 287, in _execute_wrapper
    retval = function(*p, **kw)
  File "/usr/lib64/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 211, in _execute
    return self._execute_(args, kwargs)
  File "/usr/lib64/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 301, in _execute_
    self._real_cursor.execute(self.sql, params)
psycopg2.ProgrammingError: column "channel_label" does not exist
LINE 5: AND channel_label = E'sles11-sp1-vmware-p...`  
So… should I be getting additional channels when running a list command. And how do I get past this psycopg2 error?

Thanks much!

---

<div class="post-metadata">

### Author: ![kwk](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/kwk/32/11997_2.png) [@kwk](https://forums.suse.com/u/kwk)
#### Post date: [July 17, 2013, 9:38am UTC](https://forums.suse.com/t/problem-adding-channels/24165/2 "2013-07-17T09:38:59Z")

</div>

Is your SUSE Manager server fully patched, _including_ all database schema upgrades ? It seems as if the mgr-ncc-sync tool expects a different database schema.

---

<div class="post-metadata">

### Author: ![sysengPS](https://avatars.discourse-cdn.com/v4/letter/s/f475e1/32.png) [@sysengPS](https://forums.suse.com/u/sysengPS)
#### Post date: [July 17, 2013, 2:57pm UTC](https://forums.suse.com/t/problem-adding-channels/24165/3 "2013-07-17T14:57:44Z")

</div>

After posting my original message, I ran a schema upgrade, per the login window on suse manager, then ran mgr-ncc-sync -l, and saw the same channels listed. How can I tell if the server is fully patched?

Thanks for the reply.

edit: I added my sles11-sp1-vmware-pool-x86\_64 channel successfully this time. Thanks very much. Should I be seeing more channels to add?

---

<div class="post-metadata">

### Author: ![sysengPS](https://avatars.discourse-cdn.com/v4/letter/s/f475e1/32.png) [@sysengPS](https://forums.suse.com/u/sysengPS)
#### Post date: [July 17, 2013, 4:22pm UTC](https://forums.suse.com/t/problem-adding-channels/24165/4 "2013-07-17T16:22:47Z")

</div>

ok, so I was able to add a bunch of channels. Apparently, I needed to update my schema for all this to work. Thanks again for the post.
