On 2/8/2017 3:03 PM, thun...@ahhyes.net wrote:
Hi,
Sorry this is a followup after writing as there might not be
sufficient information in my OP about whats in the database:
Some sample data:
MariaDB [mailauth]> select * from bannedsenders limit 2;
+----+--------------------------------+
| id | sender |
+----+--------------------------------+
| 1 | communities-emai...@vmware.com |
| 2 | re...@oracle-mail.com |
+----+--------------------------------+
2 rows in set (0.01 sec
Sorry for the multiple posts.
Here's how I've done it, I'm sure there are other ways to do it:
Q_BL_SENDERS = SELECT email FROM blacklists WHERE
email='${quote_mysql:$sender_address}'
addresslist blockedsenders = mysql;Q_BL_SENDERS
acl_check_rcpt:
deny senders = +blockedsenders
message = Sender $sender_address is blocked
--
## List details at https://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/