From owner-freebsd-stable@FreeBSD.ORG  Fri Dec 26 09:46:01 2014
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
Delivered-To: freebsd-stable@FreeBSD.org
Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115])
 (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by hub.freebsd.org (Postfix) with ESMTPS id E7B34C81;
 Fri, 26 Dec 2014 09:46:01 +0000 (UTC)
Received: from oslo.ath.cx (oslo.ath.cx [IPv6:2a01:4f8:200:42e4::1])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (Client CN "oslo.ath.cx", Issuer "oslo.ath.cx" (not verified))
 by mx1.freebsd.org (Postfix) with ESMTPS id 2F68A66ACA;
 Fri, 26 Dec 2014 09:46:00 +0000 (UTC)
Received: by oslo.ath.cx (OpenSMTPD) with ESMTP id 0457a15e;
 Fri, 26 Dec 2014 10:45:57 +0100 (CET)
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>
Subject: Re: mail/postfix does not resolve in mysql maps
Message-ID: <20141226094557.GA16193@oslo.ath.cx>
References: <20141225234340.c0a9d63354a2b9e5b230eb4e@mimar.rs>
 <20141226102507.82ed50bfae0d277ce65a740e@mimar.rs>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20141226102507.82ed50bfae0d277ce65a740e@mimar.rs>
User-Agent: Mutt/1.5.23 (2014-03-12)
Cc: freebsd-stable@FreeBSD.org, freebsd-ports@freebsd.org
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.18-1
Precedence: list
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-stable>,
 <mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable/>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
 <mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 26 Dec 2014 09:46:02 -0000

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