josh at innurve dot com dot au (2011-05-28 20:10:08)
If you're having trouble making the GeoIP PHP functions recognise the location of your GeoIP database, the following block of code will show you all the directories in which the PHP functions are looking... so you'll need to shift your files around to suit it:
<?php
print_r( geoip_db_get_all_info() );
?>
and it'll output an array of 13 or so elements, looking something like this:
Array
(
[1] => Array
(
[available] => 1
[description] => GeoIP Country Edition
[filename] => /usr/share/GeoIP/GeoIP.dat
)
[2] => Array
(
[available] => 1
[description] => GeoIP City Edition, Rev 1
[filename] => /usr/share/GeoIP/GeoIPCity.dat
)
[3] => Array
(
[available] =>
[description] => GeoIP Region Edition, Rev 1
[filename] => /usr/share/GeoIP/GeoIPRegion.dat
)
.. and so on.
"available" will be 1 when the GeoIP file has been found and loaded.
NOTE: if you download the GeoLiteCity.dat.gz file from MaxMind, just decompress it and rename it to GeoIPCity.dat and use the GEOIP_CITY_EDITION_REV1 constant and it'll work fine in PHP.
nospam dot guilhem at nospam dot answeb dot net (2011-04-05 02:26:27)
Hello,
While trying to update the GeoIP.dat file under debian, I've found out that automatic updates via the geoipupdate (in geoip-bin package) is not available for the free edition. Here is a one-liner script that will do it. You can put it in a crontab, it will download the .dat file only if it has change :
cd /usr/share/GeoIP && wget GEOIP_URL -N && cat GeoIP.dat.gz | gzip -d > GeoIP.dat
Note : GEOIP_URL is to be found on the page http://www.maxmind.com/app/geoip_country, under the Binary Format section (The php note system won't allow me to put the full URL here
Crontab line could be :
@weekly cd /usr/share/GeoIP && (..)
nandox7 at myrealbox dot com (2008-12-26 18:49:18)
The GeoLiteCity free db works and can resolve city names and other informations.
Make sure the instructions are followed regarding it's installation.
http://www.maxmind.com/app/installation?city=1
At step 2 the decompress file must be moved and renamed.
The files needs to be called GeoIPCity.dat if not the mod_geoip will not find it.
thomas {AT} thomasfischer {D0T} BIZ (2008-04-07 17:04:40)
you can use this function to determine the continent of a country:
function getContinentFromCountry($country)
{
$data = array ("AF"=> "AS","AX"=>"EU","AL"=>"EU", "DZ"=>"AF","AS"=>"OC", "AD"=>"EU","AO"=> "AF" ........);
return $data[$country];
}
unfortunately this comment's size is restricted, so you will have the rest by yourself
for example:
getContinentFromCountry("DE") will result in "EU"
this data is based on
wikipedia's
List_of_countries_by_continent_(data_file)
kapouer at melix dot org (2008-03-01 07:26:57)
For Debian etch users : libgeoip is in version 1.4 so get the source from lenny (apt-get build-dep libgeoip;apt-get source libgeoip), compile it on etch (dpkg-buildpackage -rfakeroot in source folder) and install resulting libgeoip1 and libgeo-dev packages (dpkg -i)... Together with php5-dev this package is easy to install (phpize5;./configure --enable-geoip;make;make install)... Then check your install in php with :
<?php
echo geoip_database_info(GEOIP_COUNTRY_EDITION);
echo $_SERVER['REMOTE_ADDR'];
echo geoip_country_code3_by_name($_SERVER['REMOTE_ADDR']);
?>
please note free .dat is in /usr/share/GeoIP/GeoIP.dat
Use geoip-bin package to schedule automatic updates (configure /etc/geoip.default.conf and copy to /etc/geoip.conf, then add a crontab to make the updates...)
hope this helps
php dot comment dot addition at gmail dot com (2007-06-10 20:57:28)
Just to clarify the other comments, the maxmind post seems to be out of date / incorrect.
This module fails to work (ie: resolve cities) with the GeoLite City database from here:
http://www.maxmind.com/app/geolitecity
The error occurs when calling the function geoip_record_by_name(), which states incorrectly that the required database is not available. I have tested it with the very latest database, for which geoip_database_info() returns the version:
GEO-533LITE 20070601 Build 1 Copyright (c) 2007 MaxMind LLC All Rights Reserved
It does, however, resolve countries OK via the GeoLite Country database, which you can grab here: http://www.maxmind.com/app/geoip_country
I tested with the version:
GEO-106FREE 20070601 Build 1 Copyright (c) 2007 MaxMind LLC All Rights Reserved
tjmather at maxmind dot com (2007-02-26 20:09:51)
The geoip_country_*_by_name functions only work with GeoIP Country. The geoip_record_by_name function works with GeoIP City. geoip_region_by_name works with GeoIP Region. So the API should work with all of the GeoIP databases, as long as you call the correct function.
(2007-01-26 17:23:44)
I couldn't get it to work with the DMA code database (product ID 137). It seems to only work with the country database. The documentation should contain a warning that this code (as of 0.2.0) is incomplete and that Net_GeoIP should be used for non-country databases.
judas dot iscariote at gmail dot com (2006-11-16 19:59:49)
If you want to use this extension in SUSE/openSUSE, it is available here:
http://repos.opensuse.org/server:/php:/extensions/
Christian (2006-09-13 05:45:11)
Both, Ubuntu and Debian itself make usage of version 1.3.x of the c libraries, so installation can't be done with the debian packages, because configure stops with:
== configure: error: You need version 1.4.0 or higher of the C API ==
so you must download it from maxmind.
Matt (2006-09-08 13:34:34)
If you are a Debian or Ubuntu user, instead of building it from source, you can:
aptitude install libgeoip-dev libgeoip1