On 8/24/10 5:02 PM, Michael Scheidell wrote:
>
> also, if users.local is defined it has to be 'Y' or NULL.
> (I think this is the problem: mark?  could this be a perl 5.10.1 problem?
> earlier versions (5.8.8, 5.8.9) knew that NULL was NULL? and not ''?
>
> the domain is local, but I don't think amavis thinks the user is local
> anymore.
> this sql db returns NULL for 'select local from users where
> email='exam...@example.com').
>
> all others do the same, but for some reason, NULL means NO to this install.
>
>
>    
Solved, sorta.  not sure if this is a perl bug, or amavisd 2.6.4 bug, or 
my bug.

certain conditions, users.local would return NULL (I have a custom query)
for ME, users.local == N means not even accept email, Y then have a 
custom policy, and NULL, they use the policy at id1.

(the domain evaluated as local, so amavisd ran the right policies!), but 
when it can time for 'do_tag' to happen, since users.local was NULL, 
amavisd saw this as ! 'Y'.
it ran the tests, based on the sql lookups, but did everything but put 
the headers in the outbound email (funny, they put the headers in the 
quarantined email!)

(mark: isn't NULL the same as the field not being there? I know if the 
users.local field is missing, you don't even evaluate it)


-- 
Michael Scheidell, CTO
o: 561-999-5000
d: 561-948-2259
ISN: 1259*1300
 > *| *SECNAP Network Security Corporation

    * Certified SNORT Integrator
    * 2008-9 Hot Company Award Winner, World Executive Alliance
    * Five-Star Partner Program 2009, VARBusiness
    * Best in Email Security,2010: Network Products Guide
    * King of Spam Filters, SC Magazine 2008


______________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r). 
For Information please see http://www.secnap.com/products/spammertrap/
______________________________________________________________________  
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users 
worldwide. Take advantage of special opportunities to increase revenue and 
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net 
https://lists.sourceforge.net/lists/listinfo/amavis-user 
 Please visit http://www.ijs.si/software/amavisd/ regularly
 For administrativa requests please send email to rainer at openantivirus dot 
org

Reply via email to