# Pt-kill is not working after moving from mysql\_native\_password to cashing\_sha2\_password
**URL:** https://forums.percona.com/t/pt-kill-is-not-working-after-moving-from-mysql-native-password-to-cashing-sha2-password/26112
**Category:** MariaDB Server & Utilities
**Tags:** percona
**Created:** [October 23, 2023, 10:58am UTC](https://forums.percona.com/t/pt-kill-is-not-working-after-moving-from-mysql-native-password-to-cashing-sha2-password/26112 "2023-10-23T10:58:37Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@zafermalik](https://forums.percona.com/u/zafermalik)
#### Post date: [October 23, 2023, 10:58am UTC](https://forums.percona.com/t/pt-kill-is-not-working-after-moving-from-mysql-native-password-to-cashing-sha2-password/26112/1 "2023-10-23T10:58:37Z")
Hi Friends, I am using mysql8.0.34 and all client libraries are latest i.e. 8.0.34 but after moving from mysql\_native\_password to cashing\_sha2\_password all is good except percona tool kit utilities like pt-kill, pt-archiver etc are not working getting below error message -
DBI connect(‘;host=127.0.0.1;mysql\_read\_default\_group=client’,‘zafar’,…) 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-kill line 2095.
As I know oracle has been removed cashing\_sha2\_password.so library and now it has been merged in another main library but here percona utilities are trying to search it while mysql client is able to connect with mysql server successfully via related library after this change. So if percona utility need this file then how I can install it or it’s any alternate. Till now I am not getting any solution in any post.
```auto
[root@test]# yum list installed | grep client
dhclient.x86_64 12:4.2.5-83.el7.centos.1 @updates
libsmbclient.x86_64 4.10.16-25.el7_9 @updates
libwbclient.x86_64 4.10.16-25.el7_9 @updates
mysql-commercial-client.x86_64 8.0.34-1.1.el7 @/mysql-commercial-client-8.0.34-1.1.el7.x86_64
mysql-commercial-client-plugins.x86_64 8.0.34-1.1.el7 @/mysql-commercial-client-plugins-8.0.34-1.1.el7.x86_64
openldap-clients.x86_64 2.4.44-25.el7_9 @updates
openssh-clients.x86_64 7.4p1-23.el7_9 @updates
pmm2-client.x86_64 2.40.0-6.el7 @percona-release-x86_64
samba-client-libs.x86_64 4.10.16-25.el7_9 @updates
sssd-client.x86_64 1.16.5-10.el7_9.15 @updates
```
I will be very thankful if some one can help here or can provide some clue.
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [October 23, 2023, 3:48pm UTC](https://forums.percona.com/t/pt-kill-is-not-working-after-moving-from-mysql-native-password-to-cashing-sha2-password/26112/2 "2023-10-23T15:48:32Z")
[https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html](https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html)
> - The client-side plugin is built into the `libmysqlclient` client library and is available to any program linked against `libmysqlclient`.
The percona toolkit should be looking for the libmysqlclient.so library, which has the sha2 inside. Most of the toolkit is Perl. Have you updated to the latest Perl DBD/DBI::mysql?
---
### Author:  [@zafermalik](https://forums.percona.com/u/zafermalik)
#### Post date: [October 24, 2023, 8:27am UTC](https://forums.percona.com/t/pt-kill-is-not-working-after-moving-from-mysql-native-password-to-cashing-sha2-password/26112/3 "2023-10-24T08:27:54Z")
@matthewb First of all thanks for your reply, we are using Perl 5.16 version as you see below and which is the latest compatible version with centos7.
```auto
[root@test]# perl --version
This is perl 5, version 16, subversion 3 (v5.16.3) built for x86_64-linux-thread-multi
```
I am also sharing few more details for better understanding-
OS Version is-
```auto
[root@test]# cat /etc/*release*
CentOS Linux release 7.9.2009 (Core)
```
mysql version is-
```auto
[root@test]# mysqld --version
/.../mysqld Ver 8.0.34-commercial for Linux on x86_64 (MySQL Enterprise Server - Commercial)
```
percona tool kit (pt-kill) version is-
```auto
[root@test]# pt-kill --version
pt-kill 3.5.5
```
Please help me how I can come out from this issue.
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [October 24, 2023, 3:06pm UTC](https://forums.percona.com/t/pt-kill-is-not-working-after-moving-from-mysql-native-password-to-cashing-sha2-password/26112/4 "2023-10-24T15:06:14Z")
I recommend installing the Percona yum repos and installing the latest DBD/DBI::Mysql package from our repo. I don’t know if this is the exact fix. This is the problem with running modern apps on outdated OS. 🤷♂️
---
### Author:  [@yunus\_shaikh](https://forums.percona.com/u/yunus_shaikh)
#### Post date: [October 24, 2023, 4:21pm UTC](https://forums.percona.com/t/pt-kill-is-not-working-after-moving-from-mysql-native-password-to-cashing-sha2-password/26112/5 "2023-10-24T16:21:13Z")
> [@zafermalik](#):
>
> Please help me how I can come out from this issue.
Please check the version of driver
```auto
ps -ef | grep -i perl-dbd-mysql
```
you need to have at least version 4.050.
Driver drives the authentication.
Try to install it from percona repo and it should work
---
### Author:  [@zafermalik](https://forums.percona.com/u/zafermalik)
#### Post date: [October 25, 2023, 3:33pm UTC](https://forums.percona.com/t/pt-kill-is-not-working-after-moving-from-mysql-native-password-to-cashing-sha2-password/26112/6 "2023-10-25T15:33:30Z")
@matthewb thanks for your support.
@yunus_shaikh : thank you very much to pinpoint this information to resolve the issue. After upgrading perl-DBD-mysql version from 4.023 (which is officially latest updated version compatible with centos7) to 4.050 it is working fine.