<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style></style></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1>Alex,<o:p></o:p><o:p> </o:p>Re-read what I actually suggested,<o:p></o:p><o:p> </o:p>Firstly, you’re using localhost, I suggested trying the FQDN that your client is trying to use<o:p></o:p><o:p> </o:p>Secondly from the client see if you can resolve the FQDN of the host you want to connect to for the updates, as it’s an error 500 I’d assume you can, but it’s worth looking at.<o:p></o:p><o:p> </o:p>Matt<o:p></o:p><o:p> </o:p><o:p> </o:p>From: spacewalk-list-bounces@redhat.com [mailto:spacewalk-list-bounces@redhat.com] On Behalf Of Aleksandar Pashaliyski Sent: 14 June 2011 09:00 To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] spacewalk problem while register clients<o:p></o:p><o:p> </o:p>Hi Matt, Yes, I'm able to resolve the hostname of machine and connect local to oracle database: [root@spacewalk ~]# sqlplus 'spacewalk/spacewalk@//localhost/XE' SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 14 10:54:55 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production [root@spacewalk ~]# sqlplus 'spacewalk/spacewalk@//<a href="http://spacewalk.local.net/XE">spacewalk.local.net/XE</a>' SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 14 10:55:15 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> SQL> Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production Regards, Alexander<o:p></o:p><div>On Tue, Jun 14, 2011 at 10:37 AM, Matthew Darcy <<a href="mailto:MDarcy@sch-group.net">MDarcy@sch-group.net</a>> wrote:<o:p></o:p><div><div><div>how spacewalk connects to the database for the web interface and clients connect can be missleading.<o:p></o:p></div><div> <o:p></o:p></div><div>try manually connecting to the database with sqlplus, but make sure you use the hostname it's using in the connection string, eg: in your example <a href="http://spacewalk.local.net" target="_blank">spacewalk.local.net</a><o:p></o:p></div><div> <o:p></o:p></div><div>make sure the basics are there too, eg: that you can resolve <a href="http://spacewalk.local.net" target="_blank">spacewalk.local.net</a> from your client (DNS/routing/etc)<o:p></o:p></div><div> <o:p></o:p></div><div>Matt<o:p></o:p></div><div> <o:p></o:p></div><div><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="100%" align=center></div><div>From: <a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a> [<a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a>] on behalf of Aleksandar Pashaliyski [<a href="mailto:al.pashaliyski@gmail.com" target="_blank">al.pashaliyski@gmail.com</a>] Sent: 14 June 2011 08:04 To: <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a> Subject: [Spacewalk-list] spacewalk problem while register clients<o:p></o:p></div><div><div><div>Hi guys, I've a problem with the spacewalk. I have installed it successfully 1.4 version on rhel6, but when I try to register a new client, it gets timeout. Also the links <a href="http://spacewalk.local.net/XMLRPC" target="_blank">http://spacewalk.local.net/XMLRPC</a> and <a href="https://spacewalk.local.net/XMLRPC" target="_blank">https://spacewalk.local.net/XMLRPC</a> returns:<o:p></o:p><h1>500 Error - Internal Server Error<o:p></o:p></h1>You may have reached this page in one of the following ways:<o:p></o:p><ol start=1 type=1><li class=MsoNormal style='color:black;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'>You've found an error in the site. Please report this error to your local administrator with details of how you received this message.<o:p></o:p></li></ol> In httpd's error logs appears: [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] mod_wsgi (pid=14093): Exception occurred processing WSGI script '/usr/share/rhn/wsgi/xmlrpc. <o:p></o:p><div>py'. [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] Traceback (most recent call last): [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] File "/usr/share/rhn/wsgi/xmlrpc.py", line 22, in application [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] return wsgiHandler.handle(environ, start_response, "xmlrpc", "server.xmlrpc") [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] File "/usr/share/rhn/wsgi/wsgiHandler.py", line 45, in handle [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] ret = appServ(req) [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheHandler.py", line 141, in handler [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] h = rhnSQL.prepare("select label, value from rhnTemplateString") [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 190, in prepare [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] db = __test_DB() [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 153, in __test_DB [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] raise SystemError, "Not connected to any database!" [Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] SystemError: Not connected to any database! But it is connected to the database, because I'm able to change configuration of spacewalk via its web interface. My netstat: [root@spacewalk httpd]# netstat -ntpl Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 <a href="http://0.0.0.0:1290/" target="_blank">0.0.0.0:1290</a> 0.0.0.0:* LISTEN 13906/python tcp 0 0 <a href="http://0.0.0.0:111/" target="_blank">0.0.0.0:111</a> 0.0.0.0:* LISTEN 1125/rpcbind tcp 0 0 <a href="http://0.0.0.0:1521/" target="_blank">0.0.0.0:1521</a> 0.0.0.0:* LISTEN 9706/tnslsnr tcp 0 0 <a href="http://0.0.0.0:33939/" target="_blank">0.0.0.0:33939</a> 0.0.0.0:* LISTEN 9733/xe_d000_XE tcp 0 0 <a href="http://0.0.0.0:5269/" target="_blank">0.0.0.0:5269</a> 0.0.0.0:* LISTEN 13891/s2s tcp 0 0 <a href="http://0.0.0.0:22/" target="_blank">0.0.0.0:22</a> 0.0.0.0:* LISTEN 1329/sshd tcp 0 0 <a href="http://127.0.0.1:25/" target="_blank">127.0.0.1:25</a> 0.0.0.0:* LISTEN 1512/master tcp 0 0 <a href="http://127.0.0.1:25151/" target="_blank">127.0.0.1:25151</a> 0.0.0.0:* LISTEN 14176/python tcp 0 0 <a href="http://127.0.0.1:9055/" target="_blank">127.0.0.1:9055</a> 0.0.0.0:* LISTEN 9706/tnslsnr tcp 0 0 <a href="http://127.0.0.1:32000/" target="_blank">127.0.0.1:32000</a> 0.0.0.0:* LISTEN 14131/java tcp 0 0 <a href="http://0.0.0.0:35872/" target="_blank">0.0.0.0:35872</a> 0.0.0.0:* LISTEN 1143/rpc.statd tcp 0 0 <a href="http://127.0.0.1:32001/" target="_blank">127.0.0.1:32001</a> 0.0.0.0:* LISTEN 14252/java tcp 0 0 <a href="http://0.0.0.0:5347/" target="_blank">0.0.0.0:5347</a> 0.0.0.0:* LISTEN 13870/router tcp 0 0 <a href="http://0.0.0.0:5222/" target="_blank">0.0.0.0:5222</a> 0.0.0.0:* LISTEN 13884/c2s tcp 0 0 ::ffff:<a href="http://127.0.0.1:8009/" target="_blank">127.0.0.1:8009</a> :::* LISTEN 13979/java tcp 0 0 ::ffff:<a href="http://127.0.0.1:2828/" target="_blank">127.0.0.1:2828</a> :::* LISTEN 14131/java tcp 0 0 ::ffff:<a href="http://127.0.0.1:2829/" target="_blank">127.0.0.1:2829</a> :::* LISTEN 14252/java tcp 0 0 :::111 :::* LISTEN 1125/rpcbind tcp 0 0 :::80 :::* LISTEN 14083/httpd tcp 0 0 ::ffff:<a href="http://127.0.0.1:8080/" target="_blank">127.0.0.1:8080</a> :::* LISTEN 13979/java tcp 0 0 :::22 :::* LISTEN 1329/sshd tcp 0 0 ::1:25 :::* LISTEN 1512/master tcp 0 0 :::443 :::* LISTEN 14083/httpd tcp 0 0 ::ffff:<a href="http://127.0.0.1:8005/" target="_blank">127.0.0.1:8005</a> :::* LISTEN 13979/java tcp 0 0 :::33863 :::* LISTEN 1143/rpc.statd I used these two howtos for installation: <a href="https://fedorahosted.org/spacewalk/wiki/OracleXeSetup" target="_blank">https://fedorahosted.org/spacewalk/wiki/OracleXeSetup</a> <a href="https://fedorahosted.org/spacewalk/wiki/HowToInstall13" target="_blank">https://fedorahosted.org/spacewalk/wiki/HowToInstall13</a> What I wrong and how can I debug the problem ? Thank you! Best Regards, Alexander<o:p></o:p></div></div></div></div></div></div> ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit <a href="http://www.messagelabs.com/email" target="_blank">http://www.messagelabs.com/email</a> ______________________________________________________________________<o:p></o:p></div> _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><o:p></o:p></div><o:p> </o:p></div> ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ </body></html>