Nginx Enabling GeoIP 2 Lite Nginx Module Errors

Followed the https://community.centminmod.com/threads/how-to-enable-geoip-2-lite-nginx-module-support.17165/ step by step and verified all settings and links.

---

Code (Text):

lsof -p 6897 | grep .so | grep geo  
nginx   6897 nginx  mem       REG              253,1    96056 42503429 /usr/local/nginx/modules/ngx_http_geoip2_module.so

Code (Text):

lsof -p 6897 | grep GeoIP
nginx   6897 nginx  mem       REG              253,1  6470616  9210863 /usr/share/GeoIP/GeoLite2-ASN.mmdb
nginx   6897 nginx  mem       REG              253,1 61366615  9074935 /usr/share/GeoIP/GeoLite2-City.mmdb
nginx   6897 nginx  mem       REG              253,1   197136   255101 /usr/lib64/libGeoIP.so.1.5.0
nginx   6897 nginx    6r      REG              253,1  1242574  9046934 /usr/share/GeoIP/GeoIP.dat
nginx   6897 nginx    7r      REG              253,1 20539238  8435135 /usr/share/GeoIP/GeoIPCity.dat

I have commented out the last line in

Code (Text):

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_country /usr/share/GeoIP/GeoIP.dat;

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_city /usr/share/GeoIP/GeoIPCity.dat;

# GeoIP2 Lite databases
include /usr/local/nginx/conf/geoip2.conf;

to include the geoip2.conf and this work fine.
Commenting the include #include /usr/local/nginx/conf/geoip2.conf and try to add this to the php.conf for example only this

Code (Text):

fastcgi_param GEOIP2_CITY_BUILD_DATE $geoip2_metadata_city_build;
fastcgi_param GEOIP2_CITY $geoip2_data_city_name;
fastcgi_param GEOIP2_CITY_GEONAMEID $geoip2_data_city_geonameid;
fastcgi_param GEOIP2_CONTINENT_CODE $geoip2_data_continent_code;

nginx -t gives erros.

Also, when commenting out the include /usr/local/nginx/conf/geoip2.conf my php.info keeps the same. And that's the main issue.


What ever I try GEOIP2 won't appear.

What am I missing here?

 

Restarting nginx (via systemctl): Job for nginx.service failed because the control process exited with error code. See "systemctl status nginx.service" and "journalctl -xe" for details.

Error indicates the when adding the for example

Code:

fastcgi_param GEOIP2_CITY_BUILD_DATE $geoip2_metadata_city_build;

to the php.conf.

And yes, restarted both services, corrected the error so that nginx -t confirms config OK.

So, testing to resolve it, but get stuck on this one. Working on Matomo: #1 Secure Open Web Analytics Platform and don't want to have 2 GEOIP dbs and the one from the server is more accurate and it gives better results.

Code (Text):

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_country /usr/share/GeoIP/GeoIP.dat;

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_city /usr/share/GeoIP/GeoIPCity.dat;

# GeoIP2 Lite databases
include /usr/local/nginx/conf/geoip2.conf;

Comment out the include does not give any problems, but the info.php does not refect any changes

 

Code:

# GeoIP2 Lite databases
  #  geoip2 /usr/share/GeoIP/GeoLite2-Country.mmdb {
  #    $geoip2_data_country_code country iso_code;
  #    $geoip2_data_country_name country names en;
  #  }

  geoip2 /usr/share/GeoIP/GeoLite2-City.mmdb {
    $geoip2_data_city_name city names en;
    $geoip2_data_city_geonameid city geoname_id;
    $geoip2_data_continent_code continent code;
    $geoip2_data_continent_geonameid continent geoname_id;
    $geoip2_data_continent_name continent names en;
    $geoip2_data_country_geonameid country geoname_id;
    $geoip2_data_country_iso country iso_code;
    $geoip2_data_country_name country names en;
    $geoip2_data_country_is_eu country is_in_european_union;
    $geoip2_data_location_accuracyradius location accuracy_radius;
    $geoip2_data_location_latitude location latitude;
    $geoip2_data_location_longitude location longitude;
    $geoip2_data_location_metrocode location metro_code;
    $geoip2_data_location_timezone location time_zone;
    $geoip2_data_postal_code postal code;
    $geoip2_data_rcountry_geonameid registered_country geoname_id;
    $geoip2_data_rcountry_iso registered_country iso_code;
    $geoip2_data_rcountry_name registered_country names en;
    $geoip2_data_rcountry_is_eu registered_country is_in_european_union;
    $geoip2_data_region_geonameid subdivisions 0 geoname_id;
    $geoip2_data_region_iso subdivisions 0 iso_code;
    $geoip2_data_region_name subdivisions 0 names en;
  }

geoip2 /usr/share/GeoIP/GeoLite2-ASN.mmdb {
    auto_reload 5m;
    $geoip2_data_autonomous_system_number autonomous_system_number;
    $geoip2_data_autonomous_system_organization autonomous_system_organization;
  }

 

Confused;

The file with this content is were can I find it?

Code (Text):

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_country /usr/share/GeoIP/GeoIP.dat;

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_city /usr/share/GeoIP/GeoIPCity.dat;

# GeoIP2 Lite databases
#include /usr/local/nginx/conf/geoip2.conf;

And watch should be by the default content in the geoip.conf file?

 

Great! Guess a lack of sleep.
I had this insind the /usr/local/nginx/conf/geoip.conf

Code (Text):

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_country /usr/share/GeoIP/GeoIP.dat;

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_city /usr/share/GeoIP/GeoIPCity.dat;

# GeoIP2 Lite databases
include /usr/local/nginx/conf/geoip2.conf;

# GeoIP2 Lite databases
#  geoip2 /usr/share/GeoIP/GeoLite2-Country.mmdb {
#    $geoip2_data_country_code country iso_code;
#    $geoip2_data_country_name country names en;
#  }
#
#  geoip2 /usr/share/GeoIP/GeoLite2-City.mmdb {
#    $geoip2_data_city_name city names en;
#    $geoip2_data_postal_code postal code;
#    $geoip2_data_latitude location latitude;
#    $geoip2_data_longitude location longitude;
#    $geoip2_data_state_name subdivisions 0 names en;
#    $geoip2_data_state_code subdivisions 0 iso_code;
#  }

 

Current setup geoip.conf:

Code (Text):

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_country /usr/share/GeoIP/GeoIP.dat;

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_city /usr/share/GeoIP/GeoIPCity.dat;

# GeoIP2 Lite databases
#include /usr/local/nginx/conf/geoip2.conf;
fastcgi_param GEOIP2_CITY_BUILD_DATE $geoip2_metadata_city_build;
fastcgi_param GEOIP2_CITY $geoip2_data_city_name;
fastcgi_param GEOIP2_CITY_GEONAMEID $geoip2_data_city_geonameid;
fastcgi_param GEOIP2_CONTINENT_CODE $geoip2_data_continent_code;
fastcgi_param GEOIP2_CONTINENT_GEONAMEID $geoip2_data_continent_geonameid;
fastcgi_param GEOIP2_CONTINENT_NAME $geoip2_data_continent_name;
fastcgi_param GEOIP2_COUNTRY_GEONAMEID $geoip2_data_country_geonameid;
fastcgi_param GEOIP2_COUNTRY_CODE $geoip2_data_country_code;
fastcgi_param GEOIP2_COUNTRY_NAME $geoip2_data_country_name;
fastcgi_param GEOIP2_COUNTRY_IN_EU $geoip2_data_country_is_eu;
fastcgi_param GEOIP2_LOCATION_ACCURACY_RADIUS $geoip2_data_location_accuracyradius;
fastcgi_param GEOIP2_LATITUDE $geoip2_data_location_latitude;
fastcgi_param GEOIP2_LONGITUDE $geoip2_data_location_longitude;
fastcgi_param GEOIP2_LOCATION_METROCODE $geoip2_data_location_metrocode;
fastcgi_param GEOIP2_LOCATION_TIMEZONE $geoip2_data_location_timezone;
fastcgi_param GEOIP2_POSTAL_CODE $geoip2_data_postal_code;
fastcgi_param GEOIP2_REGISTERED_COUNTRY_GEONAMEID $geoip2_data_rcountry_geonameid;
fastcgi_param GEOIP2_REGISTERED_COUNTRY_ISO $geoip2_data_rcountry_iso;
fastcgi_param GEOIP2_REGISTERED_COUNTRY_NAME $geoip2_data_rcountry_name;
fastcgi_param GEOIP2_REGISTERED_COUNTRY_IN_EU $geoip2_data_rcountry_is_eu;
fastcgi_param GEOIP2_REGION_GEONAMEID $geoip2_data_region_geonameid;
fastcgi_param GEOIP2_REGION $geoip2_data_region_iso;
fastcgi_param GEOIP2_REGION_NAME $geoip2_data_region_name;

fastcgi_param GEOIP2_ASN $geoip2_data_autonomous_system_number;
fastcgi_param GEOIP2_ASN_ORG $geoip2_data_autonomous_system_organization;

Give this error with:

Code (Text):

 nginx -t
nginx: [emerg] unknown "geoip2_metadata_city_build" variable
nginx: configuration file /usr/local/nginx/conf/nginx.conf test failed

Hmmm, any Idea?

 

Already tried that, including all other possibilities, but I don't get the GEOIP2 Lite as in your image: So what to do to get the fastcgi_param GEOIP2 loaded?

 

Well, was working on several things at the same time to get things done more quickly. Something went extremely wrong and I had to replace a backup from a day ago. I use notepad++ as a kind of backup for my settings/log, what went wrong I comment out or delete it from notepad++.

I followed the manual exactly, followed every link to verify and or set it that way.

See https://community.centminmod.com/threads/enabling-geoip-2-lite-nginx-module-errors.17255/#post-72937 and your response to uncomment

Code (Text):

#include /usr/local/nginx/conf/geoip2.conf;

But that didn't work as expected. Will start this whole part again, due to the fact that I replaced a backup and keep you informed if I noticed something or if I tracked down what went wrong. Maybe a little issue in the manual, so that you can improve it.

The backup gives this php.info and never changed when setting up following the manual.

 

Think I got it

 

After compiling nginx geoip.conf holds this

Code (Text):

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_country /usr/share/GeoIP/GeoIP.dat;

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_city /usr/share/GeoIP/GeoIPCity.dat;

# GeoIP2 Lite databases
#  geoip2 /usr/share/GeoIP/GeoLite2-Country.mmdb {
#    $geoip2_data_country_code country iso_code;
#    $geoip2_data_country_name country names en;
#  }
#
#  geoip2 /usr/share/GeoIP/GeoLite2-City.mmdb {
#    $geoip2_data_city_name city names en;
#    $geoip2_data_postal_code postal code;
#    $geoip2_data_latitude location latitude;
#    $geoip2_data_longitude location longitude;
#    $geoip2_data_state_name subdivisions 0 names en;
#    $geoip2_data_state_code subdivisions 0 iso_code;
#  }

Instead of

Code (Text):

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_country /usr/share/GeoIP/GeoIP.dat;

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_city /usr/share/GeoIP/GeoIPCity.dat;

# GeoIP2 Lite databases
#include /usr/local/nginx/conf/geoip2.conf;

to get it work need to change

Code (Text):

#include /usr/local/nginx/conf/geoip2.conf;

to

Code (Text):

include /usr/local/nginx/conf/geoip2.conf;

This avoid the nginx -t errors

Replace in geoip2.conf

Code (Text):

  geoip2 /usr/share/GeoIP/GeoLite2-City.mmdb {
    $geoip2_data_city_name city names en;
    $geoip2_data_city_geonameid city geoname_id;
    $geoip2_data_continent_code continent code;
    $geoip2_data_continent_geonameid continent geoname_id;
    $geoip2_data_continent_name continent names en;
    $geoip2_data_country_geonameid country geoname_id;
    $geoip2_data_country_iso country iso_code;
    $geoip2_data_country_name country names en;
    $geoip2_data_country_is_eu country is_in_european_union;
    $geoip2_data_location_accuracyradius location accuracy_radius;
    $geoip2_data_location_latitude location latitude;
    $geoip2_data_location_longitude location longitude;
    $geoip2_data_location_metrocode location metro_code;
    $geoip2_data_location_timezone location time_zone;
    $geoip2_data_postal_code postal code;
    $geoip2_data_rcountry_geonameid registered_country geoname_id;
    $geoip2_data_rcountry_iso registered_country iso_code;
    $geoip2_data_rcountry_name registered_country names en;
    $geoip2_data_rcountry_is_eu registered_country is_in_european_union;
    $geoip2_data_region_geonameid subdivisions 0 geoname_id;
    $geoip2_data_region_iso subdivisions 0 iso_code;
    $geoip2_data_region_name subdivisions 0 names en;
  }

With

Code (Text):

geoip2 /usr/share/GeoIP/GeoLite2-City.mmdb {
    auto_reload 5m;
    $geoip2_metadata_city_build metadata build_epoch;
    $geoip2_data_city_name city names en;
    $geoip2_data_city_geonameid city geoname_id;
    $geoip2_data_continent_code continent code;
    $geoip2_data_continent_geonameid continent geoname_id;
    $geoip2_data_continent_name continent names en;
    $geoip2_data_country_geonameid country geoname_id;
    $geoip2_data_country_code country iso_code;
    $geoip2_data_country_name country names en;
    $geoip2_data_country_is_eu country is_in_european_union;
    $geoip2_data_location_accuracyradius location accuracy_radius;
    $geoip2_data_location_latitude location latitude;
    $geoip2_data_location_longitude location longitude;
    $geoip2_data_location_metrocode location metro_code;
    $geoip2_data_location_timezone location time_zone;
    $geoip2_data_postal_code postal code;
    $geoip2_data_rcountry_geonameid registered_country geoname_id;
    $geoip2_data_rcountry_iso registered_country iso_code;
    $geoip2_data_rcountry_name registered_country names en;
    $geoip2_data_rcountry_is_eu registered_country is_in_european_union;
    $geoip2_data_region_geonameid subdivisions 0 geoname_id;
    $geoip2_data_region_iso subdivisions 0 iso_code;
    $geoip2_data_region_name subdivisions 0 names en;
  }

  geoip2 /usr/share/GeoIP/GeoLite2-ASN.mmdb {
    auto_reload 5m;
    $geoip2_data_autonomous_system_number autonomous_system_number;
    $geoip2_data_autonomous_system_organization autonomous_system_organization;
  }

Add in vhost

Code (Text):

  # https://community.centminmod.com/threads/how-to-enable-geoip-2-lite-nginx-module-support.17165/
  include /usr/local/nginx/conf/php.conf;

Only have to fine tune it a bit, but there are some bugs in the basic setup.

 

Every 4 hours with cronjob becuase you update the code so quickly.

Code (Text):

cmupdate
No local changes to save
Already up-to-date.

 

FYI: I don't know when you updated it, but I build this system 18 days ago.

Let's recompile nginx again to test. If it changes I'll post it.

Content of /usr/local/src/centminmod/config/nginx/geoip.conf, was shocked a bit when I looked at it and showed that the #/usr/local/src/centminmod/config/nginx/geoip.conf was commented out again. Soon realized it was not the /usr/local/nginx/conf/geoip.conf file
My fault.

Code (Text):

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_country /usr/share/GeoIP/GeoIP.dat;

# SET the path to the .dat file used for determining the visitors country from the IP-address ###
geoip_city /usr/share/GeoIP/GeoIPCity.dat;

# GeoIP2 Lite databases
#/usr/local/src/centminmod/config/nginx/geoip.conf

But as far a I can see it work fine now. Only need to put some extra variables in it to get some better tracking.

 

Again error. After recompiling PHP the content of /usr/local/nginx/conf/php.conf is reset to the old one without the GEOIP2. I had to add the again to get them back.

Code (Text):

fastcgi_param GEOIP2_CITY_BUILD_DATE $geoip2_metadata_city_build;
fastcgi_param GEOIP2_CITY $geoip2_data_city_name;
fastcgi_param GEOIP2_CITY_GEONAMEID $geoip2_data_city_geonameid;
fastcgi_param GEOIP2_CONTINENT_CODE $geoip2_data_continent_code;
fastcgi_param GEOIP2_CONTINENT_GEONAMEID $geoip2_data_continent_geonameid;
fastcgi_param GEOIP2_CONTINENT_NAME $geoip2_data_continent_name;
fastcgi_param GEOIP2_COUNTRY_GEONAMEID $geoip2_data_country_geonameid;
fastcgi_param GEOIP2_COUNTRY_CODE $geoip2_data_country_code;
fastcgi_param GEOIP2_COUNTRY_NAME $geoip2_data_country_name;
fastcgi_param GEOIP2_COUNTRY_IN_EU $geoip2_data_country_is_eu;
fastcgi_param GEOIP2_LOCATION_ACCURACY_RADIUS $geoip2_data_location_accuracyradius;
fastcgi_param GEOIP2_LATITUDE $geoip2_data_location_latitude;
fastcgi_param GEOIP2_LONGITUDE $geoip2_data_location_longitude;
fastcgi_param GEOIP2_LOCATION_METROCODE $geoip2_data_location_metrocode;
fastcgi_param GEOIP2_LOCATION_TIMEZONE $geoip2_data_location_timezone;
fastcgi_param GEOIP2_POSTAL_CODE $geoip2_data_postal_code;
fastcgi_param GEOIP2_REGISTERED_COUNTRY_GEONAMEID $geoip2_data_rcountry_geonameid;
fastcgi_param GEOIP2_REGISTERED_COUNTRY_ISO $geoip2_data_rcountry_iso;
fastcgi_param GEOIP2_REGISTERED_COUNTRY_NAME $geoip2_data_rcountry_name;
fastcgi_param GEOIP2_REGISTERED_COUNTRY_IN_EU $geoip2_data_rcountry_is_eu;
fastcgi_param GEOIP2_REGION_GEONAMEID $geoip2_data_region_geonameid;
fastcgi_param GEOIP2_REGION $geoip2_data_region_iso;
fastcgi_param GEOIP2_REGION_NAME $geoip2_data_region_name;

fastcgi_param GEOIP2_ASN $geoip2_data_autonomous_system_number;
fastcgi_param GEOIP2_ASN_ORG $geoip2_data_autonomous_system_organization;

My current /etc/centminmod/custom_config.inc

Code (Text):

MARCH_TARGETNATIVE='n'

#------nginx
NGINX_DYNAMICTLS='y'
NGINX_HPACK='y'
NGINX_LIBBROTLI='y'
NGXDYNAMIC_BROTLI='y'

NGINX_GEOIPTWOLITE='y'
NGXDYNAMIC_GEOIPTWOLITE='y'

#------nginx pagespeed
NGINX_PAGESPEED='y'
NGINX_PAGESPEEDGITMASTER='n'
NGXDYNAMIC_NGXPAGESPEED='y'

#------mariadb

#------php
PHP_PGO='y'
STRIPPHP='y'                    # set 'y' to strip PHP binary to reduce size
PHP_INSTALL='y'                 # Install PHP /w Fast Process Manager
PHP_MEMCACHE='y'                # memcache PHP extension
MEMCACHED_INSTALL='y'           # Install Memcached
PHPREDIS='n'                    # redis PHP extension install

#------Open SSL
DISABLE_TLSONEZERO_PROTOCOL='y' # disable TLS 1.0 protocol by default industry is moving to deprecate for security
NOSOURCEOPENSSL='n'             # set to 'y' to disable OpenSSL source compile for system default YUM package setup
OPENSSL_TLSONETHREE='y'         # whether OpenSSL 1.1.1 builds enable TLSv1.3

LETSENCRYPT_DETECT='y'

#-----GCC Compilers
GCCINTEL_PHP='y'                # enable PHP-FPM GCC compiler with Intel cpu optimizations
DEVTOOLSET_PHP='y'              # use devtoolset GCC for GCCINTEL_PHP='y'

Hmmm, Guess I found why it got reset....Dumb ass that I am.

Code (Text):

Do you still want to continue? [y/n] y

----------------------------------------------------------------
existing php.ini will be backed up at /usr/local/lib/php.ini-oldversion_200419-000955
Want to update to latest php.conf ? (overwrites will auto backup existing php.conf)
existing php.conf will be backed up at /usr/local/nginx/conf/php.conf-oldversion_200419-000955
----------------------------------------------------------------
Update & overwrite your existing php.conf [y/n]: y