No change when removing that line.
Even when leaving
smtpd_recipient_restrictions =
empty, it does not work.
When adding example.com to "mydestination" the system reports "Recipient address rejected: User unknown in local recipient table"
Where do I need to enable debugging in order to get details about where the rejection occurs?
I found a difference in "mysql/virtual_mailbox_domains.cf":
Working box:
query = SELECT domain FROM domain WHERE domain='%s' AND backupmx=0 AND active=1 UNION SELECT alias_domain.alias_domain FROM alias_domain,domain WHERE alias_domain.alias_domain='%s' AND alias_domain.active=1 AND alias_domain.target_domain=domain.domain AND domain.active=1 AND domain.backupmx=0
Non-Working box:
query = (SELECT domain FROM domain WHERE domain='%s' AND backupmx=0 AND active=1 LIMIT 1) UNION (SELECT alias_domain.alias_domain FROM alias_domain,domain WHERE alias_domain.alias_domain='%s' AND alias_domain.active=1 AND alias_domain.target_domain=domain.domain AND domain.active=1 AND domain.backupmx=0 LIMIT 1)
Is that change documented in the upgrade guides? I can't remember.
I check mariadb query log. Following queries have been done when trying to send telnet email:
191223 8:38:28 37 Connect vmail@localhost as anonymous on vmail
37 Query SELECT maillists.transport FROM maillists,domain WHERE maillists.address='*' AND maillists.active=1 AND maillists.domain = domain.domain AND domain.active=1
38 Connect vmail@localhost as anonymous on vmail
38 Query SELECT transport FROM domain WHERE domain='*' AND active=1 LIMIT 1
37 Query SELECT maillists.transport FROM maillists,domain WHERE maillists.address='*' AND maillists.active=1 AND maillists.domain = domain.domain AND domain.active=1
38 Query SELECT transport FROM domain WHERE domain='*' AND active=1 LIMIT 1
39 Connect vmail@localhost as anonymous on vmail
39 Query (SELECT domain FROM domain WHERE domain='senderdomain.com' AND backupmx=0 AND active=1 LIMIT 1) UNION (SELECT alias_domain.alias_domain FROM alias_domain,domain WHERE alias_domain.alias_domain='senderdomain.com' AND alias_domain.active=1 AND alias_domain.target_domain=domain.domain AND domain.active=1 AND domain.backupmx=0 LIMIT 1)
40 Connect vmail@localhost as anonymous on vmail
40 Query SELECT relayhost FROM sender_relayhost WHERE account='\"<>\"' LIMIT 1
40 Query SELECT relayhost FROM sender_relayhost WHERE account='<>' LIMIT 1
41 Connect vmail@localhost as anonymous on vmail
41 Query SELECT mailbox.transport FROM mailbox,domain WHERE mailbox.username='test@senderdomain.com' AND mailbox.domain='senderdomain.com' AND mailbox.domain=domain.domain AND mailbox.transport<>'' AND mailbox.active=1 AND mailbox.enabledeliver=1 AND domain.backupmx=0 AND domain.active=1
37 Query SELECT maillists.transport FROM maillists,domain WHERE maillists.address='test@senderdomain.com' AND maillists.active=1 AND maillists.domain = domain.domain AND domain.active=1
38 Query SELECT transport FROM domain WHERE domain='test@senderdomain.com' AND active=1 LIMIT 1
37 Query SELECT maillists.transport FROM maillists,domain WHERE maillists.address='senderdomain.com' AND maillists.active=1 AND maillists.domain = domain.domain AND domain.active=1
38 Query SELECT transport FROM domain WHERE domain='senderdomain.com' AND active=1 LIMIT 1
37 Query SELECT maillists.transport FROM maillists,domain WHERE maillists.address='.de' AND maillists.active=1 AND maillists.domain = domain.domain AND domain.active=1
38 Query SELECT transport FROM domain WHERE domain='.de' AND active=1 LIMIT 1
191223 8:38:29 39 Query (SELECT domain FROM domain WHERE domain='example.com' AND backupmx=0 AND active=1 LIMIT 1) UNION (SELECT alias_domain.alias_domain FROM alias_domain,domain WHERE alias_domain.alias_domain='example.com' AND alias_domain.active=1 AND alias_domain.target_domain=domain.domain AND domain.active=1 AND domain.backupmx=0 LIMIT 1)
40 Query SELECT relayhost FROM sender_relayhost WHERE account='test@senderdomain.com' LIMIT 1
40 Query SELECT relayhost FROM sender_relayhost WHERE account='@senderdomain.com' LIMIT 1
41 Query SELECT mailbox.transport FROM mailbox,domain WHERE mailbox.username='test@example.com' AND mailbox.domain='example.com' AND mailbox.domain=domain.domain AND mailbox.transport<>'' AND mailbox.active=1 AND mailbox.enabledeliver=1 AND domain.backupmx=0 AND domain.active=1
37 Query SELECT maillists.transport FROM maillists,domain WHERE maillists.address='test@example.com' AND maillists.active=1 AND maillists.domain = domain.domain AND domain.active=1
38 Query SELECT transport FROM domain WHERE domain='test@example.com' AND active=1 LIMIT 1
37 Query SELECT maillists.transport FROM maillists,domain WHERE maillists.address='example.com' AND maillists.active=1 AND maillists.domain = domain.domain AND domain.active=1
38 Query SELECT transport FROM domain WHERE domain='example.com' AND active=1 LIMIT 1
39 Query (SELECT domain FROM domain WHERE domain='senderdomain.com' AND backupmx=0 AND active=1 LIMIT 1) UNION (SELECT alias_domain.alias_domain FROM alias_domain,domain WHERE alias_domain.alias_domain='senderdomain.com' AND alias_domain.active=1 AND alias_domain.target_domain=domain.domain AND domain.active=1 AND domain.backupmx=0 LIMIT 1)
40 Query SELECT relayhost FROM sender_relayhost WHERE account='test@example.com' LIMIT 1
40 Query SELECT relayhost FROM sender_relayhost WHERE account='@example.com' LIMIT 1
41 Query SELECT mailbox.transport FROM mailbox,domain WHERE mailbox.username='test@senderdomain.com' AND mailbox.domain='senderdomain.com' AND mailbox.domain=domain.domain AND mailbox.transport<>'' AND mailbox.active=1 AND mailbox.enabledeliver=1 AND domain.backupmx=0 AND domain.active=1
37 Query SELECT maillists.transport FROM maillists,domain WHERE maillists.address='test@senderdomain.com' AND maillists.active=1 AND maillists.domain = domain.domain AND domain.active=1
38 Query SELECT transport FROM domain WHERE domain='test@senderdomain.com' AND active=1 LIMIT 1
37 Query SELECT maillists.transport FROM maillists,domain WHERE maillists.address='senderdomain.com' AND maillists.active=1 AND maillists.domain = domain.domain AND domain.active=1
38 Query SELECT transport FROM domain WHERE domain='senderdomain.com' AND active=1 LIMIT 1
37 Query SELECT maillists.transport FROM maillists,domain WHERE maillists.address='.de' AND maillists.active=1 AND maillists.domain = domain.domain AND domain.active=1
38 Query SELECT transport FROM domain WHERE domain='.de' AND active=1 LIMIT 1
42 Connect vmail@localhost as anonymous on vmail
42 Query SELECT forwardings.forwarding FROM forwardings,domain WHERE forwardings.address='test@senderdomain.com' AND forwardings.domain=domain.domain AND forwardings.active=1 AND domain.backupmx=0 AND domain.active=1
43 Connect vmail@localhost as anonymous on vmail
43 Query SELECT forwardings.forwarding FROM forwardings,alias_domain,domain WHERE alias_domain.alias_domain='senderdomain.com' AND forwardings.address=CONCAT('test', '@', alias_domain.target_domain) AND alias_domain.target_domain=domain.domain AND forwardings.active=1 AND alias_domain.active=1 AND domain.backupmx=0
44 Connect vmail@localhost as anonymous on vmail
44 Query SELECT forwardings.forwarding FROM forwardings,domain WHERE forwardings.address='senderdomain.com' AND 'test' NOT LIKE '%+%' AND forwardings.address=domain.domain AND forwardings.active=1 AND domain.active=1 AND domain.backupmx=0
45 Connect vmail@localhost as anonymous on vmail
45 Query SELECT forwardings.forwarding FROM forwardings,alias_domain,domain WHERE alias_domain.alias_domain='senderdomain.com' AND forwardings.address=alias_domain.target_domain AND alias_domain.target_domain=domain.domain AND forwardings.active=1 AND alias_domain.active=1
42 Query SELECT forwardings.forwarding FROM forwardings,domain WHERE forwardings.address='@senderdomain.com' AND forwardings.domain=domain.domain AND forwardings.active=1 AND domain.backupmx=0 AND domain.active=1
45 Query SELECT forwardings.forwarding FROM forwardings,alias_domain,domain WHERE alias_domain.alias_domain='senderdomain.com' AND forwardings.address=alias_domain.target_domain AND alias_domain.target_domain=domain.domain AND forwardings.active=1 AND alias_domain.active=1
