Bug #77019 Not able to connect to MySQL using MySQL Fabric Connector using .Net
Submitted: 12 May 2015 19:18 Modified: 14 Jun 2015 10:43
Reporter: Ravi Subramaniyan Email Updates:
Status: No Feedback Impact on me:
Category:Connector / NET Severity:S1 (Critical)
Version:mysqlfabric 1.5.4 and Connector 6.9.6 OS:Linux (Linux mysqlfailoverconsole 2.6.32-431.5.1.el6.x86_64 #1 SMP Tue Feb 11 11:09:04 PST 2014 x86_64 x86_)
Assigned to: Assigned Account CPU Architecture:Any
Tags: connectiontonet, mysqlfabric

[12 May 2015 19:18] Ravi Subramaniyan
I am able to connect to the MySQL Fabric using the Python code, here is the sample code:

import mysql.connector
from mysql.connector import fabric

conn = mysql.connector.connect(
    fabric={"host" : "X.X.X.X", "port" : 32274, "username": "admin", \
        "password" : "Access01"},
    user="test", database="test", password="test",

conn.set_property(mode=fabric.MODE_READWRITE, group="HAmysqlgroup")
cur = conn.cursor()
"CREATE TABLE IF NOT EXISTS subscribersRavi ("
"   sub_no INT, "
"   first_name CHAR(40), "
"   last_name CHAR(40)"

However, while connecting to C# code, it is not able to connect in the sample code listed in the url http://dev.mysql.com/doc/connector-net/en/connector-net-programming-fabric.html. 

It is not connecting to MySQL Fabric host and not recongize the Fabric host as mentioned in the sample code.

Is the sample C# code is working in your lab?

How to repeat:
Try to code the sample listed in the url 


and see whether you can able to create dtabase/tables. We are using connector 6.9.6 .
[13 May 2015 6:49] Chiranjeevi Battula
Hello  Ravi Subramaniyan,

Thank you for the bug report.
I tried to reproduce the issue at my end using Visual Studio 2013 (C#.Net) with  MySQL Connector/Net 6.9.6, mysqlfabric 1.5.4 but not seeing any issue with database connection.
It is working fine as per manual.

[13 May 2015 6:50] Chiranjeevi Battula
database connection screenshot

Attachment: 77019.PNG (image/png, text), 72.48 KiB.

[13 May 2015 6:53] Chiranjeevi Battula
-- confirmation from database side
mysql> show databases;
| Database           |
| information_schema |
| employees          |
| mysql              |
| performance_schema |
| test               |
5 rows in set (0.27 sec)

mysql> use employees;
Database changed
mysql> select * from employees;
| emp_no | first_name | last_name |
|     12 | John       | Doe       |
1 row in set (0.26 sec)

[13 May 2015 14:39] Ravi Subramaniyan
Hi Chiranjeevi,
  Could you please share App.config file and status of mysql fabric group health: 

%mysqlfabric group health my_group


[13 May 2015 14:42] Ravi Subramaniyan
I think, it is better if you can send us the project you have created for the testing along with my_group health status.
[14 May 2015 5:49] Chiranjeevi Battula
Hello  Ravi Subramaniyan,

Thank you for your feedback.
App.config file sending through attachments and rest of the code taken from the manual.

[14 May 2015 5:49] Chiranjeevi Battula
App.config file

Attachment: 77019_App.config (application/xml, text), 2.09 KiB.

[14 May 2015 9:38] Ravi Subramaniyan
Could you please send me the screenshot of code on connection where you specify fabric server and app user and passwd?
[14 May 2015 10:43] Chiranjeevi Battula
Connection screenshot

Attachment: 77019_1.PNG (image/png, text), 75.73 KiB.

[16 Jun 2015 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".