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

[Justin Edmands]

On Aug 9, 2013, at 4:34 PM, Stephan Boldt <spacewalk at sboldt.de> wrote:

> 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
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list

Hmm why does it say 127.0.1.1? 


Post your rhn.conf 


Also try ;
spacewalk-service stop
rm -rf /var/lib/jabber/db/*
spacewalk-service start


I have to put this in my rc.local to clear the db at boot.