Le 12/01/2011 00:09, Andy Spiegl a écrit : >> More specifically, "u...@example.com" is a defined email address and >> you want to accept all "prefix.u...@example.com" variants for valid >> users and arbitrary prefixes? > Exactly! > >> Well, it is not really an "extension", rather a prefix. > Oops, you are right of course. > >> You need a "tcp table", or MySQL virtual(5) table that will map alll >> such inputs to just the bare "u...@example.com", but unlike a regexp >> table, ONLY when the user is valid. > Uhm, could you elaborate on this a bit. I am still pretty new to > complicated postfix setups... >
the idea is mysql> select substring_index("joe....@example", ".", -1); +---------------------------------------------+ | substring_index("joe....@example", ".", -1) | +---------------------------------------------+ | j...@example | so simply use virtual_alias_maps = ... old_dotted_addr.cf then set QUERY as above. > Thanks a lot! > Andy. >