MySQL Forums
Forum List  »  InnoDB clusters

InnoDB cluster addInstance gives access denied over internet
Posted by: Shubhra Prakash Nandi
Date: March 30, 2018 06:36AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB cluster addInstance gives access denied over internet
121
March 30, 2018 06:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.