Print Page | Close Window

Quarantine DB problems

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=6307
Printed Date: 30 January 2025 at 9:39pm


Topic: Quarantine DB problems
Posted By: Lee_H
Subject: Quarantine DB problems
Date Posted: 27 November 2007 at 10:34pm
Question,
 
Why does the SpamFilter program stop talking to the quarantine DB server whenever there is an interuption in communication? When I reboot the quarantine server or if the connection is lost for any reason SF doesnt recover unitl I restart the service. Is there a setting that would bake it more reliable?
 
Lee


Replies:
Posted By: Desperado
Date Posted: 28 November 2007 at 12:16am
Lee,
 
What version are you running?  The SpamFilter should (and for me does) reconnect if the SQL server goes off line and then comes back. In addition to that, during the down time, the SpamFilter will spool "spam" to disk and then fulsh out to the database once the db server becoms available again.


-------------
The Desperado
Dan Seligmann.
Work: http://www.mags.net
Personal: http://www.desperado.com

Posted By: Lee_H
Date Posted: 28 November 2007 at 10:05am
3.1.3.607

Posted By: Desperado
Date Posted: 28 November 2007 at 11:16am
Lee,
 
The behavior I discussed above reflects a much newer build.  I am not sure when the SQL re-attach feature was added but that would explain the issue you are having.


-------------
The Desperado
Dan Seligmann.
Work: http://www.mags.net
Personal: http://www.desperado.com

Posted By: LogSat
Date Posted: 28 November 2007 at 2:06pm
We have seen some cases where MySQL (not Microsoft SQL Server) is not allowing automatic reconnections by SpamFilter when they are dropped. In this case, changing the setting for the "Enable Auto Reconnect" option in the Advanced properties of the MySQL drivers has sometimes solved the issue.

-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP


Print Page | Close Window