MySQL Forums :: Utilities :: MySQL Workbench can't connect to Fabric node


Advanced Search

MySQL Workbench can't connect to Fabric node
Posted by: Robert Sandiford ()
Date: April 11, 2016 01:16PM

Hi,

We're evaluating MySQL HA using Fabric. We have a Fabric node up and running on a RHEL 7 server with backing store, and we can run the mysqlfabric commands on the node. i.e. everything there *seems* to be OK.

However, when we try to connect MySQL Workbench (as per http://dev.mysql.com/doc/workbench/en/wb-mysql-connections-fabric.html), we keep getting

"Failed to Connect to MySQL at {address} fabric node with user admin. WbFabricInterface.openConnection(): Can't connect to MySQL server on '{address}' (10061)"

(where {address} is the server / port).

From the same MySQL Workbench, we can set up a normal Connection direct to the backing store, which is on the same server. So, we know we have the address right for that.

our MySQL Workbench connection properties are:
Connection Method: MySQL Fabric Management Node
Hostname {server name}
Port: 32274
Username: admin
Options MySQL Username fabric_server
Options H.A. Group Filter: none

Our Fabric config has these elements:

[servers]
user = fabric_server
password = {password}
backup_user = fabric_backup
backup_password = {password}
restore_user = fabric_restore
restore_password = {password}
unreachable_timeout = 5

[protocol.xmlrpc]
address = localhost:32274
threads = 5
user = admin
password = {password}
disable_authentication = no
realm = MySQL Fabric
ssl_ca =
ssl_cert =
ssl_key =

On the server, "netstat -tanp | grep 3227" yields:
tcp 0 0 127.0.0.1:32274 0.0.0.0:* LISTEN 2692/python
tcp 0 0 127.0.0.1:32275 0.0.0.0:* LISTEN 2692/python

We're using MySQL 5.7.12

We're using Fabric from the 1.5.6 version of the Utilities.

We're using MySQL Workbench version "6.3.6 build 517 CE" on a linux workstation, and "6.3.6 build 511 CE" on a Windows workstation - both are having the same trouble.

Any ideas?

Thanks!

Bob.

Options: ReplyQuote


Subject Views Written By Posted
MySQL Workbench can't connect to Fabric node 1483 Robert Sandiford 04/11/2016 01:16PM
Re: MySQL Workbench can't connect to Fabric node 520 Robert Sandiford 04/11/2016 03:06PM
Re: MySQL Workbench can't connect to Fabric node 554 Robert Sandiford 04/12/2016 09:08AM
Re: MySQL Workbench can't connect to Fabric node 496 Shantanu Bansal 05/27/2016 06:45AM
Re: MySQL Workbench can't connect to Fabric node 421 Chuck Bell 06/02/2016 09:03AM


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.