mylvmbackup does not work with password encrypted using sha256_password mysql plugin
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mylvmbackup |
New
|
Undecided
|
Unassigned |
Bug Description
For better security, mysql permits encrypting the passwords with the ssha256 hash using the sha256_password plugin. The default plugin is mysql_native_
When using mylvmbackup with a user that has the password encrypted with the sha256_password plugin (security constraints), mylvmbackup fails with the following error (mylvmbackup 0.16 on Ubuntu 14.04):
20170510 08:54:47 Info: Connecting to database...
DBI connect(
20170510 08:54:47 Error: Authentication plugin 'sha256_password' cannot be loaded: /usr/lib/
20170510 08:54:47 Info: Running hook 'logerr' as perl module.
Uncaught exception from user code:
Authentication plugin 'sha256_password' cannot be loaded: /usr/lib/
It works on the same machine with mysql_native_
The same error occurs with mylvmbackup 0.13 (the default version in Ubuntu 14.04) (of course different line numbers):
20170510 08:57:27 Info: Connecting to database...
DBI connect(
20170510 08:57:27 Error: Authentication plugin 'sha256_password' cannot be loaded: /usr/lib/
20170510 08:57:27 Info: Running hook 'logerr' as perl module.
Uncaught exception from user code:
Authentication plugin 'sha256_password' cannot be loaded: /usr/lib/
The sha256_password is an internal plugin, it does not have a sha256_password.so file on disk.