Spam Filter ISP Support - error while trying to quarantine Attachements

error while trying to quarantine Attachements

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=4421
Printed Date: 28 November 2025 at 2:59pm

Topic: error while trying to quarantine Attachements

Posted By: Guests
Subject: error while trying to quarantine Attachements
Date Posted: 13 October 2004 at 10:30am

For some strange reason, I have developed an issue with large attachements. If I sent a file under 1 meg, it seems to work fine. Over 1 meg, I get the error below. I never noticed the error before, I suspect it appear after doing a recient update.

Exception occurred during RECEIVEMESSAGE: [MySQL][ODBC 3.51 Driver][mysqld-4.0.21-nt]Lost connection to MySQL server during query

Replies:

Posted By: bpogue99
Date Posted: 15 October 2004 at 11:24am

This looks more like a problem with MySQL that Spam Filter. Often times I find that MySQL drops the tblmsgs.myd file for some reason. I've never been able to figure out why it does that, but once it does, the quarantine will stop. Unless you have a saved copy of the original MYD file you'll have to rebuild the database. Be sure to save a copy of all the tables, clean and empty, if you rebuild, that way, next time, if something happens, just shutdown mysql, copy the clean databases, start mysql... easy and quick.

If you find that MySQL is running and that the databases are OK, but still receive this message, let us know.

Posted By: Guests
Date Posted: 16 October 2004 at 10:24am

I took another PC, loaded MYSQL, Loaded the ODBC Driver, Loaded spamfilter 2.0.1.302 (One of the first versions that I had setup, had working). Got things up and running, then attempted to send an attachement over 1 meg, and got the SAME problem. I sent an attachement of about 600K, and it worked fine.

The Error:

[MySQL][ODBC 3.51 Driver][mysqld-4.0.21-nt]Lost connection to MySQL server during query

I have not idea where I have gone astray, except maybe in my ODBC driver, or the particular version of mysql. I am attempting to find older versions of each of them so I can get back to the point that I thought things were working fine.

Posted By: Guests
Date Posted: 18 October 2004 at 3:54pm

Well, I don't know why I developed this Problem, however I think I have it solved. I assumed the problem was between the ODBC driver and the MYSQL database. So I built a test system and placed MYSQL on another PC. I sent a file under 1 megs, and it worked fine. I sent another file over 1 meg, and it failed with a different error. This time it said the file was bigger then the max_allowed_packet. I looked at the Database with a MYSQL administration tool, and found the max_allowed_packet setting in the variable list, and it was set to 1024K (I think a default value for MYSQL 4 or newer?). After a bit of work, I found the right command line to change the value (for mysql 4.0.X or better), the command is:

mysql> set global max_allowed_packet=16777216 \g

After this, I sent an attachement over 1 meg through SPAMFILTER, and it quarantined it no problem. Now all I need to do is find out where to put the command so it sets the value evertime the Server restarts.

I hope this helps anybody else who runs into this.