Support

Admin Tools

#26623 Upgrade GeoIP GeoLite2 database

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by on Thursday, 29 December 2016 17:17 CST

user91619
 Hello there,
as stated at page 14 of manual I downloaded the new database from http://dev.maxmind.com/geoip/geoip2/geolite2/ (mmdb format) and I extracted and copied it into website_root\plugins\system\akgeoip\db, overwriting the previous one.
However, when I go into back end > AdminTool page, the component still continues to ask me to update GeoIP Database.
What's wrong?
How to tell Joomla: Hey, I already updated the database!
Thanks.

nicholas
Akeeba Staff
Manager
When you download the file from MaxMind it's a .mmdb.gz file. That's a compressed file. You will need to uncompress it using 7-Zip (Windows), Archiver (macOS) or gunzip (Linux). Then upload it. The file must be in its uncompressed form for MaxMind's library to be able to read it.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

nicholas
Akeeba Staff
Manager
I forgot to also note that the warning is issued based on the modification date of the file. If it's older than a month from the server's current date and time you get a warning. So the other thing you must check is that the modification date of the uploaded file is today and that your server's date and time are correctly set up.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user91619
Obviously I uncompressed it. I copied the GeoLite2-Country.mmdb (not the zipped version) into the previously specified folder.
If I try the automatic update, admin tool tells me that it cannot delete the old GeoLite 2 file and overwrite it with the new version.
In addition, last modified time date of the file is today (29/11/16).

user91619
I SOLVED the issue in this way: I manually delete the old GeoLite2-Country.mmdb from plugins\system\akgeoip\db folder, then I used automatic maintenance button: the procedure updated the database, without removing GeoLite2-Country.mmdb.gz from tmp folder. So I removed the last manually at the end.
Now the database is up-to-date.

I don't know why this issue arised because I gave to akgeoip folder and its subfolder all permissions (writing and reading) under Windows Server 2012 (IUSR, SYSTEM, Administrators and Users groups have All permissions to manage the folder).

Regards,

nicholas
Akeeba Staff
Manager
I was typing a similar response, assuming you're on a Linux server.

On a Windows server the FTP uploads use a local user account, not an IIS (IUSR*) user account. Namely, they use the same user account you use to connect to FTP with. By default, the uploaded files only get full access privileges for the owner and read privileges for the Users group. However, the IUSR* accounts do not belong to the Users group, therefore making the file unreadable and unwriteable to the web server (since PHP runs either as a SAPI module or through FastCGI under the same IUSR* account as your site).

My observations are on IIS 7 on Windows 10 but it shouldn't be that far removed from Windows Server 2012. IIRC this behavior exists since at least Windows Vista which predates Windows Server 2012.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!