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

[Lewis Donofrio]

testing - I have posted two times and no signs that I can post?


On Fri, 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
>



-- 
--
___________________________________________________________________
https://www.vizify.com/lewis-donofrio -
734-743-1743<https://www.vizify.com/lewis-donofrio>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130809/972d9b6e/attachment.htm>