Re: [cobalt-users] swatch on a RaQ3

["Dave" <maxdoubt@xxxxxx>]

Sent: Thursday, August 09, 2001 2:23 PM
Subject: [cobalt-users] swatch on a RaQ3


> We have a RaQ3 - swatch is hogging a lot of CPU...

Hi Matt,

This sux if it's the same problem I had - swatch was hanging/running 24/7. The
message means that one of the postgres databases Cobalt uses to sync your
virtual domains and users to Linux is missing.  This happens every now and
then and the only way to solve it is to reinstall/rebuild postgres after
having taken some precautions.  By far the safest way to correct this is to
contact Cobalt Tech support.

*IF* you REALLY want to try and rebuild the postgres database here are some
instructions.  WARNING****WARNING, do this at your own risk!!!  That being
said:

<self addition which after experiencing this problem I found useful>

Besides a second swatch process running you *probably* also have a second
CROND running too.  Type (as root) ps -aux so you can get the PID of what's
running.  KILL the CROND (yes, the CAPS version) and there will be two other
processes that die along with CROND, one of which is your second copy of
swatch.  Then KILL the hanging swatch.

Now in your favorite editor, edit /etc/crontab and insert a # in front of the
following line:
0,15,30,45 * * * * root /usr/local/sbin/swatch >>/var/cobalt/admin.log 2>&1

This prevents active monitor from restarting stopped services (like swatch
which we just killed)

KILL the sendmail process if running:
/etc/rc.d/init.d/sendmail stop

</end self additions and onto what Cobalt says>


su to root
cd /home/pgsql
su postgres
edit pg_hba.conf
change crypt to trust
pg_dump cobalt > cobalt.dump
vi cobalt.dump
find create_table for quota and hash it out ( comment it out # )
close
destroydb cobalt
createdb cobalt
psql cobalt < cobalt.dump
edit pg_hba.conf
change trust back to crypt
/usr/local/sbin/swatch

When you restart swatch (last line) this will restart sendmail too.  It's your
choice and good luck.  BTW, on my RAQ3 it was CREATE_TABLE for quota if I
remember correctly...

Dave~