dbTalk Databases Forums  

META: Filtering viruses/worms

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss META: Filtering viruses/worms in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Greg Sabino Mullane
 
Posts: n/a

Default META: Filtering viruses/worms - 03-04-2004 , 05:42 AM







-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Quote:
X-Virus-Scanned: by amavisd-new at postgresql.org
Since "amavisd" does not appear to be catching the latest worm,
how about filtering on size? Anything, say, over 20K will be held
for approval. Here are the top posts by size to this list recently:

subject | whofrom | size
- -----------------------------------------------------------+--------------------------------------------------+-------
[GENERAL] Select for update, locks and transaction levels | "Nick Barr" <nick.barr (AT) webbased (DOT) co.uk> | 35107
[GENERAL] stacy | scrappy (AT) postgresql (DOT) org | 32648
[GENERAL] My photoalbum | scrappy (AT) postgresql (DOT) org | 32600
[GENERAL] stacy | scrappy (AT) PostgreSQL (DOT) org | 32467
[GENERAL] Weah, hello! :-) | scrappy (AT) postgresql (DOT) org | 29462
[GENERAL] Weeeeee! )) | scrappy (AT) postgresql (DOT) org | 29460
[GENERAL] Hey, ya! =)) | scrappy (AT) PostgreSQL (DOT) org | 29428
[GENERAL] | scrappy (AT) postgreSQL (DOT) org | 29305
[GENERAL] Hokki =) | scrappy (AT) postgresql (DOT) org | 28738
[GENERAL] | scrappy (AT) PostgreSQL (DOT) org | 28667
[GENERAL] help using arrays in a function | "Jennifer Lee" <jlee (AT) scri (DOT) sari.ac.uk> | 22774

Note that the first one is not a worm but 4k of message content with about 30k
of unnecessary HTML markup. Filtering such stuff would be alright with me too.

- --
Greg Sabino Mullane greg (AT) turnstep (DOT) com
PGP Key: 0x14964AC8 200403040640

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

iD8DBQFARxYmvJuQZxSWSsgRAvn2AJ47YY4gZKaISddB0i3/Ew8bZdPcygCfQOnB
1eknd99Tjp3j5+vwfpJ5NCk=
=coS2
-----END PGP SIGNATURE-----



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)



Reply With Quote
  #2  
Old   
Marc G. Fournier
 
Posts: n/a

Default Re: META: Filtering viruses/worms - 03-04-2004 , 08:04 AM






On Thu, 4 Mar 2004, Greg Sabino Mullane wrote:

Quote:
------------------------------------------------------------------------------
/usr/local/libexec/ppf_verify: pgp command failed

gpg: WARNING: using insecure memory!
gpg: please see http://www.gnupg.org/faq.html for more information
gpg: Signature made Thu Mar 4 07:42:30 2004 AST using DSA key ID 14964AC8
gpg: Can't check signature: public key not found
------------------------------------------------------------------------------


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


X-Virus-Scanned: by amavisd-new at postgresql.org

Since "amavisd" does not appear to be catching the latest worm,
how about filtering on size? Anything, say, over 20K will be held
for approval. Here are the top posts by size to this list recently:
The problem is, where do we stop? Tom pop'd me off a note about it
yesterday, and we drop'd it from 40k to 30k ...


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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)



Reply With Quote
  #3  
Old   
Magnus Hagander
 
Posts: n/a

Default Re: META: Filtering viruses/worms - 03-04-2004 , 08:46 AM



Quote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


X-Virus-Scanned: by amavisd-new at postgresql.org

Since "amavisd" does not appear to be catching the latest worm, how
about filtering on size? Anything, say, over 20K will be held for
approval. Here are the top posts by size to this list recently:

The problem is, where do we stop? Tom pop'd me off a note
about it yesterday, and we drop'd it from 40k to 30k ...
A quick stop-gap is to block all ZIPs. We don't usually see a lot of ZIP
attachments on these lists, IIRC.

If I'm not mistaken, you run postfix on the server for the lists. The
something along:
/etc/postfix/main.cf:
mime_header_checks = pcre:/etc/postfix/mime_header_checks

/etc/postfix/mime_header_checks:
/name=[^>]*\.(zip|exe|com|vbs)/ REJECT Potentially dangerous file
attachment.

Remove initial spaces, of course. And add/remove any other extensions
you need.


//Magnus

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Reply With Quote
  #4  
Old   
Marc G. Fournier
 
Posts: n/a

Default Re: META: Filtering viruses/worms - 03-04-2004 , 09:09 AM




perfect, thanks ... added ...

On Thu, 4 Mar 2004, Magnus Hagander wrote:

Quote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


X-Virus-Scanned: by amavisd-new at postgresql.org

Since "amavisd" does not appear to be catching the latest worm, how
about filtering on size? Anything, say, over 20K will be held for
approval. Here are the top posts by size to this list recently:

The problem is, where do we stop? Tom pop'd me off a note
about it yesterday, and we drop'd it from 40k to 30k ...

A quick stop-gap is to block all ZIPs. We don't usually see a lot of ZIP
attachments on these lists, IIRC.

If I'm not mistaken, you run postfix on the server for the lists. The
something along:
/etc/postfix/main.cf:
mime_header_checks = pcre:/etc/postfix/mime_header_checks

/etc/postfix/mime_header_checks:
/name=[^>]*\.(zip|exe|com|vbs)/ REJECT Potentially dangerous file
attachment.

Remove initial spaces, of course. And add/remove any other extensions
you need.


//Magnus

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.