Hi Matt,<br><br><br>Yes, I'm able to resolve the hostname of machine and connect local to oracle database:<br><br>[root@spacewalk ~]# sqlplus 'spacewalk/spacewalk@//localhost/XE'<br><br>SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 14 10:54:55 2011<br>
<br>Copyright (c) 1982, 2010, Oracle. All rights reserved.<br><br><br>Connected to:<br>Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production<br><br>SQL> Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production<br>
[root@spacewalk ~]# sqlplus 'spacewalk/spacewalk@//<a href="http://spacewalk.local.net/XE">spacewalk.local.net/XE</a>'<br><br>SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 14 10:55:15 2011<br><br>Copyright (c) 1982, 2010, Oracle. All rights reserved.<br>
<br><br>Connected to:<br>Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production<br><br>SQL> <br>SQL> Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production<br><br><br><br>
<br>Regards,<br>Alexander<br><br><div class="gmail_quote">On Tue, Jun 14, 2011 at 10:37 AM, Matthew Darcy <span dir="ltr"><<a href="mailto:MDarcy@sch-group.net">MDarcy@sch-group.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
<div style="font-family: Tahoma; direction: ltr; color: rgb(0, 0, 0); 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 <a href="http://spacewalk.local.net" target="_blank">spacewalk.local.net</a></div>
<div> </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)</div>
<div> </div>
<div>Matt</div>
<div> </div>
<div style="font-family: Times New Roman; color: rgb(0, 0, 0); font-size: 16px;">
<hr>
<div style="direction: ltr;"><font color="#000000" face="Tahoma" size="2"><b>From:</b> <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>]<br>
<b>Sent:</b> 14 June 2011 08:04<br>
<b>To:</b> <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a><br>
<b>Subject:</b> [Spacewalk-list] spacewalk problem while register clients<br>
</font><br>
</div><div><div></div><div class="h5">
<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>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></div>
</div>
<br>
______________________________________________________________________<br>
This email has been scanned by the MessageLabs Email Security System.<br>
For more information please visit <a href="http://www.messagelabs.com/email" target="_blank">http://www.messagelabs.com/email</a> <br>
______________________________________________________________________<br>
</div>
<br>_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><br></blockquote></div><br>