[Spacewalk-list] spacewalk-channel don't add channels

[Fabiano Martins]

Hi all,

I've been away from the Spacewalk in the last two years, but now I changed
of employer and return to use it.

I installed the last Spacewalk version (2.2) on CentOS 6.5, but I have a
problem subscribing channels with spacewalk-channel.

The following steps reproduces the problem (I run it on my Spacewalk
server):

# Step 1 : list the current subscribed channels (success)
[root at spacewalk registra_servidor]# spacewalk-channel -v -l
centos6-x86_64
centos6-x86_64-extras
centos6-x86_64-updates
epel6-centos6-x86_64
spacewalk22-client-centos6-x86_64
spacewalk22-server-centos6-x86_64
vmwaretools55-centos6-x86_64

# Step 2 : unsubscribe 'epel6-centos6-x86_64' channel (success)
[root at spacewalk ~]# spacewalk-channel -v -u admin -p ***** -c
epel6-centos6-x86_64 -r
Channel(s): epel6-centos6-x86_64 successfully removed

# Step 3 : list the current subscribed channels (success:
epel6-centos6-x86_64 no more exists)
[root at spacewalk ~]# spacewalk-channel -v -l
centos6-x86_64
centos6-x86_64-extras
centos6-x86_64-updates
spacewalk22-client-centos6-x86_64
spacewalk22-server-centos6-x86_64
vmwaretools55-centos6-x86_64

# Step 4 : (re)subscribe 'epel6-centos6-x86_64' channel (FAIL)
[root at spacewalk ~]# spacewalk-channel -v -u admin -p ***** -c
epel6-centos6-x86_64 -a
Error communicating with server. The message was:
Internal Server Error

# Step 5 : list the current subscribed channels (expected:
epel6-centos6-x86_64 remains out)
[root at spacewalk ~]# spacewalk-channel -v -l
centos6-x86_64
centos6-x86_64-extras
centos6-x86_64-updates
spacewalk22-client-centos6-x86_64
spacewalk22-server-centos6-x86_64
vmwaretools55-centos6-x86_64

# Step 6 : via Web interface, (re)subscribe 'epel6-centos6-x86_64' channel
(success)

# Step 7 : list the current subscribed channels (success:
epel6-centos6-x86_64 returned)
[root at spacewalk ~]# spacewalk-channel -v -l
centos6-x86_64
centos6-x86_64-extras
centos6-x86_64-updates
epel6-centos6-x86_64
spacewalk22-client-centos6-x86_64
spacewalk22-server-centos6-x86_64
vmwaretools55-centos6-x86_64

Finally, when I executed step 4 above, /var/log/rhn/rhn_server_xmlrpc.log
shows it:
2014/08/04 15:12:23 -02:00 4645 10.4.20.36:
xmlrpc/up2date.subscribeChannels(1000010005, ['epel6-centos6-x86_64'])
2014/08/04 15:12:23 -02:00 4645 10.4.20.36:
server/apacheRequest.call_function('ERROR', 'rhnSQL.SQLError caught',
SQLStatementPrepareError('ERROR:  syntax error at or near
"rhnServerChannel"\nLINE 4:        join rhnServerChannel sc on
c.parent_channel = sc.cha...\n                    ^\n', <connection object
at 0x7fdf490d79f0; dsn: 'password=xxxxx dbname=rhnschema user=rhnuser',
closed: 0>, '\nselect 1\n  from rhnChannel c,\n       join rhnServerChannel
sc on c.parent_channel = sc.channel_id\n  where sc.server_id = %(sid)s\n
and c.label = %(channel)s\n'))

To sum up...
- remove works fine via command line, but add don't
- remove and add works fine via web interface

It's a bug or a problem with my environment?

Thanks,
Fabiano Martins
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140804/aec5803c/attachment.htm>