Differences

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

--- mail:spamassain_gateway [2013/03/19 13:45]
tschulz [Setup Database]
+++ 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 =====
@@ Line 49: / Line 49: @@
 /usr/local/etc/rc.d/mysql-server start
 </file>
+Run the following in a mysql prompt to create a database
 <file>
-mysql
 create database SpamAssassin;
 quit
 </file>
+create the required tables
 <file>
 cd /usr/local/share/doc/p5-Mail-SpamAssassin/sql
@@ Line 61: / Line 62: @@
 </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 79: / Line 81: @@
 bayes_sql_password **PASSWORD**
 </file>
+That's it restart and the milter will be listening of port 9999

ISD 820 Knowledge Base