Postfix – User unknown in virtual mailbox table + authentification failed

courierpostfix

I'm trying to set postfix with MySQL authentication. I can send mails (from postfixadmin) to different domains. The problem is that I cannot send any mail to my domain or even log-in to squirrelMail even if I've created new user in postfixadmin.

When I send an email to my domain it logs an error:

Jan 31 10:47:17 server postfix/proxymap[4534]: warning: table "mysql:/etc/postfix/mysql_relay_domains_maps.cf": empty lookup result for: "domain.tld" -- ignored
Jan 31 10:47:17 server postfix/smtpd[4533]: NOQUEUE: reject: RCPT from nat-simple12.ntkcz.de[195.113.241.228]: 550 5.1.1 <test@domain.tld>: Recipient address rejected: User unknown in virtual mailbox table; from=<test@workround.org> to=<test@domain.tld> proto=ESMTP helo=<workaround.org>

If I try to login to squirrelMail it logs:

Jan 31 11:15:42 server imapd: LOGIN FAILED, user=test@domain.tld, ip=[::ffff:127.0.0.1]
Jan 31 11:15:47 server imapd: LOGOUT, ip=[::ffff:127.0.0.1], rcvd=54, sent=332

my /etc/postfix/main.cf contains:

...
# my configuration
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_mailbox_base = /home/virtual
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_transport = virtual
virtual_create_maildirsize = yes
virtual_mailbox_extended = yes
virtual_mailbox_limit_maps = mysql:/etc/postfix/mysql_virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_overquota_bounce = yes
relay_domains = proxy:mysql:/etc/postfix/mysql_relay_domains_maps.cf
...

I can't find any problem in my configuration. Does anybody see any problem or any direction I can move forward because I'm completely stuck.

Thanks,
Mateo

Best Answer

Jan 31 10:47:17 server postfix/proxymap[4534]: warning: table "mysql:/etc/postfix/mysql_relay_domains_maps.cf": empty lookup result for: "domain.tld" -- ignored

That line is the first thing you need to solve. For some reason Postfix thinks that domain does not exist. I suspect that Postfixadmin is working correctly and you've entered the right domain, but you have a typo in /etc/postfix/mysql_relay_domains_maps.cf that is causing the lookup of the domain to fail.