[Spacewalk-list] invalid cert for osa-dispatcher

[jason at monsterjam.org]

On Wed, Mar 16, 2011 at 09:34:45AM +0100, Michael Mraka wrote:
> jason at monsterjam.org wrote:
> % hey folks, I had this 1.3 server working fine for a while and now it wont start because of a missing cert..
> % 
> % [root at redhouse-new etc]# /etc/init.d/osa-dispatcher restart 
> % Shutting down osa-dispatcher:                              [  OK  ]
> % Starting osa-dispatcher: RHN 3664 2011/03/15 11:38:04 -04:00: ('Invalid SSL certificate:', Unable to read file 
> % /usr/share/rhn/RHNS-OSA-CERT)
> %                                                            [  OK  ]
> % [root at redhouse-new etc]# 
> % 
> % that file is not there and I cannot figure out how to regenerate..
> 
> This is default value of osa_ssl_cert option. It's overriden during
> spacewalk-setup to '/var/www/html/pub/RHN-ORG-TRUSTED-SSL-CERT' which
> is put to /etc/rhn/rhn.conf.
> 
> It seems that your installation went wrong or your /etc/rhn/rhn.conf has
> been modified.

ok, thanks for that info, yes I was messing with the /etc/rhn/rhn.conf file.. 
but when I put that line back into my config, I always get the following 

Starting router:                                           [  OK  ]
Starting sm:                                               [  OK  ]
Starting c2s:                                              [  OK  ]
Starting s2s:                                              [  OK  ]
Starting osa-dispatcher: RHN 27702 2011/03/16 13:21:21 -04:00: ('Connection attempt failed', 12541, 
'ORA-12541: TNS:no listener\n')
RHN 27702 2011/03/16 13:21:21 -04:00: ('Error caught:',)
RHN 27702 2011/03/16 13:21:21 -04: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.4/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.4/site-packages/spacewalk/server/rhnSQL/__init__.py", line 52, in __init__DB\n    
__DB.connect()\n  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 
385, in connect\n    raise apply(sql_base.SQLConnectError, err_args)\nSQLConnectError: (12541, \'ORA-12541: 
TNS:no listener\\n\', \'//slaughterhouse.mydomain.com:1521/spwalk.mydomain.com\', \'Connection_Connect(): 
server 
attach\')\n',)
                                                           [  OK  ]
Starting tomcat5:                                          [  OK  ]
Waiting for tomcat to be ready ...

so scratching my head trying to figure this out.. obviously we have a problem connecting to our oracle rac 
server. 

regards,
Jason