Posts Tagged MaxMind

Refresh GeoIP automatically

GeoIP is a very useful tool provided by MaxMind. It can determine which country, region, city, postal code, and area code the visitor is coming from in real-time. For more information, visit MaxMind website.

This tool is also coming with an Apache module allowing to redirect users depending on their location. For example, we could redirect all users from France to the French home page of a multi-language website, or we could block the traffic to users from a specific country.

To install this module on a Debian server, you simply need to run the following command:

apt-get install libapache2-mod-geoip

But, how does this module work? How does it know where the user comes from?  😯
It is actually quite simple: GeoIP is using a mapping file of IP address by country. On Debian, this file is stored in the folder /usr/share/GeoIP and is named GeoIP.dat.

However, the IP addresses are something which change all the time. So this file will get out-of-date very quickly. This is why MaxMind provides an updated file at the beginning of each month for free. To read the installation instructions, please click the following link: http://www.maxmind.com/app/installation

This is good and well, but who will remember or even have the time to update this file every month? And imagine if you have to do this on hundreds of servers?
The solution is to use a shell script which will download, extract and install the updated GeoIP file automatically once a month:

01#!/bin/sh
02 
03# Go in the GeoIP folder
04cd /usr/share/GeoIP
05 
06# Remove the previous GeoIP file (if present)
07rm GeoIP.dat.gz
08 
09# Download the new GeoIP file
10wget http://geolite.maxmind.com/download/geoip/database/GeoLiteCountry/GeoIP.dat.gz
11 
12# Remove the previous GeoIP backup file
13rm GeoIP.dat.bak
14 
15# Backup the existing GeoIP file
16mv GeoIP.dat GeoIP.dat.bak
17 
18# Extract the new GeoIP file
19gunzip GeoIP.dat.gz
20 
21# Change the permission of the GeoIP file
22chmod 644 GeoIP.dat
23 
24# Reload Apache
25service apache2 reload

You can place this file in your root folder and set up the following crontab job:

0 0 3 * * /root/update_geoip.sh

This will execute the script automatically on the third day of every month.

, , , , , , ,

2 Comments