Auth error with sender domain Mail relay rule

[DavidePrincipi]

After Mail 1.7.0 update a relay rule based on sender domain stops to send SMTP credentials.

Steps to reproduce

• Create a sender-based relay rule, for domain domain.test and remote server authentication credentials
• Send a message from someone@domain.test

Expected behavior

The message is relayed to the remote server with SMTP authentication.

Actual behavior

Credentials are not presented to the remote server, which may refuse to deliver the message.

Jul 09 16:20:32 dn1 postfix/smtp[28288]: maps_find: smtp_sasl_password_maps: noreply@addusers.test: not found
Jul 09 16:20:32 dn1 postfix/smtp[28288]: match_list_match: addusers.test: no match
Jul 09 16:20:32 dn1 postfix/smtp[28288]: dict_sqlite_lookup: /etc/postfix/relaycredentials.cf: Searching with query SELECT FORMAT('%s:%s', username, password) AS credentials  FROM relayrules  WHERE enabled = 1 AND (    (rule_subject = '@addusers.test' AND rule_type = 'sender')    OR ('@addusers.test' IN (FORMAT('[%s]:%s', host, port), FORMAT('[%s]', host)) AND rule_type != 'sender')  ) AND username != ''  LIMIT 1
Jul 09 16:20:32 dn1 postfix/smtp[28288]: maps_find: smtp_sasl_password_maps: @addusers.test: not found
Jul 09 16:20:32 dn1 postfix/smtp[28288]: mail_addr_find: noreply@addusers.test -> (not found)
Jul 09 16:20:32 dn1 postfix/smtp[28288]: dict_sqlite_lookup: /etc/postfix/relaycredentials.cf: Searching with query SELECT FORMAT('%s:%s', username, password) AS credentials  FROM relayrules  WHERE enabled = 1 AND (    (rule_subject = '127.0.0.1' AND rule_type = 'sender')    OR ('127.0.0.1' IN (FORMAT('[%s]:%s', host, port), FORMAT('[%s]', host)) AND rule_type != 'sender')  ) AND username != ''  LIMIT 1
Jul 09 16:20:32 dn1 postfix/smtp[28288]: maps_find: smtp_sasl_password_maps: 127.0.0.1: not found
Jul 09 16:20:32 dn1 postfix/smtp[28288]: dict_sqlite_lookup: /etc/postfix/relaycredentials.cf: Searching with query SELECT FORMAT('%s:%s', username, password) AS credentials  FROM relayrules  WHERE enabled = 1 AND (    (rule_subject = '[127.0.0.1]:10002' AND rule_type = 'sender')    OR ('[127.0.0.1]:10002' IN (FORMAT('[%s]:%s', host, port), FORMAT('[%s]', host)) AND rule_type != 'sender')  ) AND username != ''  LIMIT 1
Jul 09 16:20:32 dn1 postfix/smtp[28288]: maps_find: smtp_sasl_password_maps: [127.0.0.1]:10002: not found
Jul 09 16:20:32 dn1 postfix/smtp[28288]: smtp_sasl_passwd_lookup: no auth info found (sender=`noreply@addusers.test', host=`127.0.0.1')

Components

• Mail 1.7.0

See also

• https://community.nethserver.org/t/relay-error-after-update-mail-node-to-1-7-0/26012

---

Thanks to Madpatrick

[DavidePrincipi]

In Testing Mail 1.7.1-dev.2

Test case

Check the bug is not reproducible.

This is a successful log trace, as returned by the automated test suite (POSTFIX_DEBUG=5):

Jul 09 16:49:58 dn1 postfix/smtp[28031]: dict_sqlite_lookup: /etc/postfix/relaycredentials.cf: Searching with query SELECT FORMAT('%s:%s', username, password) AS credentials  FROM relayrules  WHERE enabled = 1 AND (    (rule_type = 'sender' AND      CASE INSTR('noreply@addusers.test', '@')        WHEN 1 THEN ('@' || rule_subject) = 'noreply@addusers.test'        ELSE rule_subject = 'noreply@addusers.test'      END    )    OR ('noreply@addusers.test' IN (FORMAT('[%s]:%s', host, port), FORMAT('[%s]', host)) AND rule_type != 'sender')  ) AND username != ''  LIMIT 1
Jul 09 16:49:58 dn1 postfix/smtp[28031]: maps_find: smtp_sasl_password_maps: noreply@addusers.test: not found
Jul 09 16:49:58 dn1 postfix/smtp[28031]: match_list_match: addusers.test: no match
Jul 09 16:49:58 dn1 postfix/smtp[28031]: dict_sqlite_lookup: /etc/postfix/relaycredentials.cf: Searching with query SELECT FORMAT('%s:%s', username, password) AS credentials  FROM relayrules  WHERE enabled = 1 AND (    (rule_type = 'sender' AND      CASE INSTR('@addusers.test', '@')        WHEN 1 THEN ('@' || rule_subject) = '@addusers.test'        ELSE rule_subject = '@addusers.test'      END    )    OR ('@addusers.test' IN (FORMAT('[%s]:%s', host, port), FORMAT('[%s]', host)) AND rule_type != 'sender')  ) AND username != ''  LIMIT 1
Jul 09 16:49:58 dn1 postfix/smtp[28031]: maps_find: smtp_sasl_password_maps: sqlite:/etc/postfix/relaycredentials.cf(0,lock|fold_fix|utf8_request): @addusers.test = usr_bug7551:usr_bug7551-pass
Jul 09 16:49:58 dn1 postfix/smtp[28031]: mail_addr_find: noreply@addusers.test -> usr_bug7551:usr_bug7551-pass
Jul 09 16:49:58 dn1 postfix/smtp[28031]: smtp_sasl_passwd_lookup: host `127.0.0.1' user `usr_bug7551' pass `usr_bug7551-pass'

Search in the journal with:

journalctl --grep smtp_sasl_passwd_lookup