August 10, 2006

packet size?

On attempting to add the latest spam infestation to the blacklist I got this message:

An error occurred:

Could not save your blacklist data: Got a packet bigger than 'max_allowed_packet'

What next?

Posted by fiffdimension at August 10, 2006 08:07 AM | TrackBack


This a repeat of the problem described on the 8th July. Basically mysql is complaining that the list is too long.

If you're getting a dump of spam (as per the last few days) and the list is full open mt-blacklist.cgi and select the list option from the menu buttons at the top of the page. (The despam email will open mt-blacklist.cgi in order to do the necessary.)

Then you can delete a couple of unlikely-looking entries and add something which will block the current deluge.

One point about adding entries, add as wide a pattern as you can without getting everything. So, for example, to block all variants, you'd put furniture One word of warning, mt-blacklist interprets a "." as 'any character'. To make mt-blacklist understand you really mean a ".", you need to escape the ".". This means you write it with a backslash in front of it (that is, furniture 10\.com).

Note: I added spaces to the urls above because mt-blacklist was blocking my comment .

Posted by: .carla at August 11, 2006 11:32 AM