how to authenticate mongoose connection mongodb in node.js

Question

I have created mongodb user with command

use admin
db.createUser(
    {
      user: "superuser",
      pwd: "12345678",
      roles: [ "root" ]
    }
)

then in my app I am trying to connect mongoose like this

var options = {
user: "superuser",
pass: "12345678"
};


var mongooseConnectionString = 'mongodb://localhost/twitter-mongo';

mongoose.connect(mongooseConnectionString,options);
mongoose.model('User', UserSchema);

var User = mongoose.model('User');

I am getting this error when inserting data through mongoose

MongoError: not authorized for insert on twitter-mongo.users

please tell me what is wrong in my code

Joe Coyle · Accepted Answer · 2020-07-24 01:19:36Z

37

You must declare the authSource parameter in your connection string in order to specify the name of the database that contains your user's credentials:

var options = {
  user: "superuser",
  pass: "12345678"
};

var mongooseConnectionString = 'mongodb://localhost/twitter-mongo?authSource=admin';

Note: for users of Mongoose 4.x, you may want to also include useMongoClient: true in your options object. This silences the Please authenticate using MongoClient.connect with auth credentials and open() is deprecated error messages.

edited Jul 24, 2020 at 1:19

answered Apr 3, 2018 at 13:56

Joe Coyle

6217 silver badges16 bronze badges

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

2 Comments

MEDZ Over a year ago

Thank you. I've been suffering for hours for this :)

MeVimalkumar Over a year ago

The useMongoClient option is no longer necessary in mongoose 5.x, please remove it.

scuencag · Accepted Answer · 2014-11-02 11:16:05Z

10

This is working fine:

var options = { server: { socketOptions: { keepAlive: 1 } } };
var connectionString = 'mongodb://admin:admin1234@localhost:27017/myDB';

 mongoose.connect(connectionString, options);

//Add those events to get more info about mongoose connection:

// Connected handler
mongoose.connection.on('connected', function (err) {
  console.log("Connected to DB using chain: " + connectionString);
});

// Error handler
mongoose.connection.on('error', function (err) {
  console.log(err);
});

// Reconnect when closed
mongoose.connection.on('disconnected', function () {
   self.connectToDatabase();
});

answered Nov 2, 2014 at 11:16

scuencag

6644 silver badges11 bronze badges

1 Comment

geeky_monster Over a year ago

This seems to be deprecated.

sajan · Accepted Answer · 2019-03-02 19:05:31Z

4

try this

const mongooseConnectionString = 'mongodb://superuser:12345678@ localhost/twitter-mongo?authSource=admin'

answered Mar 2, 2019 at 19:05

sajan

1,3801 gold badge14 silver badges20 bronze badges

Comments

adnan ahmady · Accepted Answer · 2019-10-16 06:48:46Z

I did run a mongo service using docker and then connected my mongoose to it with this code

const _database = 'mongodb://user:pass@localhost:port/MyDB?authSource=admin';
mongoose.connect(_database, {
    useNewUrlParser: true
})
.then(() => console.log('Connected to MongoDB ...'))
.catch(err => console.error('Could not connect to MongoDB:‌', err));

this is equal to

mongo --username user --password pass --authenticationDatabase admin --port 27017

on connection and then use MyDB database for doing operations like find, aggregate, insert and etc on it.

if you have no user (MongoDB default user) for your database then you can change Database like bellow:

const _database = 'mongodb://localhost:port/MyDB';

27017 is default MongoDB port if your MongoDB port hasn't changed either then you can do the same for port too. like bellow:

const _database = 'mongodb://localhost/MyDB';

this is the same as bellow:

mongo

above code is because there is no user and no port then for not been a user there is no need for authentication database either.

Mario Callejas · Accepted Answer · 2020-02-18 21:48:07Z

1

mongoose.createConnection('mongodb://username:[email protected]:27017/dashboards?authSource=admin', {
   useNewUrlParser: true
}, (e) => {

    if (e) throw console.error('Error connecting to mongo database master');
    console.log('Connected to mongo database master.');

});

answered Feb 18, 2020 at 21:48

Mario Callejas

1011 silver badge2 bronze badges

1 Comment

Piotr Labunski Over a year ago

While this code may answer the question, providing additional context regarding how and/or why it solves the problem would improve the answer's long-term value.

Alagarasan M · Accepted Answer · 2019-03-28 09:27:45Z

0

You need to create an User in database which you are operating on, not the admin DB.

Use this command,

use twitter-mongo;
db.createUser({
  user: "superuser",
  pwd: "12345678",
  roles: [ "root" ]
});

Instead of this,

use twitter-mongo
db.createUser({
  user: "superuser",
  pwd: "12345678",
  roles: [ "root" ]
});

answered Mar 28, 2019 at 9:27

Alagarasan M

9078 silver badges16 bronze badges

Comments

Ari · Accepted Answer · 2021-01-22 20:15:46Z

0

Correct way to create the connection string is var connection = mongoose.createConnection("mongodb://username:pwd@hostip:port/dbname?authSource=admin", options);

Please use authSource=admin to authenticate in connection string.

answered Jan 22, 2021 at 20:15

Ari

3412 silver badges14 bronze badges

Collectives™ on Stack Overflow

how to authenticate mongoose connection mongodb in node.js

7 Answers 7

2 Comments

1 Comment

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

2 Comments

1 Comment

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related