[Spacewalk-list] Upgrading Spacewalk Server

[Jan Pazdziora]

On Tue, Oct 11, 2011 at 03:43:53PM +0000, Wojtak, Greg wrote:
>   File 
> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql
> .py", line 269, in _execute_wrapper
>     raise rhnSQL.SQLStatementPrepareError(0, str(e), self.sql)
> SQLStatementPrepareError: ('syntax error at or near "rhnCryptoKey"\nLINE
> 1: delete rhnCryptoKey where id=1\n               ^\n', 0, 'delete
> rhnCryptoKey where id=%(rhn_cryptokey_id)s')
> 
> Looks like a variable is not being interpreted properly?  I'm not sure,
> I'm not very proficient with python.
> 
> Any ideas or tips?  I would simply insert the new cert manually with psql,
> but I'm not sure how to properly encode the contents of the certificate
> file to fit in the database.

There is a patch available courtesy of George Nikandrov at

	https://www.redhat.com/archives/spacewalk-devel/2011-August/msg00031.html

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