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
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
