时间戳

首页 > 解决方案 > 无法通过 python 中的 ssh 隧道连接到远程数据库

python - 无法通过 python 中的 ssh 隧道连接到远程数据库

问题描述

我正在尝试通过 ssh 隧道连接到远程数据库。但是当我尝试连接时出现错误。下面是我的代码和错误

def query(q):
    with SSHTunnelForwarder(
            ("bastion.example.co", 22),
            ssh_username="ubuntu",
            ssh_pkey="~/.ssh/id_rsa.pub",
            remote_bind_address=("127.0.0.1", 3306)
    ) as server:
        conn = mysql.connect(host="xyz.rds.amazonaws.com",
                          port=server.local_bind_port,
                          user="prod_db",
                          passwd="123abc",
                          db="prod_db")
        return pd.read_sql_query(q, conn)

print(query('select * from abc_table'))

错误：

Traceback (most recent call last):
  File "conn_mysql.py", line 20, in <module>
    print(query('select * from abc_table'))
  File "conn_mysql.py", line 11, in query
    remote_bind_address=("127.0.0.1", 3306)
  File "/Users/mohnishmallya/PycharmProjects/3Bvs2A/venv/lib/python3.7/site-packages/sshtunnel.py", line 904, in __init__
    logger=self.logger
  File "/Users/mohnishmallya/PycharmProjects/3Bvs2A/venv/lib/python3.7/site-packages/sshtunnel.py", line 1095, in _consolidate_auth
    raise ValueError('No password or public key available!')
ValueError: No password or public key available!

我该如何解决这个问题？

标签： pythonsshssh-tunnel

解决方案

使用构造函数ssh_pkey的参数来提供您的私钥文件（不是公钥）的路径。SSHTunnelForwarder.pub

推荐阅读