Difference between revisions of "Project Gamera"
From Atomicorp Wiki
(New page: This is a stub for Project Gamera) |
|||
| Line 1: | Line 1: | ||
| − | + | ||
| + | == 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 | ||
Revision as of 13:26, 6 May 2008
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
