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


_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to