Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Error occurred during TAddToQuarantineThread when
  FAQ FAQ  Forum Search   Register Register  Login Login

Error occurred during TAddToQuarantineThread when

 Post Reply Post Reply
Author
Stupid View Drop Down
Senior Member
Senior Member


Joined: 28 November 2005
Status: Offline
Points: 127
Post Options Post Options   Thanks (0) Thanks(0)   Quote Stupid Quote  Post ReplyReply Direct Link To This Post Topic: Error occurred during TAddToQuarantineThread when
    Posted: 04 December 2007 at 9:51am
Any idea why  I am constantly getting this Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)


***************
12/03/07 23:59:46:249 -- (29376) Running TTerminateIdleThreads - SFTC=1 - SFFC=1
12/03/07 23:59:46:249 -- (30068) Blacklist cache - starting cleanup
12/03/07 23:59:46:249 -- (29376) Running TTerminateIdleThreads SSL - SFTC=0 - SFFC=1
12/03/07 23:59:46:249 -- (30076) Starting to process quarantine directory...
12/03/07 23:59:46:249 -- (30068) Blacklist cache - removed IP 222.124.65.204 from limbo during cleanup
12/03/07 23:59:46:249 -- (30068) Blacklist cache - removed IP 67.163.241.33 from cache during cleanup
12/03/07 23:59:46:249 -- (30068) Blacklist cache - removed IP 189.138.161.167 from cache during cleanup
12/03/07 23:59:46:249 -- (30068) Blacklist cache - removed IP 222.232.234.47 from limbo during cleanup
12/03/07 23:59:46:249 -- (30120) Adding to Quarantine file:Qrt30F4.tmp.queued
12/03/07 23:59:46:265 -- (26796) Adding to Quarantine file:Qrt41EF.tmp.queued
12/03/07 23:59:46:327 -- (30616) SpamFilterForm - Begin loading corpus.db
12/03/07 23:59:46:358 -- (29576) Adding to Quarantine file:Qrt4390.tmp.queued
12/03/07 23:59:46:483 -- (27260) Adding to Quarantine file:Qrt48D4.tmp.queued
12/03/07 23:59:46:515 -- (30120) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:46:546 -- (29820) Adding to Quarantine file:Qrt61D4.tmp.queued
12/03/07 23:59:46:593 -- (29996) Adding to Quarantine file:Qrt5405.tmp.queued
12/03/07 23:59:46:640 -- (20852) Adding to Quarantine file:QrtC21B.tmp.queued
12/03/07 23:59:46:671 -- (34420) Adding to Quarantine file:Qrt50E8.tmp.queued
12/03/07 23:59:46:671 -- (32532) Adding to Quarantine file:Qrt7B3C.tmp.queued
12/03/07 23:59:46:671 -- (26796) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:46:765 -- (28724) Adding to Quarantine file:QrtA31A.tmp.queued
12/03/07 23:59:46:796 -- (29664) Adding to Quarantine file:QrtE2CB.tmp.queued
12/03/07 23:59:46:952 -- (24784) Adding to Quarantine file:QrtDEEB.tmp.queued
12/03/07 23:59:46:952 -- (29820) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:46:983 -- (31848) Adding to Quarantine file:QrtFDE0.tmp.queued
12/03/07 23:59:47:062 -- (27260) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:47:077 -- (30616) TSpamFilterForm - Begin LoadFromFile for corpus.db (db.dat)
12/03/07 23:59:47:155 -- (30616) TSpamFilterForm - LoadFromFile for Corpus.db - copied db.dat -> IndF3F8.tmp
12/03/07 23:59:47:202 -- (32532) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:47:280 -- (30616) TSpamFilterForm - LoadFromFile for Corpus.db - copied db.dat.prb -> IndF3F9.tmp
12/03/07 23:59:47:452 -- (30616) TSpamFilterForm - LoadFromFile for Corpus.db - Reading Buffer in mem
12/03/07 23:59:47:593 -- (30616) TSpamFilterForm - LoadFromFile for Corpus.db - loaded files in memory - IndF3F8.tmp
12/03/07 23:59:47:702 -- (30616) TSpamFilterForm - LoadFromFile for Corpus.db - setting Buffer size to 11410077
12/03/07 23:59:47:718 -- (29664) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:47:983 -- (29996) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:47:983 -- (28724) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:54:155 -- (20852) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:54:155 -- (34420) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:54:155 -- (29576) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:54:155 -- (31848) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:54:155 -- (29788) Reloading file for tblBL_HoneypotBlockedIPs: HoneypotBlockedIPs.txt (919790 bytes)
12/03/07 23:59:54:155 -- (24784) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/03/07 23:59:54:155 -- (30616) TSpamFilterForm - LoadFromFile for Corpus.db - loaded files in memory - IndF3F9.tmp
12/03/07 23:59:54:155 -- (30616) TSpamFilterForm - End LoadFromFile for corpus.db (db.dat) (6874)
12/03/07 23:59:54:155 -- (30616) SpamFilterForm - End loading corpus.db
12/03/07 23:59:54:921 -- (27124) Received RCPT TO: 3djavier.maza@mycompany.com
12/03/07 23:59:55:015 -- (27124) Resolving 189.164.74.150 - dsl-189-164-74-150.prod-infinitum.com.mx
12/03/07 23:59:55:015 -- (27124) - EMail To is in honeypot emails -
12/03/07 23:59:55:749 -- (27124) - Added 189.164.74.150 to honeypot blacklist
12/03/07 23:59:55:749 -- (27124) 189.164.74.150 - Mail from: sukumar@der.com To: 3djavier.maza@mycompany.com will be rejected
12/03/07 23:59:59:452 -- (27124) Starting quarantine procedures
12/03/07 23:59:59:452 -- (27124) Created thread (23368) to add email to quarantine
12/03/07 23:59:59:452 -- (27124) Starting bayesian procedures
12/03/07 23:59:59:452 -- (23368) Adding to Quarantine file:QrtF3FB.tmp
12/03/07 23:59:59:499 -- (23368) EMail from sukumar@der.com to 3djavier.maza@mycompany.com was received and quarantined. Size: 2 KB, 2048 bytes
12/03/07 23:59:59:499 -- (23904) Time to add Msg to Bayes corpus:0
12/04/07 00:00:02:249 -- (29236) Connection from: 189.181.229.87  -  Originating country : Mexico
12/04/07 00:00:02:608 -- (29236) Received MAIL FROM: <promociones@expopublicitas.com>
12/04/07 00:00:02:671 -- (29236) Received RCPT TO: javier.maza@mycompany.com
12/04/07 00:00:02:749 -- (29236) Resolving 189.181.229.87 - dsl-189-181-229-87.prod-infinitum.com.mx
12/04/07 00:00:02:890 -- (27072) Connection from: 88.204.209.218  -  Originating country : Kazakstan
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 04 December 2007 at 6:07pm
This posting should have the answer to the problem:

http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5868
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Stupid View Drop Down
Senior Member
Senior Member


Joined: 28 November 2005
Status: Offline
Points: 127
Post Options Post Options   Thanks (0) Thanks(0)   Quote Stupid Quote  Post ReplyReply Direct Link To This Post Posted: 05 December 2007 at 10:47am
Where do I set this value in MySQL? Couldn't find it in Google.
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 05 December 2007 at 6:26pm
If you're using the "MySQL Administrator" tools, there should be an option for the "Max Packet Size" in the graphical user interface, often under the "Advanced Networking" options.

You can also find (or set) the value by manually editing the "my.cnf" configuration file for MySQL, and setting the value in the [mysqld] section with something like:

[mysqld]
#Max packetlength to send/receive from to server.
max_allowed_packet=16M
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Stupid View Drop Down
Senior Member
Senior Member


Joined: 28 November 2005
Status: Offline
Points: 127
Post Options Post Options   Thanks (0) Thanks(0)   Quote Stupid Quote  Post ReplyReply Direct Link To This Post Posted: 07 December 2007 at 4:54pm
don't have my.cnf file.
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 08 December 2007 at 5:57pm
The specific locations (and sometimes the names) of the config files vary depending on the platform (Windows, Mac OS X, Linux, etc) where MySQL is installed on. I'd recommend using the MySQL Administration tool (which is available for all those platforms) to tweak the MySQL configuration, so that you may "graphically" change that setting.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Stupid View Drop Down
Senior Member
Senior Member


Joined: 28 November 2005
Status: Offline
Points: 127
Post Options Post Options   Thanks (0) Thanks(0)   Quote Stupid Quote  Post ReplyReply Direct Link To This Post Posted: 10 December 2007 at 4:47pm
Found it, thanks, Roberto.

MySQL Admin for Windows, Advanced Networking, Max. packet size.


Edited by Stupid - 10 December 2007 at 4:59pm
Back to Top
Stupid View Drop Down
Senior Member
Senior Member


Joined: 28 November 2005
Status: Offline
Points: 127
Post Options Post Options   Thanks (0) Thanks(0)   Quote Stupid Quote  Post ReplyReply Direct Link To This Post Posted: 12 December 2007 at 4:44pm
I am still having big problems with this after I increased the max packet size  to 16MB.


12/12/07 14:34:49:236 -- (35716) Starting to process quarantine directory...
12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 74.127.6.175 from limbo during cleanup
12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 201.233.45.56 from limbo during cleanup
12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 81.203.73.144 from limbo during cleanup
12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 77.180.25.113 from limbo during cleanup
12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 84.58.206.218 from limbo during cleanup
12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 78.54.212.192 from limbo during cleanup
12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 79.184.37.204 from limbo during cleanup
12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 96.227.73.18 from limbo during cleanup
12/12/07 14:34:49:251 -- (42444) Adding to Quarantine file:Qrt1711.tmp.queued
12/12/07 14:34:49:267 -- (45324) Adding to Quarantine file:Qrt1A18.tmp.queued
12/12/07 14:34:49:345 -- (44692) Received MAIL FROM: <montgomery@viquel.com>
12/12/07 14:34:49:392 -- (10700) Adding to Quarantine file:Qrt30F4.tmp.queued
12/12/07 14:34:49:439 -- (44308) Adding to Quarantine file:Qrt41EF.tmp.queued
12/12/07 14:34:49:439 -- (38684) Adding to Quarantine file:Qrt3CEA.tmp.queued
12/12/07 14:34:49:470 -- (26904) Adding to Quarantine file:Qrt4390.tmp.queued
12/12/07 14:34:49:548 -- (46848) Adding to Quarantine file:Qrt50E8.tmp.queued
12/12/07 14:34:49:626 -- (44692) Received RCPT TO: customer.servicen@mycompany.com
12/12/07 14:34:49:626 -- (42444) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:49:626 -- (5588) Adding to Quarantine file:Qrt7B3C.tmp.queued
12/12/07 14:34:49:783 -- (12076) Adding to Quarantine file:Qrt48D4.tmp.queued
12/12/07 14:34:49:783 -- (8160) Adding to Quarantine file:Qrt61D4.tmp.queued
12/12/07 14:34:49:798 -- (44308) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:49:783 -- (38248) Adding to Quarantine file:Qrt9355.tmp.queued
12/12/07 14:34:49:798 -- (5588) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:49:829 -- (9680) Adding to Quarantine file:Qrt5405.tmp.queued
12/12/07 14:34:50:033 -- (10700) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:50:142 -- (38248) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:50:236 -- (8160) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:50:267 -- (12744) Adding to Quarantine file:QrtA31A.tmp.queued
12/12/07 14:34:50:283 -- (38684) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:50:283 -- (1988) Adding to Quarantine file:Qrt9B89.tmp.queued
12/12/07 14:34:50:283 -- (9680) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:50:564 -- (12076) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:50:751 -- (17372) Adding to Quarantine file:QrtC21B.tmp.queued
12/12/07 14:34:50:845 -- (12744) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:50:939 -- (17776) Adding to Quarantine file:QrtDEEB.tmp.queued
12/12/07 14:34:51:033 -- (2392) Sync Corpus.db pass 0a
12/12/07 14:34:51:033 -- (2392) Sync Corpus.db - 629439 - 349
12/12/07 14:34:51:017 -- (2392) Begin Sync Corpus.db
12/12/07 14:34:51:064 -- (2392) Sync Corpus.db pass 0c
12/12/07 14:34:51:267 -- (26904) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:51:298 -- (1988) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:51:298 -- (46848) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:51:345 -- (2392) Sync Corpus.db pass 0b
12/12/07 14:34:51:345 -- (6388) Adding to Quarantine file:QrtE2CB.tmp.queued
12/12/07 14:34:51:345 -- (45324) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:51:345 -- (45932) Adding to Quarantine file:QrtFDE0.tmp.queued
12/12/07 14:34:51:408 -- (29788) Adding to Quarantine file:QrtE17A.tmp.queued
12/12/07 14:34:51:486 -- (17372) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:51:829 -- (6388) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:51:939 -- (29788) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:51:970 -- (17776) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
12/12/07 14:34:52:345 -- (33308) Reloading file for tblBL_HoneypotBlockedIPs: HoneypotBlockedIPs.txt (1183011 bytes)
12/12/07 14:34:52:595 -- (45932) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 12 December 2007 at 6:37pm
The same error "Got a packet bigger than 'max_allowed_packet'" is being logged, which probably indicates the received emails are still too large for MySQL. Can you please zip and email us the section of SpamFilter's activity logfile for 12/12/07, for the entries between 14:00 and 15:00?
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Stupid View Drop Down
Senior Member
Senior Member


Joined: 28 November 2005
Status: Offline
Points: 127
Post Options Post Options   Thanks (0) Thanks(0)   Quote Stupid Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2007 at 9:06am
log sent
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2007 at 11:17pm
Yeap, we got them, and we replied via email that same evening on 12/13/07 :-) I'm going to re-send you the partial response via PM.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 16 December 2007 at 10:31pm
Well... We received all the tmp files, and while yes, they are all below 16MB in size, they are also all over 1MB. This could indicate that the setting you changed in MySQL did not take effect. Have you restarted MySQL after making the change? Could you verify that the MySQL Administration tools have actually made the change in the .ini file in MySQL? Unfortunately I'll have to refer you to MySQL's documentation to locate the proper file, as each installation can be different, and both the filename and the directory in which it's located can be changed depending on how MySQL has been installed. 
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Stupid View Drop Down
Senior Member
Senior Member


Joined: 28 November 2005
Status: Offline
Points: 127
Post Options Post Options   Thanks (0) Thanks(0)   Quote Stupid Quote  Post ReplyReply Direct Link To This Post Posted: 16 December 2007 at 11:31pm
I restarted and will see how it works from now on. I think you are right on the restarting thing!
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.078 seconds.