MongoDB - authentication failed

Asked Feb 02 '21 at 19:39

Active Feb 02 '21 at 19:39

Viewed 210 times

I'm using Pymongo to connect to the a read only instance of my MongoDB replica set.

The problem with my code is that sometimes the query goes through, while sometimes, apparently for no reason and with the same code, i get an Authentication failed error:

pymongo.errors.OperationFailure: Authentication failed., full error: {'ok': 0.0, 'errmsg': 'Authentication failed.', 'code': 18, 'codeName': 'AuthenticationFailed', ....}

I don't understand why is this happening, since i'm performing very basic operations and my connection string should be alright.

import pymongo
from pymongo import MongoClient

client = MongoClient('mongodb://root:MY-PASSWORD@MY-IP:27017/?authSource=MY-DB&replicaSet=replicaSetOne')
db = client.marketdata

cursor =  db['MYCOL'].find({'unix': {'$gte': 1611874500}})

for document in cursor:
    print(document)

Any kind of advice is appreciated.

asked Feb 02 '21 at 19:39

JayK23

Hi, did it work before? – Haniel Baez Feb 02 '21 at 20:03
Review the server log for the reason. – D. SM Feb 02 '21 at 20:08
Check and compare your mongod.conf in all replicaSet instances , you may have some typo when defining the authentication method ... – R2D2 Feb 02 '21 at 20:10
Is `MY-DB` really the database where the user was created? See https://stackoverflow.com/questions/63754742/authentication-failure-while-trying-to-save-to-mongodb/63755470#63755470 – Wernfried Domscheit Feb 02 '21 at 20:25
Yes! The query sometimes works and sometimes gives the error, it appears randomly – JayK23 Feb 02 '21 at 20:53
@JayK23 Are you trying to read from a secondary node of the replica-set? – prasad_ Feb 03 '21 at 03:21

MongoDB - authentication failed

0 Answers0