[Spacewalk-list] rhnreg_ks error - 1.0 - External Oracle DB

Tom Brown tom at ng23.net
Fri Jun 4 10:25:19 UTC 2010


Hi

Finally getting around to testing registrations and i see this when i
try to register a system, either in the ks or afterwards...

# rhnreg_ks -vvv --serverUrl=https://<MYSERVER>/XMLRPC
--sslCACert=/usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT
--activationkey=1-key1,1-key2
D: rpcServer: Calling XMLRPC registration.welcome_message
A protocol error occurred: Internal Server Error , attempt #1,
An error has occurred:
Internal Server Error
Error communicating with server. The message was:
Internal Server Error
See /var/log/up2date for more information

and that log on the client says

[Fri Jun  4 10:12:06 2010] up2date D: rpcServer: Calling XMLRPC
registration.welcome_message
[Fri Jun  4 10:12:06 2010] up2date A protocol error occurred: Internal
Server Error , attempt #1,
[Fri Jun  4 10:12:06 2010] up2date Error communicating with server.
The message was:
Internal Server Error
[Fri Jun  4 10:12:06 2010] up2date
Traceback (most recent call last):
  File "/usr/sbin/rhnreg_ks", line 205, in ?
    cli.run()
  File "/usr/share/rhn/up2date_client/rhncli.py", line 74, in run
    sys.exit(self.main() or 0)
  File "/usr/sbin/rhnreg_ks", line 88, in main
    rhnreg.getCaps()
  File "/usr/share/rhn/up2date_client/rhnreg.py", line 234, in getCaps
    s.capabilities.validate()
  File "/usr/share/rhn/up2date_client/rhnserver.py", line 156, in
__get_capabilities
    self.registration.welcome_message()
  File "/usr/share/rhn/up2date_client/rhnserver.py", line 50, in __call__
    return rpcServer.doCall(method, *args, **kwargs)
  File "/usr/share/rhn/up2date_client/rpcServer.py", line 277, in doCall
    raise up2dateErrors.CommunicationError(e.errmsg)
up2date_client.up2dateErrors.CommunicationError: Error communicating
with server. The message was:
Internal Server Error

Which is not that informative however i also get an exception mailed
out from the server and a snip of that says


Exception Handler Information
Traceback (most recent call last):
  File "/usr/share/rhn/server/apacheHandler.py", line 72, in headerParserHandler
    rhnSQL.initDB()
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 98, in initDB
    __init__DB(backend, host, port, username, password, database)
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 52, in __init__DB
    __DB.connect()
  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 386, in connect
    raise apply(sql_base.SQLConnectError, err_args)
SQLConnectError: (12541, 'ORA-12541: TNS:no listener\n', 'SPACEWALK',
'Connection_Connect(): server attach')

Local variables by frame
Frame connect in /usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py at line 386
	                   e = <type 'instance'> ORA-12541: TNS:no listener

	               errno = <type 'int'> 12541
	                self = <type 'instance'>
<server.rhnSQL.driver_cx_Oracle.Database instance at 0x2b06f441b098>
	                 ret = <type 'tuple'> (12541, 'ORA-12541: TNS:no
listener\n', 'Connection_Connect(): server attach')
	           reconnect = <type 'int'> 1
	            err_args = <type 'list'> ['SPACEWALK', 12541, 'ORA-12541:
TNS:no listener\n', 'Connection_Connect(): server attach']
	              errmsg = <type 'str'> ORA-12541: TNS:no listener


Frame __init__DB in /usr/share/rhn/server/rhnSQL/__init__.py at line 52
	            username = <type 'str'> SPACEWALK
	            db_class = <type 'classobj'>
server.rhnSQL.driver_cx_Oracle.Database
	            database = <type 'str'> SPACEWALK
	                host = <type 'str'> localhost
	            password = <type 'str'> <MYPASSWORD>
	                port = <type 'NoneType'> None
	             backend = <type 'str'> oracle

Frame initDB in /usr/share/rhn/server/rhnSQL/__init__.py at line 104
	            username = <type 'str'> SPACEWALK
	                temp = <type 'str'> <MYPASSWORD>@SPACEWALK
	            database = <type 'str'> SPACEWALK
	                 dsn = <type 'str'> <CENSORED!>
	                host = <type 'str'> localhost
	            password = <type 'str'> <MYPASSWORD>
	                port = <type 'NoneType'> None
	             backend = <type 'str'> oracle


Exception Handler Information
Traceback (most recent call last):
  File "/usr/share/rhn/server/apacheHandler.py", line 72, in headerParserHandler
    rhnSQL.initDB()
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 98, in initDB
    __init__DB(backend, host, port, username, password, database)
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 52, in __init__DB
    __DB.connect()
  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 386, in connect
    raise apply(sql_base.SQLConnectError, err_args)
SQLConnectError: (12541, 'ORA-12541: TNS:no listener\n', 'SPACEWALK',
'Connection_Connect(): server attach')

Local variables by frame
Frame connect in /usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py at line 386
	                   e = <type 'instance'> ORA-12541: TNS:no listener

	               errno = <type 'int'> 12541
	                self = <type 'instance'>
<server.rhnSQL.driver_cx_Oracle.Database instance at 0x2b06f441b098>
	                 ret = <type 'tuple'> (12541, 'ORA-12541: TNS:no
listener\n', 'Connection_Connect(): server attach')
	           reconnect = <type 'int'> 1
	            err_args = <type 'list'> ['SPACEWALK', 12541, 'ORA-12541:
TNS:no listener\n', 'Connection_Connect(): server attach']
	              errmsg = <type 'str'> ORA-12541: TNS:no listener


Frame __init__DB in /usr/share/rhn/server/rhnSQL/__init__.py at line 52
	            username = <type 'str'> SPACEWALK
	            db_class = <type 'classobj'>
server.rhnSQL.driver_cx_Oracle.Database
	            database = <type 'str'> SPACEWALK
	                host = <type 'str'> localhost
	            password = <type 'str'> <MYPASSWORD>
	                port = <type 'NoneType'> None
	             backend = <type 'str'> oracle

Frame initDB in /usr/share/rhn/server/rhnSQL/__init__.py at line 104
	            username = <type 'str'> SPACEWALK
	                temp = <type 'str'> <MYPASSWORD>@SPACEWALK
	            database = <type 'str'> SPACEWALK
	                 dsn = <type 'str'> <CENSORED!>
	                host = <type 'str'> localhost
	            password = <type 'str'> <PASSWORD>
	                port = <type 'NoneType'> None
	             backend = <type 'str'> oracle

Frame headerParserHandler in /usr/share/rhn/server/apacheHandler.py at line 74
	                self = <type 'instance'>
<server.apacheHandler.apacheHandler instance at 0x2b06f4264908>
	                 req = <type 'mp_request'> <mp_request object at
0x2b06ed673050>
	                 ret = <type 'int'> 0

Frame __call__ in /usr/share/rhn/server/apacheServer.py at line 58
	                self = <type 'instance'>
<server.apacheServer.HandlerWrap instance at 0x2b06efcb8b00>
	                 req = <type 'mp_request'> <mp_request object at
0x2b06ed673050>
	             options = <type 'mp_table'> {'RHNComponentType':
'server.xmlrpc', 'SERVER': 'xmlrpc', 'RootDir': '/usr/share/rhn'}
	                   f = <type 'instancemethod'> <bound method
apacheHandler.headerParserHandler of
<server.apacheHandler.apacheHandler instance at 0x2b06f4264908>>


So any clue why this is trying to connecto to a DB on localhost when
its actually external? This only seems to happen for registrations -
The portal is OK.

Any thoughts?




More information about the Spacewalk-list mailing list