Thanks for the quick response. I did do cd /var/lib/jabberd/db cp /usr/share/jabberd/db-setup.sqlite . sqlite3 sqlite.db < db-setup.sqlite
the only thing I missed was the c2s.xml. will try this again . Thanks Keith -----Original Message----- From: r.ri...@leeds.ac.uk [mailto:r.ri...@leeds.ac.uk] Sent: Tuesday, March 15, 2011 9:17 AM To: Hagberg, Keith Cc: spacewalk-list@redhat.com Subject: RE: [Spacewalk-list] jabberd log files 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 _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list