View source for Project Gamera


== Clustering with Project Gamera ==



# 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 

# 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