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