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 at 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 = 1Gives 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 at mail:~ % drill mysql1.mimar.rs > mysql1.mimar.rs. 3600 IN A 193.53.106.138> pacija at 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
On Thu, 25 Dec 2014 23:43:40 +0100 Marko Cupa? <marko.cupac at mimar.rs> wrote: Sorry, stupid typo in previous mail. Actually, this does not work (fqdn does not work, ip address does):> pacija at 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 > > 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 at mail:~ % drill mysql1.mimar.rs > > mysql1.mimar.rs. 3600 IN A 193.53.106.138 > > > pacija at 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 > _______________________________________________ > freebsd-ports at freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-ports > To unsubscribe, send any mail to "freebsd-ports-unsubscribe at freebsd.org"-- Marko Cupa? https://www.mimar.rs
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 at 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 = 1And 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 at mimar.rs"Forward and reverse drill resolve fine:> pacija at mail:~ % drill mysql1.mimar.rs > mysql1.mimar.rs. 3600 IN A 193.53.106.138> pacija at 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