Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- print mysql.connector.__version__
- from mysql.connector import fabric
- from mysql.connector import errors
- fabric_config = {'host': '208.68.xxx.xxx','username':'admin','password':'Test101','port':32274}
- fcnx = mysql.connector.connect(fabric=fabric_config, user='root',password='Test101',database='fu')
- fcnx.set_property(group='druid', mode=fabric.MODE_READWRITE)
- cursor = fcnx.cursor()
- cursor.execute('select * from t1')
- rows = cursor.fetchall()
- print rows
- cursor.close()
- >>> import mysql.connector
- >>> print mysql.connector.__version__
- 2.1.3
- >>> from mysql.connector import fabric
- >>> from mysql.connector import errors
- >>> fabric_config = {'host': '208.xxx.xxx.xxx',username':'admin','password':'Test101','port':32274}
- >>> fcnx = mysql.connector.connect(fabric=fabric_config, user='root',password='Test101',database='fu')
- >>> fcnx.set_property(group='druid', mode=fabric.MODE_READWRITE)
- >>> cursor = fcnx.cursor()
- >>> cursor.execute('select * from t1')
- >>> rows = cursor.fetchall()
- >>> print rows
- [(u'f1',), (u'f2',)]
- >>> cursor.close()
- True
- Traceback (most recent call last):
- File "/home/ubuntu/workspace/bootops/scripts/mysql_conn.py", line 21, in <module>
- fcnx = mysql.connector.connect(fabric=fabric_config, user='root',password='Test101',database='fu')
- File "/usr/local/lib/python2.7/dist-packages/mysql/connector/__init__.py", line 146, in connect
- return fabric_connect(*args, **kwargs)
- File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/__init__.py", line 60, in connect
- return MySQLFabricConnection(**kwargs)
- File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 974, in __init__
- self.store_config(**kwargs)
- File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 1113, in store_config
- self._configure_fabric(config['fabric'])
- File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 1094, in _configure_fabric
- self._fabric.seed()
- File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 457, in seed
- inst.connect()
- File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 928, in connect
- self._proxy = self._xmlrpc_get_proxy()
- File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 912, in _xmlrpc_get_proxy
- proxy._some_nonexisting_method() # pylint: disable=W0212
- File "/usr/lib/python2.7/xmlrpclib.py", line 1233, in __call__
- return self.__send(self.__name, args)
- File "/usr/lib/python2.7/xmlrpclib.py", line 1587, in __request
- verbose=self.__verbose
- File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 368, in request
- raise InterfaceError("Connection with Fabric failed: " + msg)
- mysql.connector.errors.InterfaceError: Connection with Fabric failed: <urlopen error [Errno 111] Connection refused>
- lsof -i :32274
- COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
- mysqlfabr 16147 root 4u IPv4 40864 0t0 TCP *:32274 (LISTEN)
- lsof -i :32275
- COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
- mysqlfabr 16147 root 6u IPv4 40865 0t0 TCP *:32275 (LISTEN)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement