Trying to impliment mysql db replication. However facing issue. After analysisng found that below command is failing with "UnrecoverableKeyException: Password verification failed"
symadmin --engine source create-sym-tables
Below nc response. Would you please advise is this fine?
nc source 3306 is giving below response.
"J
8.0.1qd v@"]�����j>Z~v(
m
3ucaching_sha2_password"
Attached entrypoint.sh file
SSL @DB is enabled. Below is output after connecting to db.
mysql: [Warning] Using a password on the command line interface can be insecure.
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.13 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
You are enforcing ssl conection via unix socket. Please consider
switching ssl off as it does not make connection via unix socket
any more secure.
mysql>
Trying to impliment mysql db replication. However facing issue. After analysisng found that below command is failing with "UnrecoverableKeyException: Password verification failed"
symadmin --engine source create-sym-tables
Below nc response. Would you please advise is this fine?
nc source 3306 is giving below response.
"J
8.0.1qd v@"]�����j>Z~v(
m
3ucaching_sha2_password"
Attached entrypoint.sh file
SSL @DB is enabled. Below is output after connecting to db.
mysql: [Warning] Using a password on the command line interface can be insecure.
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.13 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
You are enforcing ssl conection via unix socket. Please consider
switching ssl off as it does not make connection via unix socket
any more secure.
mysql>
Last edit: Jagannath Bilgi 2018-11-24
Able to setup mysql replication. Issue was due to version mismatch between mysql and connector. It is working with mysql 5.6.42 and connector 5.1.45
Thank you for posting your solution!