User Tools

Site Tools


mail:spamassain_gateway

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
mail:spamassain_gateway [2013/03/19 13:36]
tschulz [Install Ports]
mail:spamassain_gateway [2013/03/19 13:48]
tschulz [local.cf]
Line 41: Line 41:
 spamass_milter_enable="​YES"​ spamass_milter_enable="​YES"​
 spamass_milter_socket="​inet:​9999@127.0.0.1"​ spamass_milter_socket="​inet:​9999@127.0.0.1"​
 +mysql_enable="​YES"​
 ... ...
 </​file>​ </​file>​
  
 +===== Setup Database =====
 +<​file>​
 +/​usr/​local/​etc/​rc.d/​mysql-server start
 +</​file>​
 +Run the following in a mysql prompt to create a database
 +<​file>​
 +create database SpamAssassin;​
 +quit
 +</​file>​
 +create the required tables
 +<​file>​
 +cd /​usr/​local/​share/​doc/​p5-Mail-SpamAssassin/​sql
 +mysql SpamAssassin < awl_mysql.sql
 +mysql SpamAssassin < userpref_mysql.sql
 +mysql SpamAssassin < bayes_mysql.sql
 +</​file>​
 ===== local.cf ===== ===== local.cf =====
-default: /​usr/​local/​etc/​mail/​spamassassin/​local.cf+  * default: /​usr/​local/​etc/​mail/​spamassassin/​local.cf 
 +  * replace **USERNAME** and **PASSWORD** with the correct values
 <file config local.cf>​ <file config local.cf>​
 user_scores_dsn DBI:​mysql:​SpamAssassin:​localhost user_scores_dsn DBI:​mysql:​SpamAssassin:​localhost
mail/spamassain_gateway.txt · Last modified: 2013/03/22 06:08 by tschulz