Pt-archiver to “Azure Database for MySQL servers” failed: SSL connection is required. Please specify SSL options and retry

MySQL & MariaDB Other MySQL® Questions
1

After enabling SSL mode on MySQL Azure PaaS the connection fails with the following error:
failed: SSL connection is required. Please specify SSL options and retry
mycommd:

pt-archiver --source h=XXX,P=3306,u="XXX",p=XXX,D=dbatest,t=XXX,A=utf8mb4 --dest h=XXX,P=3306,u=XXX,D=dbatest,t=XXX,A=utf8mb4 --where "XXX'"   --progress=500 --txn-size=10000 --limit=1000 --statistics --ask-pass  --dry-run

I tried to configure the Azure CA certificate in my.cnf of the client, but I have the same error:

[client]
ssl-mode= VERIFY_CA
ssl-ca = /opt/bakss/DigiCertGlobalRootCA.pem

and i also follow this blog post too Percona Toolkit for MySQL with MySQL-SSL Connections

i can use ssl in mysql

mysql -h XXX -uXXX -p -e "SHOW STATUS LIKE 'Ssl_cipher'"
Enter password: 
+---------------+-----------------------------+
| Variable_name | Value                       |
+---------------+-----------------------------+
| Ssl_cipher    | ECDHE-RSA-AES128-GCM-SHA256 |
+---------------+-----------------------------+

I can’t understand where I’m wrong, Thanks for the help…

1 Like
2

Hi, can you try the steps listed in Does Percona Toolkit support SSL client authentication? - #3 by jfg956
let me know if that helps

1 Like
3

Its really helpful. Thank you very much

1 Like
4

glad to hear! you are most welcome

1 Like