Authentication plugin 'caching_sha2_password' cannot be loaded
General
Escalation
General
Escalation
Description
Environment
None
AFFECTED CS IDs
CS0041305
Activity
Sveta Smirnova April 22, 2024 at 3:21 PM
Sveta Smirnova April 22, 2024 at 3:21 PM
This plugin requires SSL connection, so this bug is practically duplicate of https://perconadev.atlassian.net/browse/PT-191. For now, specify SSL options in the configuration file and pass it with F option of DSN.
Matthew Boehm September 9, 2020 at 6:41 PM
Ok, so it'll work, just have to remember to upgrade perl-mysql using experimental packages. Still, at least it is confirmation that you can't use toolkit out-of-box on PS8. I've emailed Marco on this, hoping we can get some priority/focus on it.
C W September 9, 2020 at 4:59 PMEdited
Actually, upgrading MySQL did seem to trigger the issue, but then you just need perl-DBD-MySQL from the tools/expermental repo
$ mysqld -V; rpm -q percona-toolkit perl-DBD-MySQL; repoquery --location --enablerepo=tools-experimental-x86_64 perl-DBD-MySQL
/usr/sbin/mysqld Ver 8.0.20-11 for Linux on x86_64 (Percona Server (GPL), Release 11, Revision 5b5a5d2)
percona-toolkit-3.2.1-1.el7.x86_64
perl-DBD-MySQL-4.050-4.el7.x86_64
http://repo.percona.com/tools/yum/experimental/7/RPMS/x86_64/perl-DBD-MySQL-4.050-4.el7.x86_64.rpm
$ pt-heartbeat --monitor --user testme --database percona --ask-pass --create-table
Enter password:
Error creating heartbeat table:DBD::mysql::db do failed: The MySQL server is running with the --read-only option so it cannot execute this statement [for Statement " CREATE TABLE IF NOT EXISTS `percona`.`heartbeat` (
ts varchar(26) NOT NULL,
server_id int unsigned NOT NULL PRIMARY KEY,
file varchar(255) DEFAULT NULL, -- SHOW MASTER STATUS
position bigint unsigned DEFAULT NULL, -- SHOW MASTER STATUS
relay_master_log_file varchar(255) DEFAULT NULL, -- SHOW SLAVE STATUS
exec_master_log_pos bigint unsigned DEFAULT NULL -- SHOW SLAVE STATUS
);"] at /usr/bin/pt-heartbeat line 5997.
C W September 9, 2020 at 4:27 PMEdited
$ pt-heartbeat --version
pt-heartbeat 3.2.1
$ rpm -q perl-DBD-MySQL
perl-DBD-MySQL-4.023-6.el7.x86_64
Duplicate
Details
Details
Assignee
Unassigned
UnassignedReporter
C W
C WPriority
Components
Labels
Created April 26, 2019 at 10:24 AM
Updated April 25, 2024 at 11:10 AM
Resolved April 22, 2024 at 3:21 PM
Unable to correct an issue on the client
$ pt-table-sync --sync-to-master --replicate percona.checksums --verbose --user=root --print h=localhost DBI connect(';host=localhost;mysql_read_default_group=client','root',...) failed: Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory at /bin/pt-table-sync line 2257. $ pt-table-sync --version pt-table-sync 3.0.13 $ mysqld -V /usr/sbin/mysqld Ver 8.0.15-5 for Linux on x86_64 (Percona Server (GPL), Release 5, Revision f8a9e99) $ rpm -qa "*percona*" percona-server-shared-8.0.15-5.1.el7.x86_64 percona-backup-tools-1.0.0-16.x86_64 percona-server-shared-compat-8.0.15-5.1.el7.x86_64 percona-server-server-8.0.15-5.1.el7.x86_64 percona-release-1.0-11.noarch percona-rdba-1.0.0-710.noarch percona-toolkit-3.0.13-1.el7.x86_64 percona-nagios-plugins-1.1.8-1.noarch percona-server-client-8.0.15-5.1.el7.x86_64 percona-backup-1.0.1-20.noarch