[Spacewalk-list] [SPW 2.2] ISE when using spacewalk-channel

[Pierre Casenove]

Hello,
I have a spacewalk server version 2.2, using pgsql 8.4 on rhel 6.
When I try to add a child channel to a recently registered system using
spacewalk-channel command, it fails with the following error message:
spacewalk-client $ spacewalk-channel -c dell-pfind-el6-x64 -a
Username:
Password:
Error communicating with server. The message was:
Internal Server Error

Here is the traceback I receive:

SQLStatementPrepareError: ('ERROR:  syntax error at or near
"rhnServerChannel"\nLINE 4:        join rhnServerChannel sc on
c.parent_channel = sc.cha...\n                    ^\n', <connection object
at 0x7f0b0b73b9f0; dsn: 'password=xxxxxxxxxxx dbname=spaceschema
user=spaceuser', 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')



Local variables by frame

Frame _execute_wrapper in
/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py
at line 294

                            function = <type 'instancemethod'> <bound
method Cursor._execute of <spacewalk.server.rhnSQL.driver_postgresql.Cursor
instance at 0x7f0b0c1003f8>>

                                   e = <class 'psycopg2.ProgrammingError'>
syntax error at or near "rhnServerChannel"

LINE 4:        join rhnServerChannel sc on c.parent_channel = sc.cha...



On the client, I have the latest rhn-setup package:

$ rpm -qf /usr/sbin/spacewalk-channel

rhn-setup-2.2.7-1.el6.noarch


Is this a known issue?

Pierre
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20141126/c36ad153/attachment.htm>