本地python如何通过ssh连接生产环境的mongo数据库

本地python如何通过ssh连接生产环境的mongo数据库

在这个环节踩了很多坑，很多资料验证的结果都是异常，无法正常运行

from sshtunnel import SSHTunnelForwarder
from pymongo import MongoClient

SSH连接配置

ssh_host = ‘’ #跳转服务器ip
ssh_port = 8322 #跳转服务器端口
ssh_username = ‘’#跳转服务器用户
ssh_password = ‘’ #跳转服务器密码

MongoDB连接配置

mongo_host = ‘’ #mongo的ip
mongo_port = 27017 # MongoDB默认端口
mongo_username = ‘’ #mongo的用户名
mongo_password = ‘’#mongo的密码
mongo_db_name = ‘’#mongo的数据库

创建SSH隧道

with SSHTunnelForwarder(
(ssh_host, ssh_port),
ssh_username=ssh_username,
ssh_password=ssh_password,
remote_bind_address=(mongo_host, mongo_port)
) as tunnel:
# 连接MongoDB
# client = MongoClient(‘127.0.0.1’, tunnel.local_bind_port)

client = MongoClient(f'mongodb://{mongo_username}:{mongo_password}@127.0.0.1:{tunnel.local_bind_port}/{mongo_db_name}?authSource=admin')
db = client[mongo_db_name]
# 执行MongoDB操作
collection = db['mongo集合']
documents = collection.find()
print(documents)
for document in documents:
    print(document)
# 关闭连接
client.close()

重点关注client = MongoClient(f’mongodb://{mongo_username}:{mongo_password}@127.0.0.1:{tunnel.local_bind_port}/{mongo_db_name}?authSource=admin’)，在这块的连接权限上问题比较多