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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. LAMP
  3. Mysql "loading local data disabled" error

Mysql "loading local data disabled" error

Scheduled Pinned Locked Moved Solved LAMP
3 Posts 2 Posters 910 Views 2 Watching
  • 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.
  • ShaiS Offline
    ShaiS Offline
    Shai
    wrote on last edited by
    #1

    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?

    girishG 1 Reply Last reply
    0
    • ShaiS 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?

      girishG Offline
      girishG Offline
      girish
      Staff
      wrote on last edited by
      #2

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

      ShaiS 1 Reply Last reply
      0
      • girishG 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.

        ShaiS Offline
        ShaiS Offline
        Shai
        wrote on last edited by
        #3

        @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
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • Bookmarks
        • Search