From owner-freebsd-ports@FreeBSD.ORG Fri Dec 26 09:25:15 2014 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id F3C256EB; Fri, 26 Dec 2014 09:25:14 +0000 (UTC) Received: from mail.mimar.rs (mail.mimar.rs [193.53.106.129]) by mx1.freebsd.org (Postfix) with ESMTP id A9E4366864; Fri, 26 Dec 2014 09:25:14 +0000 (UTC) Received: from mail.mimar.rs (localhost [127.0.0.1]) by mail.mimar.rs (Postfix) with ESMTP id E79661AF3A5; Fri, 26 Dec 2014 10:25:11 +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 pZN5sA91GYvG; Fri, 26 Dec 2014 10:25:08 +0100 (CET) Received: from efreet.mimar.rs (unknown [193.53.106.34]) (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 CABEE1AF312; Fri, 26 Dec 2014 10:25:07 +0100 (CET) Date: Fri, 26 Dec 2014 10:25:07 +0100 From: Marko =?UTF-8?B?Q3VwYcSH?= To: freebsd-ports@freebsd.org Subject: Re: mail/postfix does not resolve in mysql maps Message-Id: <20141226102507.82ed50bfae0d277ce65a740e@mimar.rs> In-Reply-To: <20141225234340.c0a9d63354a2b9e5b230eb4e@mimar.rs> References: <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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 26 Dec 2014 09:25:15 -0000 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? -- Marko Cupać https://www.mimar.rs