Connect to MongoDB without password using pymongo

Question

I'm a bit confused with the problem with pymongo and MongoDB.

I have a MongoDB server that I can connect using Studio 3T without any password (behind VPN):

mongodb://mongodb-dev.my.server:27017/?serverSelectionTimeoutMS=5000&connectTimeoutMS=10000

When I'm connecting to the server from Python I get error:

pymongo.errors.ServerSelectionTimeoutError: Could not reach any servers in [('mongodb-dev', 27017)]. Replica set is configured with internal hostnames or IPs?, Timeout: 5.0s, Topology Description: <TopologyDescription id: 6200d97072f39326314e6916, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('mongodb-dev', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('mongodb-dev:27017: [Errno 11001] getaddrinfo failed

Python script:

import pymongo

client = pymongo.MongoClient('mongodb://mongodb-dev.my.server:27017/?serverSelectionTimeoutMS=5000&connectTimeoutMS=10000')

db = client.get_database('feeeper')
col = db.get_collection('my_collection')

cur = col.find({}, {'body': 1})
last_task = cur.sort([('created', pymongo.DESCENDING)]).limit(1)

for t in last_task:
    print(t)

UPD: Ping to the server works fine:

I can connect to the server with mongo shell:

Did you actually try to do anything in Studio 3T? Try a read operation to ensure the connection is complete. — Joe Drumgoole
– Joe Drumgoole, Commented Feb 7, 2022 at 10:11
My next step is 1. Ensure I can ping the server 2. Try and connect with the mongo shell. These two steps often resolve any problems. Can you login to the server and try connecting via local host? — Joe Drumgoole
– Joe Drumgoole, Commented Feb 7, 2022 at 13:10
It looks like the server is configured as a replicaset. Can you click the "To URL" button and post the results. — Belly Buster
– Belly Buster, Commented Feb 7, 2022 at 21:52
@JoeDrumgoole mongo shell works fine, studio 3t connects correctly, python script fails same as with dns name — feeeper
– feeeper, Commented Feb 9, 2022 at 13:24

davmos · Accepted Answer · 2024-05-31 13:06:45Z

6

The problem is with default arguments for the MongoClient constructor. It has a directConnection parameter with default value of False — connect to replica set:

directConnection (optional): if True, forces this client to connect directly to the specified MongoDB host as a standalone. If false, the client connects to the entire replica set of which the given MongoDB host(s) is a part. If this is True and a mongodb+srv:// URI or a URI containing multiple seeds is provided, an exception will be raised.

When I passed directConnection as True the query worked fine.

edited May 31, 2024 at 13:06

davmos

9,6074 gold badges45 silver badges46 bronze badges

answered Feb 14, 2022 at 11:19

feeeper

3,0474 gold badges32 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connect to MongoDB without password using pymongo

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related