Hi
I've been using SQL lookups on amavisd-new 2.4.2 for a couple weeks
with relative success.
Today I was looking at amavisd-new logfile (debuglevel 4) and I got
surprised when I noticed that '$sql_select_policy' query was being
performed twice for each email processed: at first with the sender
address as argument, and then with the recipient address.
According to README.sql "$sql_select_policy setting in amavisd.conf
tells amavisd how to fetch per-recipient policy settings." I thought
it'd be called only with recipients addresses as arguments.
With two SQL queries being performed for each message processed,
there's a waste of server resources. Furthermore, I have the fear the
wrong 'banned_rulenames' can be selected if I send an internal mail.
Would somebody explain me if that's a 'normal' amavisd-new behaviour
- or tell me if I'm missing something ?
______________________________
Ricardo Canani
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
