I would like to configure the GeoIP module to use the free MaxMind GeoLite city database, available here: http://www.maxmind.com/app/geolitecity
The MaxMind database comes in the form of two comma delimited files: one that maps IP addresses to numeric location ids (GeoLiteCity-Blocks.csv), and another that maps location ids to country/city/state/zip (GeoLiteCity-Location.csv).
The GeoIP module appears to be looking for a single database file (geoip_city.dat). How do I convert the two files from MaxMind into a single city-level file for GeoIP?
The fallback would be to use the MaxMind GeoLite country database, available here: http://www.maxmind.com/app/geoip_country , then convert it using the /contrib/geo2nginx.pl script into a GeoIP-compatible format. However, I'd prefer to have the higher resolution of the city database, if possible.
Cheers.