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-stable
mailing list