| 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 | ||
[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. http://dev.mysql.com/doc/connector-net/en/connector-net-programming-fabric.html Thanks, Chiranjeevi.
[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) mysql>
[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 Thanks. Regards, Ravi
[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. http://dev.mysql.com/doc/connector-net/en/connector-net-programming-fabric.html Thanks, Chiranjeevi.
[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
Hi, 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".
Description: 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", autocommit=True ) conn.set_property(mode=fabric.MODE_READWRITE, group="HAmysqlgroup") cur = conn.cursor() cur.execute( "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 http://dev.mysql.com/doc/connector-net/en/connector-net-programming-fabric.html and see whether you can able to create dtabase/tables. We are using connector 6.9.6 .