Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2016
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.18 KB | None | 0 0
  1. import mysql.connector
  2. print mysql.connector.__version__
  3. from mysql.connector import fabric
  4. from mysql.connector import errors
  5. fabric_config = {'host': '208.68.xxx.xxx','username':'admin','password':'Test101','port':32274}
  6. fcnx = mysql.connector.connect(fabric=fabric_config, user='root',password='Test101',database='fu')
  7. fcnx.set_property(group='druid', mode=fabric.MODE_READWRITE)
  8. cursor = fcnx.cursor()
  9. cursor.execute('select * from t1')
  10. rows = cursor.fetchall()
  11. print rows
  12. cursor.close()
  13.  
  14. >>> import mysql.connector
  15. >>> print mysql.connector.__version__
  16. 2.1.3
  17. >>> from mysql.connector import fabric
  18. >>> from mysql.connector import errors
  19. >>> fabric_config = {'host': '208.xxx.xxx.xxx',username':'admin','password':'Test101','port':32274}
  20. >>> fcnx = mysql.connector.connect(fabric=fabric_config, user='root',password='Test101',database='fu')
  21. >>> fcnx.set_property(group='druid', mode=fabric.MODE_READWRITE)
  22. >>> cursor = fcnx.cursor()
  23. >>> cursor.execute('select * from t1')
  24. >>> rows = cursor.fetchall()
  25. >>> print rows
  26. [(u'f1',), (u'f2',)]
  27. >>> cursor.close()
  28. True
  29.  
  30. Traceback (most recent call last):
  31. File "/home/ubuntu/workspace/bootops/scripts/mysql_conn.py", line 21, in <module>
  32. fcnx = mysql.connector.connect(fabric=fabric_config, user='root',password='Test101',database='fu')
  33. File "/usr/local/lib/python2.7/dist-packages/mysql/connector/__init__.py", line 146, in connect
  34. return fabric_connect(*args, **kwargs)
  35. File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/__init__.py", line 60, in connect
  36. return MySQLFabricConnection(**kwargs)
  37. File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 974, in __init__
  38. self.store_config(**kwargs)
  39. File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 1113, in store_config
  40. self._configure_fabric(config['fabric'])
  41. File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 1094, in _configure_fabric
  42. self._fabric.seed()
  43. File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 457, in seed
  44. inst.connect()
  45. File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 928, in connect
  46. self._proxy = self._xmlrpc_get_proxy()
  47. File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 912, in _xmlrpc_get_proxy
  48. proxy._some_nonexisting_method() # pylint: disable=W0212
  49. File "/usr/lib/python2.7/xmlrpclib.py", line 1233, in __call__
  50. return self.__send(self.__name, args)
  51. File "/usr/lib/python2.7/xmlrpclib.py", line 1587, in __request
  52. verbose=self.__verbose
  53. File "/usr/local/lib/python2.7/dist-packages/mysql/connector/fabric/connection.py", line 368, in request
  54. raise InterfaceError("Connection with Fabric failed: " + msg)
  55. mysql.connector.errors.InterfaceError: Connection with Fabric failed: <urlopen error [Errno 111] Connection refused>
  56.  
  57.  
  58.  
  59. lsof -i :32274
  60. COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
  61. mysqlfabr 16147 root 4u IPv4 40864 0t0 TCP *:32274 (LISTEN)
  62. lsof -i :32275
  63. COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
  64. mysqlfabr 16147 root 6u IPv4 40865 0t0 TCP *:32275 (LISTEN)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement