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

[Waldirio Manhães Pinheiro]

Pierre good morning

I'm just in cel but take a look in the flags of this command. Can you force
the server name ?

Try it and tell me.

B'regards
Waldirio
Em 26/11/2014 05:04, "Pierre Casenove" <pcasenove at gmail.com> escreveu:

> 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
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20141126/e3a20c54/attachment.htm>