Differences

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

--- 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 =====
+Add the following to /etc/rc.conf
 <file config rc.conf>
 spamd_enable="YES"
@@ Line 6: / Line 41: @@
 spamass_milter_enable="YES"
 spamass_milter_socket="inet:9999@127.0.0.1"
+mysql_enable="YES"
+...
 </file>
-===== local.cf =====
+===== Setup Database =====
-default: /usr/local/etc/mail/spamassassin/local.cf
 <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_sql_username **USERNAME**
@@ Line 27: / Line 81: @@
 bayes_sql_password **PASSWORD**
 </file>
+That's it restart and the milter will be listening of port 9999

ISD 820 Knowledge Base

User Tools

Site Tools

Differences

Page Tools