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' 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]>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 > > make sure the basics are there too, eg: that you can resolve > spacewalk.local.net from your client (DNS/routing/etc) > > Matt > > ------------------------------ > *From:* [email protected] [ > [email protected]] on behalf of Aleksandar Pashaliyski [ > [email protected]] > *Sent:* 14 June 2011 08:04 > *To:* [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 0.0.0.0:* > LISTEN 13906/python > tcp 0 0 0.0.0.0:111 0.0.0.0:* > LISTEN 1125/rpcbind > tcp 0 0 0.0.0.0:1521 0.0.0.0:* > LISTEN 9706/tnslsnr > tcp 0 0 0.0.0.0:33939 0.0.0.0:* > LISTEN 9733/xe_d000_XE > tcp 0 0 0.0.0.0:5269 0.0.0.0:* > LISTEN 13891/s2s > tcp 0 0 0.0.0.0:22 0.0.0.0:* > LISTEN 1329/sshd > tcp 0 0 127.0.0.1:25 0.0.0.0:* > LISTEN 1512/master > tcp 0 0 127.0.0.1:25151 0.0.0.0:* > LISTEN 14176/python > tcp 0 0 127.0.0.1:9055 0.0.0.0:* > LISTEN 9706/tnslsnr > tcp 0 0 127.0.0.1:32000 0.0.0.0:* > LISTEN 14131/java > tcp 0 0 0.0.0.0:35872 0.0.0.0:* > LISTEN 1143/rpc.statd > tcp 0 0 127.0.0.1:32001 0.0.0.0:* > LISTEN 14252/java > tcp 0 0 0.0.0.0:5347 0.0.0.0:* > LISTEN 13870/router > tcp 0 0 0.0.0.0:5222 0.0.0.0:* > LISTEN 13884/c2s > tcp 0 0 ::ffff:127.0.0.1:8009 > :::* LISTEN 13979/java > tcp 0 0 ::ffff:127.0.0.1:2828 > :::* LISTEN 14131/java > tcp 0 0 ::ffff: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 > :::* 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 > :::* 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] > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
