mail/postfix does not resolve in mysql maps

[Herbert J. Skuhra]

On Fri, Dec 26, 2014 at 10:25:07AM +0100, Marko Cupać wrote:
> 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?

Chroot? Maybe someone can help if you post the output of 'postconf -n'
and your master.cf?

-- 
Herbert