[Spacewalk-list] osa-dispatcher (1.6 nightly) now requires a password

[Milan Zazrivec]

> > Clients don't have to do anything.
> > 
> > On the server, you just need to:
> > * stop osa-dispatcher & jabberd
> > * update to latest nightly spacewalk-backend* & osa-dispatcher
> > * rm -f /var/lib/jabberd/db/*
> > * start jabberd & osa-dispatcher
> 
> Milan,
> 
> Thank you for the support.  This is what I have done, but
> osa-dispatcher still will not start.
> 
> [root at spacewalk-01 etc]# service osa-dispatcher stop ; service jabberd stop
> Shutting down osa-dispatcher:                              [FAILED]
> Terminating jabberd processes ...
> Stopping router:                                           [  OK  ]
> Stopping sm:                                               [  OK  ]
> Stopping c2s:                                              [  OK  ]
> Stopping s2s:                                              [FAILED]
> [root at spacewalk-01 etc]# yum check-update
> Loaded plugins: changelog, downloadonly, fastestmirror, rhnplugin
> Loading mirror speeds from cached hostfile
> 
> ...already up-to-date
> 
> [root at spacewalk-01 etc]# unalias rm
> [root at spacewalk-01 etc]# rm -f /var/lib/jabberd/db/*
> [root at spacewalk-01 etc]# service jabberd start ; service osa-dispatcher
> start Initializing jabberd processes ...
> Starting router:                                           [  OK  ]
> Starting sm:                                               [  OK  ]
> Starting c2s:                                              [  OK  ]
> Starting s2s:                                              [  OK  ]
> 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
>                                                            [  OK  ]
> [root at spacewalk-01 etc]# cat /var/log/rhn/osa-dispatcher.log
> 2011/12/05 13:14:36 -04:00 1244 0.0.0.0: osad/jabber_lib.__init__
> 2011/12/05 13:14:36 -04:00 1244 0.0.0.0:
> osad/jabber_lib.setup_connection('Connected to jabber server',
> 'spacewalk-01.somedomain.com')
> 2011/12/05 13:14:36 -04:00 1244 0.0.0.0:
> osad/osa_dispatcher.fix_connection('Upstream notification server
> started on port', 1290)
> 2011/12/05 13:14:36 -04:00 1244 0.0.0.0: osad/jabber_lib.main('ERROR',
> 'Error caught:')
> 2011/12/05 13:14:36 -04:00 1244 0.0.0.0: osad/jabber_lib.main('ERROR',
> 'Traceback (most recent call last):\n  File
> "/usr/share/rhn/osad/jabber_lib.py", line 113, in main\n
> self.fix_connection(c)\n  File
> "/usr/share/rhn/osad/osa_dispatcher.py", line 123, in fix_connection\n
>    self._register_dispatcher(c.jid, hostname, port)\n  File
> "/usr/share/rhn/osad/osa_dispatcher.py", line 273, in
> _register_dispatcher\n    h =
> rhnSQL.prepare(self._query_register_dispatcher, params = (
> \'hostname_in varchar\', \'port_in numeric\', \'jabber_id_in
> varchar\', \'password varchar\' ))\n  File
> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py",
> line 196, in prepare\n    return db.prepare(sql, params=params,
> blob_map=blob_map)\n  File
> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql
> .py", line 200, in prepare\n    c.execute()\n  File
> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py",
> line 163, in execute\n    return apply(self._execute_wrapper,
> (self._execute, ) + p, kw)\n  File
> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql
> .py", line 270, in _execute_wrapper\n    retval = apply(function, p, kw)\n
> File
> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py",
> line 217, in _execute\n    return self._execute_(args, kwargs)\n  File
> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresq
> l.py", line 283, in _execute_\n    self._real_cursor.execute(self.sql,
> params)\nSQLStatementPrepareError: (\'syntax error at or near
> "$1"\\nLINE 1: ...er (id, jabber_id, last_checkin, hostname, port,  $1
> ) value...\\n
>    ^\\nQUERY:  insert into rhnPushDispatcher (id, jabber_id,
> last_checkin, hostname, port,  $1 ) values
> (sequence_nextval(\\\'rhn_pushdispatch_id_seq\\\'),  $2 ,
> current_timestamp,  $3 ,  $4 ,  $1 )\\nCONTEXT:  SQL statement in
> PL/PgSQL function "rhn_asdf_03139246e715360fa7b1c85c7b9978d72cedccd8"
> near line 15\\n\', 0, "create function
> rhn_asdf_03139246e715360fa7b1c85c7b9978d72cedccd8 (hostname_in
> varchar,port_in numeric,jabber_id_in varchar,password varchar) returns
> void as $x03139246e715360fa7b1c85c7b9978d72cedccd8$\\n
> declare\\n            i numeric;\\n        begin\\n            update
> rhnPushDispatcher\\n               set last_checkin =
> current_timestamp,\\n                   hostname = hostname_in,\\n
>               port = port_in\\n             where jabber_id =
> jabber_id_in\\n            returning id into i;\\n            if i is
> null then\\n                -- Have to insert the row\\n
>  insert into rhnPushDispatcher \\n                       (id,
> jabber_id, last_checkin, hostname, port, password)\\n
> values (sequence_nextval(\'rhn_pushdispatch_id_seq\'), jabber_id_in,
> current_timestamp,\\n                       hostname_in, port_in,
> password);\\n            end if;\\n        end;\\n
> $x03139246e715360fa7b1c85c7b9978d72cedccd8$ language plpgsql")\n')

This problem has been fixed by commit
116b246bac4b525e12f7d755e7d82a327ac4d516 and should be included
in osa-dispatcher-5.10.28 from nightly.

-MZ