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.
A.
On 2017-08-02 21:54, [email protected] wrote:
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 been handy for blocking various new domain TLD's
that spammers like to use of late.
Here's what I have in my configuration, which just reads from a file:
drop senders = /usr/local/etc/eximreject.lst
message = Not acceptable - You are blacklisted
The above has worked a treat for years. But I would like to move
things to a database instead so I can have more things centralised.
I have imported the contents of this file into an SQL table I made:
MariaDB [mail]> describe bannedsenders;
+--------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+--------+---------------------+------+-----+---------+----------------+
| id | tinyint(3) unsigned | NO | PRI | NULL | auto_increment
|
| sender | tinytext | NO | | NULL |
|
+--------+---------------------+------+-----+---------+----------------+
The 'sender' column contains the equivalent of what is in tne plain
text file, just addresses.
I had a read of the exim manual for MySQL lookups but there is
obviously something I don't get, since I cant get it to work. I made a
futile attempt which failed:
drop senders = ${lookup mysql{select sender from
mail.bannedsenders} {$value}fail}
message = Not acceptable - You are blacklisted
Doesn't work. Any suggestions would be appreciated.
Thanks!
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/
