If mysql user does not have sufficient privileges, Piwik install fails "website time zone is not valid"
|Reported by:||matt||Owned by:|
Reported in forum:
Rather than failing with error message "timezone not valid"
- we should display a proper error message "User does not have privilege"
- update the requirement documentation to detail which privileges are required
Problem in code:
This issue arises from a call to Piwik_SetOption (when it's called from setDefaultTimezone) that causes an exception to be thrown because the public function "set" in Option.php fails at it's database call. This is due to insufficient database user privileges. Granting the piwik DB user more privileges allows the setup to continue.
Maybe we could have a page that checks the database user grants before continuing the setup. Or at-least some docs on the needed permissions for the piwik DB user since not everyone will be doing a "grant all".
Change History (8)
comment:3 Changed 20 months ago by matt (mattab)
- Milestone changed from 1.7.x - Piwik 1.7.x to 1.7.2 - Piwik 1.7.2
comment:6 Changed 19 months ago by capedfuzz (diosmosis)
- Resolution set to fixed
- Status changed from new to closed