Hi all,
using amavisd-2.4.x I have setup usage of SQL for lookup and
storage. Everything works fine. Only the wblist table of my
database is never used.
My /usr/sbin/amavisd contains the correct default setting for
$sql_select_white_black_list, which is referenced by %sql_clause.
In my /etc/amavisd.conf no SQL clause is changed, so the correct
default settings should apply (all other SQL statements work as
expected).
But when I send a test mail to amavisd-new and log the executed
SQL statements (checking this in the log files of postgresql), I
see the SELECT FROM users statement, the INSERT INTO msgs
statement and so on. But a statement involving wblist is never
executed.
Any hints where I have to take a look at?
I could think of a couple of reasons, but the ultimate answer
would be in the log-level 5 log.
Reasons to skip wblist check: infected or banned message,
or bypassing of spam checks active for this recipient,
or no 'user' records matching a recipient,
or $sql_clause{sel_wblist} disabled.
I have solved the issue - it was my fault. The amavisd.conf did
not overwrite anything SQL related (only the DSNs are set), but
there are some more config files included, one of which contained
$sql_select_white_black_list = undef;
Thanks a lot
Regards
-stefan-
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/