Solved Mysql "loading local data disabled" error

[Shai]

I'm getting the following error when trying to load data from a zip file that is included with the code base.

Error: Loading local data is disabled; this must be enabled on both the client and server sides

/app/data/openemr/library/standard_tables_capture.inc at 558:sqlStatement
/app/data/openemr/interface/code_systems/standard_tables_manage.php at 99:icd_import(ICD10)

The following php.ini setting is in /app/data/php.ini

mysqli.allow_local_infile = On

I've added the following to /etc/mysql/my.cnf

[mysqld]
local_infile=1
[client]
local_infile=1

Apache and Mysql have been restarted. I'm still getting the same error. Any ideas?

[girish]

@shai That flag has to enabled in mysql configuration which is not editable on Cloudron. We have disabled that on Cloudron because it's a security issue . You can also see matomo's faq on this - https://matomo.org/faq/troubleshooting/faq_194/ . Does the app not work without this feature? It's supposed to be a way to load data into the database from a file on the filesystem. This won't work on Cloudron since the app and mysql are in separate containers and will require some shared filesystem for the feature to work.

[Shai]

@girish the local_infile is the approach the app uses to load data sets for optional functionality. I'll go to the forum for OpenEMR and see if there is a way for me to manually upload the data instead of being done through the webapp UI.