SpamFilter Enterprise

Top  Previous  Next

SpamFilter Enterprise requires the use of a database. To maximize SpamFilter's availability, SpamFilter maintains a local file-based copy of its database settings locally on the server. This allows SpamFilter Enterprise to function even if the database is offline. To achieve this goal, SpamFilter Enterprise relies on triggers available only in certain database servers. SpamFilter Enterprise does not support Microsoft Access, Oracle, and older versions of MySQL and Microsoft SQL Server.

 

Supported Databases

The following database platforms are supported by SpamFilter Enterprise:

Microsoft SQL Server 2000 or higher
MySQL v5.1 or higher with MySQL ODBC Connector v3.51.12. Warning - MySQL ODBC Driver v3.51.14 has a known bug that renders it incompatible with SpamFilter. Please install v3.51.12 or earlier of the driver.

 

Prerequisites

SpamFilter Enterprise will run in "Standard" mode when the database is not configured (the default mode). Before being able to switch functionality to the "Enterprise" mode, SpamFilter requires that a supported database platform be configured using the Database Setup tab.

Figure 9

Figure 9

 

 

Enterprise Database Configuration

Once the database has been configured to use the SpamFilter "Standard" tables, the "Enterprise Mode" can be enabled. To proceed, perform the following 4 steps on the "Enterprise / Standard Version" tab, as shown on the screenshot in Figure 10.

 

1.Click on "Use Enterprise Filters"
2.Click on the "Save Settings" button.
3.Click on "Create / Check Database tables" button to have SpamFilter create the necessary Enterprise tables. The database script commands being executed, and any errors that may result, will be displayed in the memo field underneath the button. We recommend scrolling thru the results to see if any major errors appear in the results.
4.Once the script in the above step has completed, restart SpamFilter.

 

Figure 10

Figure 10