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

System check not verifying permissions for LOAD DATA INFILE #7185

Closed
averymd opened this issue Feb 12, 2015 · 1 comment
Closed

System check not verifying permissions for LOAD DATA INFILE #7185

averymd opened this issue Feb 12, 2015 · 1 comment
Assignees
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone

Comments

@averymd
Copy link

averymd commented Feb 12, 2015

Discovered during #6868. Despite a DB user not having permission to use LOAD DATA INFILE, the system check page believes that they do. When the user doesn't have permission, their Piwik logs will contain entries like the following during the archive process:

INFO Referrers[2015-02-12 03:41:31] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]:
Invalid authorization specification: 1045 Access denied for user '<username>'@'%' (using password: YES)[28000]

This error isn't reported in the cron job's log, only Piwik's own log.

@mattab
Copy link
Member

mattab commented Feb 19, 2015

here probably what's happening is that LOAD DATA INFILE does not work and is logged, however LOAD DATA LOCAL INFILE then works. When one of the method works, we should not log an error if the other method does not work.

@mattab mattab added the Bug For errors / faults / flaws / inconsistencies etc. label Feb 19, 2015
@mattab mattab added this to the Piwik 2.12.0 milestone Feb 19, 2015
@mattab mattab self-assigned this Feb 19, 2015
@mattab mattab closed this as completed in 11a4c9f Feb 19, 2015
@mattab mattab modified the milestones: Piwik 2.12.0, Piwik 2.11.1 Feb 19, 2015
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.
Projects
None yet
Development

No branches or pull requests

2 participants