[Spacewalk-list] jabberd log files

[r.rigby at leeds.ac.uk]

hi keith,

On Tue, 15 Mar 2011, Hagberg, Keith wrote:

> I tried doing the sqlite option and after setting it up it never seems to work.
>
> I stopped osa-dispatcher and jabberd,
> Modified the sm.xml
> Deleted the /var/lib/jabberd/db/ contents
> Created the sqlite.db file
> Restarted everything
>
> Still did not work,

apologies if i may have missed out some details here. it was a little 
while ago that this was set up.
looking again, over command history, etc., it seems the process was:

-shut down osa-dispatcher and jabberd
-remove everything from /var/lib/jabberd/db/
-setup sqlite:

cd /var/lib/jabberd/db
cp /usr/share/jabberd/db-setup.sqlite .
sqlite3 sqlite.db < db-setup.sqlite

-set up jabber config files for sqlite:

/etc/jabberd/sm.xml and /etc/jabberd/c2s.xml both need entries for sqlite.

as far as i can tell, all i did was change:

<driver>db</driver>

to:

<driver>sqlite</driver>

in both of these. the rest of the settings should be in there.

-restart jebberd and osa-dispatcher

i may still have missed something out, but i think that is it.

>
> Then stopped osad on client, deleted osad-auth.conf and restart osad
> And still nothing.
>
> I have successfully deleted the sm.db and restarted but clients would not work until I
> Deleted the osad-auth.conf file and restarted osad.
>
> Is there a way to turn off all the logging?
>
> Again does anyone know of a way to reduce the size of the sm.db without breaking the clients osad?
>
> Keith

i'm sure there will be some way to disable the logging, but i'm afraid i 
don't know to do that myself. i think i might have tried something with a 
DB_CONFIG file which didn't work.. but i just didn't have time to spend on 
getting db to behave nicely, and switching to sqlite has worked better in 
our case.

also, as previously mentioned, i don't think it should be necessary to 
remove the osad-auth.conf on the clients, after removing the database, 
and it wasn't the case with our spacewalk install prior to the upgrade to 
1.2.

again, haven't had time to delve into this, though i feel that some of the 
suggestions on the bugzilla:

> https://bugzilla.redhat.com/show_bug.cgi?id=662593

could be worth a try.

hope this is of some use.

many thanks,

richard