GeoIP not working?

04nunhucks

Well-Known Member
#1
Hello, I can't seem to get GeoIP working properly for use with scripts on my server.

Basically, I've enabled the IP GeoLocation in LS, at server level, and provided the .dat for it. I've also enabled it at VHOST level, and added a GeoIPEnable On directive to the relevant htaccess.

However, scripts cannot use functions, such as -Call to undefined function- geoip_database_info().

PHPInfo shows that _SERVER[GEOIP_*] (4 entries) and it's accurate, but I can't seem to get scripts to use the functions. Any ideas?
 

webizen

Well-Known Member
#4
Here is the procedure:
  1. download pecl geoip from http://pecl.php.net/package/geoip
    wget http://pecl.php.net/get/geoip-1.0.7.tgz
  2. build geoip.so module
    tar zxf geoip-1.0.7.tgz
    cd geoip-1.0.7
    /usr/local/lsws/lsphp5/bin/phpize
    ./configure --with-php-config=/usr/local/lsws/lsphp5/bin/php-config
    make
    make install
    Note:
    a. you need to install geoip and geoip-devel rpm if not done so (yum install GeoIP-devel).
    b. /usr/local/lsws/lsphp5 is the prefix of running lsphp5.
  3. add line "extension=geoip.so" to your lsphp5 php.ini file.
  4. restart lsws to make it effective.
 

04nunhucks

Well-Known Member
#6
Webizen, when I try to use some functions, as in the code below,

PHP:
<?php
if (geoip_db_avail(GEOIP_CITY_EDITION_REV1))
    print geoip_database_info(GEOIP_CITY_EDITION_REV1)."<br>";
$record = geoip_record_by_name("www.google.com");
if ($record) {
    print_r($record);
}
else {
    print "No location found!";
}
?>
It doesn't work - the function is just failing.
 

webizen

Well-Known Member
#7
Here is what GeoIP can do in LSWS (http://www.maxmind.com/http://www.litespeedtech.com/support/forum/showthread.php?t=830)

Notes

GeoIP: Set GeoIP database in Server scope and enable GeoIP for specific vhosts. Processed GeoIP data is available in the SERVER environment variables in the variable name format of 'GEOIP_XYZ' where XYZ depends on edition of Maxmind product you use. Fully compatible with scripts designed for mod_geoip.
Once you see the $_SERVER[GEOIP_*] variables, GeoIP in LSWS is working properly.

You are trying to use GeoIP functions (http://www.php.net/manual/en/ref.geoip.php) in PHP which is outside of LSWS. That's why suggestion to add geoip support in lsphp5 is provided. Looks like your GeoDB data file isn't not in the right place. Hence the problem. Copy the GeoIP data file to /usr/share/GeoIP directory to let PHP GeoIP extension pick them up (http://www.php.net/manual/en/geoip.setup.php).

Once done, you can verify which database is available in your system with a script like the following:
PHP:
<?php
$cst = array(
             'GEOIP_COUNTRY_EDITION' => GEOIP_COUNTRY_EDITION,
             'GEOIP_REGION_EDITION_REV0' => GEOIP_REGION_EDITION_REV0,
             'GEOIP_CITY_EDITION_REV0' => GEOIP_CITY_EDITION_REV0,
             'GEOIP_ORG_EDITION' => GEOIP_ORG_EDITION,
             'GEOIP_ISP_EDITION' => GEOIP_ISP_EDITION,
             'GEOIP_CITY_EDITION_REV1' => GEOIP_CITY_EDITION_REV1,
             'GEOIP_REGION_EDITION_REV1' => GEOIP_REGION_EDITION_REV1,
             'GEOIP_PROXY_EDITION' => GEOIP_PROXY_EDITION,
             'GEOIP_ASNUM_EDITION' => GEOIP_ASNUM_EDITION,
             'GEOIP_NETSPEED_EDITION' => GEOIP_NETSPEED_EDITION,
             'GEOIP_DOMAIN_EDITION' => GEOIP_DOMAIN_EDITION,
             );

foreach ($cst as $k=>$v) {
    echo $k.': '.geoip_db_filename($v).'  '.(geoip_db_avail($v) ? 'Available':'').'<br>';
}
?>
 
Last edited:

04nunhucks

Well-Known Member
#8
Hello webizen,

Thank you very much for the details - it is much appreciated.

Below's a copy of the output:

GEOIP_COUNTRY_EDITION: /var/lib/GeoIP/GeoIP.dat Available
GEOIP_REGION_EDITION_REV0: /var/lib/GeoIP/GeoIPRegion.dat
GEOIP_CITY_EDITION_REV0: /var/lib/GeoIP/GeoIPCity.dat Available
GEOIP_ORG_EDITION: /var/lib/GeoIP/GeoIPOrg.dat
GEOIP_ISP_EDITION: /var/lib/GeoIP/GeoIPISP.dat
GEOIP_CITY_EDITION_REV1: /var/lib/GeoIP/GeoIPCity.dat Available
GEOIP_REGION_EDITION_REV1: /var/lib/GeoIP/GeoIPRegion.dat
GEOIP_PROXY_EDITION: /var/lib/GeoIP/GeoIPProxy.dat
GEOIP_ASNUM_EDITION: /var/lib/GeoIP/GeoIPASNum.dat
GEOIP_NETSPEED_EDITION: /var/lib/GeoIP/GeoIPNetSpeed.dat
GEOIP_DOMAIN_EDITION: /var/lib/GeoIP/GeoIPDomain.dat
 

DanEZPZ

Well-Known Member
#9
Here is the procedure:
  1. download pecl geoip from http://pecl.php.net/package/geoip
    wget http://pecl.php.net/get/geoip-1.0.7.tgz
  2. build geoip.so module
    tar zxf geoip-1.0.7.tgz
    cd geoip-1.0.7
    /usr/local/lsws/lsphp5/bin/phpize
    ./configure --with-php-config=/usr/local/lsws/lsphp5/bin/php-config
    make
    make install
    Note:
    a. you need to install geoip and geoip-devel rpm if not done so (yum install GeoIP-devel).
    b. /usr/local/lsws/lsphp5 is the prefix of running lsphp5.
  3. add line "extension=geoip.so" to your lsphp5 php.ini file.
  4. restart lsws to make it effective.
I assume these instructions are outdated as the path /usr/local/lsws/lsphp5/bin no longer exists.
 
#11
Last Friday I have searched some solutions about magento extensions and I have found Geo-IP lock extension on some websites. But there was some errors on sites but I saw a demo on fmeextensions.com/magento-geo-ip-ultimate-lock.html where it was perfectly.
 
Top