On 2017-08-02 22:16, Marius Stan wrote:
On 2/8/2017 3:03 PM, [email protected] 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 | [email protected] |
|  2 | [email protected]          |
+----+--------------------------------+
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

Hi Maruis,

I have data like this in the table:

| 21 | *.date                               |
| 22 | *.top                                |
| 23 | *.us                                 |

Would it still work?

A.

--
## 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/

Reply via email to