Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Mysql errors after keyword found
  FAQ FAQ  Forum Search   Register Register  Login Login

Mysql errors after keyword found

 Post Reply Post Reply
Author
DavidF View Drop Down
Newbie
Newbie
Avatar

Joined: 07 September 2006
Location: New Zealand
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote DavidF Quote  Post ReplyReply Direct Link To This Post Topic: Mysql errors after keyword found
    Posted: 09 November 2006 at 7:26pm
Hi

We have been experiencing problems with the database connection to mysql after keywords are detected in messages. I first noticed the problem after doubling the default keyword filter size limit. Putting the limit size back made a big difference to the frequency however we are still getting the error.

It also occurs when a banned attachment is blocked. I suspect it is something to do with the size of the attachment that is being written to the quarantine DB. The following is a sample of the errors received from our log:
=============================
11/08/06 08:50:50:582 -- (9760) Found Keywords: [Found prohibited attachment: Judgement1.wmv]
11/08/06 08:50:50:582 -- (9760) EMail from user@address.co.nz to other@other.co.nz, other1@other.co.nz matches content filter rules - rejected.
11/08/06 08:50:50:941 -- (9760) Created thread (944) to add email to quarantine
11/08/06 08:50:51:347 -- (9760) Blacklist cache - Added 210.54.141.243 to limbo
11/08/06 08:50:51:988 -- (9760) SFDB - Added 210.54.141.243 - Response: Error=0
11/08/06 08:50:51:988 -- (9760) Disconnect
11/08/06 08:50:52:316 -- (944) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]Lost connection to MySQL server during query ( 83 84 85 86 86a 86b 86c 87 88 89 90 91)

=================================
11/10/06 08:50:51:238 -- (2328) Connection from: 207.46.50.72  -  Originating country : United States
11/10/06 08:50:52:613 -- (2328) Resolving 207.46.50.72 - mail-sin1.microsoft.com
11/10/06 08:50:53:457 -- (2328) found SPF record for microsoft.com: v=spf1 mx include:_spf-a.microsoft.com include:_spf-b.microsoft.com include:_spf-c.microsoft.com ~all
11/10/06 08:50:54:019 -- (2328) found SPF record for _spf-a.microsoft.com: v=spf1 ip4:213.199.128.139 ip4:213.199.128.145 ip4:207.46.50.72 ip4:207.46.50.82 a:delivery.pens.microsoft.com a:mh.microsoft.m0.net mx:microsoft.com ~all
11/10/06 08:50:54:019 -- (2328) SPF query result: pass
11/10/06 08:50:54:019 -- (2328) - SPF analysis for _spf-a.microsoft.com done: - pass
11/10/06 08:50:54:019 -- (2328) SPF query result: pass
11/10/06 08:50:54:019 -- (2328) - SPF analysis for microsoft.com done: - pass
11/10/06 08:50:54:019 -- (2328) RCPT TO: user@address.co.nz accepted
11/10/06 08:51:02:988 -- (2328) Found Keywords: [((?i)(\boem\b))]
11/10/06 08:51:02:988 -- (2328) EMail from user@address.co.nz to other@other.co.nz matches content filter rules - rejected.
11/10/06 08:51:03:035 -- (2328) Created thread (9752) to add email to quarantine
11/10/06 08:51:03:316 -- (9752) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]Lost connection to MySQL server during query ( 83 84 85 86 86a 86b 86c 87 88 89 90 91)
============================
Has anyone come across this problem or have any ideas for a resolution? At the moment restarting SF seems to be the only way to reconnect to the quarantine. Unfortunately if the error is not seen to occur a lot of email doesn't make it to the quarantine.

Regards
David Fox
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 14 November 2006 at 12:21am
David,

You may be exceeding one of MySQL's default limits when SpamFilter tries to upload large files.

Changing the "max_allowed_packet" setting in MySQL (it should default to 1MB) to a higher value, ex 16MB, could solve the issue.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
DavidF View Drop Down
Newbie
Newbie
Avatar

Joined: 07 September 2006
Location: New Zealand
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote DavidF Quote  Post ReplyReply Direct Link To This Post Posted: 14 November 2006 at 4:29pm
Roberto

Thanks very much for the info. I have modified the settings and will see how it goes.

Regards
David
Back to Top
DavidF View Drop Down
Newbie
Newbie
Avatar

Joined: 07 September 2006
Location: New Zealand
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote DavidF Quote  Post ReplyReply Direct Link To This Post Posted: 05 December 2006 at 12:40am
Roberto

Just a note to let you know that we haven't had a problem with mySQL going offline since making the changes to the allowed packet size.

Thanks very much for your help.

Regards
David
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.063 seconds.