Authentication error when connecting to specific mongodb database

Question

I am currently using nodejs with mongodb native driver. So my mongodb has been set with admin auth with root role, so I can log in using robomongo or command line just fine. So back to my project, I m able to connect to mongodb just fine if i set my connection string:

mongodb://admin:password@localhost:27017/

However, if I use this connection string:

mongodb://admin:password@localhost:27017/specificdb

It return as:

MongoError: Authentication failed

I am able to access the db using command and robomongo, is there anything I can do? I have added the admin user under the db, but still got the same problem.

You have to login and auth via CLI as admin to admin DB, then use specificdb and then: docs.mongodb.com/manual/reference/method/db.createUser — Damaged Organic
– Damaged Organic, Commented Jul 13, 2017 at 6:41

Khmiri Mohamed Khalil · Accepted Answer · 2022-09-08 08:36:15Z

7

this worked for me :

first solution on connection :

mongoose.connect('mongodb://....', {
// add this line 
authSource:"admin",
....
})

or second solution add to the uri "?authSource=admin" :

mongodb://user:password@host/yourDB?authSource=admin

** to note that I am using mongoose and this is the documentation specefic statement and the url :

authSource - The database to use when authenticating with user and pass. In MongoDB, users are scoped to a database. If you are getting an unexpected login failure, you may need to set this option.

https://mongoosejs.com/docs/connections.html#options

edited Sep 8, 2022 at 8:36

answered Sep 8, 2022 at 8:21

Khmiri Mohamed Khalil

1762 silver badges5 bronze badges

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

Comments

p.streef · Accepted Answer · 2017-07-13 06:43:02Z

2

The database you specify is the one you authenticate on. If the user is not known/has no roles for that database it cannot authenticate to it.

https://docs.mongodb.com/manual/reference/connection-string/

What you can do is either create the (or a new) user for that database or use an authentication database parameter.

answered Jul 13, 2017 at 6:43

p.streef

3,8255 gold badges31 silver badges50 bronze badges

Collectives™ on Stack Overflow

Authentication error when connecting to specific mongodb database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related