GeoIp

jos-Error: Error opening database file

1 year 1 month ago #75732

Lumiga's Avatar Lumiga

Dear Peter,

I get this error after I creat a ReReplacer item where I use the GeoLite plugin. Also the whole site went on a blank page.
When I ignore the option for Geolocation in the ReReplacer item then there is no error at all. Only the Deprecated error but that because I turned on the errorreporting.

The error on the frontend is:

jos-Error: Error opening database file (/home/users/.../.../libraries/geoip/GeoLite2-City.mmdb). 
Is this a valid MaxMind DB file?

I hope you know how to fix this error.

Kind regards,
Lumiga

1 year 1 month ago #75734

Peter van Westen's Avatar Peter van Westen Admin

What version of Joomla and GeoIp are you using?

1 year 1 month ago #75738

Lumiga's Avatar Lumiga

GeoIP Version 2.2.0
Joomla 3.8.1

1 year 1 month ago #75741

Peter van Westen's Avatar Peter van Westen Admin

Maybe you are running into php file size limits set up on your server or something.

Try reinstalling GeoIP.

1 year 1 month ago #75742

Peter van Westen's Avatar Peter van Westen Admin

Please see: www.regularlabs.com/forum/geoip/41953-error-0#61363

So it is probably down to the php memory limit.

1 year 1 month ago #75745

Lumiga's Avatar Lumiga

Hi Peter,

I have no problem installing this plugin. Only when I want to use it in combination with ReReplacer.

So if this could be a php memory limit how can I see that or fix this limit?

My hoster is www.byte.nl

Kind Regards,
Lumiga

1 year 1 month ago #75746

Peter van Westen's Avatar Peter van Westen Admin

Check the memory_limit setting in your Joomla admin under: System Information > PHP Information

1 year 1 month ago #75748

Lumiga's Avatar Lumiga

1 year 1 month ago #75749

Peter van Westen's Avatar Peter van Westen Admin

That should be more than enough.

Can you give me (super) admin and (s)ftp access so I can take a look?
And tell me on what url I can see/reproduce the issue.
You can use the 'Hidden text' button in the forum editor to hide the confidential information.

1 year 1 month ago #75751

Lumiga's Avatar Lumiga

Confidential information:
(hidden)

1 year 1 month ago #75754

Peter van Westen's Avatar Peter van Westen Admin

I tried doing a force database update in the GeoIP system plugin settings, but that fails too.
So looks like your setup/server has something blocking it:



Can you also give me (s)ftp access so I can take a deeper look?

1 year 1 month ago #75757

Lumiga's Avatar Lumiga

Confidential information:
(hidden)

1 year 1 month ago #75759

Peter van Westen's Avatar Peter van Westen Admin

It seems the MaxMind GeoIP file that is trying to get downloaded is being blocked when accessed through your server.
The file ( geolite.maxmind.com/download/geoip/datab...ite2-country.mmdb.gz ) is behind Cloudflare which is - instead of returning the file - returning a security check form.
Best to ask your host about this. Your server's IP address might be on some blacklist.

What you can do is manually download the file - unpack it - and upload it to your server as:

libraries/geoip/GeoLite2-City.mmdb

1 year 1 month ago #75763

Lumiga's Avatar Lumiga

Oké thanks!

First I'll try this with other domains so I can see if it has something to do with a sort of blacklist of that is has something to do with the host.