Previously I used MS access to check my quarantine but the volume of email was too much and forced me not to quarantine email at all. this was fine until the new corpus version came out and I need to check the quarantine for false positives....
I need major help getting spam filter to use the MySql db. so far I have installed the latest version of MySql, and upgraded to MDAC 2.8. I am running this on a test windows 2000 pro box if that matters.
I have not changed any config files.
when I hit the "check db connection string" button it gives an error.
"Error connecting to database. [Microsoft][ODBC driver Manager] data source name not found and no default driver specified."
I have chosen the MySql udl string...

any help is greatly appreciated.

Thanks.

You have to first build the database in mysql. Open a command prompt, switch to your mysql bin directory (usually c:\mysql\bin). Run MYSQL, at the prompt, type in 'create database spamfilter' (I'm doing this from memory and I've slept some since then but you should get the point <G>). Exit Mysql and close the command prompt.

Next, make sure you've installed the ODBC connector for Mysql. It's a download from the Mysql site. Install it. Then...

Start->Settings->Control Panel->Administrative Tools->Data Sources

Create a data source in the System DSN using the Mysql ODBC connector and connecting to the database you made above. Usually the login id for the connector is root and the password is blank. If you've put security in place around all that you'll need to use whatever login/password combo you made.

Next, open Spam Filter, go to the Settings tab, Quarantine DB tab, and to the right of the Connection String is a small button with 3 dots. Click that button. Make a Connection String using the next dialog box. The connection string attaches to your DSN you created with the ODBC connector above. You can use the BUILD button to help make it. When you click Build the pulldown for 'Use Data Source Named' will show the ODBC connector. Select it, provide the root and password (blank unless changed), click allow blank password, click save password, and test the connection. If it tests ok, you're good to go, if not, then something still isn't right.

Assuming things are ok, click ok. Click ok again, Now proceed through the Step 1-3 for making the tables and activating the quarantine.

I may have missed some stuff because I don't have it in front of me, but that's the general idea. You have to have Mysql installed, Mysql ODBC installed, Create a database, make an ODBC connector for the database, tell spam filter about that connector, then create the tables, and then activate the quarantine.

Hope this helps!

bill

Keizersozay ,

Bill's instructions are perfect (thanks Bill!). One recommendation however. When you create a connection in SpamFilter, and you opt to "Build a connection string", please choose the "Microsoft OLE DB Provider for ODBC" as other odbc providers cause problems. An alternative is to "Use Data Link File" option and to select the SpamFilterMySQL.udl file in the /SpamFilter/Database directory. That UDL file already chooses the correct provider. Please note that you'll have to make the necessary changes (username/password to MySQL) in that UDL beforehand, done by simply double-clicking the UDL filename to bring up the properties for the connection.

Roberto F.
LogSat Software

Doh! That's right, I even posted that we needed to use the OLE driver because of the SQL connection at a few of my customers... geez, must be getting old.

bill

Thanks for all of your help.

Just to let everyone else out these know how to get it to work, this is what I did:

Download and install the mysql server software from mysql.com along with the ODBC connector.

Open a command prompt and go to c:\mysql\bin (or where ever) and type “mysql” then type “create database spamfilter;”  ß don’t forget the semicolon.

Now go to admin tools, -> data sources.  Create a data source in the System DSN using the Mysql ODBC connector and connecting to the database you made above. Usually the login id for the connector is root and the password is blank. If you've put security in place around all that you'll need to use whatever login/password combo you made.

Next go to the spam filter database setup under settings -> Quarantine DB. Click the three dots on the right and choose ‘use the data link file’ and choose the mysql connection string. you may need to edit the connection string to exactly match the name of the database you dropped in mysql above.  I.e. change from “Source=SpamFilterMySQL” to “Source=SpamFilter”

Next basically follow steps 1-3 on the Quarantine DB screen. After you are done you may need to stop and restart spam filter. It kept throwing errors on the activity screen every time I refreshed the database until I restarted spam filter.

Thanks to Bill and Roberto.