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

[Tomas Lestach]

Hello Brendan,

I suspect you're hitting https://bugzilla.redhat.com/show_bug.cgi?id=1122438

I recommend to apply following patch:
https://github.com/spacewalkproject/spacewalk/commit/4bf063f97ae66d889236e11ea237dfd785dbce29
(to /usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py)

It should be safe.

Regards,
--
Tomas Lestach
Red Hat Satellite Engineering, Red Hat


----- Original Message -----
> From: "Brendan Wood" <Brendan.Wood at Mercy.Net>
> To: spacewalk-list at redhat.com
> Sent: Tuesday, October 14, 2014 10:27:00 PM
> Subject: [Spacewalk-list] SP 2.2 & rhn-channel command issue
> 
> 
> 
> 
> 
> 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.
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list