<div dir="ltr">Yes, I found that and did the update on my server. Thank you for responding!</div><div class="gmail_extra"> <div class="gmail_quote">On Tue, Aug 26, 2014 at 8:34 AM, Dimitar Yordanov <<a href="mailto:dyordano@redhat.com" target="_blank">dyordano@redhat.com</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Mark, This issue was addressed in SW-nightly via bug report 1122438 - Syntax Error in SQL-Statement "subscribe_sql" in "rhnChannel.py" <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1122438" target="_blank">https://bugzilla.redhat.com/show_bug.cgi?id=1122438</a> Dimi <div><div class="h5"> ----- Original Message ----- > From: "Mark Manley" <<a href="mailto:mwmanley@gmail.com">mwmanley@gmail.com</a>> > To: <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> > Sent: Tuesday, August 19, 2014 12:20:37 AM > Subject: [Spacewalk-list] rhn-channel command bombs on servers when adding child channels > > Howdy, > > I'm running Spacewalk client/server 2.2 on CentOS 6.4 and seeing these SQL > errors when trying to run the rhn-channel command on clients to add child > channels via a proxy. I'm redacting most of the traceback emails since it > emails quite a bit of information, including passwords. Is this a known bug? > I have no problems adding child channels via the Spacewalk server's web > interface or via the spacecmd command, and I used to do this quite a bit > with the 1.x versions of Spacewalk. > > I see this running: > > rhn-channel -a -c <CHILD CHANNEL LABEL> -u <USER> -p <PASSWORD> > > Removing child channels works great. > > Thanks! > > -MM > > ###### > > Extra information about this error: > SQL Error generated: ('ERROR: syntax error at or near > "rhnServerChannel"\nLINE 4: join rhnServerChannel sc on > c.parent_channel = sc.cha...\n ^\n', <connection object > at 0x7fb57452bad0; dsn: 'port=5432 > host=spacewalk\-db01\.prd\.nj1\.tapad\.com password=xxxxxxxxxxxxxxxxxxxxxxxx > 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') > > Exception Handler Information > Traceback (most recent call last): > File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py", > line 122, in call_function > response = func(*params) > File "/usr/share/rhn/server/handlers/xmlrpc/up2date.py", line 171, in > subscribeChannels > username, passwd) > File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py", > line 1756, in subscribe_channel > h.execute(sid=server_id, channel=str(channel)) > File > "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", > line 147, in execute > return self._execute_wrapper(self._execute, *p, **kw) > File > "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", > line 294, in _execute_wrapper > raise sql_base.SQLStatementPrepareError(self.dbh, e.pgerror, self.sql) > SQLStatementPrepareError: ('ERROR: syntax error at or near > "rhnServerChannel"\nLINE 4: join rhnServerChannel sc on > c.parent_channel = sc.cha...\n ^\n', <connection object > at 0x7fb57452bad0; dsn: 'port=5432 > host=spacewalk\-db01\.prd\.nj1\.tapad\.com password=xxxxxxxxxxxxxxxxxxxxxxxx > 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 0x7fb574d6be60>> > e = <class 'psycopg2.ProgrammingError'> syntax error at > or near "rhnServerChannel" > LINE 4: join rhnServerChannel sc on c.parent_channel = sc.cha... > ^ > > </div></div>> _______________________________________________ > Spacewalk-list mailing list > <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> > <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> -- Dimitar Yordanov System Management Quality Engineer Red Hat Satellite | Spacewalk </blockquote></div> </div>