-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 12/15/10 7:31 PM, Mark Martinec wrote: > The USER_IN_WHITELIST comes from SpamAssassin. > It has nothing to do with amavisd black/whitelisting mechanism.
*nod* Gotcha. :) > Thanks for the log and the database (sent offlist). > This explains. Thank *you*... I set up the schema and stuff based on the amavisnewsql plugin for SquirrelMail, so that's probably why it isn't quite the same? (And I know it's not been updated in forever, and apparently there's something called "server settings" but I haven't figured that plugin out yet...) (much snippage) > I believe what you need is: > > $sql_select_white_black_list = > 'SELECT wb FROM wblist'. > ' WHERE wblist.rid=? AND wblist.email IN (%k)'. > ' ORDER BY wblist.priority DESC'; > > and make sure sender addresses are kept in wblist.email > and recipients are kept in table users. This seems to do what is expected... when I put an email address in the blacklist (one I own from gmail), and send an email to the account that's blacklisted it, it gets treated thusly: Dec 17 17:20:34 caduceus postfix/smtpd[77552]: NOQUEUE: filter: RCPT from mail-gw0-f45.google.com[74.125.83.45]: <g...@wingfoot.org>: Recipient address triggers FILTER smtp-amavis:[127.0.0.1]:10024; from=<my_address...@gmail.com> to=<g...@wingfoot.org> proto=ESMTP helo=<mail-gw0-f45.google.com> Dec 17 17:20:34 caduceus postgrey[1054]: action=pass, reason=client whitelist, client_name=mail-gw0-f45.google.com, client_address=74.125.83.45, sender=my_address...@gmail.com, recipient=...@wingfoot.org Dec 17 17:20:34 caduceus postfix/smtpd[77552]: D2BF439DC25: client=mail-gw0-f45.google.com[74.125.83.45] Dec 17 17:20:34 caduceus postfix/cleanup[77554]: D2BF439DC25: message-id=<4d0be22e.7090...@gmail.com> Dec 17 17:20:34 caduceus postfix/qmgr[98929]: D2BF439DC25: from=<my_address...@gmail.com>, size=2196, nrcpt=1 (queue active) Dec 17 17:20:35 caduceus postfix/smtp[77555]: D2BF439DC25: to=<g...@wingfoot.org>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.84, delays=0.55/0/0.01/0.28, dsn=2.7.0, status=sent (250 2.7.0 Ok, discarded, id=77786-01 - SPAM) Dec 17 17:20:35 caduceus postfix/qmgr[98929]: D2BF439DC25: removed Removing the email from the blacklist or adding it to the whitelist, results in delivery of the email, as expected. Thank you! :-D Best, - --Glenn -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk0L6+EACgkQf5MxTDXTimGa6gCfXSoBhYKyTleRtKEW5b4d5nE3 O5sAoK8jheHiTHzYaQI4r0cOhrG3Kgrj =9lAm -----END PGP SIGNATURE----- ------------------------------------------------------------------------------ Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user Please visit http://www.ijs.si/software/amavisd/ regularly For administrativa requests please send email to rainer at openantivirus dot org
