Bug 618300 - Starting osa-dispatcher: ... ('Connection attempt failed
Summary: Starting osa-dispatcher: ... ('Connection attempt failed
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 1.1
Hardware: All
OS: Linux
high
medium
Target Milestone: ---
Assignee: Milan Zázrivec
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Keywords:
Depends On:
Blocks: space11
TreeView+ depends on / blocked
 
Reported: 2010-07-26 15:21 UTC by Petr Sklenar ⛄
Modified: 2011-03-07 14:29 UTC (History)
1 user (show)

(edit)
Clone Of:
(edit)
Last Closed: 2010-08-19 08:24:20 UTC


Attachments (Terms of Use)

Description Petr Sklenar ⛄ 2010-07-26 15:21:44 UTC
Description of problem:
I took today's sw nightly and I could see error when restarting rhn-satellite

Version-Release number of selected component (if applicable):
rhel55 + sw1.1-nightly
osa-dispatcher-5.9.36-1.el5


How reproducible:
always 


Steps to Reproduce:
1.rhn-satellite restart


Actual results:
Starting spacewalk services...
Initializing jabberd processes ...
Starting router:                                           [  OK  ]
Starting sm:                                               [  OK  ]
Starting c2s:                                              [  OK  ]
Starting s2s:                                              [  OK  ]
Starting Oracle Net Listener.
Starting Oracle Database 10g Express Edition Instance.

Starting osa-dispatcher: RHN 23977 2010/07/26 13:36:56 +02:00: ('Connection attempt failed', 12154, 'ORA-12154: TNS:could not resolve the connect identifier specified\n')
RHN 23977 2010/07/26 13:36:56 +02:00: ('Error caught:',)
RHN 23977 2010/07/26 13:36:56 +02:00: ('Traceback (most recent call last):\n  File "/usr/share/rhn/osad/jabber_lib.py", line 119, in main\n    self.setup_config(config)\n  File "/usr/share/rhn/osad/osa_dispatcher.py", line 81, in setup_config\n    rhnSQL.initDB()\n  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 118, in initDB\n    __init__DB(backend, host, port, username, password, database)\n  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 52, in __init__DB\n    __DB.connect()\n  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 385, in connect\n    raise apply(sql_base.SQLConnectError, err_args)\nSQLConnectError: (12154, \'ORA-12154: TNS:could not resolve the connect identifier specified\\n\', \'oracleinstance\', \'Connection_Connect(): server attach\')\n',)
                                                           [  OK  ]
Starting tomcat5:                                          [  OK  ]
Starting httpd:                                            [  OK  ]
Starting Monitoring ...  
[ OK ]
Starting MonitoringScout ...  
[ OK ]
Starting rhn-search...
Starting cobbler daemon: SERVING!
                                                           [  OK  ]
Starting RHN Taskomatic...
Done.


Expected results:
osa-dispatcher starts

Additional info:

Comment 1 Milan Zázrivec 2010-07-26 15:36:01 UTC
spacewalk.git master: 24a652b81a51a12127500c3ae87fe4f19fdae66f

Comment 2 Milan Zázrivec 2010-08-19 08:24:20 UTC
Spacewalk 1.1 has been released.

Comment 3 Dan Bateman 2011-03-07 14:29:34 UTC
I'm seeing this on Spacewalk 1.3 on RHEL6 x86_64 using Oracle XE - when I restart/start rhn-satellite and also in /var/log/rhn/osa-dispatcher.log:


Starting osa-dispatcher: /usr/lib/python2.6/site-packages/jabber/jabber.py:68: DeprecationWarning: the sha module is deprecated; use the hashlib module instead
  import sha, time
RHN 4394 2011/03/07 14:14:13 +01:00: ('Connection attempt failed', 12154, 'ORA-12154: TNS:could not resolve the connect identifier specified\n')
RHN 4394 2011/03/07 14:14:13 +01:00: ('Error caught:',)
RHN 4394 2011/03/07 14:14:13 +01:00: ('Traceback (most recent call last):\n  File "/usr/share/rhn/osad/jabber_lib.py", line 118, in main\n    self.setup_config(config)\n  File "/usr/share/rhn/osad/osa_dispatcher.py", line 80, in setup_config\n    rhnSQL.initDB()\n  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 121, in initDB\n    __init__DB(backend, host, port, username, password, database)\n  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 52, in __init__DB\n    __DB.connect()\n  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 385, in connect\n    raise apply(sql_base.SQLConnectError, err_args)\nSQLConnectError: (12154, \'ORA-12154: TNS:could not resolve the connect identifier specified\\n\', \'XE\', \'Connection_Connect(): server attach\')\n',)


Note You need to log in before you can comment on or make changes to this bug.