Created attachment 924219 [details]
Sample code that reproduces the problem

Description of problem:
The subscribeChannels() function does not work. This occurs in spacewalk-channel program, and calling also the function directly.

Version-Release number of selected component (if applicable):
- client: rhn-client-tools-2.2.7-1.el6.noarch
- server: spacewalk-backend-xmlrpc-2.2.43-1.el6.noarch

How reproducible:
Always

Steps to Reproduce:
Call "spacewalk-channel -a -c <CHANNEL> -u <USER>", or made a Python program that call subscribeChannels() funcion.
I attached a sample code that reproduces the problem: fill TEST_CHANNEL, TEST_USER and TEST_PASSWORD variables in it.
===========================================================
On my environment, the output of sample code is:
[root@centos6 fabiano]# python test.py 
---------- channel_list()
centos6-x86_64
centos6-x86_64-extras
centos6-x86_64-updates
epel6-centos6-x86_64
spacewalk22-client-centos6-x86_64
---------- channel_del()
vou chamar unsubscribeChannels("['epel6-centos6-x86_64']", "admin", "m1pnmq2ns")
Channel(s): epel6-centos6-x86_64 successfully removed
---------- channel_list()
centos6-x86_64
centos6-x86_64-extras
centos6-x86_64-updates
epel6-centos6-x86_64
spacewalk22-client-centos6-x86_64
---------- channel_add()
Traceback (most recent call last):
  File "test.py", line 65, in <module>
    channel_add(TEST_CHANNEL, TEST_USER, TEST_PASSWORD)
  File "test.py", line 34, in channel_add
    result = subscribeChannels(channels, user, password)
  File "/usr/share/rhn/up2date_client/rhnChannel.py", line 129, in subscribeChannels
    passwd)
  File "/usr/share/rhn/up2date_client/rhnserver.py", line 63, in __call__
    return rpcServer.doCall(method, *args, **kwargs)
  File "/usr/share/rhn/up2date_client/rpcServer.py", line 203, in doCall
    ret = method(*args, **kwargs)
  File "/usr/lib64/python2.6/xmlrpclib.py", line 1199, in __call__
    return self.__send(self.__name, args)
  File "/usr/share/rhn/up2date_client/rpcServer.py", line 37, in _request1
    ret = self._request(methodname, params)
  File "/usr/lib/python2.6/site-packages/rhn/rpclib.py", line 384, in _request
    self._handler, request, verbose=self._verbose)
  File "/usr/lib/python2.6/site-packages/rhn/transports.py", line 170, in request
    headers, fd = req.send_http(host, handler)
  File "/usr/lib/python2.6/site-packages/rhn/transports.py", line 729, in send_http
    response.status, response.reason, response.msg)
up2date_client.up2dateErrors.CommunicationError: Erro ao comunicar com o servidor. A mensagem foi:
Internal Server Error
===========================================================
Looking at /var/log/rhn/rhn_server_xmlrpc.log on server, the output is:
2014/08/05 10:28:51 -02:00 20803 10.4.251.49: xmlrpc/up2date.listChannels(1000010008,)
2014/08/05 10:28:52 -02:00 20805 10.4.251.49: xmlrpc/up2date.unsubscribeChannels(1000010008, ['epel6-centos6-x86_64'])
2014/08/05 10:28:52 -02:00 10029 10.4.251.49: xmlrpc/up2date.subscribeChannels(1000010008, ['epel6-centos6-x86_64'])
2014/08/05 10:28:52 -02:00 10029 10.4.251.49: 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 0x7f5939b119f0; 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'))
===========================================================

Actual results:
Exception when I try add a valid channel.

Expected results:
Success on add the channel.


Additional info:
Making the same action on Web UI works fine.