From owner-freebsd-ports@FreeBSD.ORG  Thu Dec 25 22:43:51 2014
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
Delivered-To: freebsd-ports@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 AD08033D;
 Thu, 25 Dec 2014 22:43:51 +0000 (UTC)
Received: from mail.mimar.rs (mail.mimar.rs [193.53.106.129])
 by mx1.freebsd.org (Postfix) with ESMTP id 62D6E641C1;
 Thu, 25 Dec 2014 22:43:50 +0000 (UTC)
Received: from mail.mimar.rs (localhost [127.0.0.1])
 by mail.mimar.rs (Postfix) with ESMTP id CA2A61AF347;
 Thu, 25 Dec 2014 23:43:48 +0100 (CET)
X-Virus-Scanned: amavisd-new at mimar.rs
Received: from mail.mimar.rs ([127.0.0.1])
 by mail.mimar.rs (mail.mimar.rs [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 2xCEsk5eZIAj; Thu, 25 Dec 2014 23:43:41 +0100 (CET)
Received: from efreet.mimar.rs (unknown [93.87.149.102])
 (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits))
 (No client certificate requested)
 (Authenticated sender: marko.cupac@mimar.rs)
 by mail.mimar.rs (Postfix) with ESMTPSA id 471481AF2E5;
 Thu, 25 Dec 2014 23:43:41 +0100 (CET)
Date: Thu, 25 Dec 2014 23:43:40 +0100
From: Marko =?UTF-8?B?Q3VwYcSH?= <marko.cupac@mimar.rs>
To: freebsd-ports@FreeBSD.org
Subject: mail/postfix does not resolve in mysql maps
Message-Id: <20141225234340.c0a9d63354a2b9e5b230eb4e@mimar.rs>
X-Mailer: Sylpheed 3.4.2 (GTK+ 2.24.25; amd64-portbld-freebsd10.0)
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Cc: freebsd-stable@FreeBSD.org
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.18-1
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-ports>,
 <mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports/>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
 <mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 25 Dec 2014 22:43:51 -0000

Hi,

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.

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
> hosts = 193.53.106.138
> dbname = somedb
> query = SELECT goto FROM alias WHERE address = '%s' AND active = 1

Gives the following message in maillog:
> Dec 25 14:12:56 mail postfix/submission/smtpd[1277]: warning: connect to mysql server mysql1.mimar.rs: Unknown MySQL server host 'mysql1.mimar.rs' (0)

Drill resolves fine both forward and reverse:
> 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.

I have updated jail and am rebuilding postfix.
-- 
Marko Cupać
https://www.mimar.rs