[solved] GeoIP not working

Odon Garma · Post by **Odon Garma** » 08 Jan 2019 15:20

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?

Odon Garma · Post by **Odon Garma** » 14 Jan 2019 14:40

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??

Post by **shawniverson** » 14 Jan 2019 17:44

eFa v4 is the solution. It uses GeoIP2. I am working hard to get it ready.

henk · Post by **henk** » 15 Jan 2019 08:13

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

Odon Garma · Post by **Odon Garma** » 16 Jan 2019 07:23

You made my day! Thanks for the files.

i'm looking forward to start with efa v4

Greetz

w_bufffet · Post by **w_bufffet** » 23 Jan 2019 19:15

Thanks, that was helpful.

iglooo · Post by **iglooo** » 06 Feb 2019 19:59

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

henk · Post by **henk** » 12 Feb 2019 18:22

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.

DeRaptor · Post by **DeRaptor** » 28 May 2019 13:06

Hey Henk,

also saved my day - after trying 3 different backups

and wondering, what's going on here.

Bonnette · Post by **Bonnette** » 26 Sep 2019 09:13

Hi guys,

I have problems with the attached files - I get an antivirus message protection error. Could anyone please resend the files via email, Dropbox perhaps? I'd appreciate that. Thanks.

Randy

henk · Post by **henk** » 26 Sep 2019 21:54

Hi Bonnette,

As you have some funny antivirus protection

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/

teknikl · Post by **teknikl** » 02 Dec 2019 16:06

you're a lifesaver!!

efa-project.org

[solved] GeoIP not working

[solved] GeoIP not working

Re: GeoIP not working

Re: GeoIP not working

Re: GeoIP not working

Re: GeoIP not working

Re: GeoIP not working

Re: GeoIP not working

Re: GeoIP not working

Re: GeoIP not working

Re: [solved] GeoIP not working

Re: [solved] GeoIP not working

Re: [solved] GeoIP not working