How to add regex aliases in Postfix when using MySQL

Question

I need to create regex based catchall aliases in Postfix setup with MySQL. I have found examples of a mysql_virtual_alias_maps_regexp.cf with this query:

query = SELECT goto FROM alias WHERE '%s' REGEXP CONCAT('^',address,'$') AND SUBSTRING(address,1,1) != '@' AND x_regexp = '1'

But I cannot find the actual structure for the table that goes with that query.

My alias table has id,domain_id,source,destination based on this guide: https://www.linode.com/docs/email/postfix/email-with-postfix-dovecot-and-mysql which wasn't written to allow regex aliases.

How can I create a table / virtual_alias_maps that will support regex aliases when using MySQL? All decent guides are for non-MySQL setups using /etc/postfix/virtual

Thank you.

Answer 1

A few google searches found me this postfix-admin wiki page: http://sourceforge.net/p/postfixadmin/wiki/Regex_aliases/