View source for GeoIP

==GeoIP install==
[http://www.maxmind.com/app/c GeoIP Country detection]
 apt-get install geoip-bin
To get city level geolocalisation we can get the free city db:
 mkdir /usr/local/share/GeoIP
 cd /usr/local/share/GeoIP
 wget http://www.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz
 gunzip GeoLiteCity.dat.gz
 ln -s /usr/local/share/GeoIP/GeoLiteCity.dat /usr/share/GeoIP/GeoIPCity.dat

 geoiplookup 85.234.207.107 
 GeoIP Country Edition: BE, Belgium
 GeoIP City Edition, Rev 1: BE, 02, Ixelles, (null), 50.833302, 4.366700, 0, 0
 GeoIP City Edition, Rev 0: BE, 02, Ixelles, (null), 50.833302, 4.366700
==Usage with AWFFull==
cf [[AWFFull]] page

in /etc/awffull/awffull.conf:
 GeoIP          yes

Actually awffull is not compiled with GeoIP support but we can rebuild the package
 awffull -v (interrupt it, it's at the beginning)
 => GeoIP is not available in this binary. Ignoring request to use.
ok, don't be impressed ;-)
<br>the building process of awffull is pretty well done, if it detects the headers of GeoIP it uses it, as simply as that.
 apt-get build-dep awffull
 apt-get source awffull
 cd awffull-3.7.1/
 apt-get install libgeoip1 libgeoip-dev
 dpkg-buildpackage -uc -b 
Et voilà! You can install the new .deb freshly created.
<br>Now you can run it, it will give e.g.
 awffull -v
 => awffull 3.7.1 (Linux 2.6.17-2-vserver-amd64) English
 => Using GeoIP for IP Address Lookups: /usr/share/GeoIP/GeoIP.dat
One bad point: we didn't fix the dependancies of our new package, for a local use this is ok but for larger use we should have added the libgeoip1 package in the list of dependencies of awffull.

==Usage with Zope==
cf [[Zope]]

First import the database on your MySQL db as <db_name>.csv [http://www.delau.net/php/geoip.html as descibed here]
Add a Python Script in zope (e.g. geoip):
 from Products.PythonScripts.standard import html_quote
 request = container.REQUEST
 RESPONSE =  request.RESPONSE
 ip = context.REQUEST.REMOTE_ADDR
 line = string.split(ip,'.')
 ip0 = line[0]
 ip1 = line[1]
 ip2 = line[2]
 ip3 = line[3]
 ipnum = int(ip0) * 16777216 + int(ip1) * 65536 + int(ip2) * 256 + int(ip3) * 1
 print ipnum
 return printed
Add a Z Mysql Method (e.g. select_GeoIP) with as Arguments  '''ipnum'''
 SELECT cn 
 from <db_name>.csv 
 where start < <dtml-sqlvar ipnum type="string"> and end > <dtml-sqlvar ipnum type="string">
In a DTML Method, test :
 <dtml-in expr="select_GeoIPs(ipnum=geoip())">Hoo, you are from <dtml-var cn>, Welcome !</dtml-in>
Same for latitude and longitude of the country [http://www.maxmind.com/app/country_latlon Country Geolocalization]