[Spacewalk-list] Fix broken osa-dispatcher and empty sqlite.db

[Stephan Boldt]

Hello everybody,

after the filesystem ran out of space the /var/lib/jabberd/db/sqlite.db has
a size of 0 byte and the log states:

jabberd/c2s[1932]: [8] [::ffff:127.0.1.1, port=46094] connect
jabberd/c2s[1932]: sqlite (authreg): no such table: authreg

I tried to repopulate sqlite.db by issueing

sqlite3 sqlite.db < /usr/share/jabberd/db-setup.sqlite

afterwards the log now states

[...]
jabberd/c2s[2070]: [10] [::ffff:127.0.1.1, port=32942] connect
jabberd/c2s[2070]: sqlite (authreg): SQL logic error or missing database
jabberd/c2s[2070]: [10] created user: user=rhn-dispatcher-sat; realm=
jabberd/c2s[2070]: sqlite (authreg): SQL logic error or missing database
[...]

Any idea how I can fix this situation? I've found very few informations
regarding the structure of the osa-dispatcher and ways to rebuild it's dbs
or completely reinitialize it. May be somebody can point me in the right
direction...

Thanks in advance!

regards,
Stephan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130809/411b1522/attachment.htm>