Re: [AMaViS-user] Question about @local_domains_maps

2007-07-26 Thread Gary V
Tom wrote: > Hi, > I am in the process of setting up amavisd-new-2.5.2 with postfix-2.3.2-1. > I would appreciate it if someone could tell me exactly what the > @local_domains_maps parameter really does. The docs seem to indicate that > all it does is determine wether or not amavis should add s

[AMaViS-user] Question about @local_domains_maps

2007-07-26 Thread Tom Diehl
Hi, I am in the process of setting up amavisd-new-2.5.2 with postfix-2.3.2-1. I would appreciate it if someone could tell me exactly what the @local_domains_maps parameter really does. The docs seem to indicate that all it does is determine wether or not amavis should add spam headers. Am I unde

Re: [AMaViS-user] SQL-Quarantine DB LOCK while cleaning

2007-07-26 Thread Mark Martinec
> > Question: why "LIMIT 1" ? > > I'm not certain whether it makes a difference or not but I think > if it does make a difference it would make things go quicker. > The idea is to stop SELECT'ing once the first matching record is found. The LIMIT is redundant, the msgs.mail_id is a PRIMARY KEY and

Re: [AMaViS-user] interesting patch proposition

2007-07-26 Thread Robert Brooks
Bartłomiej Rutkowski wrote: > So, the time has passed, and still there is no answer... Is there no way, > that users > can make their improvements way to amavisd-new official builds? Or is the > project > not interested in such participation? I think you're jumping to conclusions there, I suspe

Re: [AMaViS-user] SQL-Quarantine DB LOCK while cleaning

2007-07-26 Thread Gary V
Paolo wrote: > Gary V wrote: >> I came up with this as an example: >> >> #!/bin/bash echo "USE amavis;" >amavistrim.sql >> mysql -uamavis -pamavis_password amavis -B -N -e "SELECT CONCAT('DELETE >> FROM msgs WHERE mail_id = ', CHAR(39), mail_id, CHAR(39), ' LIMIT 1;' ) >> FROM msgs WHERE time_i

Re: [AMaViS-user] interesting patch proposition

2007-07-26 Thread Bartłomiej Rutkowski
> Bartłomiej wrote: > > > Hi, > > > We, at Lerkins Group have used amavisd-new for our anti-spam & anti-virus > > cluster, and we > > have found that that would be very usable to have the ability to resend the > > message > > that came from host X to host Y, based on config specified in amavisd

[AMaViS-user] using an ldap addressbook as a whitelist

2007-07-26 Thread Robert Brooks
Is it possible to use an ldap address book as a whitelist? I've been doing a bit of googling, but apart from a brief comment here: http://www.afp548.com/article.php?story=20041114233708682 I can't find much evidence that it's possible and README.ldap makes it look unlikely. It seems to be a co

Re: [AMaViS-user] SQL-Quarantine DB LOCK while cleaning

2007-07-26 Thread Paolo Cravero
Gary V wrote: > I came up with this as an example: > > #!/bin/bash echo "USE amavis;" >amavistrim.sql > mysql -uamavis -pamavis_password amavis -B -N -e "SELECT CONCAT('DELETE > FROM msgs WHERE mail_id = ', CHAR(39), mail_id, CHAR(39), ' LIMIT 1;' ) > FROM msgs WHERE time_iso < NOW() - INTERVAL