leister mail 16.04 catchall

/etc/postfix/sql/aliases.cf
## original query
#query = select concat(destination_username, '@', destination_domain) as destinations from aliases where source_username = '%u' and source_domain = '%d' and enabled = true;

## catchall query by jochen z
query = SELECT CONCAT(destination_username, '@', destination_domain) AS destinations FROM aliases WHERE source_username = '%u' AND source_domain = '%d' AND enabled = true UNION SELECT CONCAT(destination_username, '@', destination_domain)
AS destinations FROM aliases WHERE source_username = '' AND source_domain = '%d' AND enabled = true;

## create catchall alias
INSERT INTO aliases (source_username, source_domain, destination_username, destination_domain, enabled) values ('', 'example.de', 'catchall', 'example.de', true);