

Information regarding the IP location, the country data and email address is provided with this check type.


To enable MaxMind integration in WHMCS 8.1 and earlier, follow the steps below: You can find these within the My License Key page inside the MaxMind online portal. Enter your MaxMind User ID and the Licence Key.Navigate to Configuration ( ) > System Settings > Fraud Protection.Recode latin1.utf-8 GeoLiteCity-Location.To enable MaxMind integration in WHMCS 8.2 and later, follow the steps below: Sed -i -e 's/"//g' GeoLiteCity-Blocks.csvįinally, you probably want to use UTF-8 encoded data, so the Location CSV needs some recoding:

Luckily the strings are simple so the quotes can just be stripped: The Maxmind CSV uses quotes to encapsulate string contents but sqlite doesn't understand this and will add all strings with quotes. Sed -i -n '3,$p' GeoLiteCity-Location.csv Since working with a 120MB file in an editor can be a pain 1), we do this with sed: LocId,country,region,city,postalCode,latitude,longitude,metroCode,areaCodeĪs you can see the first two lines are not real data – they have to go. Let's have a look at their format:Ĭopyright (c) 2007 MaxMind LLC. After downloading and unpacking the ZIP file you'll have two files: GeoLiteCity-Blocks.csv and GeoLiteCity-Location.csv.
