Date: Fri, 26 Dec 2014 10:45:57 +0100 From: "Herbert J. Skuhra" <herbert@oslo.ath.cx> To: Marko =?utf-8?B?Q3VwYcSH?= <marko.cupac@mimar.rs> Cc: freebsd-stable@FreeBSD.org, freebsd-ports@freebsd.org Subject: Re: mail/postfix does not resolve in mysql maps Message-ID: <20141226094557.GA16193@oslo.ath.cx> In-Reply-To: <20141226102507.82ed50bfae0d277ce65a740e@mimar.rs> References: <20141225234340.c0a9d63354a2b9e5b230eb4e@mimar.rs> <20141226102507.82ed50bfae0d277ce65a740e@mimar.rs>
next in thread | previous in thread | raw e-mail | index | archive | help
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@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@mimar.rs" > > Forward and reverse drill resolve fine: > > pacija@mail:~ % drill mysql1.mimar.rs > > mysql1.mimar.rs. 3600 IN A 193.53.106.138 > > > pacija@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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20141226094557.GA16193>