Sunday, 6 December 2015

ssh db connectivity

manual steps:
login forticlient

putty prodip port 2022
ssh ip2
redirects to mysql ip3

with SSHTunnelForwarder(
         ('ip1', 2022),
         ssh_password="user1",
         ssh_username="pwd1",
         remote_bind_address=('ip3', 3306)) as server:
            db = MySQLdb.connect(host='127.0.0.1',
                       port=server.local_bind_port,
                       user='sql_user',
                       passwd='sql pwd',
                       db='sql db')
            with db:
                cur = db.cursor()

No comments:

Post a Comment