MongoError: auth failed mongoose connection string

Question

I can connect to the DB through terminal, but getting this error using mongoose and gulp. mongoose/node_modules/mongodb/lib/mongodb/connection/base.js:246 MongoError: auth failed

My connection string is:

mongodb://usr:psw@localhost:27017/dbname

Any idea what it can be?

For those who come looking for a solution, https://stackoverflow.com/a/49957410/13062813 is your answer — Joshua Varghese, Feb 16 '21 at 10:40

score 34 · Answer 1 · edited Dec 06 '21 at 12:32

34

I installed MEAN from MEAN packaged by Bitnami for windows 7 using the following password: 123456

Syntax for connection string to connect to mongodb with mongoose module

mongoose.connect("mongodb://[usr]:[pwd]@localhost:[port]/[db]",{auth:{authdb:"admin"}});

If you don't have {auth:{authdb:"admin"}} in the connection string, you will get the following error: MongoError: Authentication failed.

JS Example: mongo-test/app.js

var mongoose = require('mongoose');
mongoose.connect('mongodb://root:123456@localhost/test',{auth:{authdb:"admin"}});
mongoose.set('debug', true); // turn on debug

edited Dec 06 '21 at 12:32

Abdullah Khawer

4,461
4
29
66

answered Sep 03 '16 at 17:03

Thien Nguyen

928
10
12

9

I added the `{auth:{authdb:"admin"}}` but still getting `"MongoError: auth failed"` – Shanika Ediriweera May 12 '19 at 20:30

score 28 · Answer 2 · answered Apr 21 '18 at 15:36

28

just add ?authSource=yourDB&w=1 to end of db url

 mongoose.connect('mongodb://user:password@host/yourDB?authSource=yourDB&w=1')

this work for me . &w=1 is important

answered Apr 21 '18 at 15:36

ali karimi

542
4
13

yes, this worked for me. Quite strange that from pymongo, it doesn't need the authSource parameter. – swateek Jul 17 '18 at 09:19
10

mongoose.connect('mongodb://admin:password@localhost/some_db?authSource=admin&w=1',{}) – Pankaj Kumar Jan 29 '19 at 14:45
2

what is the purpose of w=1? – Ryan Griggs Apr 27 '20 at 21:41
2

@RyanGriggs The w option requests acknowledgment that the write operation has propagated to a specified number of mongod instances or to mongod instances with specified tags. – David Sep 16 '20 at 16:53

score 16 · Answer 3 · edited Nov 20 '21 at 03:24

16

There is many ways to make it work. This is what worked for me [mongoose v5.9.15] :

mongoose.connect('mongodb://localhost:27017/', {
    auth: {
        user:'root',
        password:'example'
    },
    authSource:"admin",
    useUnifiedTopology: true,
    useNewUrlParser: true
})

edited Nov 20 '21 at 03:24

Ashwin

7,277
1
48
70

answered May 20 '20 at 11:06

akheron

321
3
5

2

Had this issue when switching from the mongo node driver to mongoose. Used the same connection string, but I kept on getting the auth error. I added authSource='admin' and problem was solved. – Andre Aug 21 '20 at 12:58
1

In my case, ("mongoose": "^6.0.2") "user" need to be changed as "username' – 鄭大大 Aug 29 '21 at 09:21

score 9 · Answer 4 · answered Nov 11 '15 at 01:25

9

You might want to do something like this...

var opt = {
    user: config.username,
    pass: config.password,
    auth: {
        authdb: 'admin'
    }
};
var connection = mongoose.createConnection(config.database.host, 'mydatabase', config.database.port, opt);

'authdb' option is the database you created the user under.

answered Nov 11 '15 at 01:25

Leon

5,701
3
38
38

`Error [MongooseError]: Mongoose 5.x no longer supports ``mongoose.connect(host, dbname, port)`` or ``mongoose.createConnection(host, dbname, port)``. See http://mongoosejs.com/docs/connections.html for supported connection syntax` (yes I realize 5 years have passed... info for visitors) – Chaim Eliyah Apr 04 '20 at 04:23

score 8 · Answer 5 · answered Sep 06 '18 at 09:45

8

mongoose.connect("mongodb://[host]/[db]", { auth:{

    authdb: "admin",
    user: [username],
    password: [pw]

}}).then(function(db){

    // do whatever you want

    mongoose.connection.close() // close db

})

answered Sep 06 '18 at 09:45

anniex

326
3
7

2

This should be the default way in the documentation. All other ways lead to error and confusion. Congratulations! – Stefan Sprenger Mar 08 '19 at 08:55

score 5 · Answer 6 · answered May 08 '15 at 03:42

5

Do you have a user set up for dbname? By default, no user is required to connect to the database unless you explicitly set one. If you haven't, you should just try to connect to mongodb://localhost:27017/dbname and see if you still get an error.

answered May 08 '15 at 03:42

Kamagatos

854
9
12

1

I have a user and a password, otherwise the data will be available to everybody. I tried also with the root user, but the problem exist. I am using mongoose, just interested if anybody else issued similar problem...and solved) – Sunkat May 08 '15 at 08:21
same issue here. i noticed it only has problem when i make a second or higher number db link, not to the first one i made.. – MartianMartian Jul 16 '15 at 11:19

score 1 · Answer 7 · edited May 23 '17 at 12:10

1

I have found the solution hier, looks like when you create an user from the mongo shell, it makes SCRAM-SHA-1 instead of MongoDB-CR. So the solution to create a new user with MongoDB-CR authentication.

MongoDB-CR Authentication failed

edited May 23 '17 at 12:10

Community

1
1

answered Jul 28 '15 at 21:17

user3531155

439
4
11

hey, thanks for the answer. I will try it. But we have switched to sqlite. – Sunkat Aug 03 '15 at 12:50

score 0 · Answer 8 · answered Apr 28 '18 at 19:19

0

just make sure that your database is created. and also if your user is not added in the admin database, then make sure to add it by putting db.createUser( ... {user:'admin',pwd:'admin',roles:['root']} ... )

answered Apr 28 '18 at 19:19

Apoorv Bankey

53
8

score 0 · Answer 9 · answered Aug 06 '19 at 02:33

0

This worked for me for mongod --version = db version v3.6.13

mongoose.connect('mongodb://localhost/expressapi', {
    auth: {
        authdb: "admin",
        user: "root",
        password: "root",

    }
});

answered Aug 06 '19 at 02:33

Arun

344
2
11

score 0 · Answer 10 · answered Mar 06 '20 at 10:55

0

mongo mongodb://usr:psw@localhost:27017/dbname

Password should be alphanumeric only
User should be also available in db 'dbname' (Note : Even if user is super admin)

With above changes it connected successfully.

answered Mar 06 '20 at 10:55

Sandeep PC

797
8
12

score 0 · Answer 11 · answered Sep 10 '20 at 20:39

mongoose.connect("mongodb://[usr]:[pwd]@localhost:[port]/[db]",{ authSource: 'admin', useNewUrlParser: true, useUnifiedTopology: true });

I was getting same error. Resolved by adding authSource option to connect function solved the issue. see above code.

score -1 · Answer 12 · answered Nov 23 '21 at 06:26

-1

The connection string will be like

mongodb://username:password@localhost:27017/yourdbname?authSource=admin

answered Nov 23 '21 at 06:26

MD SHAYON

7,001
45
38

MongoError: auth failed mongoose connection string

12 Answers12

Linked

Related