Project Gamera

Clustering with Project Gamera

1. On the PG server

1) install mysql on PG

 yum install mysql-server

2) set mysql pass on PG

 mysqladmin -u root password PASSWORD

3) set up tortuga DB

 wget http://www.atomicrocketturtle.com/tortuga/tortuga.sql
 mysql -u root -p < tortuga.sql

4) configure Spamassassin to use mysql

 cd /etc/mail/spamassassin/
 wget http://www.atomicrocketturtle.com/tortuga/tortuga.cf
 

5) Set spamd to use mysql

 vim /etc/sysconfig/spamassassin
 SPAMDOPTIONS="-d -x -q -c -m30 -u qscand"

6) restart spamd

 /etc/init.d/spamassassin restart

7) create remote mysql user

 GRANT ALL ON tortuga.* TO tortuga@'192.168.100.244' IDENTIFIED BY 'collection';
 flush privileges;

TODO: Set up maintenance

1. On the plesk server

1) Add the tortuga-learn script

 wget http://www.atomicrocketturtle.com/tortuga/tortuga-user-client.sh

2) Set up the tortuga client config for SA

 mkdir /etc/mail/tortuga/
 cd /etc/mail/tortuga/
 wget http://www.atomicrocketturtle.com/tortuga/tortuga-client.cf

3) add to cron

 crontab -e 
 0       4       *       *       *       /root/bin/tortuga-user-client.sh >/dev/null 2>&1