Navigation Menu

Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Mention DB Lite DB will be automatically updated (filename etc) #16618

Closed
dev-101 opened this issue Oct 27, 2020 · 8 comments · Fixed by #16713
Closed

Mention DB Lite DB will be automatically updated (filename etc) #16618

dev-101 opened this issue Oct 27, 2020 · 8 comments · Fixed by #16713
Labels
c: Documentation For issues related to in-app product help messages, or to the Matomo knowledge base.

Comments

@dev-101
Copy link

dev-101 commented Oct 27, 2020

Hi, I know MaxMind put their DB behind API / login, and now Matomo uses db-ip download. For at least a year I have noticed that cities are very wrong, they are not at all accurate as before (countries are still accurate, as I can tell so far).

Today I devoted some time to exploring this issue, and discovered that update db link is hard coded with a date from January 2020. But, Matomo correctly reports that latest db version is from October 2020.

Does this affect downloading latest version or not (see screenshot)? Do we have to manually update this link from time to time?

matomo-geoip-db

@dev-101
Copy link
Author

dev-101 commented Oct 27, 2020

Follow-up question: Is there a way to manually trigger geo-ip db update procedure e.g. not to wait next cron cycle to run?

@Findus23
Copy link
Member

Hi,

As far as I know Matomo internally replaces this link with the current month when e.g. downloading the file.

Is there a way to manually trigger geo-ip db update procedure e.g. not to wait next cron cycle to run?

sudo -u www-data php console core:run-scheduled-tasks "Piwik\Plugins\GeoIp2\GeoIP2AutoUpdater.update" should run the task (not sure if it downloads the file if it isn't old enough)

@dev-101
Copy link
Author

dev-101 commented Oct 27, 2020

Thanks, command worked, although I can't ran it on all other shared hosting servers,
I was thinking about internal "button" to manually trigger it from Admin dash. But, I can replace / upload file manually, as well.

So, you are probably correct, I have updated to the latest version, or so I think, but the accuracy of the database is very poor. It shows a different city hundred miles away from true location.

I will probably have to register and switch back to MM, since it was spot on.

@dev-101 dev-101 changed the title GeoIP DB not updated? Wrong Cities reported by DBIP GeoIP DB not updated? | Poor Accuracy of GeoIP Database - Wrong Cities reported by DBIP Oct 27, 2020
@dev-101
Copy link
Author

dev-101 commented Oct 27, 2020

Yep, switched back to MM (even older version from Dec-2019) and it is so much more accurate, not to mention some 25-30% lighter in size. Now getting latest update...

We have to rename the file to DBIP-City.mmdb (otherwise it is not recognized by Matomo if we leave MM name convention).

Apparently, not, but if both DBs are present, first one will be used.

@tsteur
Copy link
Member

tsteur commented Oct 27, 2020

Matomo indeed replaces the month automatically and downloads up to date file without needing to do anything.

@tsteur tsteur closed this as completed Oct 27, 2020
@tsteur tsteur added the answered For when a question was asked and we referred to forum or answered it. label Oct 27, 2020
@dev-101
Copy link
Author

dev-101 commented Oct 28, 2020

Thanks, I did not close this issue right away, even if I resolved it personally in my case.
You might consider expanding information on Geolocation page in Admin Dash to clarify few things, e.g. regarding file names of 2 alternatives (DB-IP vs MaxMind) and such :)

@tsteur
Copy link
Member

tsteur commented Oct 28, 2020

sure I can reopen the issue and adjust the title in case someone wants to do a PR

@tsteur tsteur reopened this Oct 28, 2020
@tsteur tsteur changed the title GeoIP DB not updated? | Poor Accuracy of GeoIP Database - Wrong Cities reported by DBIP Mention DB Lite DB will be automatically updated (filename etc) Oct 28, 2020
@tsteur tsteur added c: Documentation For issues related to in-app product help messages, or to the Matomo knowledge base. and removed answered For when a question was asked and we referred to forum or answered it. labels Oct 28, 2020
@tsteur tsteur added this to the Backlog (Help wanted) milestone Oct 28, 2020
@nina-py
Copy link
Contributor

nina-py commented Nov 13, 2020

I think there might be a better way to improve the usability of this page than just adding an explanation. The URL in the form field - the one that @dev-101 reported as obsolete - is saved in the options at the time of the initial Matomo install.

Why not update this URL each time it changes when the updater task runs to download the latest copy of the geolocation database? Then users will either see that the URLs in the screenshot above match as they have the latest copy of the database or at most that it's a month out of date - and if that's the case, once they scroll further down the page and see when the updater runs next, the discrepancy becomes self-explanatory. Will add a PR for this shortly and will be happy to make any changes to it as you see fit, @tsteur.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
c: Documentation For issues related to in-app product help messages, or to the Matomo knowledge base.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants