MySQL Forums
Forum List  »  Utilities

mysql fabric does noit work
Posted by: David Monty
Date: April 03, 2016 04:12AM

Hi,

I am very concerned about the use of fabric in production environmemts given that lack not being able to connect.

I have 2 shards and created my groups. in fabric all is healthy groups etc..

Yet I cant use python to connect to Fabric? Wow! I tried also the defult protocal on 32274. Is the use of fabric still experimental?


I mean I used the saem username and password for everything and rather confused on how I can get access denined.

>>> fabric_config = {"host" : "172.31.30.59", "port" : 32275, "protocol": "mysql", "user":'root',"password":"Test101"}
>>> fcnx = mysql.connector.connect(fabric=fabric_config, user='root',password='Test101',database='employees')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/lib/python2.7/dist-packages/mysql/connector/__init__.py", line 153, in connect
return fabric_connect(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/mysql/connector/fabric/__init__.py", line 54, in connect
return MySQLFabricConnection(**kwargs)
File "/usr/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 1264, in __init__
self.store_config(**kwargs)
File "/usr/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 1408, in store_config
self._configure_fabric(config['fabric'])
File "/usr/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 1389, in _configure_fabric
self._fabric.seed()
File "/usr/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 627, in seed
connect_delay=self._connect_delay)
File "/usr/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 158, in __init__
self.handler.connect()
File "/usr/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 1229, in connect
self._connection = self._get_connection()
File "/usr/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 1215, in _get_connection
return MySQLConnection(**dbconfig)
File "/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line 95, in __init__
self.connect(**kwargs)
File "/usr/lib/python2.7/dist-packages/mysql/connector/abstracts.py", line 719, in connect
self._open_connection()
File "/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line 210, in _open_connection
self._ssl)
File "/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line 144, in _do_auth
self._auth_switch_request(username, password)
File "/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line 177, in _auth_switch_request
raise errors.get_exception(packet)
mysql.connector.errors.ProgrammingError: 1044 (42000): [Fabric] Access denied for user 'root'

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql fabric does noit work
1532
April 03, 2016 04:12AM
648
April 06, 2016 12:50PM


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.