Re: [AMaViS-user] How to identify SPAM and SPAMMY mail in SQL

2009-08-03 Thread Thomas Gelf
Spam = S, spammy = s Please note that MySQL is case insensitive on many string comparsion functions with certain encodings. Therefore if using VARCHAR or CHAR s == S could be true for your system. Either change your columns to VARBINARY or BINARY - or use the BINARY() function when comparing

Re: [AMaViS-user] 503 5.5.1 Error: nested MAIL

2009-08-03 Thread Mark Martinec
Diego, Update to lenny and etch problems started ... I have major problems with Amavis and do not know if courier-imap and postfix are also involved. The current version I'm using are: amavisd-new 1:2.6.1. dfsg-1 postfix 2.5.5-1.1 courier-imap-ssl 4.4.0-2 Sometimes sending an email

Re: [AMaViS-user] Delivery Failures From Banned Emails to Sender

2009-08-03 Thread Mark Martinec
Carlos, When someone sends a message that is blocked / quarantined for banned contents or viruses, I would like to get notification sent to postmast...@$mydomain however I do not want notification sent to the sender that their message was not delivered based on whatever reason. Right now I

Re: [AMaViS-user] Q about partitioning tables and data types

2009-08-03 Thread Luis Daniel Lucio Quiroz
Le samedi 1 août 2009 11:15:43, Nathan M a écrit : On Fri, Jul 31, 2009 at 7:59 PM, Luis Daniel Lucio Quirozluis.daniel.lu...@gmail.com wrote: A stupid question, what advantages do I get if I use partition_tag with amavisd+mysql? Faster database cleanups. On a high traffic mail server,

Re: [AMaViS-user] Q about partitioning tables and data types

2009-08-03 Thread Nathan M
On Mon, Aug 3, 2009 at 9:22 AM, Luis Daniel Lucio Quirozluis.daniel.lu...@gmail.com wrote: OK, and I've already a database with some emails, if I change $sql_partition_tag = 1, will I mess the DB? $sql_partition_tag = 1; would do little good. If you have the db setup with partition_tag, it's

Re: [AMaViS-user] policy bank options ignored?

2009-08-03 Thread Mark Martinec
Tim, I have the following for my originating senders: $interface_policy{'10026'} = 'ORIGINATING'; $policy_bank{'ORIGINATING'} = { originating = 1, virus_admin_maps = [virus_adm...@$mydomain], spam_admin_maps = [spam_adm...@$mydomain], warnbadhsender = 1, warnspamsender =

Re: [AMaViS-user] Q about partitioning tables and data types

2009-08-03 Thread Mark Martinec
Luis, OK, and I've already a database with some emails, if I change $sql_partition_tag = 1, will I mess the DB? Should be alright. Note that each partition will collect its own subset of e-mail addresses in a table maddr, which means some addresses will be duplicates, typically all local user

[AMaViS-user] POLL: Database Hardware vs Daily Messages

2009-08-03 Thread Nathan M
I am curious what amavisd-new users out there have for DB setups for maintaining the storage component of amavis data (maddr, msgrcpt, msgs, quarantine tables). I'll start. Incoming Email: 10,000,000 messages/day Current Hardware: Single Core 2000Mhz Athlon 64 CPU 4GB RAM 2 x Seagate ES 500GB

Re: [AMaViS-user] POLL: Database Hardware vs Daily Messages

2009-08-03 Thread Jim Bourne
On Mon, 3 Aug 2009, Nathan M wrote: I am curious what amavisd-new users out there have for DB setups for maintaining the storage component of amavis data (maddr, msgrcpt, msgs, quarantine tables). I'll start. Incoming Email: 10,000,000 messages/day Current Hardware: Single Core 2000Mhz

Re: [AMaViS-user] Q about partitioning tables and data types

2009-08-03 Thread Luis Daniel Lucio Quiroz
Le lundi 3 août 2009 12:13:06, Nathan M a écrit : On Mon, Aug 3, 2009 at 9:22 AM, Luis Daniel Lucio Quirozluis.daniel.lu...@gmail.com wrote: OK, and I've already a database with some emails, if I change $sql_partition_tag = 1, will I mess the DB? $sql_partition_tag = 1; would do little

Re: [AMaViS-user] policy bank options ignored?

2009-08-03 Thread Tim Howe
Thanks for your reply :) On Mon, 3 Aug 2009 19:11:45 +0200 Mark Martinec mark.martinec+ama...@ijs.si wrote: The DSN for spam is suppressed when spam score exceeds spam_dsn_cutoff_level. Yes, that's why I set it so high, I was using the GTUBE email to test which scores around 1000.

Re: [AMaViS-user] POLL: Database Hardware vs Daily Messages

2009-08-03 Thread Henrik K
On Mon, Aug 03, 2009 at 10:24:48AM -0700, Nathan M wrote: I am curious what amavisd-new users out there have for DB setups for maintaining the storage component of amavis data (maddr, msgrcpt, msgs, quarantine tables). I'll start. Incoming Email: 10,000,000 messages/day Current