Skip to content

odm-web requires super mysql privilege #16

@ohmer1

Description

@ohmer1

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions