[solved] GeoIP not working

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

[solved] GeoIP not working

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?
Last edited by Odon Garma on 29 May 2019 19:59, edited 1 time in total.

Odon Garma
Posts: 28
Joined: 08 May 2017 14:10

Re: GeoIP not working

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

User avatar
shawniverson
Posts: 2899
Joined: 13 Jan 2014 23:30
Location: Rushville, Indiana, USA
Contact:

Re: GeoIP not working

Post by shawniverson » 14 Jan 2019 17:44

eFa v4 is the solution. It uses GeoIP2. I am working hard to get it ready.
Version eFa 4.0.0 now available!

henk
Posts: 401
Joined: 14 Dec 2015 22:16
Location: Netherlands
Contact:

Re: GeoIP not working

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
Attachments
geoip.tar.gz
(1.84 MiB) Downloaded 1122 times
Last edited by henk on 02 Jul 2019 21:57, edited 1 time in total.

Odon Garma
Posts: 28
Joined: 08 May 2017 14:10

Re: GeoIP not working

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
Posts: 11
Joined: 27 Mar 2016 15:32

Re: GeoIP not working

Post by w_bufffet » 23 Jan 2019 19:15

Thanks, that was helpful.

iglooo
Posts: 32
Joined: 25 Jan 2019 19:52

Re: GeoIP not working

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

Re: GeoIP not working

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
Posts: 16
Joined: 25 Oct 2017 15:47

Re: GeoIP not working

Post by DeRaptor » 28 May 2019 13:06

Hey Henk,

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

User avatar
Bonnette
Posts: 1
Joined: 26 Sep 2019 08:57

Re: [solved] GeoIP not working

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

Re: [solved] GeoIP not working

Post by henk » 26 Sep 2019 21:54

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/

BenStill
Posts: 1
Joined: 16 Oct 2019 13:29

Re: [solved] GeoIP not working

Post by BenStill » 16 Oct 2019 13:33

Oh, thanks a lot, I had a similar problems

teknikl
Posts: 5
Joined: 13 Jun 2016 12:53

Re: [solved] GeoIP not working

Post by teknikl » 02 Dec 2019 16:06

you're a lifesaver!!

Post Reply