This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
mail:spamassain_gateway [2013/03/19 13:29] tschulz |
mail:spamassain_gateway [2013/03/22 06:08] (current) tschulz [Spam Assassin Gateway (FreeBSD 9.1)] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Spam Assassin Gateway (FreeBSD 9.1) ====== | + | ====== SpamAssassin with MySQL Gateway (FreeBSD 9.1) ====== |
+ | |||
+ | ===== /var/db/ports/p5-Mail-SpamAssassin/options ===== | ||
+ | Copy the following to /var/db/ports/p5-Mail-SpamAssassin/options | ||
+ | <file config options> | ||
+ | # This file is auto-generated by 'make config'. | ||
+ | # Options for p5-Mail-SpamAssassin-3.3.2_6 | ||
+ | _OPTIONS_READ=p5-Mail-SpamAssassin-3.3.2_6 | ||
+ | _FILE_COMPLETE_OPTIONS_LIST= AS_ROOT SPAMC SACOMPILE DKIM SSL GNUPG MYSQL PGSQL RAZOR SPF_QUERY RELAY_COUNTRY DCC | ||
+ | OPTIONS_FILE_SET+=AS_ROOT | ||
+ | OPTIONS_FILE_SET+=SPAMC | ||
+ | OPTIONS_FILE_SET+=SACOMPILE | ||
+ | OPTIONS_FILE_SET+=DKIM | ||
+ | OPTIONS_FILE_SET+=SSL | ||
+ | OPTIONS_FILE_SET+=GNUPG | ||
+ | OPTIONS_FILE_SET+=MYSQL | ||
+ | OPTIONS_FILE_UNSET+=PGSQL | ||
+ | OPTIONS_FILE_SET+=RAZOR | ||
+ | OPTIONS_FILE_SET+=SPF_QUERY | ||
+ | OPTIONS_FILE_SET+=RELAY_COUNTRY | ||
+ | OPTIONS_FILE_SET+=DCC | ||
+ | </file> | ||
+ | |||
+ | ===== Install Ports ===== | ||
+ | Run the following commands to install the required ports | ||
+ | <file> | ||
+ | cd /usr/ports/mail/p5-Mail-SpamAssassin | ||
+ | make install | ||
+ | cd /usr/ports/mail/spamass-rules/ | ||
+ | make install | ||
+ | cd /usr/ports/mail/spamass-milter/ | ||
+ | make install | ||
+ | cd /usr/ports/databases/mysql55-server/ | ||
+ | make install | ||
+ | </file> | ||
===== /etc/rc.conf ===== | ===== /etc/rc.conf ===== | ||
+ | Add the following to /etc/rc.conf | ||
<file config rc.conf> | <file config rc.conf> | ||
spamd_enable="YES" | spamd_enable="YES" | ||
Line 6: | 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> | ||
- | ===== local.cf ===== | + | ===== Setup Database ===== |
- | default: /usr/local/etc/mail/spamassassin/local.cf | + | |
<file> | <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 ===== | ||
+ | * default: /usr/local/etc/mail/spamassassin/local.cf | ||
+ | * replace **USERNAME** and **PASSWORD** with the correct values | ||
+ | <file config local.cf> | ||
user_scores_dsn DBI:mysql:SpamAssassin:localhost | user_scores_dsn DBI:mysql:SpamAssassin:localhost | ||
user_scores_sql_username **USERNAME** | user_scores_sql_username **USERNAME** | ||
Line 27: | 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 |