Authentication plugin 'caching_sha2_password' cannot be loaded

Description

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

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 PM
Edited

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 PM
Edited

$ pt-heartbeat --version pt-heartbeat 3.2.1 $ rpm -q perl-DBD-MySQL perl-DBD-MySQL-4.023-6.el7.x86_64
Duplicate

Details

Assignee

Reporter

Priority

Components

Affects versions

Created April 26, 2019 at 10:24 AM
Updated April 25, 2024 at 11:10 AM
Resolved April 22, 2024 at 3:21 PM