MT6 Squirrelmail Sasql

From The Network People, Inc. - Wiki
Jump to navigation Jump to search

Configure SpamAssassin Prefs DB

jailmanage spamassassin
tee /root/.my.cnf <<EO_SA_MYSQL
[mysql]
host = 127.0.0.4
database = spamassassin
user = spamassassin
password = CHANGE.THIS
EO_SA_MYSQL
chmod 600 /root/.my.cnf
cd /usr/local/share/doc/p5-Mail-SpamAssassin/sql/
cat awl_mysql.sql | sed -e 's/TYPE=MyISAM//' | mysql
cat bayes_mysql.sql | sed -e 's/TYPE=MyISAM//' | mysql
cat userpref_mysql.sql | sed -e 's/TYPE=MyISAM//' | mysql

Configure SA to use prefs DB

cd /usr/local/etc/mail/spamassassin
tee sql.cf <<EO_SA_PERUSER
loadplugin Mail::SpamAssassin::Plugin::AWL

user_scores_dsn                 DBI:mysql:spamassassin:127.0.0.4
user_scores_sql_username        spamassassin
user_scores_sql_password        CHANGE.THIS
#user_scores_sql_table           userpref

bayes_store_module              Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn                   DBI:mysql:spamassassin:127.0.0.4
bayes_sql_username              spamassassin
bayes_sql_password              CHANGE.THIS

auto_whitelist_factory          Mail::SpamAssassin::SQLBasedAddrList
user_awl_dsn                    DBI:mysql:spamassassin:127.0.0.4
user_awl_sql_username           spamassassin
user_awl_sql_password           CHANGE.THIS
user_awl_sql_table              awl
EO_SA_PERUSER

Configure Squirrelmail SASQL plugin

jailmanage webmail
cd /usr/local/www/squirrelmail/plugins/sasql
cp sasql_conf.php.dist sasql_conf.php

TODO: $SqlDSN = 'mysql://spamassassin:CHANGE.THIS@127.0.0.4/spamassassin'