A little up.
How are you supposed to do that securely when the user / group is set everywhere to www-data:www-data ? And by “parent-folders”, it means the parent-folder of the piwik folder ?
I’m far for expert, and i don’t see how i can currently set permissions for mysql only since chmod is only able to set permissions for the current user / current group / all the others users / all users.
Everything else is properly set (local_infile=1 in show variables), file permissions are granted to piwik.
Errors are the same than anyone else :
Try #1: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 13 Can’t get stat of ‘/home/…/piwik/tmp/assets/…’ (Errcode: 13),
Try #2: LOAD DATA LOCAL INFILE : SQLSTATE: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version
MySQL version : 5.5.37
Edit : i’ve created a group “piwik” with www-data and mysql just for piwik folder and all subfolders / files. It didn’t work. I added “adapter = MYSQLI” in the config file, it works. I set back the group for piwik folder and all subfolders / files to www-data, it still works… Mindfuck.