Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.1.4
-
Fix Version/s: 10.1.5
-
Component/s: Encryption
-
Labels:None
-
Environment: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
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
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