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

Jump to bottom

When DB user doesn't have the 'CREATE TEMPORARY TABLE' grant, display a clear error message #15237

Closed
mattab opened this issue Dec 5, 2019 · 1 comment
Closed

When DB user doesn't have the 'CREATE TEMPORARY TABLE' grant, display a clear error message #15237

mattab opened this issue Dec 5, 2019 · 1 comment
Assignees
@sgiehl
Labels
c: Usability For issues that let users achieve a defined goal more effectively or efficiently. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Milestone
4.0.0

Comments

@mattab
Copy link
Member

mattab commented Dec 5, 2019

Currently when the MySQL DB user does not have the "create temporary table" grant/permission set (a new requirement we introduced in Matomo 3.12.0 or so), the archiving of reports fails with a cryptic error message, as reported by several users in the forum.

The message says SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'abc'@'localhost' to database 'matomo' - in plugin Goals so it's not clear what the problem is.

Ideally when the user does not have the right permission:

  • The error message would be clear and explain the user doesn't have the GRANT CREATE TEMPORARY TABLES and maybe list the command to execute directly, or link to a new FAQ or our FAQ explaining the command to run
  • maybe we could also have a system check diagnostic error, when the user doesn't have this permission, that also outputs the same suggestion of which command to type
@mattab mattab added Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. c: Usability For issues that let users achieve a defined goal more effectively or efficiently. labels Dec 5, 2019
@mattab mattab added this to the 3.13.1 milestone Dec 5, 2019
This was referenced Dec 5, 2019
Merged
Closed
@katebutler katebutler assigned katebutler and unassigned katebutler Dec 9, 2019
@mattab mattab modified the milestones: 3.13.1, 4.0.0 Jan 8, 2020
@sgiehl
Copy link
Member

sgiehl commented Feb 3, 2020

was fixed with #15139

@sgiehl sgiehl closed this as completed Feb 3, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@sgiehl sgiehl

Labels
c: Usability For issues that let users achieve a defined goal more effectively or efficiently. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Projects
None yet
Milestone
4.0.0
Development

No branches or pull requests
3 participants
@mattab @sgiehl @katebutler