MailScanner bayes to mysql

[super]

sa-learn -p /etc/MailScanner/spam.assassin.prefs.conf --backup > /tmp/sa_bayes_backup.txt

代碼: 選擇全部

wget http://mail.wes.com.tw/sa_bayes.zip
unzip sa_bayes.zip
mysql -u sa_user -p sa_bayes < sa_bayes.sql

mysql -u root -p

代碼: 選擇全部

create database sa_bayes;
GRANT ALL ON sa_bayes.* TO sa_user@localhost IDENTIFIED BY 'xxxxxxxx';
GRANT ALL ON sa_bayes.* TO sa_user@local_fqdn IDENTIFIED BY 'xxxxxxxxr';
GRANT ALL ON sa_bayes.* TO sa_user@remote_fqdn IDENTIFIED BY 'xxxxxxxx';
flush privileges;
quit

代碼: 選擇全部

wget http://spamassassin.apache.org/full/3.0.x/dist/sql/bayes_mysql.sql
mysql -u sa_user -p sa_bayes < bayes_mysql.sql
cp /etc/MailScanner/spam.assassin.prefs.conf /etc/MailScanner/spam.assassin.prefs.conf.local
vi /etc/MailScanner/spam.assassin.prefs.conf


代碼: 選擇全部

# bayes_path /etc/MailScanner/bayes/bayes
# bayes_file_mode 0660

bayes_store_module           Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn                DBI:mysql:sa_bayes:localhost
bayes_sql_username           sa_user
bayes_sql_password           xxxxxxxx
bayes_sql_override_username  root

sa-learn -p /etc/MailScanner/spam.assassin.prefs.conf --restore /tmp/sa_bayes_backup.txt


spamassassin -x -D -p /etc/MailScanner/spam.assassin.prefs.conf --lint

sa-learn --force-expire --sync -p  /etc/MailScanner/spam.assassin.prefs.conf

[super]

代碼: 選擇全部

cp /etc/MailScanner/spam.assassin.prefs.conf /etc/MailScanner/spam.assassin.prefs.conf.local
wget wes.com.tw/CentOS/spam.assassin.prefs.conf.mysql
mv spam.assassin.prefs.conf.mysql /etc/MailScanner/spam.assassin.prefs.conf -f
spamassassin -x -D -p /etc/MailScanner/spam.assassin.prefs.conf --lint

vi /etc/crontab
*/10 * * * * root  /usr/bin/sa-learn --force-expire --sync -p  /etc/MailScanner/spam.assassin.prefs.conf  > /dev/null 2>&1



[super]

cd /tmp
service mysqld stop;mv /var/lib/mysql/sa_bayes /tmp ;service mysqld start
wget wes.com.tw/sa_bayes.sql

echo 'CREATE DATABASE sa_bayes;'| mysql -u root -peversuper

mysql -u root -peversuper  sa_bayes < sa_bayes.sql
service MailScanner restart