Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11997

secure_file_priv works for CONNECT XML Tables but not for MEMORY Tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • 10.1.20
    • N/A
    • Authentication and Privilege System
    • None
    • openSUSE Thumbleweed VM, 4GB RAM, 2 CPU, 30GB HDD (10GB free) on top of EXSi 6

    Description

      I successfully ran the examples in https://mariadb.com/kb/en/mariadb/connect-xml-table-type/ with the XML files located in the /var/lib/mysql-files/ directory.

      However when tried to run the benchmark in https://mariadb.com/kb/en/mariadb/performance-of-memory-tables/ with the files hash1.txt and hash2.txt in the same directory, I got SQL Error 1290 as shown in the attached screenshot.

      Is this a bug?

      Please advice

      Attachments

        1. Error-secure_file_priv.png
          131 kB
          Eduardo Reyes
        2. Error-secure_file_priv-2.png
          116 kB
          Eduardo Reyes

        Activity

          People

            Unassigned Unassigned
            erchbox Eduardo Reyes
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.