error while trying to quarantine Attachements |
Post Reply 
|
| Author | |
Richard 
Guest Group 
|
 Post Options
 Thanks(0)
 Quote Reply
 Topic: error while trying to quarantine AttachementsPosted: 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
|
|
 |
|
|
bpogue99
Groupie 
Joined: 26 January 2005 Status: Offline Points: 59 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
Richard
Guest Group
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
Richard
Guest Group
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
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.141 seconds.