On 2017-08-02 22:16, Marius Stan wrote:
> On 2/8/2017 3:03 PM, thunder@??? 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-emailer@??? |
>> | 2 | reply@??? |
>> +----+--------------------------------+
>> 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.
