Mongoose.connect() fails when database is specified in connection string

Question

I'm running a local MongoDB server and am trying to connect to it from a node.js server using the Mongoose library.

I'm using SCRAM-SHA-1 as the authentication mechanism

I'm able to connect to it with the admin account when I don't specify a database to connect to, using a connection string such as:

mongodb://{username}:{password}@{address}:{port}?authMechanism=SCRAM-SHA-256

But when I try to specify which database to connect to, using a connection string such as:

mongodb://{username}:{password}@{address}:{port}/database123?authMechanism=SCRAM-SHA-256

the authentication fails.

For reference, my code looks like:

    const mongoose = require('mongoose');

    let conn_string = `mongodb://mongo_uname:[email protected]:3000/database123?authMechanism=SCRAM-SHA-256`

    mongoose
    .connect(database_uri, {
        useUnifiedTopology: true
    })
    .then(() => console.log('MongoDB database Connected...'))
    .catch((err) => console.log(err))

Is there a different way to specify which database to connect to with mongoose, or is there something I can do differently when constructing the connection string to make it work?

Cheers.

christian21 · Accepted Answer · 2022-11-29 19:49:32Z

3

Make sure that the database user you are using is configured to read and write to the database uou are trying to connect to.

answered Nov 29, 2022 at 19:49

christian21

816 bronze badges

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

Comments

NeNaD · Accepted Answer · 2022-09-22 09:45:44Z

1

If you are using Mongoose v6+, you should NOT specify useUnifiedTopology.

That is deprecated and if you include it, Mongoose will throw the error. Try to include the connection string only:

mongoose.connect(database_uri)

answered Sep 22, 2022 at 9:45

NeNaD

20.8k11 gold badges64 silver badges118 bronze badges

Comments

Niraj Gautam · Accepted Answer · 2022-09-22 03:35:27Z

0

import mongoose from "mongoose";

const mongoDB = "mongodb://localhost:27017/twlight";
mongoose.Promise = global.Promise;

mongoose.connect(mongoDB, { useNewUrlParser: true })
.then(() => {
  console.log("Database is connected");
},
(err) => {
console.log("There is problem while connecting database " + err);
});

Please try

Note: twilight is database name

answered Sep 22, 2022 at 3:35

Niraj Gautam

1777 bronze badges

Comments

lhoogenraad · Accepted Answer · 2022-09-22 21:14:01Z

0

My error ended up being in the configuration of the database user I was trying to connect with, they weren't even set up to read or write to the database I was attempting to connect to.

answered Sep 22, 2022 at 21:14

lhoogenraad

1381 silver badge14 bronze badges

Collectives™ on Stack Overflow

Mongoose.connect() fails when database is specified in connection string

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related