Re: This mail list and its policies - Mailing list pgsql-general

From Bruce Momjian
Subject Re: This mail list and its policies
Date
Msg-id 200309241611.h8OGBTr11575@candle.pha.pa.us
Whole thread Raw
In response to Re: This mail list and its policies  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> nolan@celery.tssi.com writes:
> > Also, I DO run spamassassin here, and it is finding only perhaps 10-20%
> > of the copies of the most recent worm.  I think it sends out copies that
> > are sufficiently different from each other that it bypasses all the
> > checks, including a Bayesian filter.
>
> Hmm.  I've had no trouble filtering the actual worm (I filter using a
> pattern that looks for the first few bytes of a base64-encoded Windows
> executable file).  The only copies that were getting as far as my spam
> inbox were ones that had had the executable file removed by various
> "helpful" filtering programs.

Rather than configuring my filter for every virus, I just block evil
attachments via procmail:

    * ^(Content-Type: [^;]*;|       )? *(file)?name="?[^"]*\.(exe|com|pif|scr|bat)"?$

One interesting modification I have is that once I recieve a virus
email, I block further emails from that host.  Yea, it could block later
valid email, but preventing all those viruses from being downloaded
before being checked is worth it.

--
  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

pgsql-general by date:

Previous
From: "Daniel E. Fisher"
Date:
Subject: 7.3.3 again - fixed
Next
From: Russ Brown
Date:
Subject: Re: pltcl problem