[AMaViS-user] SQL table "wblist" not used

From: Stefan Palme <kleiner(at)hora-obscura.de>
Date: Wed Feb 20 2008 - 03:35:48 EST

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?

Thanks and 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
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/ Received on Wed Feb 20 03:36:44 2008