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

[Michael Mraka]

Fabiano Martins wrote:
% 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 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
...
% 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?

It's a bug https://bugzilla.redhat.com/show_bug.cgi?id=1122438.
Already fixed in nightly, you can safely patch your Spacewalk 2.2 with
https://github.com/spacewalkproject/spacewalk/commit/4bf063f97ae66d889236e11ea237dfd785dbce29
to fix it.
 

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat