[SOLVED] Postfix ignoring Alias table
04-25-2017, 11:36 AM
(This post was last modified: 04-25-2017, 11:56 PM by inweb.
Edit Reason: Solved
)
Hi there,
please, help, trying to figure out a very strange problem.
My server is ignoring the postfix's "alias" table. It was working, nothing changed (config files). Everything original from Sentora installation. Sentora creates correctly the table records.
Alias example:
address=john@mydomain.com
goto=foo@mydomain.com
Postfix returns a "user unknown" error on john@mydomain.com.
The only thing is that there's a Distribution List with >20 destinations. But I've tried to remove it, no effect.
Everything on "alias" table is just ignored. If I create a real box ("mailbox" table) everything goes ok.
No typos detected. Checked a zillion times. This is driving me crazy.
Any ideas how to fix or debug this?
Thank you.
-----------------
virtual_alias_maps = proxy:mysql:/etc/sentora/configs/postfix/mysql-virtual_alias_maps.cf, regexp:/etc/sentora/configs/postfix/virtual_regexp
query = SELECT goto FROM alias WHERE address='%s' AND active = '1'
If I run the query manually:
SELECT goto FROM alias WHERE address='john@mydomain.com' AND active = '1'
returns correctly foo@mydomain.com
please, help, trying to figure out a very strange problem.
My server is ignoring the postfix's "alias" table. It was working, nothing changed (config files). Everything original from Sentora installation. Sentora creates correctly the table records.
Alias example:
address=john@mydomain.com
goto=foo@mydomain.com
Postfix returns a "user unknown" error on john@mydomain.com.
The only thing is that there's a Distribution List with >20 destinations. But I've tried to remove it, no effect.
Everything on "alias" table is just ignored. If I create a real box ("mailbox" table) everything goes ok.
No typos detected. Checked a zillion times. This is driving me crazy.
Any ideas how to fix or debug this?
Thank you.
-----------------
virtual_alias_maps = proxy:mysql:/etc/sentora/configs/postfix/mysql-virtual_alias_maps.cf, regexp:/etc/sentora/configs/postfix/virtual_regexp
query = SELECT goto FROM alias WHERE address='%s' AND active = '1'
If I run the query manually:
SELECT goto FROM alias WHERE address='john@mydomain.com' AND active = '1'
returns correctly foo@mydomain.com