Not the answer you need?
Register and ask your own question!

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

grosenthalgrosenthal EntrantCurrent User Role Supporter
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.

Answers

  • carlos.salguerocarlos.salguero Percona Toolkit Developer Percona Staff Role
    Hello, 
    Please check https://jira.percona.com/browse/PT-191. It has info about using SSL with Toolkit.

    Regards

  • grosenthalgrosenthal Entrant Current User Role Supporter
    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 --check
    DBI 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=myuser
    password=mypass
    host=xx.xx.xx.xx
    port=3306
    ssl-mode=REQUIRED

    Any suggestions?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.