Print Page | Close Window

MySQL setup - Step2b

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=4624
Printed Date: 14 October 2025 at 1:23am


Topic: MySQL setup - Step2b
Posted By: Guests
Subject: MySQL setup - Step2b
Date Posted: 23 November 2004 at 12:47pm
I am trying to MySQL setup and following the instructions from
 
http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=3255" CLASS="ASPForums" TITLE="WARNING: URL created by poster. - http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=3255" CLASS="ASPForums" TITLE="WARNING: URL created by poster. - http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=3255
 
and http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=3273" CLASS="ASPForums" TITLE="WARNING: URL created by poster. - http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=3273" CLASS="ASPForums" TITLE="WARNING: URL created by poster. - http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=3273
 
Everything seems to working except when I start working through the "Steps"
 
I complete "Step1" - everything is fine -> "Step 2" the initial tables are built and then it says some tables are missing and to proceed to Step2b -> I proceed to "Step 2b" and click on "Update" and it kills the Spamfilter service: the MySQL tables never get updated.
 
How can I manually fix this?
 
Thanks
 
Robert


Replies:
Posted By: Guests
Date Posted: 23 November 2004 at 1:50pm

Another piece to the puzzle...

The MySQL database I am/was trying to connect to is located on another server (a linux box).

I installed MySQL on the Windows server that is running Spamfilter ISP and again (carefully) followed the instructions from http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=3255" CLASS="ASPForums" TITLE="WARNING: URL created by poster. - http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=3255" CLASS="ASPForums" TITLE="WARNING: URL created by poster. - http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=3255

I created the database spamfilter -> recreated the new ODBC connector to connect to localhost -> build the string -> tested OK -> ran "Step1" -> everything OK -> ran "Step 2" -> received messaged about incomplete tables; Step 2b was now listed -> run "Step 2b" choose Update and it kills the Spamfilter ISP service.

Same problem connecting to 2 separate databases - help?

Thanks

Robert

 

 

 

 

 

Posted By: Guests
Date Posted: 23 November 2004 at 2:06pm

More information....

I manually ran the MySql script in "d:\Spamfilter\database\MySql.sql" - the tables added in fine but when I test it still gives the "Step 2b" update issue. 

Is there a script to manually add the missing tables?

 

Posted By: Guests
Date Posted: 23 November 2004 at 2:47pm

Why "Step 2b" doesn't work....

I ran Spamfilter on my local worksation (not as a service) and I get the exact same results except now I can see why the service is failing.

When I connect to the MySQL database and I get to "Step 2b" I get a Pop-Up Windows error message "Cannot Open File """". The System can not find the path specified"

 

Robert

 

 

Posted By: Guests
Date Posted: 23 November 2004 at 3:44pm

More info...

I have luckily saved all my old versions of SpamFilter ISP and I have tried using an older version to create the tables and the error is remarkably consistent - it simply can't find the file to complete "Step 2b".

To figure out which tables are missing I started SpamFilter with the incomplete MySQL database - a portion of the logfile is posted below...

Robert

11/23/04 13:40:51:918 -- SpamFilter ISP v2.1.1.385 Listening on all IPs port 25
11/23/04 13:40:52:008 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:038 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:068 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:068 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:088 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:108 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:118 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:128 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:128 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:138 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:149 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:159 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:169 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:179 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:52:189 -- Error updading/checking tblRejectCodes - [MySQL][ODBC 3.51 Driver][mysqld-3.23.49]Table 'spamfilter.tblRejectCodes' doesn't exist
11/23/04 13:40:53:260 -- Starting to process queue directory...
11/23/04 13:40:53:310 -- (3344) SpamFilterForm - Begin loading corpus.db
11/23/04 13:40:53:310 -- (6892) BayesianThread starting
11/23/04 13:40:53:310 -- (6892) Begin Sync Corpus.db
11/23/04 13:40:53:310 -- (6892) Sync Corpus.db pass 0a
11/23/04 13:40:53:310 -- (6892) Sync Corpus.db pass 0b
11/23/04 13:40:53:310 -- (6892) Sync Corpus.db pass 0c
11/23/04 13:40:53:310 -- (6892) Sync Corpus.db - 0 - 0
11/23/04 13:40:53:310 -- (6892) Sync Corpus.db pass 1 (0)
11/23/04 13:40:53:310 -- (6892) Sync Corpus.db pass 2 (0)
11/23/04 13:40:53:310 -- (6892) Sync Corpus.db pass 3 (0)
11/23/04 13:40:53:310 -- (6892) Sync Corpus.db pass 4 (0)
11/23/04 13:40:53:310 -- (6892) skipping Corpus.db save - tmp files are 0KB in size
11/23/04 13:40:53:310 -- (6892) Sync Corpus.db pass 7 (0)
11/23/04 13:40:53:310 -- (6892) Sync Corpus.db pass 8 (0)
11/23/04 13:40:53:310 -- (6892) End Sync Corpus.db (0)
11/23/04 13:40:53:320 -- (3344) SpamFilterForm - End loading corpus.db
11/23/04 13:40:54:312 -- (7428) BayesianThread starting

Posted By: LogSat
Date Posted: 23 November 2004 at 4:04pm
Robert,

Can you please try to install/reinstall the latest MDAC data components from http://www.microsoft.com/data?" CLASS="ASPForums" TITLE="WARNING: URL created by poster. - http://www.microsoft.com/data? Even if the latest version is already installed, we've seen several instances where other applications will overwite some newer DLL's with older one.

Could you please also email us at support@logsat.com a copy of your SpamFilter.ini file?

Roberto F. LogSat Software


Print Page | Close Window