InnoDB cluster addInstance gives access denied over internet

[Shubhra Prakash Nandi]

Hi, I have been able to successfully setup InnoDB multi-primary cluster on a subnet/LAN but I am stuck at addInstance process when trying to setup the cluster using the same process for instances over Internet.I am getting the following error.

Cluster.addInstance: ERROR: Error joining instance to cluster: 'db-node1:3306' - mysql.get_classic_session: Access denied for user 'ca'@'db-node1' (using password: YES) (RuntimeError)


--From mysql error.log

2018-03-30 12:23:29: Debug: mysqlprovision: Traceback (most recent call last):
File "/usr/share/mysqlsh/mysqlprovision.zip/__main__.py", line 99, in <module>
join(server, peer_server, **cmd_options)
File "/usr/share/mysqlsh/mysqlprovision.zip/mysql_gadgets/command/gr_admin.py", line 770, in join
peer_server = get_server(server_info=peer_server_info)
File "/usr/share/mysqlsh/mysqlprovision.zip/mysql_gadgets/common/server.py", line 280, in get_server
server.connect()
File "/usr/share/mysqlsh/mysqlprovision.zip/mysql_gadgets/common/server.py", line 753, in connect
self.db_conn = self.get_connection()
File "/usr/share/mysqlsh/mysqlprovision.zip/mysql_gadgets/common/server.py", line 812, in get_connection
raise GadgetCnxError(err.args[1], err.args[0], cause=err, server=self)
GadgetCnxError: 'db-node1:3306' - mysql.get_classic_session: Access denied for user 'ca'@'db-node1' (
using password: YES)


I am able to successfully connect to the other instance from db-node1 via mysqlsh so it seems some issue in clustering / GR layer. Can anyone assist?



Edited 2 time(s). Last edit at 03/30/2018 06:42AM by Shubhra Prakash Nandi.