MongoError: connect ECONNREFUSED 127.0.0.1:27017

Question

I'm using NodeJS wih MongoDB using mongodb package. When I run mongod command it works fine and gives "waiting for connection on port 27017". So, mongod seems to be working. But MongoClient does not work and gives error when I run node index.js command-

MongoError: failed to connect to server [localhost:27017] on first connect [MongoError: connect ECONNREFUSED 127.0.0.1:27017]

I have install mongo db 3.4 and my code is-

var MongoClient = require('mongodb').MongoClient;
var dburl       =   "mongodb://localhost:27017/test";
MongoClient.connect(dburl, function(err, db) {
  if (err) {
    throw err;
  }
  console.log('db connected');
  db.close();
});

I have created data/db directories on root and given write permissions. mongod.conf file takes db path as-

storage: dbPath: /var/lib/mongo

But it seems that it is actually taking db path as data/db and not var/lib/mongo

It working earlier but suddenly stopped.

Answer 1

My apps stopped working after upgrading from Node.js 14 to 17.

The error I got was:

MongoServerSelectionError: connect ECONNREFUSED ::1:27017

The solution was simply replacing localhost by 0.0.0.0. I.e. in my source code I had to change:

const uri = "mongodb://localhost:27017/";
const client = new MongoClient(uri);

to:

const uri = "mongodb://0.0.0.0:27017/";
const client = new MongoClient(uri);

Answer 2

This happened probably because the MongoDB service isn't started. Follow the below steps to start it:

1. Press the Windows + R keys on your keyboard to open the Run window. Type services.msc and hit Enter on your keyboard or click/tap the OK button. A new window opens up.
2. Search MongoDB.exe. Right click on it and select Start.

The server will start. Now execute npm start again and the code might work this time.

Answer 3

I've forgot to start MongoDB at all. Go to separate tab in terminal and type:

sudo service mongod start

Answer 4

Search services.msc in your device and click start to run the mongoDB server

After started running MongoDB server you will able to run your program

Answer 5

Instead of this:

const url = "mongodb://localhost:27017";

Use this:

const url = "mongodb://0.0.0.0:27017";

Answer 6

For windows - just go to Mongodb folder (ex : C:\ProgramFiles\MongoDB\Server\3.4\bin) and open cmd in the folder and type "mongod.exe --dbpath c:\data\db"

if c:\data\db folder doesn't exist then create it by yourself and run above command again.

All should work fine by now.))

Answer 7

Method 1

If It’s MAC OS, run following command and try again:

brew services restart mongodb-community

Stopping mongodb-community... (might take a while) ==> Successfully stopped mongodb-community (label: homebrew.mxcl.mongodb-community) ==> Successfully started mongodb-community (label: homebrew.mxcl.mongodb-community)

Answer 8

For Windows users.

This happens because the MondgDB server is stopped. to fix this you can,

1. 1 search for Services ,for that search using the left bottom corner search option.

   2 then there is a gear icon named with 'Services'.

   3 after clicking that you will get a window with lot of services

   4 scroll down and you will find 'MongoDB server (MongoDB)'.

   5 so you will see that there is an option to start the service.

   6 start it.

2. 1 then open your command prompt.

   2 type mongod

now you can connect to your server.

this steps also working fine if your sql server service down. (find sql server services)

Answer 9

For Ubuntu users run sudo systemctl restart mongod

Answer 10

I had below error:

Error: connect ECONNREFUSED 127.0.0.1:27017

In my case, this issue occurred since MongoDB is not installed at all.

The solution was to install MongoDB from below location:
https://www.mongodb.com/download-center/community

After installing the ECONNREFUSED error did not appear again.

Hope that helps.

Answer 11

I just found a solution in the internet , If you are using latest nodejs (v17.x) , then try updating mongodb url from localhost to 127.0.0.1

ref: https://www.mongodb.com/community/forums/t/mongooseserverselectionerror-connect-econnrefused-127-0-0-1-27017/123421/3

Answer 12

If you already installed "MongoDB", if you accidentally exit from the MongoDB server, then "restart your system".

This method solved for me...

[On Windows only]

And also another method is there:

press:

Windows + R

type:

services.msc

and click "ok", it opens "services" window, and then search for "MongoDB Server" in the list. After you find "MongoDB Server", right-click and choose "start" from the pop-up menu.

The MongoDb Server will start running.

Hope it works!!

Answer 13

Try to start mongoDB server by giving the --dbpath with mongod.

sudo mongod --dbpath /var/lib/mongo/data/db &

'&' in the last will start the mongodb server as service on your server.

Hope it Works.

Answer 14

You can run Cmd as administrator and write this command to start Mongodb service:

 net start MongoDB

OR

1. Click window key + r key
2. Type services.msc and press ok
3. Wait open service
4. Search mongodb
5. Click right key and start press

and reopen mongodb

Answer 15

Press CTRL+ALT+DELETE/task manager , then go to services , find MongoDB , right click on it. start. go back to terminal . npm start it will work.

Answer 16

On a mac I had to run brew services start [email protected]

Check: Install MongoDB Community Edition on macOS

Answer 17

I had the same error because i had not installed mongoDB. Make sure that you have mongodb installed and if not, you can download it from here https://www.mongodb.com/download-center/community

Answer 18

For Windows users: Mongo version 4.4 Use following commands: NET STOP MONGODB – To stop MongoDB as a service,if this returns "mongoDb service is not running then use below command to start service" NET START MONGODB – To start MongoDB as a service.

This worked for me.

Answer 19

just start the mongo server from terminal

Ubuntu -

     sudo systemctl start mongod

Answer 20

UPDATED ANSWER FOR THIS QUESTION !!

So I tried everything in this forum. but no result!(From my side). so i tried this one:

1)go to control panel

2)Select System and Security and choose last option :Administrative tools.

3)Select Services

4)Search for MongoDB Server (MongoDB)

5)Right click on it and click on run.

6)and close the Services blindly

7)last but not least,change your mongodb url to mongodb://0.0.0.0:27017/

8)Restart your server and that worked for me!.

9)So i tried this by combining 2 answers in this forum !🤣🤣

Answer 21

I faced the same error then I found that If you are using the latest nodejs (v17.x), then try updating the MongoDB URL from localhost to 127.0.0.1 This worked for me.

Answer 22

If you use MongoDb Compass make sure that you have installed MongoDB Community Server.

Answer 23

I was facing the same issue on windows 10. I just uninstall MongoDB and installed it again and it started working. It solved my problem.

Answer 24

Check where your .sock file is located. For my case, it was in /tmp folder.

Then run the following commands.

chown mongodb:mongodb /tmp/mongodb-27017.sock

sudo systemctl start mongod

mongosh

This worked for me.

For more reference

Answer 25

I was getting same error. I was doing everything right like path variables and stating mongodb before running code. Replacing localhost with IP i.e 127.0.0.1 in connection code solved for me.

mongoose.connect('mongodb://127.0.0.1/test', {useNewUrlParser: true, useUnifiedTopology: true});

Answer 26

From MongoDB Forums

MongooseServerSelectionError: connect ECONNREFUSED 127.0.0.1:27017 Answer

Just change the "URI" from

mongodb://localhost:27017

to

mongodb://127.0.0.1:27017

Answer 27

I debugged this same error on my own for over 5 hours. Eventually it worked out for me. Below is a check list of items to make sure they are correct before using Mongoose.

• MongoDB is installed on your system
• MongoDB is running as a service before you use npm run start
• The mongoose code does not have any syntax errors
• Use promises .then() in the connect function for mongoose
• If you are using localhost in URL, try switching it with 0.0.0.0 or vice versa

Once you have done all this, run the command node run start and hopefully this should work now. To verify, go to mongoDB and see the newly created database.

Below is a sample code for MongoDB and Mongoose that worked for me.

const mongoose = require('mongoose');

const myFunc = () => {
    const userSchema = mongoose.Schema({
        name: String
    });

    const User = mongoose.model("User", userSchema);

    const userObject = new User({
        name: 'Abhishek'
    });

    userObject.save((err, data) => {
        if (err)
            console.log('Error in saving = ' + err);
        if (data)
            console.log('Saved to DB = ' + data)
    }
    );
};

mongoose
    .connect("mongodb://0.0.0.0/userdb")
    .then(myFunc(), err => console.log(`Error = ${err}`));

Answer 28

most probably your mongo db service is not started. For ubuntu : sudo service mongod start For windows : go to services and start the MongoDB service

also install link for mondoDB service https://www.mongodb.com/download-center/community

I had this problem and i solved it thanks to this man's answer https://stackoverflow.com/a/47433551/7917608

Answer 29

Please ensure that your mongo DB is set Automatic and running at Control Panel/Administrative Tools/Services like below. That way you wont have to start mongod.exe manually each time.

Answer 30

I was having the same problem today.. and has been searching for answers.. I am on Ubuntu... however, I could not find the correct one that works on this thread.. after much research the following worked for me finally!! :)

First, after running

mongod dbpath

if appeared that mongodb was looking for the data/db directory.. which was missing in my installed mongodb app.. so I ran the following commands:

$ sudo mkdir -p /data/db

then run,

$ sudo chown -R $USER /data/db

chown - changes ownership of files/dirs. Ie. owner of the file/dir changes to the specified one, but it doesn't modify permissions. As detailed here: https://unix.stackexchange.com/questions/402062/how-are-chown-and-chmod-command-different-in-the-given-operation

Finally, run

`$ sudo systemctl enable mongod.service

It will give a message: Created symlink /etc/systemd/system/multi-user.target.wants/mongod.service → /lib/systemd/system/mongod.service and started the service.