connect ECONNREFUSED 127.0.0.1:27017'

Question

I have that code:

var express = require('express'),
    stylus = require('stylus'),
    logger = require('morgan'),
    bodyParser = require('body-parser'),
    mongoose = require('mongoose');

var env = process.env.NODE_ENV = process.env.NODE_ENV || 'development';

var app = express();

function compile(str, path){
    return stylus(str).set('filename', path);
}

app.set('views', __dirname + '/server/views');
app.set('view engine', 'jade');
app.use(logger('dev'));
app.use(bodyParser.urlencoded({ extended: true }));
app.use(stylus.middleware(
        {
            src: __dirname + '/public',
            compile: compile
        }
    ));
app.use(express.static(__dirname + '/public'));

mongoose.connect('mongodb://localhost/multivision');
var db = mongoose.connection;
db.on('error', console.error.bind(console, 'connection error..'));
db.once('open', function callback(){
    console.log('multivision db opened');
});

app.get('/partials/:partialPath', function(req, res){
    res.render('partials/' + req.params.partialPath);
});

app.get('*', function(req, res) {
  res.render('index');
});

var port = 3131;
app.listen(port);
console.log('Listening on port ' + port + '...');

but when I'm trying nodemon server.js it throws an error:

connection error.. { [MongoError: connect ECONNREFUSED 127.0.0.1:27017] name: 'MongoError' message: 'connect ECONNREFUSED 127.0.0.1:27017' }

how can I improve that? I've already installed mongoose using npm install mongoose --save in my directory

Yeah there are dozens question like this but none of these helped me.. I'm new at nodejs and probably missing something

Does mongodb run on the same host? The 27017 port is the default mongodb port and it seems that no mongodb is available there. — TeTeT, Apr 04 '16 at 10:33
I'm going through this tutorial https://www.pluralsight.com/courses/building-angularjs-nodejs-apps-mean and he haven't done anything to run mongodb. only installed it and then `nodemon server.js` — gsiradze, Apr 04 '16 at 10:37
http://stackoverflow.com/questions/35515174/error-in-running-a-node-js-file — SiddAjmera, Apr 04 '16 at 10:38
hmmm only mongod. And I was trying nodemon mongod etc. it took about 30-45 min. thanks a lot mates — gsiradze, Apr 04 '16 at 10:39

score 11 · Answer 1 · answered Nov 22 '17 at 11:20

I was also facing the same issue, when I was executing node server on my project directory. For me the MongoDB service was not started, that makes this issue.

So I had to run services.msc and activated the service.

After that I was able to run my command.

D:\SVenu\MyApp>node server
Saving User
App is listening on port: 3000
Already Exist
Already Exist
Already Exist
Already Exist
Done save

score 11 · Answer 2 · edited Dec 17 '20 at 12:26

11

run services.msc and activate the Mongodb service.

Now Mongodb will connect

the status of the Mongodb indicated as Running

edited Dec 17 '20 at 12:26

Tomer Shetah

8,413
7
27
35

answered Aug 21 '19 at 10:30

Satheesh kumar

111
1
3

score 5 · Answer 3 · answered Feb 27 '18 at 18:21

5

I was having the same problem, and found that it was a mongod issue.(I am running Ubuntu 16.04). Looking through the errors there was a directory missing. After adding the directory, I needed to change permissions, and finally, set the mongod service to start at boot.

$ sudo mkdir -p /data/db
$ sudo chown -R $USER /data/db
$ sudo systemctl enable mongod.service

answered Feb 27 '18 at 18:21

froglegs

133
2
8

I was having this problem inside a custom Docker container, after adding `chown -R $USER /data/db` it worked! Thanks! – Lucas Abbade May 08 '19 at 03:41

score 4 · Answer 4 · answered Nov 22 '17 at 11:27

4

Your mongodb service is probably down. Run sudo service mongod start to start the daemon process

answered Nov 22 '17 at 11:27

Alberto Centelles

1,215
11
24

score 2 · Answer 5 · answered Aug 23 '20 at 09:20

2

I know this issue is old, but i came across a similar issue and the above solutions did not work for me, I'm using Ubuntu 20.04 LTS.

What i did to make it work was just running mongo service using this command:

$ mongod

Then everything worked fine

answered Aug 23 '20 at 09:20

Fayez Nazzal

319
2
10

score 2 · Answer 6 · answered Jan 03 '21 at 14:21

2

If you're in windows and you had this issue, just go the installer exe app for the mongodb and click "Repair" this works for me

answered Jan 03 '21 at 14:21

Osta

33
6

score 1 · Answer 7 · answered Aug 18 '16 at 02:34

try this:

mongod.exe --dbpath c:\data\db

c:\data\db is the place where you put your db.

and when you see something like this :

2016-08-18T10:22:31.020+0800 I CONTROL  [main] Hotfix KB2731284 or later update is not installed, will zero-out data files
2016-08-18T10:22:31.022+0800 I CONTROL  [initandlisten] MongoDB starting : pid=4356 port=27017 dbpath=c:\data\db 64-bit host=sevencai-PC0
2016-08-18T10:22:31.022+0800 I CONTROL  [initandlisten] targetMinOS: Windows 7/Windows Server 2008 R2
2016-08-18T10:22:31.023+0800 I CONTROL  [initandlisten] db version v3.2.8
2016-08-18T10:22:31.023+0800 I CONTROL  [initandlisten] git version: ed70e33130c977bda0024c125b56d159573dbaf0

......

and then node yourserver.js

maybe everything will be fine!

score 1 · Answer 8 · edited Dec 17 '20 at 12:28

1

Follow as below:

=> run services.msc and start mondodb server

and save the file in node project, you can see the server connected!!

edited Dec 17 '20 at 12:28

Tomer Shetah

8,413
7
27
35

answered Dec 17 '20 at 11:49

Alok Srivastav

51
1

Please don't post "have same issue" as an answer. Please read the [tour](https://stackoverflow.com/tour), and [How do I write a good answer?](https://stackoverflow.com/help/how-to-answer) – Tomer Shetah Dec 17 '20 at 12:29

score 0 · Answer 9 · answered Mar 17 '21 at 16:46

0

In Most of the case you will get the error bcz the service MongoDB Database Server (MongoDB) Might be stopped.

Just start the service to be connected with DB

answered Mar 17 '21 at 16:46

Debendra Dash

5,334
46
38

score 0 · Answer 10 · edited Jan 10 '22 at 02:48

it's doesn't work as localhost but IP address works 127.0.0.1 and solves this problem:

  // .connect("mongodb://localhost:27017/lofydb")

    const mongoose = require("mongoose");

    mongoose.connect("mongodb://127.0.0.1:27017/lofydb")
      // .connect("mongodb://127.0.0.1:27017")
    
      .then(() => {
        console.log("Connected to Database");
      })
      .catch((err) => {
        console.log("Not Connected to Database ERROR! ", err);
      });

score 0 · Answer 11 · edited Jan 14 '22 at 08:49

0

please check the MongoDB service is active and running. Refer the running services
If it is running and available on MongoDB compass or on MongoDB shell and if you are working with node version >17.0.0 or so it will give error. So plz change to the stable version of node.

edited Jan 14 '22 at 08:49

Saravanan G

581
1
9
26

answered Jan 09 '22 at 09:18

Somesh Joshi

1
1

score 0 · Answer 12 · answered May 31 '22 at 07:30

Make sure MongdoDB is running

To run MongoDB as a macOS service, run:

brew services start mongodb-community@5.0

And when you see:

==> Successfully started mongodb-community (label: homebrew.mxcl.mongodb-commu

OR type on command line, to check the mongo service.

mongod

After run service, You can easily connect with mongdoDB localhost or remote connection.

Ahnaf Khan · Answer 13 · 2022-09-17T21:03:48.423

I had the same issue and it had to do with the fact that my MongoDB service wasn't running locally. Make sure you followed all the correct installation steps for whatever OS you are trying to run MongoDB service here: https://www.mongodb.com/docs/manual/administration/install-community/

Then follow the respective guide for the running the service under "Run MongoDB Community Edition". So for example, for macOS you would do

brew services start mongodb-community@6.0

if you wanted to run as a macOS service, or

mongod --config /opt/homebrew/etc/mongod.conf --fork

if you wanted to run manually as a background service on Apple M1 processor. The same page I shared above also has commands you can run for verifying if your MongoDB process is running.

score 0 · Answer 14 · answered Dec 27 '22 at 20:50

0

Step 1: open conf file to edit.

sudo vim /etc/mongod.conf

Step 2: find port and change it.

net: port: 27017 -> default port before any change

After changing port, my issue solved :

answered Dec 27 '22 at 20:50

Bilal Ahmad Khan

1

connect ECONNREFUSED 127.0.0.1:27017'

14 Answers14

Make sure MongdoDB is running

Linked