[Spacewalk-list] Configuration File Import Problem

[Joshua Roys]

On 03/04/2010 08:43 AM, Trevor T Kates wrote:
> Josh:
>
> I applied the patch you provided; however, I am now getting a 500 Internal Server Error on CONFIG-MANAGEMENT. This is the relevant output from rhn_check -vvvvvvvvv:
>
> D: do_call configfiles.upload (68, ['/etc/X11/xorg.conf'])
> XML-RPC call error:<ProtocolError for spacewalk.domain.com /CONFIG-MANAGEMENT: 500 Internal Server Error>
> Traceback (most recent call last):
>    File "/usr/share/rhn/config_client/rpc_cli_repository.py", line 120, in put_files
>      self.system_id, action_id, params)
>    File "/usr/share/rhn/config_client/rpc_cli_repository.py", line 51, in rpc_call
>      (self, method_name) + params)
>    File "/usr/share/rhn/config_common/repository.py", line 360, in rpc_call
>      sys.exit(1)
> SystemExit: 1
> D: Sending back response ((6,), 'Fatal error in Python code occurred', {})
>
> Thank you for the help thus far.
>

Hello,

I just sent another patch a bit ago to fix what might be your new 
problem...  look on the server in /var/log/rhn/* (and in the mailbox 
that tracebacks are sent to- traceback_mail in /etc/rhn/rhn.conf) for 
something like this:

SQL Error generated: ('ORA-00918: column ambiguously defined\n', 918,
'select id, c.checksum_type, c.checksum, file_size, contents,
is_binary from rhnConfigContent, rhnChecksumView c where c.checksum =
:checksum and c.checksum_type = :checksum_type and file_size =
:file_size and checksum_id = c.id')

If you see something else, please reply with the error you find. 
Otherwise, see if the attached patch helps.

server# cd /usr/share/rhn/server/
server# patch -p3 < try-to-fix-an-ora-00918.diff

Thanks,

Josh
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: try-to-fix-an-ora-00918.diff
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100304/9449f2c9/attachment.ksh>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2719 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100304/9449f2c9/attachment.p7s>