[Spacewalk-list] osa-dispatcher (1.6 nightly) now requires a password
Scott Worthington
scott.c.worthington at gmail.com
Mon Dec 5 18:23:12 UTC 2011
> 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_postgresql.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')
2011/12/05 13:14:46 -04:00 1244 0.0.0.0:
rhnSQL/driver_postgresql.check_connection('ERROR', "DATABASE
CONNECTION TO 'spaceschema' LOST", 'Exception information: current
transaction is aborted, commands ignored until end of transaction
block\n')
2011/12/05 13:14:46 -04:00 1244 0.0.0.0: osad/jabber_lib.__init__
2011/12/05 13:14:46 -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:46 -04:00 1244 0.0.0.0:
osad/jabber_lib.register('ERROR', 'Invalid password')
There exists a single row in the postgresql table rhnpushdispatcher.
-bash-4.1$ psql -d spaceschema
psql (8.4.9)
Type "help" for help.
spaceschema=# select * from rhnpushdispatcher;
id | jabber_id
| last_checkin | hostname
|
port | created | modified | password
----+--------------------------------------------------------------------+-------------------------------+-------------------------------------+-
-----+-------------------------------+-------------------------------+----------
1 | rhn-dispatcher-sat at spacewalk-01.somedomain.com/superclient |
2011-12-02 14:33:12.493545-05 | spacewalk-01.somedomain.com |
1290 | 2011-09-02 12:47:06.562546-04 | 2011-12-02 14:33:12.493545-05 |
(1 row)
The password field is empty.
Should this row be deleted and/or altered?
More information about the Spacewalk-list
mailing list