Hi,
Le 19/05/2015 14:54, Jorge Bastos a écrit :
Hi Samuel,
On a fresh install of Jessie, I achieve to make dovecot/postfix working
with SQL, but I still can't send email to alias for wich one I get :
"Unknown user"
After debug enable in dovecot, I see that the user_query SQL , just
query for the "users" table and not the "forward" table so the final
alias user is not known.
But when I check postfix for alias, it seems ok :
root@cluster-dovecot:/etc/dovecot# postmap -q conta...@xxxxxxxx.com
mysql:alias_maps cont...@xxxxxxxxxx.com
So what do I missed for alias working with dovecot ?
I had similar question on how to make it working, and it ended up being:
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf
Finally I achieved making alias to work by changing the user_query:
#FROM users WHERE username = '%n' AND domain = '%d'
TO :
FROM users WHERE username = '%n' AND domain = '%d' or email=(select
destination from forwards where source='%u');
But I don't know if that's the right way.
Wanting for any suggestion ....
Samuel.
