[Spacewalk-list] spacewalk-utils-1.6.1-1 - PostgreSQL #fail

[Jan Pazdziora]

On Fri, Jul 22, 2011 at 09:18:56AM +0200, Jan Pazdziora wrote:
> On Thu, Jul 21, 2011 at 05:35:16PM -0300, Alex Sandro de Lacerda Vitola wrote:
> > 
> > I'm using the latest version of spacewalk-utils to rename my server, but is giving the error below:
> > 
> > rhn:/tmp# /usr/bin/spacewalk-hostname-rename 000.000.000.000
> > Validating IP ... OK
> > =============================================
> > hostname: rhn.domainname
> > ip: 000.000.000.000
> > =============================================
> > Stopping rhn-satellite services ... OK
> > Testing DB connection ... psql:<stdin>:1: ERROR:  syntax error at or near "off"
> > LINE 1: set feed off;
> >                  ^
> > FAILED
> > Your database isn't running.
> > Fix the problem and run /usr/bin/spacewalk-hostname-rename again
> > 
> > It should be supported
> 
> Yes, the syntax is Oracle-specific.
> 
> Could you please come up with equivalent PostgreSQL command? I'll be
> happy to review a patch.

Maybe all it takes is to just remove all the set commands because
spacewalk-sql --select-mode should take care of everything anyway.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat