<!DOCTYPE html>
<html><head>
<meta charset="UTF-8">
</head><body><p>After digging into this more, it seems that the problem is that 4.1.3 does not support MMDB. That support is going to be added in v4.2.0. It should not crash though, but the fix is going to be more like "your database is not supported" -type of fix, if accepted by maintainers.</p><p>Aki</p><blockquote type="cite">On May 27, 2018 at 8:19 AM Chris Jones <cpjones44@gmail.com> wrote: <br> <br><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="ox-4768ab33f1-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>It seems you found a bug. <a href="https://github.com/PowerDNS/pdns/issues/6676" target="_blank" rel="noopener">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" target="_blank" rel="noopener">geo.example.org</a> <br> > ttl: 60 <br> > records: <br> > <a href="http://geo.example.org" target="_blank" rel="noopener">geo.example.org</a>: <br> > - soa: <a href="http://ns.example.org" target="_blank" rel="noopener">ns.example.org</a>. <a href="http://geoman.example.org" target="_blank" rel="noopener">geoman.example.org</a>. 1 7200 3600 86400 60 <br> > - ns: <a href="http://ns.example.org" target="_blank" rel="noopener">ns.example.org</a>. <br> > <a href="http://deu.geo.example.org" target="_blank" rel="noopener">deu.geo.example.org</a>: <br> > - a: 192.0.0.2 <br> > - txt: Guten Tag <br> > <a href="http://esp.geo.example.org" target="_blank" rel="noopener">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" target="_blank" rel="noopener">blah.geo.example.org</a>: <br> > - a: 1.1.1.1 <br> > "*. <a href="http://geo.example.org" target="_blank" rel="noopener">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" target="_blank" rel="noopener">www.geo.example.org</a>: '% <a href="http://co.geo.example.org" target="_blank" rel="noopener">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" target="_blank" rel="noopener">blah.geo.example.org</a> @ <a href="http://14.201.167.71" target="_blank" rel="noopener">14.201.167.71</a> <br> > <br> > ; <<>> DiG 9.10.3-P4-Ubuntu <<>> <a href="http://blah.geo.example.org" target="_blank" rel="noopener">blah.geo.example.org</a> @ <a href="http://14.201.167.71" target="_blank" rel="noopener">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" target="_blank" rel="noopener">blah.geo.example.org</a>. IN A <br> > <br> > ;; ANSWER SECTION: <br> > <a href="http://blah.geo.example.org" target="_blank" rel="noopener">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" target="_blank" rel="noopener">geo.example.org</a> @ <a href="http://14.201.167.71" target="_blank" rel="noopener">14.201.167.71</a> <br> > <br> > ; <<>> DiG 9.10.3-P4-Ubuntu <<>> <a href="http://geo.example.org" target="_blank" rel="noopener">geo.example.org</a> @ <a href="http://14.201.167.71" target="_blank" rel="noopener">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" target="_blank" rel="noopener">geo.example.org</a>. IN A <br> > <br> > ;; AUTHORITY SECTION: <br> > <a href="http://geo.example.org" target="_blank" rel="noopener">geo.example.org</a>. 60 IN SOA <a href="http://ns.example.org" target="_blank" rel="noopener">ns.example.org</a>. <br> > <a href="http://geoman.example.org" target="_blank" rel="noopener">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" target="_blank" rel="noopener">www.geo.example.org</a> @ <a href="http://14.201.167.71" target="_blank" rel="noopener">14.201.167.71</a> <br> > <br> > ; <<>> DiG 9.10.3-P4-Ubuntu <<>> <a href="http://www.geo.example.org" target="_blank" rel="noopener">www.geo.example.org</a> @ <a href="http://14.201.167.71" target="_blank" rel="noopener">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="noopener">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/" target="_blank" rel="noopener">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/" target="_blank" rel="noopener">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></blockquote></body></html>