[Spacewalk-list] error generated when running rhn_check on client

[Michael Mraka]

Assaf Flatto wrote:
% Hello 
% 
% When trying to do an rhn_check on a client machine i am getting this error :
% rhn_check -v 
% XMLRPC ProtocolError: <ProtocolError for FOO /XMLRPC: 500 Internal Server Error>
% 
% and i am getting the email (below) from the server .
% 
% Can you tell me what is the issue ?

I guess you are trying to deploy a configuration file from Spacewalk 1.3
server @ PostgreSQL.

It's been fixed in 1.4 RC.

% Thank you  
...
% > SQL Error generated: ('syntax error at or near ")" at character 1296\n', 0, "\n    select cfn.path,\n           cc.label config_channel,\n           ccont.contents file_contents,\n           ccont.is_binary is_binary,\n           c.checksum_type,\n           c.checksum,\n           ccont.delim_start,\n           ccont.delim_end,\n           cr.revision,\n           ci.username,\n           ci.groupname,\n           ci.filemode,\n\t       cft.label,\n\t       ci.selinux_ctx,\n           case \n                when cft.label='symlink' then (select path from rhnConfigFileName where id = ci.SYMLINK_TARGET_FILENAME_ID)\n                else ''\n            end as symlink\t       \n      from \n           rhnConfigFileState cfs,\n           rhnConfigContent ccont,\n           rhnChecksumView c,\n           rhnConfigChannel cc,\n           rhnConfigFileName cfn,\n           rhnConfigInfo ci,\n           rhnConfigFile cf,\n           rhnConfigRevision cr,\n\t   rhnConfigFileType c!
%  ft,
% > \n           rhnActionConfigRevision acr\n     where acr.server_id = %(server_id)s\n       and acr.action_id = %(action_id)s\n       and acr.config_revision_id = cr.id\n       and cr.config_file_id = cf.id\n       and cr.config_info_id = ci.id\n       and cf.config_file_name_id = cfn.id\n       and cf.config_channel_id = cc.id\n       and cf.state_id = cfs.id\n       and cfs.label = 'alive'\n       and cr.config_content_id = ccont.id (+)\n       and cr.config_file_type_id = cft.id\n       and ccont.checksum_id = c.id(+)\n")

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat