Page 1 of 1

[solved] GeoIP not working

Posted: 08 Jan 2019 15:20
by Odon Garma
after update GeoIP Database from tools menu no detail view is possible

GeoIP.dat under /var/www/html/mailscanner/temp is

Code: Select all

<html>
<head><title>404 Not Found</title></head>
.....
</html>
/var/log/httpd/ssl_error_log says

Code: Select all

PHP Fatal error: GeoIP API: Error traversing database - perhaps it is corrupt? ....
to workaround, to be able to view detail, delete GeoIP.dat!

Any solution for this problem?

Re: GeoIP not working

Posted: 14 Jan 2019 14:40
by Odon Garma
Discontinuation of the GeoLite Legacy Databases

https://blog.maxmind.com/2018/01/02/dis ... databases/

Solutions?? Any??

Someone can send me the latest working GeoIP.dat to replace my non-working version??

Re: GeoIP not working

Posted: 14 Jan 2019 17:44
by shawniverson
eFa v4 is the solution. It uses GeoIP2. I am working hard to get it ready.

Re: GeoIP not working

Posted: 15 Jan 2019 08:13
by henk
I attached the GEOIP files. ( from Dec 17 2018). Since the files are to big to attach, I needed to compress the files a bit.

Code: Select all

export GZIP='--best'
tar -c -z -f geoip.tar.gz /root/backup/geoip
Result:

Code: Select all

[root@sansspam geoip]# ls -l
total 5492
-rw-r--r-- 1 apache apache 1242574 Dec 17 14:33 GeoIP.dat
-rw-r--r-- 1 root   root   1926651 Jan 15 09:06 geoip.tar.gz
-rw-r--r-- 1 apache apache 2447543 Dec 17 14:33 GeoIPv6.dat
P.S.
Any new install or EFA - configure will have the same issue. :(
January 2, 2019 – The remaining GeoLite Legacy builds will be removed from our website. GeoLite Legacy database users will need to have switched to the GeoLite2 or commercial GeoIP databases and update their integrations.

Code: Select all

[root@sansspam ~]# ls -l /usr/share/GeoIP/GeoLiteCountry.dat
lrwxrwxrwx 1 root root 40 Apr 26  2018 /usr/share/GeoIP/GeoLiteCountry.dat -> /var/www/html/mailscanner/temp/GeoIP.dat

Re: GeoIP not working

Posted: 16 Jan 2019 07:23
by Odon Garma
You made my day! Thanks for the files.

i'm looking forward to start with efa v4

Greetz

Re: GeoIP not working

Posted: 23 Jan 2019 19:15
by w_bufffet
Thanks, that was helpful.

Re: GeoIP not working

Posted: 06 Feb 2019 19:59
by iglooo
henk wrote: 15 Jan 2019 08:13 ...
And the file should be a link.

Code: Select all

[root@sansspam ~]# ls -l /usr/share/GeoIP/GeoLiteCountry.dat
lrwxrwxrwx 1 root root 40 Apr 26  2018 /usr/share/GeoIP/GeoLiteCountry.dat -> /var/www/html/mailscanner/temp/GeoIP.dat
Thanks for the updated database henk! Curious, why does GeoLiteCountry.dat have to be a link? I just extracted your files to /var/www/html/mailscanner/temp/ and it seems to have worked - I can see all the additional details now

Re: GeoIP not working

Posted: 12 Feb 2019 18:22
by henk
Only if you live in the Shire, have proof you are a genuine Hobbit and closely related to Bilbo or Frodo Baggins.
In rare occasions a specific ring will do. In all other cases you need a wizard.

Re: GeoIP not working

Posted: 28 May 2019 13:06
by DeRaptor
Hey Henk,

also saved my day - after trying 3 different backups :roll: :lol: and wondering, what's going on here.

Re: [solved] GeoIP not working

Posted: 26 Sep 2019 21:54
by henk
Hi Bonnette,

As you have some funny antivirus protection :roll:
Log in to efa and exec:

Code: Select all

wget -O geoip.tar.gz  https://forum.efa-project.org/download/file.php?id=418
To unpack the downloaded file:

Code: Select all

tar -xvzf geoip.tar.gz
Result:

Code: Select all

ls -l /root/backup/G*
-rw-r--r-- 1 apache apache 1242574 Dec 17 2018 /root/backup/GeoIP.dat
-rw-r--r-- 1 apache apache 2447543 Dec 17 2018 /root/backup/GeoIPv6.dat

and copy the files to

Code: Select all

/var/www/html/mailscanner/temp/

Re: [solved] GeoIP not working

Posted: 02 Dec 2019 16:06
by teknikl
you're a lifesaver!!