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

file_key_management_filekey doesn't work as expected with FILE:

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.4
    • 10.1.5
    • Encryption
    • None
    • CentOS 7 64 Bit

    Description

      The file_key_management_filekey variable doesn't seem to be parsed correctly when used with the FILE: option. The log file responds with the following message...

      [ERROR] mysqld: Cannot decrypt /var/lib/mysql/key.enc. Wrong key?

      I've checked my key.enc file decrypts successfully with the following command...

      openssl aes-256-cbc -d -md sha1 -k secret -in key.enc

      and when I set...

      file_key_management_filekey=secret

      and restart mariadb there are no complaints in the error log. Running SHOW VARIABLES LIKE 'file%';

      Show the file_key_management_% variables have been set by the server.

      I've checked my pwd file a number of times, tried it with a newline after the password, all with the same result.

      Cheers,

      Rhys

      Attachments

        Activity

          People

            serg Sergei Golubchik
            rhyscampbell Rhys Campbell
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.