Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved Mysql "loading local data disabled" error

    LAMP
    2
    3
    223
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Shai
      Shai last edited by

      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 1 Reply Last reply Reply Quote 0
      • girish
        girish Staff @Shai last edited by

        @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 1 Reply Last reply Reply Quote 0
        • Shai
          Shai @girish last edited by

          @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.

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Powered by NodeBB