[AMaViS-user] email in white/blacklist in SQL UNIQUE

2007-03-15 Thread Frank Patzig
Hallo, in the table mailaddr is email UNIQUE. User A has the email [EMAIL PROTECTED] in the table mailaddr as black and user B will the email [EMAIL PROTECTED] as white. Is it a problem when deaktiv the UNIQUE in email? Thanks -- Frank Patzig

Re: [AMaViS-user] email in white/blacklist in SQL UNIQUE

2007-03-15 Thread Mark Martinec
Frank, in the table mailaddr is email UNIQUE. User A has the email [EMAIL PROTECTED] in the table mailaddr as black and user B will the email [EMAIL PROTECTED] as white. Is it a problem when deaktiv the UNIQUE in email? Both wblist entries must reference the same mailaddr.id, and all is

Re: [AMaViS-user] email in white/blacklist in SQL UNIQUE

2007-03-15 Thread Frank Patzig
Mark Martinec schrieb: Both wblist entries must reference the same mailaddr.id, and all is fine. When attempting to enter new address into table mailaddr, always check first if such address already exists, and reuse it if it does. After all, this is really the same sender. Mark

[AMaViS-user] releasing message through tcp socket

2007-03-15 Thread peceka
hi all, i've got a problem releasing message using tcp socket. on machine amavis1 i've got amavis. From my development machine i do: telnet amavis1 9998 Trying 10.1.1.2... Connected to amavis1. Escape character is '^]'. request=release mail_id=4YK18SgAEKEG secret_id=CM0xNNj-SvYj quar_type=Q

Re: [AMaViS-user] How does one disable sql logging for certain policies?

2007-03-15 Thread Riaan Kok
So, how to do it? 'sql_clause' IS a policy-able variable, but I'm not sure amavisd-new would be stable if that is set to undef in a policy declaration. That could work, but I never tried it. Please see if it works, and if it doesn't I'd consider it a bug and fix it. I do find problems

Re: [AMaViS-user] Delivery of mail is slow

2007-03-15 Thread Gary V
Henrik wrote: On Wed, Mar 14, 2007 at 05:12:45PM -0500, Kyle Kniepkamp wrote: I am running into the problem, after an upgrade, that delivery of my messages is slow. Hence, my queue is getting backed up and messages are taking about an hour to get delivered. tail -f /var/log/maillog | grep

Re: [AMaViS-user] p0f sql

2007-03-15 Thread Alan Munday
Mark Martinec wrote the following on 16/12/2006 01:35: Alan, In 2.4.4 I've uncommented the # , p0f=? in the sql statement. As this is not logging into the p0f field in msgs I presumed some additional changes are still required? The -execute part of the patch is needed too. Here is the

Re: [AMaViS-user] Delivery of mail is slow

2007-03-15 Thread Mark Martinec
Kyle, Gary/Henrik, thanks for the responses. I set $log_level = 2 and it is showing about 18 seconds to scan a message (see output below). It was taking on average about 600ms before. Turning on SA logging may show where the processing stalls (by observing the running SA log on the screen):

[AMaViS-user] Separate virus and spam scanning

2007-03-15 Thread Xander Vranken
Hello, Does any of you guys have some experience with separate spam/virus + amavis gateways. We want to buy one very fast server for virusscanning only and one for spamassassing only but I can't find anything about a setup like this. Thanks, Xander

[AMaViS-user] amavisd and perl vacation posibble ?

2007-03-15 Thread Benny Pedersen
i need help to make this perl into amavisd.conf so it sends vacation for users that are stored in mysql as so, the guide i have it from tells me to use seperate unix account for this script, but problem is that i only have virtual users can i mix this so it works from amavisd ? -- This message

Re: [AMaViS-user] Somewhat OT: Postgrey vs. SQLGrey

2007-03-15 Thread Patrick Ben Koetter
* Danita Zanre [EMAIL PROTECTED]: Any opinions about these two? I've been using postgrey for awhile, and I like it, but I also like the idea of using mysql so that I can perhaps get info out of the database if I want. Any opinions as to which would be faster, etc.? I recommend policyd - it