odm-web requires super mysql privilege
- Dominant language
- PHP
- Stars
- 50
- Forks
- 33
- PR merge metrics
- No merged PRs in 30d
Description
I think this is wrong.
This exception pop when I request a photo from the device.
> Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation' in /var/web/mdm.xxxx.ca/src/odm-web/odm/include/db.php:54
> Stack trace:
> # 0 /var/web/mdm.xxxx.ca/src/odm-web/odm/include/db.php(54): PDO->prepare('SET GLOBAL max_...')
> # 1 /var/web/mdm.xxxx.ca/src/odm-web/odm/api/file.php(36): storeFile('79', Resource id #2) {main}
>
> thrown in /var/web/mdm.xxxx.ca/src/odm-web/odm/include/db.php on line 54
I commented out lines 54-55 and 64-65 from odm-web/odm/include/db.php and it seem to work.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.