Geolocation (MaxMind) not working

[moucho]

Hi,

seems that the bug reported in this previous topic viewtopic.php?f=4&t=12044 is happening again.

On several of our servers it was not working until we did apply the same fix.

[marcele]

I can confirm that we are also seeing the same issue on some of our servers using CSF v14.11. Using the fix corrects it.

Before

Code: Select all

# csf -i 81.202.228.230
81.202.228.230 (81.202.228.230.dyn.user.ono.com)

After the fix

Code: Select all

echo ',,,,,,' >> /var/lib/csf/Geo/GeoLite2-Country-Locations-en.csv
csf -i 81.202.228.230
81.202.228.230 (ES/Spain/81.202.228.230.dyn.user.ono.com)

[ForumAdmin]

This should be resolved in v14.12 which has just been released:
https://blog.configserver.com/

[moucho]

Today the same thing happened again. CSF is updated to the latest version (v14.12) but the bug persists.

[ForumAdmin]

We are unable to recreate the problems:

Code: Select all

[root@homer Geo]# ls -la
total 373644
drw-------  2 root root      4096 Nov 11 12:28 .
drw------- 10 root root      4096 Nov 11 12:29 ..
-rw-r--r--  1 root root        55 Nov 11 12:28 COPYRIGHT.txt
-rw-r--r--  1 root root  19576642 Nov 11 12:28 GeoLite2-ASN-Blocks-IPv4.csv
-rw-r--r--  1 root root   4580406 Nov 11 12:28 GeoLite2-ASN-Blocks-IPv6.csv
-rw-r--r--  1 root root 228692587 Nov 11 12:28 GeoLite2-City-Blocks-IPv4.csv
-rw-r--r--  1 root root  88496601 Nov 11 12:28 GeoLite2-City-Blocks-IPv6.csv
-rw-r--r--  1 root root  12055633 Nov 11 12:28 GeoLite2-City-Locations-en.csv
-rw-r--r--  1 root root  13090736 Nov 11 12:28 GeoLite2-Country-Blocks-IPv4.csv
-rw-r--r--  1 root root  16076430 Nov 11 12:28 GeoLite2-Country-Blocks-IPv6.csv
-rw-r--r--  1 root root      9850 Nov 11 12:28 GeoLite2-Country-Locations-en.csv
-rw-r--r--  1 root root       398 Nov 11 12:28 LICENSE.txt
[root@homer Geo]# csf -i 81.202.228.230
81.202.228.230 (ES/Spain/Valencia/Valencia/81.202.228.230.dyn.user.ono.com)
[root@homer Geo]#

[moucho]

I can reproduce it on my testing machine:

Code: Select all

[root@test]# csf -v
csf: v14.12 (cPanel)

[root@test]# ls -lah /var/lib/csf/Geo/
total 34M
drw------- 2 root root 4,0K nov 11 15:19 .
drw------- 9 root root 4,0K nov 11 15:30 ..
-rw------- 1 root root   55 nov  3 15:59 COPYRIGHT.txt
-rw------- 1 root root  13M nov  3 15:59 GeoLite2-Country-Blocks-IPv4.csv
-rw------- 1 root root  22M nov  3 15:59 GeoLite2-Country-Blocks-IPv6.csv
-rw------- 1 root root 9,7K nov 11 15:19 GeoLite2-Country-Locations-en.csv
-rw------- 1 root root  398 nov  3 15:59 LICENSE.txt

[root@test]# tail -n 2 /var/lib/csf/Geo/GeoLite2-Country-Locations-en.csv
7626844,en,NA,"North America",BQ,"Bonaire, Sint Eustatius, and Saba",0
7909807,en,AF,Africa,SS,"South Sudan",0

[root@test]# csf -i 88.12.14.151
88.12.14.151 (151.red-88-12-14.staticip.rima-tde.net)

Then, if I add the "fix":

Code: Select all

[root@test]# tail -n 2 /var/lib/csf/Geo/GeoLite2-Country-Locations-en.csv
7909807,en,AF,Africa,SS,"South Sudan",0
,,,,,,

[root@test]# csf -i 88.12.14.151
88.12.14.151 (ES/Spain/151.red-88-12-14.staticip.rima-tde.net)