spacewalk 1.6 nightly schema changes

When using spacewalk nightly, spacewalk-schema-upgrade will not work for minor schema changes.

After updating the packages osa-dispatcher-5.10.25-1.el6 and spacewalk-schema-1.6.28-1.el6, it was necessary to apply the schema changes manually because starting osa-dispatcher threw this error:

2011/11/17 23:19:10 +02:00 5950 0.0.0.0: osad/jabber_lib.main('ERROR', 'Traceback (most recent call last):\n  File "/usr/share/rhn/osad/jabber_lib.py", line 111, in main\n    self.setup_config(config)\n  File "/usr/share/rhn/osad/osa_dispatcher.py", line 100, in setup_config\n    self._password = self.get_dispatcher_password(self._username)\n  File "/usr/share/rhn/osad/osa_dispatcher.py", line 67, in get_dispatcher_password\n    h.execute(jabber_id = username + "%")\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_cx_Oracle.py", line 108, 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_cx_Oracle.py", line 161, in _execute_\n    self._real_cursor.execute(*(None, ), **params)\nSQLStatementPrepareError: (\'ORA-00904: "PASSWORD": invalid identifier\\n\', 904, \'select password from rhnPushDispatcher where jabber_id like :jabber_id\')\n')

The reason is that the password is now stored in the database instead of the config file /etc/rhn/rhn.conf, see also
https://bugzilla.redhat.com/show_bug.cgi?id=679335

To fix this, I did the following:

[root@spacew1 ~]# cat /etc/sysconfig/rhn/schema-upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/124-rhnPushDispatcher.sql.oracle

alter table rhnPushDispatcher add password varchar2(32);

[root@spacew1 ~]# fgrep jabber_password /etc/rhn/rhn.conf
osa-dispatcher.jabber_password = rhn-dispatcher-s12645

[root@spacew1 ~]# sqlplus spacewalk/spwpass@//localhost/XE

SQL> alter table rhnPushDispatcher add password varchar2(32);

SQL> update rhnpushdispatcher set password='rhn-dispatcher-s12645' where id=1;

After restarting osa-dispatcher, everything works fine.

Anyway, Spacewalk nightly builds are not made for being updated continuously. So it's more or less a matter of luck.