Differences

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

--- mail:spamassain_gateway [2013/03/19 13:34]
tschulz
+++ mail:spamassain_gateway [2013/03/19 13:48]
tschulz
@@ Line 23: / Line 23: @@
 ===== Install Ports =====
+Run the following commands to install the required ports
 <file>
 cd /usr/ports/mail/p5-Mail-SpamAssassin
@@ Line 29: / Line 30: @@
 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 38: / Line 41: @@
 spamass_milter_enable="YES"
 spamass_milter_socket="inet:9999@127.0.0.1"
+mysql_enable="YES"
 ...
 </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 =====
-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>
 user_scores_dsn DBI:mysql:SpamAssassin:localhost
@@ Line 60: / Line 81: @@
 bayes_sql_password **PASSWORD**
 </file>
+That's it restart and the milter will be listening of port 9999

ISD 820 Knowledge Base