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/vse0120000070mrt/direct/01/
_______________________________________________
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/
