Thread: Spam filtering for mailing lists

Spam filtering for mailing lists

From
"Greg Sabino Mullane"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Could we implement some sort of spam filtering on the mail server
for gborg? The dbdpg-general list is being flooded with spam, and
even a simple SpamAssassin filter with a relatively high number
would drop the number by quite a bit. I'm having to clear 100+
messages out of the mailman queue every few days now.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200601270750
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFD2hcsvJuQZxSWSsgRAjDzAKCg5BJdOatAC9sH6+fkW3/Ba/uGqgCeODJ3
pamBQWb23Qrz1qalt9vkMlU=
=ilgF
-----END PGP SIGNATURE-----



Re: Spam filtering for mailing lists

From
Peter Eisentraut
Date:
Am Freitag, 27. Januar 2006 13:56 schrieb Greg Sabino Mullane:
> Could we implement some sort of spam filtering on the mail server
> for gborg? The dbdpg-general list is being flooded with spam, and
> even a simple SpamAssassin filter with a relatively high number
> would drop the number by quite a bit. I'm having to clear 100+
> messages out of the mailman queue every few days now.

What's the problem?  Just leave them there and let them expire.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: Spam filtering for mailing lists

From
"Greg Sabino Mullane"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> What's the problem?  Just leave them there and let them expire.

(1) As far as I know, they don't "expire".

(2) There are legitimate messages that need to be approved
occasionally. If there weren't, we could simply drop all
messages from non-subscribers.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200601270848
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8





-----BEGIN PGP SIGNATURE-----

iD8DBQFD2iS5vJuQZxSWSsgRAmuWAJ463YX4FvUBvaZUH5MiDji6tDZ6LQCgyMVw
EuU0JRP67eI6nKlZdvc39VI=
=Wc5M
-----END PGP SIGNATURE-----



Re: Spam filtering for mailing lists

From
"Marc G. Fournier"
Date:
Done ... email now goes throgh both GreyListing *and* Amavisd, which is
setup for anti-spam and virus ...

On Fri, 27 Jan 2006, Greg Sabino Mullane wrote:

>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Could we implement some sort of spam filtering on the mail server
> for gborg? The dbdpg-general list is being flooded with spam, and
> even a simple SpamAssassin filter with a relatively high number
> would drop the number by quite a bit. I'm having to clear 100+
> messages out of the mailman queue every few days now.
>
> - --
> Greg Sabino Mullane greg@turnstep.com
> PGP Key: 0x14964AC8 200601270750
> http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
> -----BEGIN PGP SIGNATURE-----
>
> iD8DBQFD2hcsvJuQZxSWSsgRAjDzAKCg5BJdOatAC9sH6+fkW3/Ba/uGqgCeODJ3
> pamBQWb23Qrz1qalt9vkMlU=
> =ilgF
> -----END PGP SIGNATURE-----
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Re: Spam filtering for mailing lists

From
"Marc G. Fournier"
Date:
On Fri, 27 Jan 2006, Greg Sabino Mullane wrote:

>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
>> What's the problem?  Just leave them there and let them expire.
>
> (1) As far as I know, they don't "expire".
>
> (2) There are legitimate messages that need to be approved
> occasionally. If there weren't, we could simply drop all
> messages from non-subscribers.

Ummm, one thing to note, we don't have spamassassin set to auto-kill
anything, you have to setup some sort of filter on your end for that ...
with Majordomo2, we have it as an access_rule, but I don't know how to do
it with mailman ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Re: Spam filtering for mailing lists

From
Kenneth Marshall
Date:
Speaking of subscribing, how does one subscribe to avoid the
moderation delay? I receive the mailings but all of my postings
are delayed.

Ken

On Fri, Jan 27, 2006 at 01:50:13PM -0000, Greg Sabino Mullane wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> > What's the problem?  Just leave them there and let them expire.
>
> (1) As far as I know, they don't "expire".
>
> (2) There are legitimate messages that need to be approved
> occasionally. If there weren't, we could simply drop all
> messages from non-subscribers.
>
> - --
> Greg Sabino Mullane greg@turnstep.com
> PGP Key: 0x14964AC8 200601270848
> http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
>
>
>
>
>
> -----BEGIN PGP SIGNATURE-----
>
> iD8DBQFD2iS5vJuQZxSWSsgRAmuWAJ463YX4FvUBvaZUH5MiDji6tDZ6LQCgyMVw
> EuU0JRP67eI6nKlZdvc39VI=
> =Wc5M
> -----END PGP SIGNATURE-----
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

Re: Spam filtering for mailing lists

From
"Greg Sabino Mullane"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> Done ... email now goes throgh both GreyListing *and* Amavisd, which is
> setup for anti-spam and virus ...

Thank you much.

> Ummm, one thing to note, we don't have spamassassin set to auto-kill
> anything, you have to setup some sort of filter on your end for that ...
> with Majordomo2, we have it as an access_rule, but I don't know how to do
> it with mailman .

Mailman has a way to do this. If not, I'll let you know. :)

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200601270929
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFD2i6lvJuQZxSWSsgRApBLAJ4h/iEtBaEkr2rK5FtTUNsur8VLnwCgq9BH
b3bv7/k36Pr+psGJRm3s+3E=
=ve/E
-----END PGP SIGNATURE-----



Re: Spam filtering for mailing lists

From
"Larry Rosenman"
Date:
Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
>> Done ... email now goes throgh both GreyListing *and* Amavisd, which
>> is setup for anti-spam and virus ...
>
> Thank you much.
>
>> Ummm, one thing to note, we don't have spamassassin set to auto-kill
>> anything, you have to setup some sort of filter on your end for that
>> ... with Majordomo2, we have it as an access_rule, but I don't know
>> how to do it with mailman .
>
> Mailman has a way to do this. If not, I'll let you know. :)
>

http://www.jamesh.id.au/articles/mailman-spamassassin/

and what version of Mailman?

LER

--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 512-248-2683                 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893


Re: Spam filtering for mailing lists

From
"Greg Sabino Mullane"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> Speaking of subscribing, how does one subscribe to avoid the
> moderation delay? I receive the mailings but all of my postings
> are delayed.

The information on the dbdpg-general list, including how to subscribe,
can be found here:

http://gborg.postgresql.org/mailman/listinfo/dbdpg-general

If you have any problems subscribing, please email me off-list.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200601271000
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFD2jW4vJuQZxSWSsgRAkPCAKDgwwbWZHxKLRIYP+cEGE8G1Z4ghgCg2al+
pTGlxlrJlrOvTkEHmci3im8=
=qrwl
-----END PGP SIGNATURE-----



Re: Spam filtering for mailing lists

From
Bruce Momjian
Date:
Marc G. Fournier wrote:
> On Fri, 27 Jan 2006, Greg Sabino Mullane wrote:
>
> >
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> >
> >> What's the problem?  Just leave them there and let them expire.
> >
> > (1) As far as I know, they don't "expire".
> >
> > (2) There are legitimate messages that need to be approved
> > occasionally. If there weren't, we could simply drop all
> > messages from non-subscribers.
>
> Ummm, one thing to note, we don't have spamassassin set to auto-kill
> anything, you have to setup some sort of filter on your end for that ...
> with Majordomo2, we have it as an access_rule, but I don't know how to do
> it with mailman ...

Yes, I noticed that while spamassasin marks email as spam, it still
forwards it to the recipient.  I had to add a rule in my spamassasin
filter to delete those marked as spam.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: Spam filtering for mailing lists

From
"Greg Sabino Mullane"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


>> Ummm, one thing to note, we don't have spamassassin set to auto-kill
>> anything, you have to setup some sort of filter on your end for that ...
>> with Majordomo2, we have it as an access_rule, but I don't know how to do
>> it with mailman ...

I've got it working within Mailman, and it seems to be working well: the
queue this morning has 2 spams and 1 real message, which is a vast improvement
as the old ratio was more like 70:1.

The dbdpg-commits list still seems stuck, however. I'm ccing the admin
for that list as well.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200602011046
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFD4NgfvJuQZxSWSsgRAjrgAJoDFtpvlTVgJhEJZFwgoJgig3tXgACg/Aai
LEfNWPDs0voUizPnGYyfILU=
=7eDn
-----END PGP SIGNATURE-----