如何将Pymongo与ssh连接为Robo3T？

Question

我正在尝试用SSH和Pymongo连接远程mongo服务器。我使用python包ssh隧道。它适用于Robo3T，但对pythons无效。

它与Robo3T一起工作：

​

​

​

​

这是我的密码：

from sshtunnel import SSHTunnelForwarder
from pymongo import MongoClient
from pprint import pprint

MONGO_HOST = "localhost:27017"
MONGO_DB = "dbasename"
MONGO_USER = "username"
MONGO_PASS = "password"

server = SSHTunnelForwarder(
    MONGO_HOST,
    ssh_username=MONGO_USER,
    ssh_password=MONGO_PASS,
    remote_bind_address=('10.0.0.244', 22)
)
server.start()
client = pymongo.MongoClient('127.0.0.1', server.local_bind_port) 
db = client[MONGO_DB]

代码在server.start()停止。这是一个错误：

‘无法建立到SSH网关’

的会话

Answer 1

这是工作的代码：

from sshtunnel import SSHTunnelForwarder
from pymongo import MongoClient
from pprint import pprint

MONGO_HOST = "localhost:27017"
MONGO_DB = "dbasename"
MONGO_USER = "username"
MONGO_PASS = "password"

server = SSHTunnelForwarder(
  MONGO_HOST,
  ssh_username=MONGO_USER,
  ssh_password=MONGO_PASS,
  remote_bind_address=('localhost', 27017)
) 
server.start()
client = MongoClient(host= 'localhost', port=server.local_bind_port) 
db = client[MONGO_DB]