Postfix is delivering all mail to [e-mail]

Question

I am attempting to email an address on my own box ([e-mail]), and postfix is attempting to deliver to [e-mail] - the username is replaced with the number 1. This message is included in mailer-daemon's response:

<[e-mail]> (expanded from <[e-mail]>): host mail.domain.tld[private/dovecot-lmtp] said: 550 5.1.1 <[e-mail]> User doesn't exist: [e-mail] (in reply to RCPT TO command)

Searching the mail log, the first result that refers to [e-mail] is this:

Oct 19 13:41:44 servername postfix/lmtp[16232]: A547EC29C2: to=<[e-mail]>, orig_to=<[e-mail]>, relay=mail.domain.tld[private/dovecot-lmtp], delay=0.19, delays=0.16/0.01/0.01/0.02, dsn=5.1.1, status=bounced (host mail.domain.tld[private/dovecot-lmtp] said: 550 5.1.1 <[e-mail]> User doesn't exist: [e-mail] (in reply to RCPT TO command))

[e-mail] exists, and can send mail outwards. [e-mail] does not exist, obviously.

So why is Postfix repeatedly delivering all mail to [e-mail]?

Answer 1

Running doveconf -n to verify the confirmation revealed the following line:

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

Checking /etc/postfix/mysql-virtual-email2email.cf revealed the actual error:

query = SELECT 1 FROM virtual_users WHERE email='%s'

So, after carefully searching the database, it would select the number 1, for any user where the email was the given address. To fix this, change 1 in the query to the actual proper column name your table uses.