Fmstrat / Fmstrat/odm-web

odm-web requires super mysql privilege

Open
#16 0 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.