Skip to content

Instantly share code, notes, and snippets.

@JinhaiZ
Created November 19, 2017 16:39
Show Gist options
  • Save JinhaiZ/3ad536870b9853dbff11ab4241380c0d to your computer and use it in GitHub Desktop.
Save JinhaiZ/3ad536870b9853dbff11ab4241380c0d to your computer and use it in GitHub Desktop.
connect to MongoDB via ssh tunnel
from sshtunnel import SSHTunnelForwarder
import pymongo
MONGO_HOST = "IP_ADDRESS"
MONGO_USER = "USERNAME"
MONGO_PASS = "PASSWORD"
MONGO_DB = "DATABASE_NAME"
MONGO_COLLECTION = "COLLECTION_NAME"
# define ssh tunnel
server = SSHTunnelForwarder(
MONGO_HOST,
ssh_username=MONGO_USER,
ssh_password=MONGO_PASS,
remote_bind_address=('127.0.0.1', 27017)
)
# start ssh tunnel
server.start()
connection = pymongo.MongoClient('127.0.0.1', 27017)
db = connection[MONGO_DB]
collection = db[MONGO_COLLECTION]
# close ssh tunnel
server.stop()
@Thevakajan
Copy link

how can resolve mongo DB connection issues

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment