All,
This is seemingly, an elementary question, but I am missing something. First, I have used this configuration for whitelisting/blacklisting for years: read_hash(\%whitelist_sender, '/var/amavis/lists/whitelist'); read_hash(\%blacklist_sender, '/var/amavis/lists/blacklist'); I would like to move to an SQL method. The problem being, I do not know all of the configuration I need to do to make this happen. I am already SQL for lookups, so I thought simply it would be something like this: $sql_select_white_black_list = 'SELECT wb'. ' FROM wblist JOIN mailaddr ON wblist.sid=mailaddr.id'. ' WHERE wblist.rid=? and mailaddr.email IN (%k)'. ' ORDER BY mailaddr.priority DESC'; #%sql_clause = ( #'sel_wblist' => \$sql_select_white_black_list, #); @blacklist_sender_maps = (\%blacklist_sender, \...@blacklist_sender_acl, \$blacklist_sender_re); @whitelist_sender_maps = (\%whitelist_sender, \...@whitelist_sender_acl, \$whitelist_sender_re); However, when I turn debugging on and analyze the SQL statements, I have a dead end. No SQL and prepare for anything with wblist in it. Am I perhaps missing a dependency or something? Thanks! Jason ------------------------------------------------------------------------------ _______________________________________________ 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/
