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

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

Comments

Projects
None yet
1 participant
@mattab
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