Re: [AMaViS-user] whitelisting not working

2010-09-17 Thread McDonald, Dan
On Sep 17, 2010, at 8:54 PM, "Benny Pedersen" wrote: > On lør 18 sep 2010 02:17:12 CEST, Daniel McDonald wrote > >>> They refer to mailaddr.id, unless you changed the >> Ok, my mistake. > > rid is refering users table Thanks, I was able to make that work. That still means that the static ha

Re: [AMaViS-user] whitelisting not working

2010-09-17 Thread Benny Pedersen
On lør 18 sep 2010 02:17:12 CEST, Daniel McDonald wrote >> They refer to mailaddr.id, unless you changed the > Ok, my mistake. rid is refering users table -- xpoint -- Start uncovering the many advantages of virtual a

Re: [AMaViS-user] whitelisting not working

2010-09-17 Thread Daniel McDonald
On 9/17/10 7:00 PM, "Mark Martinec" wrote: > Daniel, > >> The wblist table uses numeric references to another table for lookups: >> > They refer to mailaddr.id, unless you changed the Ok, my mistake. I've added entries there, and still no boost being applied. I tried to follow the syntax on

Re: [AMaViS-user] whitelisting not working

2010-09-17 Thread Mark Martinec
Daniel, > The wblist table uses numeric references to another table for lookups: > > mysql> describe wblist > | Field | Type | Null | Key | Default | Extra | > | rid | int(10) unsigned | NO | PRI | NULL| | > | sid | int(10) unsigned | NO | PRI | NULL| | > |

Re: [AMaViS-user] whitelisting not working

2010-09-17 Thread Daniel McDonald
Michael Scheidell secnap.com> 2010-09-17 20:38:07 GMT > On 9/17/10 3:55 PM, Daniel McDonald wrote: >> I thought about testing the wblist table, but the maddr table has partition >> tags, so the address in question has multiple RIDs (once per week). I¹m not >> certain what the best way to deal w

Re: [AMaViS-user] Soft-whitelisting not working?

2010-09-17 Thread Michael Scheidell
On 9/17/10 3:55 PM, Daniel McDonald wrote: > I thought about testing the wblist table, but the maddr table has partition > tags, so the address in question has multiple RIDs (once per week). I¹m not > certain what the best way to deal with that would be. maddr table has nothing to do with whitel

[AMaViS-user] Soft-whitelisting not working?

2010-09-17 Thread Daniel McDonald
Running amavisd-new 2.6.4 (rpm version 2.6.4-7 from Mandriva Cooker rebuilt for Mandriva Enterprise server 5), soft whitelisingt does not appear to be working correctly. I added a line to the @sender_score_maps, following the examples, with the address intending to be soft whitelisted. Nothing is

Re: [AMaViS-user] Authentication-Results missing

2010-09-17 Thread Mark Martinec
Miha, >> A recipient must be considered local (matching the @local_domains_maps) >> for this header field to be inserted. [...] > Could you add change a wording a bit in that section: "To each message > passed to local recipients amavisd inserts a header field" int sth. like > this "To each messag

Re: [AMaViS-user] Complex sql lookup query, bad performance

2010-09-17 Thread Mark Martinec
Marco, > We build a clustered mail system with postfix, amavisd, clamd, SA, > dovecot, mysql, etc. 2 Servers are handling incoming mail (MX records > pointing to us) and 2 are handling outgoing mail (relaying). mysql > database is stored on 2 master-master replicated servers. > > so far, everythi