mail/postfix does not resolve in mysql maps

Marko Cupać marko.cupac at mimar.rs
Fri Dec 26 09:25:15 UTC 2014


Sorry for stupid typo in original mail, let's try once again.

I'm running 10.1-RELEASE-p3 and postfix-2.11.3_3,1 built in poudriere
on jail 10.1-RELEASE-p1, It seems that after upgrade to 10.1-RELEASE-p3
postfix stopped resolving FQDNs in my mysql maps files.

When 'hosts' is specified by IP address, connection to mysql server
works, but when it is specified by FQDN, it does not.

This does not work:
> pacija at mail:~ % sudo cat /usr/local/etc/postfix/smtpd_sender_login_maps.cf 
> user = someuser
> password = somepass
> hosts = mysql1.mimar.rs
> dbname = somedb
> query = SELECT goto FROM alias WHERE address = '%s' AND active = 1

And with the configuration above I get the following in maillog when
trying to send mail:
> Dec 26 10:13:42 mail postfix/submission/smtpd[7456]: warning: connect to mysql server mysql1.mimar.rs: Unknown MySQL server host 'mysql1.mimar.rs' (0)
> Dec 26 10:13:42 mail postfix/submission/smtpd[7456]: warning: mysql:/usr/local/etc/postfix/smtpd_sender_login_maps.cf lookup error for "marko.cupac at mimar.rs"

Forward and reverse drill resolve fine:
> pacija at mail:~ % drill mysql1.mimar.rs
> mysql1.mimar.rs.	3600	IN	A	193.53.106.138

> pacija at mail:~ % drill -x 193.53.106.138
> 138.106.53.193.in-addr.arpa.	3600	IN	PTR	mysql1.mimar.rs.

Where should I start looking for a solution?
-- 
Marko Cupać
https://www.mimar.rs


More information about the freebsd-ports mailing list