The steps to configure SpamFilter ISP to use a MySQL database are:
1. | Install MySQL on a server (it can be installed on the same server running SpamFilter). On Windows platforms we recommend installing the “MySQL Administrator” tool as it allows easier administration for MySQL. |
2. | Install the MySQL ODBC Driver v3.51 (do not use any beta drivers). Warning - MySQL ODBC Connector Driver v3.51.14 has a known bug that renders it incompatible with SpamFilter. Please install v3.51.15 or later, or v3.51.12 or earlier of the driver. |
3. | Create an empty database in MySQL. The sample screenshots assume this database to be named “spamfilter”, but you can use any other naming convention. |
4. | In MySQL, create a new user (“SpamFilterUser” in the sample screenshots), and assign it all privileges for the “spamfilter” database. Please see the screenshot in Figure 9 for a sample. Figure 9 |
5. | In the ODBC Data Sources on the server, create a DSN for the above database using the MySQL ODBC Driver. See the screenshot in Figure 10 for a sample. |
6. | Configure the database connection in SpamFilter to point to the DSN above. The simplest way to proceed is to use a UDL file (Microsoft's Universal DataLink) to define the connection to the MySQL server. In the SpamFilter\database directory you'll find several .UDL files for each database platform. Please double-click on the one for MySQL, SpamFilterMySQL.udl. The correct OLE DB Provider should already be selected in the "Provider" tab. Under the "Connection" tab select the DNS created in step 4 above. Please see the screenshot in Figure 11 for sample settings. Click on "Test Connection" to ensure the UDL file works. Please ensure that the "Return Matching Rows" option in the Advanced settings has been checked. Figure 10 / Figure 11 |
7. | In SpamFilter, under the "Settings - Quarantine DB" tab, click on the "..." ellipse button to select a Connection String. In the box that follows, select "Use Data Link File" and select the SpamFilterMySQL.udl you customized before. See screenshot in Figure 12 for sample settings. |
8. | Use the 1-2-3 step wizard in SpamFilter's Quarantine DB tab to create the necessary tables in SpamFilter. On step 3, ensure to click on the “Save & Activate Conn String” button. |
9. | Click on the “Save Settings” button. |
 Figure 12
|