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:45] tschulz |
mail:spamassain_gateway [2013/03/19 13:48] tschulz |
||
---|---|---|---|
Line 48: | Line 48: | ||
<file> | <file> | ||
/usr/local/etc/rc.d/mysql-server start | /usr/local/etc/rc.d/mysql-server start | ||
- | mysql | + | </file> |
+ | Run the following in a mysql prompt to create a database | ||
+ | <file> | ||
create database SpamAssassin; | create database SpamAssassin; | ||
quit | quit | ||
+ | </file> | ||
+ | create the required tables | ||
+ | <file> | ||
cd /usr/local/share/doc/p5-Mail-SpamAssassin/sql | cd /usr/local/share/doc/p5-Mail-SpamAssassin/sql | ||
mysql SpamAssassin < awl_mysql.sql | mysql SpamAssassin < awl_mysql.sql | ||
Line 56: | Line 61: | ||
mysql SpamAssassin < bayes_mysql.sql | mysql SpamAssassin < bayes_mysql.sql | ||
</file> | </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 76: | 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 |