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 ------------------------ [EMAIL PROTECTED] | 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-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/