[solved] GeoIP not working

Report bugs and workarounds
Post Reply
Odon Garma
Posts: 33
Joined: 08 May 2017 14:10

[solved] GeoIP not working

Post 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?
Last edited by Odon Garma on 29 May 2019 19:59, edited 1 time in total.
Odon Garma
Posts: 33
Joined: 08 May 2017 14:10

Re: GeoIP not working

Post 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??
User avatar
shawniverson
Posts: 3640
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: GeoIP not working

Post by shawniverson »

eFa v4 is the solution. It uses GeoIP2. I am working hard to get it ready.
henk
Posts: 517
Joined: 14 Dec 2015 22:16
Location: Netherlands
Contact:

Re: GeoIP not working

Post 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
Attachments
geoip.tar.gz
(1.84 MiB) Downloaded 2105 times
Last edited by henk on 02 Jul 2019 21:57, edited 1 time in total.
“We are stuck with technology when what we really want is just stuff that works.” -Douglas Adams
Odon Garma
Posts: 33
Joined: 08 May 2017 14:10

Re: GeoIP not working

Post by Odon Garma »

You made my day! Thanks for the files.

i'm looking forward to start with efa v4

Greetz
w_bufffet
Posts: 12
Joined: 27 Mar 2016 15:32

Re: GeoIP not working

Post by w_bufffet »

Thanks, that was helpful.
iglooo
Posts: 32
Joined: 25 Jan 2019 19:52

Re: GeoIP not working

Post 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
henk
Posts: 517
Joined: 14 Dec 2015 22:16
Location: Netherlands
Contact:

Re: GeoIP not working

Post 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.
“We are stuck with technology when what we really want is just stuff that works.” -Douglas Adams
DeRaptor
Posts: 28
Joined: 25 Oct 2017 15:47

Re: GeoIP not working

Post by DeRaptor »

Hey Henk,

also saved my day - after trying 3 different backups :roll: :lol: and wondering, what's going on here.
henk
Posts: 517
Joined: 14 Dec 2015 22:16
Location: Netherlands
Contact:

Re: [solved] GeoIP not working

Post 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/
“We are stuck with technology when what we really want is just stuff that works.” -Douglas Adams
teknikl
Posts: 5
Joined: 13 Jun 2016 12:53

Re: [solved] GeoIP not working

Post by teknikl »

you're a lifesaver!!
Post Reply