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

Installer: After db-credentials are entered, check if that access has enough permissions that piwik needs in its runtime. #3117

Closed
anonymous-matomo-user opened this issue Apr 20, 2012 · 2 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. duplicate For issues that already existed in our issue tracker and were reported previously. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Milestone

Comments

@anonymous-matomo-user
Copy link

Currently, the installer does not check if the given credentials have enough permissions for piwik to run normally.

Example
I gave the MySQL permissions:

Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv.

"Alter_priv" was missing and is quite critical for piwik to run. At the first start (or at the end of the installer) it tries to alter a table.

The quite easy and automatic webinstaller feels good and gives an impression as if everything works fine when you see those green check marks. But in the end, it failed horribly. It didn't put any error message or whatsoever in any logfile or log facility that I know of although the column "location_provider" in table "piwik_log_visit" was missing!

Please check for those db permissions right after db credentials are given. And ... if permissions are missing, please log an error somewhere!

Cost me three hours to find out about that. :( me sad.

@anonymous-matomo-user
Copy link
Author

I just found out about: #478
So this also happened three years ago.

Same shit, different time.

Seriously?! ;) Closed?! The solution is not to close, but to check and to print an error and possibly some pointer what went wrong!

@robocoder
Copy link
Contributor

Duplicate of #2963. Thanks for voting this up.

@anonymous-matomo-user anonymous-matomo-user added this to the 1.12.x - Piwik 1.12.x milestone Jul 8, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. duplicate For issues that already existed in our issue tracker and were reported previously. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Projects
None yet
Development

No branches or pull requests

2 participants