Alias with wildcard (tweak mysql_virtual_alias_maps.cf )

karlsteinscheisser

Hi,

for our special use case, we would need to match email aliases using a wildcard.
foo-12345@xxx.io should goto 12345@xxx.io
<whatever>-12345@xxx.io should goto 12345@xxx.io
This could be done, if something like this would be possible, when adding an alias entry:
%-12345@xxx.io goto 12345@xxx.io

The mysql_virtual_alias_maps.cf is querying the alias entry using =, simply changing this to LIKE could do the trick.
However, mysql_virtual_alias_maps.cf is overwritten after each restart, so it is not so easy to change this.
Or are there better solutions to accomplish this?

cheers,

ol2tmx

Hi, I was not speaking about the domain remapping rules but regarding the Fail2ban black list rules. I kicked my self out of the system by typing in the networks into the IP blacklist. This causes to interrupt the communication between the backend and front-end. I was hoping to find the wrong IP networks somewhere in one of the mailcow mysql tables. But I did not find anything. I think it needs an approach to delete wrong fail2ban / ipatable / netfilter rules to re-enable the service. Finally I ended up with a messed system and I had to reinstall everything and restored the vmail folder and index.

thx 4 the reply

karlsteinscheisser

I have just found that there is PR open for this issue:
mailcow/mailcow-dockerized4015
any chance getting this merged?

ol2tmx

great, within regex you can do almost anything but it can very tricky. For very complicated regex pattern I am using an online pattern generator. This tool is nice but German lang. only.: Brain4

turboyz

I solved using a sieve filter. You can find and create one going to the section email/configuration/filters

I used the wildcard * to forward all support email created by chatwoot in this format: reply+<random-hex>@mydomain.com

I substituted the <random-hex> with the wildcard *

require ["body","fileinto","imap4flags"];

# rule:[ForwardSupportChatwoot]
if address :matches "to" "reply+*@mydomain.com" {
    redirect "support@mydomain.com";
}

This should be your case

require ["body","fileinto","imap4flags"];

# rule:[ForwardSupportToxxx.io]
if address :matches "to" "*12345@xxx.io" {
    redirect "12345@xxx.io";
}