<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle">P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</style>
</head>
<body fPStyle="1" ocsi="0">
<div style="FONT-FAMILY: Tahoma; DIRECTION: ltr; COLOR: #000000; FONT-SIZE: 13px">
<div>how spacewalk connects to the database for the web interface and clients connect can be missleading.</div>
<div> </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 spacewalk.local.net</div>
<div> </div>
<div>make sure the basics are there too, eg: that you can resolve spacewalk.local.net from your client (DNS/routing/etc)</div>
<div> </div>
<div>Matt</div>
<div> </div>
<div style="FONT-FAMILY: Times New Roman; COLOR: #000000; FONT-SIZE: 16px">
<hr tabindex="-1">
<div style="DIRECTION: ltr" id="divRpF540156"><font color="#000000" size="2" face="Tahoma"><b>From:</b> spacewalk-list-bounces@redhat.com [spacewalk-list-bounces@redhat.com] on behalf of Aleksandar Pashaliyski [al.pashaliyski@gmail.com]<br>
<b>Sent:</b> 14 June 2011 08:04<br>
<b>To:</b> spacewalk-list@redhat.com<br>
<b>Subject:</b> [Spacewalk-list] spacewalk problem while register clients<br>
</font><br>
</div>
<div></div>
<div>Hi guys,<br>
<br>
<br>
I've a problem with the spacewalk.<br>
I have installed it successfully 1.4 version on rhel6, but when I try to register a new client, it gets timeout.<br>
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:<br>
<h1>500 Error - Internal Server Error</h1>
<p>You may have reached this page in one of the following ways:</p>
<ol>
<li>You've found an error in the site. Please report this error to your local administrator with details of how you received this message.</li></ol>
<br>
In httpd's error logs appears:<br>
<br>
<br>
[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.
<div id=":11z">py'.<br>
[Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] Traceback (most recent call last):<br>
[Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] File "/usr/share/rhn/wsgi/xmlrpc.py", line 22, in application<br>
[Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] return wsgiHandler.handle(environ, start_response, "xmlrpc", "server.xmlrpc")<br>
[Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] File "/usr/share/rhn/wsgi/wsgiHandler.py", line 45, in handle<br>
[Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] ret = appServ(req)<br>
[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<br>
[Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] h = rhnSQL.prepare("select label, value from rhnTemplateString")<br>
[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<br>
[Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] db = __test_DB()<br>
[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<br>
[Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] raise SystemError, "Not connected to any database!"<br>
[Thu Jun 09 13:11:31 2011] [error] [client 10.5.1.64] SystemError: Not connected to any database!<br>
<br>
<br>
But it is connected to the database, because I'm able to change configuration of spacewalk via its web interface.<br>
<br>
My netstat:<br>
[root@spacewalk httpd]# netstat -ntpl<br>
Active Internet connections (only servers)<br>
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
<br>
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
<br>
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
<br>
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
<br>
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
<br>
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
<br>
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
<br>
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
<br>
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
<br>
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
<br>
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
<br>
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
<br>
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
<br>
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
<br>
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
<br>
tcp 0 0 ::ffff:<a href="http://127.0.0.1:8009/" target="_blank">127.0.0.1:8009</a> :::* LISTEN 13979/java
<br>
tcp 0 0 ::ffff:<a href="http://127.0.0.1:2828/" target="_blank">127.0.0.1:2828</a> :::* LISTEN 14131/java
<br>
tcp 0 0 ::ffff:<a href="http://127.0.0.1:2829/" target="_blank">127.0.0.1:2829</a> :::* LISTEN 14252/java
<br>
tcp 0 0 :::111 :::* LISTEN 1125/rpcbind
<br>
tcp 0 0 :::80 :::* LISTEN 14083/httpd
<br>
tcp 0 0 ::ffff:<a href="http://127.0.0.1:8080/" target="_blank">127.0.0.1:8080</a> :::* LISTEN 13979/java
<br>
tcp 0 0 :::22 :::* LISTEN 1329/sshd
<br>
tcp 0 0 ::1:25 :::* LISTEN 1512/master
<br>
tcp 0 0 :::443 :::* LISTEN 14083/httpd
<br>
tcp 0 0 ::ffff:<a href="http://127.0.0.1:8005/" target="_blank">127.0.0.1:8005</a> :::* LISTEN 13979/java
<br>
tcp 0 0 :::33863 :::* LISTEN 1143/rpc.statd
<br>
<br>
<br>
<br>
I used these two howtos for installation:<br>
<a href="https://fedorahosted.org/spacewalk/wiki/OracleXeSetup" target="_blank">https://fedorahosted.org/spacewalk/wiki/OracleXeSetup</a><br>
<a href="https://fedorahosted.org/spacewalk/wiki/HowToInstall13" target="_blank">https://fedorahosted.org/spacewalk/wiki/HowToInstall13</a><br>
<br>
<br>
<br>
What I wrong and how can I debug the problem ?<br>
<br>
<br>
<br>
<br>
Thank you!<br>
Best Regards,<br>
Alexander<br>
</div>
</div>
</div>
</div>
<BR>
______________________________________________________________________<BR>
This email has been scanned by the MessageLabs Email Security System.<BR>
For more information please visit http://www.messagelabs.com/email <BR>
______________________________________________________________________<BR>
</body>
</html>