Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.4
-
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
Did you try the password file without a newline? Because the plugin uses the whole file content as a password, including the last newline character. Try
echo -n secret > pwdfile