[Spacewalk-list] osad problems postgresql?

[Michael Mraka]

tiesinga wrote:
% Hi List,
% 
% My clients can not connect to osad. it looks like a sql problem.
% Server centos 5.5
% spacewalk nightly 1.4
% database postgresql
% Client os sl6.0
% 
% regards,
% Eite Tiesinga
% 
% 
% Error messages:
...
%   File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
% line 268, in _execute_wrapper
%     raise rhnSQL.SQLStatementPrepareError(0, str(e), self.sql)
% SQLStatementPrepareError: ('syntax error at or near
% "autonomous_transaction" at character 21\n', 0, "\ndeclare\n
% pragma autonomous_transaction;\nbegin\n    update rhnPushClient \n
% set name = %(name)s,\n           shared_key = %(shared_key)s,\n
% state_id = %(state_id)s,\n           next_action_time = NULL,\n
% last_ping_time = NULL\n     where server_id = %(server_id)s;\n    if
% sql%%rowcount = 1 then\n        -- Entry successfully updated\n
% commit;\n        return;\n    end if;\n\n    insert into
% rhnPushClient \n           (id, server_id, name, shared_key,
% state_id)\n    values (sequence_nextval('rhn_pclient_id_seq'),
% %(server_id)s, %(name)s, \n         %(shared_key)s, %(state_id)s);\n
% commit;\nend;\n")


Today I've fixed couple of issues in osad - spacewalk on postgresql
communication.
The error above is fixed in osad-5.10.5-1 and spacewalk-backend-1.4.18-1
in spacewalk nightly repo.

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat