Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- import sshtunnel
- with sshtunnel.SSHTunnelForwarder(
- (_host, _ssh_port),
- ssh_username=_username,
- ssh_password=_password,
- remote_bind_address=(_remote_bind_address, _remote_mysql_port),
- local_bind_address=(_local_bind_address,_local_mysql_port)
- ) as tunnel:
- connection = mysql.connector.connect(
- user=_db_user,
- passwd=_db_password,
- host=_local_bind_address,
- database=_db_name,
- port=_local_mysql_port)
- csr = connection.cursor()
- Traceback (most recent call last):
- File "dbtest1.py", line 30, in <module>
- csr = connection.cursor()
- File "/usr/local/lib/python2.7/dist-packages/mysql/connector/connection.py", line 848, in cursor
- raise errors.OperationalError("MySQL Connection not available.")
- mysql.connector.errors.OperationalError: MySQL Connection not available.
Add Comment
Please, Sign In to add comment