odm-web icon indicating copy to clipboard operation
odm-web copied to clipboard

odm-web requires super mysql privilege

Open ohmer1 opened this issue 10 years ago • 0 comments

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.

ohmer1 avatar Jun 13 '14 15:06 ohmer1