Re: [exim] MySQL - Blocking senders at RCPT time

2017-08-06 Thread Jasen Betts
On 2017-08-05, Jasen Betts wrote: >> >> I have data like this in the table: >> >>| 21 | *.date | >>| 22 | *.top| >>| 23 | *.us | >> >> Would it still work? > > No, but like this it

Re: [exim] MySQL - Blocking senders at RCPT time

2017-08-05 Thread Jasen Betts
On 2017-08-02, thun...@ahhyes.net wrote: > On 2017-08-02 22:16, Marius Stan wrote: >> 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:

Re: [exim] MySQL - Blocking senders at RCPT time

2017-08-02 Thread thunder
On 2017-08-02 23:14, Jan Ingvoldstad via Exim-users wrote: For use with "deny senders", you need e-mail addresses, even though they may contain wildcards. So your data would probably need to look like this if you want to use that: | 21 | *@*.date | | 22 |

Re: [exim] MySQL - Blocking senders at RCPT time

2017-08-02 Thread Jan Ingvoldstad via Exim-users
On Wed, Aug 2, 2017 at 2:49 PM, wrote: > Hi Maruis, > > I have data like this in the table: > > | 21 | *.date | > | 22 | *.top| > | 23 | *.us | > > Would it still work? For use with

Re: [exim] MySQL - Blocking senders at RCPT time

2017-08-02 Thread thunder
On 2017-08-02 22:16, Marius Stan wrote: 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;

Re: [exim] MySQL - Blocking senders at RCPT time

2017-08-02 Thread thunder
On 2017-08-02 22:13, Evgeniy Berdnikov wrote: On Wed, Aug 02, 2017 at 10:03:47PM +1000, thun...@ahhyes.net wrote: >dropsenders = ${lookup mysql{select sender from >mail.bannedsenders} {$value}fail} >message = Not acceptable - You are blacklisted > >Doesn't work. Any suggestions

Re: [exim] MySQL - Blocking senders at RCPT time

2017-08-02 Thread Evgeniy Berdnikov
On Wed, Aug 02, 2017 at 10:03:47PM +1000, thun...@ahhyes.net wrote: > >dropsenders = ${lookup mysql{select sender from > >mail.bannedsenders} {$value}fail} > >message = Not acceptable - You are blacklisted > > > >Doesn't work. Any suggestions would be appreciated. It should not work

Re: [exim] MySQL - Blocking senders at RCPT time

2017-08-02 Thread Marius Stan
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; +++ |

Re: [exim] MySQL - Blocking senders at RCPT time

2017-08-02 Thread thunder
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 |

[exim] MySQL - Blocking senders at RCPT time

2017-08-02 Thread thunder
Hi All, I was wondering whether anyone could help me with getting some configuration to work. Currently I have the following in my exim configuration, and I am using it for manually blocking addresses (its handy where someone is dumb enough to keep using the same 'from' address, its even