On 2017-08-02, thunder@??? <thunder@???> wrote:
> 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?
No, but like this it will.
Q_BL_SENDERS = SELECT email FROM blacklists WHERE \
email='${quote_mysql:$sender_address}' \
OR email LIKE '*%';
--
This email has not been checked by half-arsed antivirus software
