This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last 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 |
||
---|---|---|---|
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 | ||
Line 63: | Line 81: | ||
bayes_sql_password **PASSWORD** | bayes_sql_password **PASSWORD** | ||
</file> | </file> | ||
+ | |||
+ | That's it restart and the milter will be listening of port 9999 |