enterprise-support team mailing list archive

[George Mihalcea <george.mihalcea@xxxxxxxxx>]

Public bug reported:

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.

** Affects: mylvmbackup
     Importance: Undecided
         Status: New


** Tags: sha256password

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1689762

Title:
  mylvmbackup does not work with password encrypted using
  sha256_password mysql plugin

To manage notifications about this bug go to:
https://bugs.launchpad.net/mylvmbackup/+bug/1689762/+subscriptions