Trying to configure nginx GeoLite2 Country with showing up on Grafana

Grafana Configuration
1

  • What Grafana version and what operating system are you using?
    Ubuntu 22.04.5 LTS x86_64 and Grafana free tier?

  • What are you trying to achieve?
    Trying to show geoIP2 from nginx from visitor request to the grafana nginx dashboard where it shows where the user IP address is located based on GeoLite2 Country

  • How are you trying to achieve it?
    i am trying to make nginx 1.18.0 support GeoLite2 Country

  • What happened?
    I have tried recompiling nginx, ver 1.27.2 but i was on 1.18.0 so i grabbed the wrong source file and iv tried recompiling for GeoIP work alongside

  • What did you expect to happen?
    that the GeoLite2 Country nginx model would work with nginx 1.18.0

  • Can you copy/paste the configuration(s) that you are having problems with?

log_format json_analytics escape=json '{'
'"msec": "$msec", ' # request unixtime in seconds with a milliseconds resolution
'"connection": "$connection", ' # connection serial number
'"connection_requests": "$connection_requests", ' # number of requests made in connection
'"pid": "$pid", ' # process pid
'"request_id": "$request_id", ' # the unique request id
'"request_length": "$request_length", ' # request length (including headers and body)
'"remote_addr": "$remote_addr", ' # client IP
'"remote_user": "$remote_user", ' # client HTTP username
'"remote_port": "$remote_port", ' # client port
'"time_local": "$time_local", '
'"time_iso8601": "$time_iso8601", ' # local time in the ISO 8601 standard format
'"request": "$request", ' # full path no arguments if the request
'"request_uri": "$request_uri", ' # full path and arguments if the request
'"args": "$args", ' # args
'"status": "$status", ' # response status code
'"body_bytes_sent": "$body_bytes_sent", ' # the number of body bytes exclude headers sent to a client
'"bytes_sent": "$bytes_sent", ' # the number of bytes sent to a client
'"http_referer": "$http_referer", ' # HTTP referer
'"http_user_agent": "$http_user_agent", ' # user agent
'"http_x_forwarded_for": "$http_x_forwarded_for", ' # http_x_forwarded_for
'"http_host": "$http_host", ' # the request Host: header
'"server_name": "$server_name", ' # the name of the vhost serving the request
'"request_time": "$request_time", ' # request processing time in seconds with msec resolution
'"upstream": "$upstream_addr", ' # upstream backend server for proxied requests
'"upstream_connect_time": "$upstream_connect_time", ' # upstream handshake time incl. TLS
'"upstream_header_time": "$upstream_header_time", ' # time spent receiving upstream headers
'"upstream_response_time": "$upstream_response_time", ' # time spent receiving upstream body
'"upstream_response_length": "$upstream_response_length", ' # upstream response length
'"upstream_cache_status": "$upstream_cache_status", ' # cache HIT/MISS where applicable
'"ssl_protocol": "$ssl_protocol", ' # TLS protocol
'"ssl_cipher": "$ssl_cipher", ' # TLS cipher
'"scheme": "$scheme", ' # http or https
'"request_method": "$request_method", ' # request method
'"server_protocol": "$server_protocol", ' # request protocol, like HTTP/1.1 or HTTP/2.0
'"pipe": "$pipe", ' # "p" if request was pipelined, "." otherwise
'"gzip_ratio": "$gzip_ratio", '
'"geoip_country_code": "$geoip_country_code"'
'}';

  geoip_country /etc/nginx/GeoLite2-Country.mmdb;
#     $geoip_country_code default=US source=$remote_addr country iso_code;
#}

access_log /var/log/nginx/json_access.log json_analytics;

I’m mostly having issues with

 geoip_country /etc/nginx/GeoLite2-Country.mmdb;
#     $geoip_country_code default=US source=$remote_addr country iso_code;
#}

had to disable

#  geoip_country /etc/nginx/GeoLite2-Country.mmdb;
# '"geoip_country_code": "$geoip_country_code"'

for nginx to work again disabling the GeoLite2 module since i keep being stuck in a loop where if i try to fix it it will spit out an error.

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    when i had it enabled, i did see an error in the Grafana nginx console about { being broken but i just have both
  • Did you follow any online instructions? If so, what is the URL?
    I did try the Nginx integration for Grafana Cloud page where it said on how to configure the block until i got to the GeoIP2 module snippet where that’s where all the issues started.
    Install GeoIP for Nginx · GitHub
    GitHub - leev/ngx_http_geoip2_module: Nginx GeoIP2 module
    everything worked fine until iv used the wrong nginx ver. right now without geoip it looks fine but whenever i try to setup geoip i end in a loop where i see
nginx: [emerg] unknown directive "geoip_country" in /etc/nginx/nginx.conf:109
nginx: configuration file /etc/nginx/nginx.conf test failed

in my nginx config. i want to personally thank Garrett T for trying to help me trying to get GeoLite2 Country to work on nginx (in a ticket).
My grafana-server ver is Version 11.2.2 (commit: c47b921ef40c0c411e9bad2cac05eb6c540c0979, branch: HEAD)
My alloy randomly spikes up to 40% then back down to %2 randomly, idk if it’s the hetrixtools agent doing that but yeah

4

Is your question about getting geolite2 to work in ngnix

5

Yes, thats what im trying to do on nginx 1.18.0
Sorry for the late response, it’s late at night atm

6

Might want to ask that question on an ngnix forum?

7

Yeah… I’ll go ask that on the main nginx forum when I have the chance… Thanks tho