The mailing list for listmasters using Sympa

[Amos <address@concealed>]

There's nothing in the postfix queues, which leads me to believe it's in one of the batch processing tables in the Sympa db.  For now I put something

header_checks       = pcre:$config_directory/header-checks.pcre

to DISCARD messages that match the sender in question.  They are coming from postdrop connections, not from SMTP, so once again I think it's coming from the Sympa db.

Anyway, that crude, brutal, but effect postfix hack is working to at least halt the mail from filling up people's inboxes.  Now I guess I just wait until Sympa has cleared out that table....

On Tue, Jul 19, 2011 at 9:17 PM, Malcolm Waltz <address@concealed> wrote:

Working on the MTA queue might help (if you haven't already).  If you are using postfix, you could do something like this to put the relevant messages on hold:

mailq | tail +2 | grep -v '^ *(' | awk  'BEGIN { RS = "" } { if ($7 == "address@concealed") print $1 }'| tr -d '*!' | postsuper -h -

mailq | tail +2 | grep -v '^ *(' | awk  'BEGIN { RS = "" } { if ($8 == "address@concealed") print $1 }'| tr -d '*!' | postsuper -h -

 

Once you are sure you have put the right messages on hold, you could use the following command to purge them (or similar):

mailq | tail +2 | grep -v '^ *(' | awk  'BEGIN { RS = "" } { print $1 }'| perl -pi -e 'if(/(^\S+)\!$/){$_="$1\n"}else{$_=undef}' | postsuper -d -

 

The above commands could be adapted for sendmail as well (use the mv command to move the d* and q* files, in pairs, out of the appropriate queue directory).

 

Here's a couple relevant pages I found while Googling:

http://ramnik.net/wp/?p=5

http://www.faqforge.com/tag/postfix/

 

 

From: address@concealed [mailto:address@concealed] On Behalf Of Amos
Sent: Tuesday, July 19, 2011 6:58 PM
To: address@concealed
Subject: [sympa-users] spam flood

 

Well, due to some unpleasant circumstances, one of our lists got hammered with thousands of mail.  I'm trying to cut-off further delivery of mail out of this list.  I even removed and purged the list.  However, mail is still coming out from this list.  My guess is that the internal queue/db still have tons of mail.  However, how do I clear this out?  I want to obliterate all artifacts of this list from our server!