mylvmbackup does not work with password encrypted using sha256_password mysql plugin

Bug #1689762 reported by George Mihalcea
6
This bug affects 1 person
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_password.

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('database=mysql;mysql_read_default_group=client','backup',...) failed: Authentication plugin 'sha256_password' cannot be loaded: /usr/lib/mysql/plugin/sha256_password.so: cannot open shared object file: No such file or directory at /usr/bin/mylvmbackup-0.16 line 265.
20170510 08:54:47 Error: Authentication plugin 'sha256_password' cannot be loaded: /usr/lib/mysql/plugin/sha256_password.so: cannot open shared object file: No such file or directory
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/mysql/plugin/sha256_password.so: cannot open shared object file: No such file or directory at /usr/bin/mylvmbackup-0.16 line 269.

It works on the same machine with mysql_native_password.

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('database=mysql;mysql_read_default_group=client','backup',...) failed: Authentication plugin 'sha256_password' cannot be loaded: /usr/lib/mysql/plugin/sha256_password.so: cannot open shared object file: No such file or directory at /usr/bin/mylvmbackup line 202.
20170510 08:57:27 Error: Authentication plugin 'sha256_password' cannot be loaded: /usr/lib/mysql/plugin/sha256_password.so: cannot open shared object file: No such file or directory
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/mysql/plugin/sha256_password.so: cannot open shared object file: No such file or directory at /usr/bin/mylvmbackup line 206.

The sha256_password is an internal plugin, it does not have a sha256_password.so file on disk.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.