RE: [Sqlgrey-users] [BUGFIX RELEASE] 1.6.6

[Steffen P. <swp...@am...>]

(The previous reply/posting was incomplete - sorry)

Hi Lionel,

I would like to thank you for the quick turn around fixing this issue. I
studied the changes, and the logic is now clear to me what happened (a
raise condition between the 2 grey listing servers, and a comparison of
the number of rows in the connect table for a given set that IF there
was more than 1 it would not return 'at least one entry' - it now does).
Thank you. =20

The user community of Amherst College has stated at several occassions
their appreciation of the reduction of incoming spam.

Our setup used to be 2 MailScanner servers -> Exchange. We then
purchased the Barracuda spam firewall and found that its spam flagging
capabilities are outstanding (with only one problem - still way too much
spam).

We then implemented postfix+rbl+sqlgrey -> barracuda -> exchange. Now
things look really good.=20

The postfix server processes 30-50 incoming messages/minute/server
continously. Using the averages we have the following breakdown:=20

22.85%	passed to barracuda for further processing

28.57% greylisted (we have close to 100k rows and growing in the
awl_from table and 1700 in domain_awl, we average about 20k rows in the
connect table, steady)

42.85% rejected due to RBLs

5.71% reject due to malformed sender domains and so on.

So, we have 77% of incoming stuff is spam of some kind. 23% is for real.
The barracudas used to flag the 77% of mail as spam since we had no RBL
filters, greylisting in place. Now the barracudas barely flag anything
spam.

In conclusion, I have to say this is a effective method against the
current state of the spam warfare.

Great job, Lionel.

Steffen


-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Lionel
Bouton
Sent: Wednesday, September 14, 2005 4:26 PM
To: sql...@li...
Subject: [Sqlgrey-users] [BUGFIX RELEASE] 1.6.6

Hi,

1.6.6 is on sourceforge, currently only the tar.bz2 is available. I'll
generate RPMS tomorrow.

http://sourceforge.net/project/showfiles.php?group_id=3D113566&package_id=
=3D
155492&release_id=3D356574

This should fix the bug found by Steffen (race condition in multiple
instances configs which leads to mail being delayed indefinitely).
There's a bugfix for the weekly stats that was waiting in the pipe too.

Lionl.


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server.
Download it for free - -and be entered to win a 42" plasma tv or your
very own Sony(tm)PSP.  Click here to play:
http://sourceforge.net/geronimo.php
_______________________________________________
Sqlgrey-users mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users