Global SQL WhiteList

Hi all,

I would like to setup a global sneder whitelist using MySQL
(not per
recipients), but I don't see how to write the correct SQL
lookup as
amavisd-new seems tobe very dependent on the sql_policy
lookup (it never
hit my sql_select_white_black_list because it don't have an
answer to
the policy lookup).

I tried something like this:

lookup_sql_dsn = ( ['DBI:mysql:database=amavis',
'amavis',
'xxxxxxxx']);
$sql_select_white_black_list = 'SELECT wb.action FROM wb
WHERE wb.email
IN (%k) AND NOT action=?';


with a simple wb table containing something like this:

email          |  action
------------------------
senderfoo.bar |  W


Is there someone who know if it's possible to do this, and
if so what
could be the correct amavis parameters to use?

Thanks for any help 

-- 
Emmanuel Lacour

------------------------------------------------------------
-------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user

AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/