GeoIP lookup broken with latest maxmind db

murmaider · Post by **murmaider** » 10 Nov 2023, 09:42

Hi,

There has been an update to the GeoLite2-Country-Locations-en.csv file that comes from maxmind.

Prior to around 31st October 2023, the GeoLite2-Country-Locations-en.csv file had this entry:

Code: Select all

2750405,en,EU,Europe,NL,Netherlands,1

After the 1st November 2023, this line has been updated to:

Code: Select all

2750405,en,EU,Europe,NL,"The Netherlands",1

For some reason, csf is having an issue with parsing "The Netherlands" and is causing the csf ip lookups to fail.

Code: Select all

# csf --iplookup 169.159.129.125
169.159.129.125 (-)

# sed -i 's/\"The Netherlands\"/Netherlands/g' /var/lib/csf/Geo/GeoLite2-Country-Locations-en.csv

# csf --iplookup 169.159.129.125
169.159.129.125 (ZA/South Africa/-)

This is using csf: v14.20

Regards,
Dave