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. 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
|