How do you get pt-heartbeat to connect to a slave who has require_secure_transport enabled?

grosenthal · December 30, 2020, 4:26pm

I do not see any ssl options listed in the pt-heartbeat --help. Please advise as i’m unable to get it to connect to my slaves.

carlos.salguero · December 30, 2020, 4:36pm

Hello, Please check https://jira.percona.com/browse/PT-191. It has info about using SSL with Toolkit.
Regards

grosenthal · December 30, 2020, 4:36pm

Thanks. I have tried 6 ways to sunday to ge this to work but seeing unauthroized user hung up in connection control plugin on the slave and seeing ssl connection error on the master. See below

bash$ pt-heartbeat F=/var/lib/mysql/my1.cnf -D test --master-server-id 1 --checkDBI connect(‘test;mysql_read_default_file=/var/lib/mysql/my1.cnf;mysql_read_default_group=client’,’’,…) failed: SSL connection error: error:00000001:lib(0):func(0):reason(1) at /bin/pt-heartbeat line 2908.

my1.cnf looks like this[client]user=myuserpassword=mypasshost=xx.xx.xx.xxport=3306ssl-mode=REQUIRED

Any suggestions?