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