Alex,

Re-read what I actually suggested,

Firstly, you're using localhost, I suggested trying the FQDN that your client 
is trying to use

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.

Matt


From: [email protected] 
[mailto:[email protected]] On Behalf Of Aleksandar Pashaliyski
Sent: 14 June 2011 09:00
To: [email protected]
Subject: Re: [Spacewalk-list] spacewalk problem while register clients

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@//spacewalk.local.net/XE<http://spacewalk.local.net/XE>'

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
On Tue, Jun 14, 2011 at 10:37 AM, Matthew Darcy 
<[email protected]<mailto:[email protected]>> wrote:
how spacewalk connects to the database for the web interface and clients 
connect can be missleading.

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<http://spacewalk.local.net>

make sure the basics are there too, eg: that you can resolve 
spacewalk.local.net<http://spacewalk.local.net> from your client 
(DNS/routing/etc)

Matt

________________________________
From: 
[email protected]<mailto:[email protected]> 
[[email protected]<mailto:[email protected]>] 
on behalf of Aleksandar Pashaliyski 
[[email protected]<mailto:[email protected]>]
Sent: 14 June 2011 08:04
To: [email protected]<mailto:[email protected]>
Subject: [Spacewalk-list] spacewalk problem while register clients
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 http://spacewalk.local.net/XMLRPC and 
https://spacewalk.local.net/XMLRPC returns:
500 Error - Internal Server Error

You may have reached this page in one of the following ways:

  1.  You've found an error in the site. Please report this error to your local 
administrator with details of how you received this message.

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.
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 0.0.0.0:1290<http://0.0.0.0:1290/>                0.0.0.0:* 
                  LISTEN      13906/python
tcp        0      0 0.0.0.0:111<http://0.0.0.0:111/>                 0.0.0.0:*  
                 LISTEN      1125/rpcbind
tcp        0      0 0.0.0.0:1521<http://0.0.0.0:1521/>                0.0.0.0:* 
                  LISTEN      9706/tnslsnr
tcp        0      0 0.0.0.0:33939<http://0.0.0.0:33939/>               
0.0.0.0:*                   LISTEN      9733/xe_d000_XE
tcp        0      0 0.0.0.0:5269<http://0.0.0.0:5269/>                0.0.0.0:* 
                  LISTEN      13891/s2s
tcp        0      0 0.0.0.0:22<http://0.0.0.0:22/>                  0.0.0.0:*   
                LISTEN      1329/sshd
tcp        0      0 127.0.0.1:25<http://127.0.0.1:25/>                0.0.0.0:* 
                  LISTEN      1512/master
tcp        0      0 127.0.0.1:25151<http://127.0.0.1:25151/>             
0.0.0.0:*                   LISTEN      14176/python
tcp        0      0 127.0.0.1:9055<http://127.0.0.1:9055/>              
0.0.0.0:*                   LISTEN      9706/tnslsnr
tcp        0      0 127.0.0.1:32000<http://127.0.0.1:32000/>             
0.0.0.0:*                   LISTEN      14131/java
tcp        0      0 0.0.0.0:35872<http://0.0.0.0:35872/>               
0.0.0.0:*                   LISTEN      1143/rpc.statd
tcp        0      0 127.0.0.1:32001<http://127.0.0.1:32001/>             
0.0.0.0:*                   LISTEN      14252/java
tcp        0      0 0.0.0.0:5347<http://0.0.0.0:5347/>                0.0.0.0:* 
                  LISTEN      13870/router
tcp        0      0 0.0.0.0:5222<http://0.0.0.0:5222/>                0.0.0.0:* 
                  LISTEN      13884/c2s
tcp        0      0 ::ffff:127.0.0.1:8009<http://127.0.0.1:8009/>       :::*    
                    LISTEN      13979/java
tcp        0      0 ::ffff:127.0.0.1:2828<http://127.0.0.1:2828/>       :::*    
                    LISTEN      14131/java
tcp        0      0 ::ffff:127.0.0.1:2829<http://127.0.0.1:2829/>       :::*    
                    LISTEN      14252/java
tcp        0      0 :::111                      :::*                        
LISTEN      1125/rpcbind
tcp        0      0 :::80                       :::*                        
LISTEN      14083/httpd
tcp        0      0 ::ffff:127.0.0.1:8080<http://127.0.0.1:8080/>       :::*    
                    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:127.0.0.1:8005<http://127.0.0.1:8005/>       :::*    
                    LISTEN      13979/java
tcp        0      0 :::33863                    :::*                        
LISTEN      1143/rpc.statd



I used these two howtos for installation:
https://fedorahosted.org/spacewalk/wiki/OracleXeSetup
https://fedorahosted.org/spacewalk/wiki/HowToInstall13



What I wrong and how can I debug the problem ?




Thank you!
Best Regards,
Alexander

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

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


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to