Starting osa-dispatcher with jabberd is failing with "osad/jabber_lib.register('ERROR', 'Invalid password')"

Solution Verified - Updated -

Environment

  • Red Hat Satellite 5.8

Issue

  • Error as seen in /var/log/rhn/osa-dispatcher.log:
2013/03/22 17:11:53 +10:00 30155 0.0.0.0: rhnSQL/driver_cx_Oracle.connect('Connecting to database', 'rhnsat')
2013/03/22 17:11:53 +10:00 30155 0.0.0.0: osad/jabber_lib.__init__
2013/03/22 17:11:53 +10:00 30155 0.0.0.0: osad/jabber_lib.setup_connection('Connected to jabber server', u'satellite.example.com')
2013/03/22 17:11:53 +10:00 30155 0.0.0.0: osad/jabber_lib.register('ERROR', 'Invalid password')

Resolution

  • Stop jabberd and osa-dispatcher and remove jabberd's database:
# service jabberd stop
# service osa-dispatcher stop
# cp -rp /var/lib/jabberd/db /tmp/jabberd-db
# rm -rf /var/lib/jabberd/db/*
  • Log into the database and delete the rows from the rhnPushDispatcher table:
# spacewalk-sql -i
# delete from rhnPushDispatcher;
    \quit
  • Start jabberd & osa-dispatcher again:
# service jabberd start
# sleep 10
# service osa-dispatcher start

Root Cause

  • There were multiple entries for rhn-dispatcher-sat in the rhnPushDispatcher table:
SQL> select jabber_id, password from rhnpushdispatcher;
JABBER_ID                                                                        PASSWORD
-------------------------------------------------------------------------------- --------------------------------
rhn-dispatcher-sat@satellite.example.com/superclient                             N2wFcyBRKvKX8psnxxNU0kEVCC0Fern2
rhn-dispatcher-sat@satellite.example.com/superclient                             N2wFcyBRKvKX8psnxxNU0kEVCC0Fern2

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments