Quarantine DB problems |
Post Reply 
|
| Author | |
Lee_H 
Newbie 
Joined: 29 November 2006 Location: United States Status: Offline Points: 7 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Quarantine DB problemsPosted: 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
|
|
 |
|
|
Desperado
Senior Member 
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
Lee_H
Newbie
Joined: 29 November 2006 Location: United States Status: Offline Points: 7 |
Post Options
Thanks(0)
Quote Reply
Posted: 28 November 2007 at 10:05am |
|
3.1.3.607
|
|
|
|
|
Desperado
Senior Member
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.234 seconds.