Hi, I want to move my file lookups to database lookups (mariadb). While it is no problem with some of those file lookups because they become simple SELECTs. But I have a problem with (n)wildlsearch. Because I just don't know how I could replace them. For example a sender-lookup for:
^.*@(.*\.)?domain\.tld$ How would I do look something like this up? I know that it would be easy to just look up a domain or a complete sender, but in this case I want for example block a domain and all possible subdomains from that domain. Or I redirect some users that send out newsletters to special servers. I do that by doing a wildlsearch and have there an entry like: ^bounce.*@newsletter.domain.tld Since there is always a random string coming after the bounce. Is there a way to realize that with a database lookup? I know that there is apparently a regexp-lookup for mariadb (https://mariadb.com/kb/en/regexp/) but I think I cannot use that. Because I actually get the sender-address and would need to put the regexp in the database. The only solution so far I come up with that I can put singular senders and domains in tables and have multiple ACLs and routers. And then have an extra file for those cases where I need a regexp but then someone who needs to debug things, needs to look into several places (even though I could for example add some info into the log-messages, so that the debugging person has a better clue where to look). How are others on the list solving this problem? Best, Niels -- ## subscription configuration (requires account): ## https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/ ## unsubscribe (doesn't require an account): ## [email protected] ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
