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

DB error: 1227 Access denied; you need (at least one of) the PROCESS privilege(s) for this operation #8871

Closed
mattab opened this issue Sep 30, 2015 · 0 comments
Closed

DB error: 1227 Access denied; you need (at least one of) the PROCESS privilege(s) for this operation #8871

mattab opened this issue Sep 30, 2015 · 0 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone
2.15.0

Comments

@mattab
Copy link
Member

mattab commented Sep 30, 2015

When a Mysql user does not have PROCESS privilege, when a DB error occurs, Piwik will trigger another exception and original exception message is hidden.

Following error can be triggered:

SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

For example during archiving:


Error: Got invalid response from API request: http://example.com/index.php?module=API&method=API.get&idSite=3&period=day&date=last2&format=php&token_auth=removed&segment=entryPageUrl%3D%3Dhttp%253A%252F%252Fwww.x4&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:141:"SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the PROCESS privilege(s) for this operation";}

It's triggered here: https://github.com/piwik/piwik/blob/2.15.0-b14/core/Db.php#L709-L718

Steps:

  • check if this SQL query SHOW ENGINE returns an exception 1227 (or maybe any), and catch it and don't display this error but bubble original exception.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Milestone
2.15.0
Development

No branches or pull requests
1 participant
@mattab