[Spacewalk-list] SP 2.2 & rhn-channel command issue

[Wood, Brendan]

Hey list,

When running rhn-channel to subscribe systems to channels, I am getting an internal server error.

At the client:

[root at rhel6test2 svcMymcywsDev]# rhn-channel -L -u admin -p xxx
jbappplatform-6-x86_64-server-6-rpm
rhel-x86_64-rhev-mgmt-agent-6
rhel-x86_64-rhev-mgmt-agent-6-beta
rhel-x86_64-server-6-rhevh
rhel-x86_64-server-6-rhevh-beta
rhel-x86_64-server-6-rhevm-3-beta
rhel-x86_64-server-6-rhevm-3.1
rhel6-3rdparty
rhel6-emergency
rhel6-epel

[root at rhel6test2 svcMymcywsDev]# rhn-channel -a -c rhel6-epel -u admin -p xxx
Error communicating with server. The message was:
Internal Server Error

In my rhn_server_xmlrpc.log:

2014/10/14 14:48:03 -05:00 10367 10.10.246.124: xmlrpc/up2date.subscribeChannels(1000010510, ['rhel6-epel'])
2014/10/14 14:48:04 -05:00 10367 10.10.246.124: 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 0x7f49410c69f0; dsn: 'password=xxxxxxxx dbname=spacewalkdb user=spacewalker', 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'))

(subscribing clients to channels via the spacewalk web UI works fine)

Anyone else seeing this?

Thanks!
-brendan
This electronic mail and any attached documents are intended solely for the named addressee(s) and contain confidential information. If you are not an addressee, or responsible for delivering this email to an addressee, you have received this email in error and are notified that reading, copying, or disclosing this email is prohibited. If you received this email in error, immediately reply to the sender and delete the message completely from your computer system.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20141014/dbe56d8b/attachment.htm>