Differences

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

--- mail:spamassain_gateway [2013/03/19 13:34]
tschulz [/etc/rc.conf]
+++ mail:spamassain_gateway [2013/03/19 13:48]
tschulz [local.cf]
@@ 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
@@ Line 39: / 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

ISD 820 Knowledge Base