[Spacewalk-list] spacewalk problem while register clients
Aleksandar Pashaliyski
al.pashaliyski at gmail.com
Tue Jun 14 08:00:21 UTC 2011
Hi Matt,
Yes, I'm able to resolve the hostname of machine and connect local to oracle
database:
[root at 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 at 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 <MDarcy at sch-group.net>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:* spacewalk-list-bounces at redhat.com [
> spacewalk-list-bounces at redhat.com] on behalf of Aleksandar Pashaliyski [
> al.pashaliyski at gmail.com]
> *Sent:* 14 June 2011 08:04
> *To:* spacewalk-list at redhat.com
> *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 at 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
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110614/8baff7f6/attachment.htm>
More information about the Spacewalk-list
mailing list