Hi,

I've setup virtual alias/users/domains with postfix and dovecot, so far so good.

In the alias table I set the information of the source and destination address, but then I try to send an email to the alias, dovecot complains about it.

What am I doing wrong?

Nov 7 23:04:13 fastmail dovecot: lmtp(4687): Connect from local

Nov 7 23:04:13 fastmail postfix/lmtp[6556]: 1D2AC100E0A: to=b@a.com, relay=fastmail.domain.pt[private/dovecot-lmtp], delay=6.3, delays=6.2/0/0/0.06, dsn=5.1.1, status=bounced (host fastmail.domain.pt[private/dovecot-lmtp] said: 550 5.1.1 b@a.com User doesn't exist: b@a.com (in reply to RCPT TO command))

Nov 7 23:04:13 fastmail dovecot: lmtp(4687): Disconnect from local: Successful quit

Postfix alias conf:

virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf

cat mysql-virtual-alias-maps.cf

user = posuser

password = popass

hosts = 127.0.0.1

dbname = postfix

query = SELECT deliver_to FROM dovecot_aliases WHERE alias='%s'

where the table structure is:

CREATE TABLE dovecot_aliases (

id int(11) NOT NULL,

alias varchar(255) NOT NULL,

deliver_to varchar(255) NOT NULL,

PRIMARY KEY (id)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

Records are, considering that the main address is a@a.com:

Insert into dovecot_alias values (1,'b@a.com','a@a.com');

Should be postfix that should had send this to the main address right? What could be wrong?

SQL Logs for this, show's that dovecot considered the alias to check if the users exists instead of the real address:

141107 23:18:12 45 Connect postfix_usr@localhost on postfix

               45 Query     SELECT deliver_to FROM dovecot_aliases WHERE

alias='ola.pt'

               46 Connect   postfix_usr@localhost on postfix

               46 Query     SELECT 1 FROM dovecot_domains WHERE

domain='ola.pt' and status='true'

141107 23:18:16 45 Query SELECT deliver_to FROM dovecot_aliases WHERE alias='a.com'

               46 Query     SELECT 1 FROM dovecot_domains WHERE

domain='a.com' and status='true'

               47 Connect   postfix_usr@localhost on postfix

               47 Query     SELECT deliver_to FROM dovecot_aliases WHERE

alias='b@a.com'

141107 23:18:22 45 Query SELECT deliver_to FROM dovecot_aliases WHERE alias='a.com'

               46 Query     SELECT 1 FROM dovecot_domains WHERE

domain='a.com' and status='true'

               48 Connect   postfix_usr@192.168.69.223 on postfix

               48 Query     select uid,gid from dovecot_users where

username='b@a.com'

               49 Connect   postfix_usr@localhost on postfix

               49 Query     SELECT deliver_to FROM dovecot_aliases WHERE

alias='ola@ola.pt'

               49 Query     SELECT deliver_to FROM dovecot_aliases WHERE

alias='@ola.pt'

               45 Query     SELECT deliver_to FROM dovecot_aliases WHERE

alias='ola.pt'

               46 Query     SELECT 1 FROM dovecot_domains WHERE

domain='ola.pt' and status='true'

PS: offtopic, don't understand why postfix queries the sender domain in the domains table and the sender email in the alias table.

Thanks in advanced,

Jorge,