<div dir="auto">Thanks for documenting Aki. I look forward to this bug being resolved.<div dir="auto"><br></div><div dir="auto">Regards,</div><div dir="auto">Chris.</div></div><br><div class="gmail_quote"><div dir="ltr">On Sun, May 27, 2018, 4:15 PM Aki Tuomi <<a href="mailto:cmouse@cmouse.fi">cmouse@cmouse.fi</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">It seems you found a bug. <a href="https://github.com/PowerDNS/pdns/issues/6676" rel="noreferrer noreferrer" target="_blank">https://github.com/PowerDNS/pdns/issues/6676</a><br>
<br>
Aki<br>
<br>
On Sun, May 27, 2018 at 08:43:22AM +1000, Chris Jones wrote:<br>
> Hi Aki,<br>
> <br>
> Here is my geo.yml zone file:<br>
> <br>
> domains:<br>
> - domain: <a href="http://geo.example.org" rel="noreferrer noreferrer" target="_blank">geo.example.org</a><br>
> ttl: 60<br>
> records:<br>
> <a href="http://geo.example.org" rel="noreferrer noreferrer" target="_blank">geo.example.org</a>:<br>
> - soa: <a href="http://ns.example.org" rel="noreferrer noreferrer" target="_blank">ns.example.org</a>. <a href="http://geoman.example.org" rel="noreferrer noreferrer" target="_blank">geoman.example.org</a>. 1 7200 3600 86400 60<br>
> - ns: <a href="http://ns.example.org" rel="noreferrer noreferrer" target="_blank">ns.example.org</a>.<br>
> <a href="http://deu.geo.example.org" rel="noreferrer noreferrer" target="_blank">deu.geo.example.org</a>:<br>
> - a: 192.0.0.2<br>
> - txt: Guten Tag<br>
> <a href="http://esp.geo.example.org" rel="noreferrer noreferrer" target="_blank">esp.geo.example.org</a>:<br>
> - a: 192.0.0.10<br>
> - txt: Muy buenos dias<br>
> - loc: 40 8 43.041 N 3 21 42.539 W 714m 10m 100m 10m<br>
> <a href="http://blah.geo.example.org" rel="noreferrer noreferrer" target="_blank">blah.geo.example.org</a>:<br>
> - a: 1.1.1.1<br>
> "*.<a href="http://geo.example.org" rel="noreferrer noreferrer" target="_blank">geo.example.org</a>":<br>
> - a: 127.0.0.53<br>
> - txt: I don't know exactly where you are<br>
> services:<br>
> <a href="http://www.geo.example.org" rel="noreferrer noreferrer" target="_blank">www.geo.example.org</a>: '%<a href="http://co.geo.example.org" rel="noreferrer noreferrer" target="_blank">co.geo.example.org</a>'<br>
> <br>
> Here is the output of some dig commands too (note, the DNS server is on the<br>
> internet, so feel free to dig yourself):<br>
> <br>
> *cpjones@ubuntu:~$* dig <a href="http://blah.geo.example.org" rel="noreferrer noreferrer" target="_blank">blah.geo.example.org</a> @<a href="http://14.201.167.71" rel="noreferrer noreferrer" target="_blank">14.201.167.71</a><br>
> <br>
> ; <<>> DiG 9.10.3-P4-Ubuntu <<>> <a href="http://blah.geo.example.org" rel="noreferrer noreferrer" target="_blank">blah.geo.example.org</a> @<a href="http://14.201.167.71" rel="noreferrer noreferrer" target="_blank">14.201.167.71</a><br>
> ;; global options: +cmd<br>
> ;; Got answer:<br>
> ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 31532<br>
> ;; flags: qr aa rd; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1<br>
> ;; WARNING: recursion requested but not available<br>
> <br>
> ;; OPT PSEUDOSECTION:<br>
> ; EDNS: version: 0, flags:; udp: 1680<br>
> ;; QUESTION SECTION:<br>
> ;<a href="http://blah.geo.example.org" rel="noreferrer noreferrer" target="_blank">blah.geo.example.org</a>. IN A<br>
> <br>
> ;; ANSWER SECTION:<br>
> <a href="http://blah.geo.example.org" rel="noreferrer noreferrer" target="_blank">blah.geo.example.org</a>. 60 IN A 1.1.1.1<br>
> <br>
> ;; Query time: 3 msec<br>
> ;; SERVER: 14.201.167.71#53(14.201.167.71)<br>
> ;; WHEN: Sun May 27 08:38:54 STD 2018<br>
> ;; MSG SIZE rcvd: 65<br>
> <br>
> *cpjones@ubuntu:~$* dig <a href="http://geo.example.org" rel="noreferrer noreferrer" target="_blank">geo.example.org</a> @<a href="http://14.201.167.71" rel="noreferrer noreferrer" target="_blank">14.201.167.71</a><br>
> <br>
> ; <<>> DiG 9.10.3-P4-Ubuntu <<>> <a href="http://geo.example.org" rel="noreferrer noreferrer" target="_blank">geo.example.org</a> @<a href="http://14.201.167.71" rel="noreferrer noreferrer" target="_blank">14.201.167.71</a><br>
> ;; global options: +cmd<br>
> ;; Got answer:<br>
> ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 25678<br>
> ;; flags: qr aa rd; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 1<br>
> ;; WARNING: recursion requested but not available<br>
> <br>
> ;; OPT PSEUDOSECTION:<br>
> ; EDNS: version: 0, flags:; udp: 1680<br>
> ;; QUESTION SECTION:<br>
> ;<a href="http://geo.example.org" rel="noreferrer noreferrer" target="_blank">geo.example.org</a>. IN A<br>
> <br>
> ;; AUTHORITY SECTION:<br>
> <a href="http://geo.example.org" rel="noreferrer noreferrer" target="_blank">geo.example.org</a>. 60 IN SOA <a href="http://ns.example.org" rel="noreferrer noreferrer" target="_blank">ns.example.org</a>.<br>
> <a href="http://geoman.example.org" rel="noreferrer noreferrer" target="_blank">geoman.example.org</a>. 1 7200 3600 86400 60<br>
> <br>
> ;; Query time: 4 msec<br>
> ;; SERVER: 14.201.167.71#53(14.201.167.71)<br>
> ;; WHEN: Sun May 27 08:37:37 STD 2018<br>
> ;; MSG SIZE rcvd: 90<br>
> <br>
> And finally, the record under services:<br>
> <br>
> *cpjones@ubuntu:~$* dig <a href="http://www.geo.example.org" rel="noreferrer noreferrer" target="_blank">www.geo.example.org</a> @<a href="http://14.201.167.71" rel="noreferrer noreferrer" target="_blank">14.201.167.71</a><br>
> <br>
> ; <<>> DiG 9.10.3-P4-Ubuntu <<>> <a href="http://www.geo.example.org" rel="noreferrer noreferrer" target="_blank">www.geo.example.org</a> @<a href="http://14.201.167.71" rel="noreferrer noreferrer" target="_blank">14.201.167.71</a><br>
> ;; global options: +cmd<br>
> ;; connection timed out; no servers could be reached<br>
> <br>
> Regards,<br>
> Chris.<br>
> <br>
> On Sun, May 27, 2018 at 3:06 AM Aki Tuomi <<a href="mailto:cmouse@cmouse.fi" target="_blank" rel="noreferrer">cmouse@cmouse.fi</a>> wrote:<br>
> <br>
> > On Sat, May 26, 2018 at 08:14:15PM +1000, Chris Jones wrote:<br>
> > > Hi there,<br>
> > ><br>
> > > I have successfully setup a pdns instance using the geoip backend and a<br>
> > > copy of the legacy GeoIP database (from<br>
> > > <a href="https://dev.maxmind.com/geoip/legacy/install/country/" rel="noreferrer noreferrer" target="_blank">https://dev.maxmind.com/geoip/legacy/install/country/</a>). Throughout the<br>
> > > MaxMind website, I read that this database is end of life in favor for<br>
> > > GeoIP2 (available at <a href="https://dev.maxmind.com/geoip/geoip2/geolite2/" rel="noreferrer noreferrer" target="_blank">https://dev.maxmind.com/geoip/geoip2/geolite2/</a>).<br>
> > ><br>
> > > The GeoIP legacy database is in the .DAT format, and the GeoIP2 database<br>
> > is<br>
> > > in a MMDB format. Reading the pdns documentation, it is confusing whether<br>
> > > MMDB is nativity supported or if I have to do something to the database<br>
> > > file to make it work.<br>
> > ><br>
> ><br>
> > It should work.<br>
> ><br>
> > > My pdns.conf file contains the following parameters when using the GeoIP<br>
> > > legacy database:<br>
> > ><br>
> > > launch=geoip<br>
> > > geoip-database-files=/etc/pdns/GeoIP.dat<br>
> > > geoip-zones-file=/etc/pdns/geo.yml<br>
> > ><br>
> > > That works fine. But when I change the *geoip-database-files* parameter<br>
> > to<br>
> > > use the MMDB file, it does not work (geo requests are timing out -<br>
> > standard<br>
> > > records work fine though).<br>
> > ><br>
> > > launch=geoip<br>
> > > geoip-database-files=/etc/pdns/GeoLite2-City.mmdb<br>
> > > geoip-zones-file=/etc/pdns/geo.yml<br>
> > ><br>
> > > Has anyone got an example or suggestions on how I can use the GeoIP2<br>
> > > databases with the pdns-geoip backend?<br>
> > ><br>
> > > System: CentOS 7 + pdns 4.1.3<br>
> > ><br>
> > > Thanks,<br>
> > > Chris.<br>
> ><br>
> > Can you provide your geo.yml?<br>
> ><br>
> > Aki<br>
> ><br>
</blockquote></div>