Guest User

Untitled

a guest
Apr 7th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. import mysql.connector
  2. import sshtunnel
  3.  
  4. with sshtunnel.SSHTunnelForwarder(
  5. (_host, _ssh_port),
  6. ssh_username=_username,
  7. ssh_password=_password,
  8. remote_bind_address=(_remote_bind_address, _remote_mysql_port),
  9. local_bind_address=(_local_bind_address,_local_mysql_port)
  10. ) as tunnel:
  11. connection = mysql.connector.connect(
  12. user=_db_user,
  13. passwd=_db_password,
  14. host=_local_bind_address,
  15. database=_db_name,
  16. port=_local_mysql_port)
  17.  
  18. csr = connection.cursor()
  19.  
  20. Traceback (most recent call last):
  21. File "dbtest1.py", line 30, in <module>
  22. csr = connection.cursor()
  23. File "/usr/local/lib/python2.7/dist-packages/mysql/connector/connection.py", line 848, in cursor
  24. raise errors.OperationalError("MySQL Connection not available.")
  25. mysql.connector.errors.OperationalError: MySQL Connection not available.
Add Comment
Please, Sign In to add comment