Help with GeoIP and csv format

[ChrisC]

Hi everyone,
I just learnt of this service: https://ip66.dev/ which purports to be a drop-in replacement for the MaxMind service.
I downloaded the mmdb, and using mmdbinspect against it works fine.
There exists a github project to convert .mmdb files into .csv files, but I have no idea if this would be compatible.
Does anyone know the format of the CSV files that OPNsense will accept for the GeoIP function?
I assume it also has to be compressed? I have seen both .zip and .gz extensions mentioned in URLs.

Thanks!

[meyergru]

Interesting. Their database seems to be bigger at 17 MByte than Maxmind's GeoIP Lite at 11 MByte.

I just emailed them if they could provide a compressed CSV version like Maxmind.

That being said, if you need more accurate data than Maxmind's, which is also free, you can use ipinfo.io, like explained here.

[IPinfo]

I work for IPinfo. We are the most accurate IP geolocation data provider out there. The IP to Country data integration we have with Opnsense is the full accuracy version of it even though it is free. So, if you need country-level geolocation for free, it does not get better than this, which also includes paid data.

Another aspect is that we are active in the community. So, you can always ping me and ask questions about our data. Cheers.

— Abdullah | DevRel, IPinfo

[Patrick M. Hausen]

Hi!

Thanks for joining in the discussion. I use IPinfo with OPNsense, already.

Is the file format identical to Maxmind, so I can use it with software officially only supporting the latter? Like Elastiflow? Just point it at your files instead?

Thanks!
Patrick

[ChrisC]

Interesting. Their database seems to be bigger at 17 MByte than Maxmind's GeoIP Lite at 11 MByte.

I just emailed them if they could provide a compressed CSV version like Maxmind.

That being said, if you need more accurate data than Maxmind's, which is also free, you can use ipinfo.io, like explained here.

I did think about mailing them, but I thought I should at least try and figure out some of it myself!
Thanks, I'll check it out!