Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 26 Dec 2014 10:25:07 +0100
From:      Marko =?UTF-8?B?Q3VwYcSH?= <marko.cupac@mimar.rs>
To:        freebsd-ports@freebsd.org
Cc:        freebsd-stable@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>

next in thread | previous in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20141226102507.82ed50bfae0d277ce65a740e>