Hi, I have amavisd-new install by yum on my FC5 box. I used the http://www.ijs.si/software/amavisd/README.sql.txt file to configure mysql and amavis.
I changed my amavisd.conf file to include: $sql_select_policy = 'SELECT *,users.id FROM users,policy'. ' WHERE (users.policy_id=policy.id) AND (users.email IN (%k))'; $sql_select_white_black_list = 'SELECT wb FROM wblist,mailaddr'. ' WHERE (wblist.rid=?) AND (wblist.sid=mailaddr.id)'. ' AND (mailaddr.email IN (%k))'. ' ORDER BY mailaddr.priority DESC'; I added some entries into my wblist table. My problem: I still receive the mail when I send an email from a blacklisted address. The maillog do id the address as a blacklist sender. How do I configure my policy table to bounce the mail. If possible can someone point me to some detailed docs about the sql tables. Thanks ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ 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/