CODEWITHSUNDEEP
node.jsexpress
user2825729
user2825729

Reputation:

ECONNREFUSED error while running express code

I am not able to run the server ...... I am getting the error as ECONNREFUSED

How to resolve this Error !

When i tried to use different ports .... all are giving me the same error !

ubuntu@ip-MyIP:~/rainmelon/projects/FindMyBuffet$ node app.js
Express server listening on port 7005

Error: connect ECONNREFUSED
    at errnoException (net.js:884:11)
    at Object.afterConnect [as oncomplete] (net.js:875:19)
    --------------------
    at Handshake.Sequence (/home/ubuntu/rainmelon/projects/FindMyBuffet/node_modules/mysql/lib/protocol/sequences/Sequence.js:15:20)
    at new Handshake (/home/ubuntu/rainmelon/projects/FindMyBuffet/node_modules/mysql/lib/protocol/sequences/Handshake.js:9:12)
    at Protocol.handshake (/home/ubuntu/rainmelon/projects/FindMyBuffet/node_modules/mysql/lib/protocol/Protocol.js:42:50)
    at Connection.connect (/home/ubuntu/rainmelon/projects/FindMyBuffet/node_modules/mysql/lib/Connection.js:73:18)
    at Object.<anonymous> (/home/ubuntu/rainmelon/projects/FindMyBuffet/app.js:15:12)
    at Module._compile (module.js:456:26)
    at Object.Module._extensions..js (module.js:474:10)
    at Module.load (module.js:356:32)
    at Function.Module._load (module.js:312:12)
    at Function.Module.runMain (module.js:497:10)

Upvotes: 2

Views: 11005

Answers (3)

dazzledax
dazzledax

Reputation: 1

Your mysql process is down, which means it is not running. You need to restart your mysql process (changing ports wont help). To solve this problem you need to restart it. You can do by doing any of the following:

  1. You can start your wamp or xamp server which will automatically start the process.
  2. Or you can open the commandline prompt and start it manually like so "c:\wamp\bin\mysql\mysql5.5.24\bin\mysqld.exe"

Note that using the second method will require knowing the exact location of your wamp folder like I have used mine up top.(in quotes)

Upvotes: 0

robertklep
robertklep

Reputation: 203231

The traceback says where the exception is coming from:

Error: connect ECONNREFUSED
    at errnoException (net.js:884:11)
    at Object.afterConnect [as oncomplete] (net.js:875:19)
    --------------------
    ...
    at Connection.connect (.../node_modules/mysql/lib/Connection.js:73:18)
-->                                         ^^^^^
    at Object.<anonymous> (/home/ubuntu/rainmelon/projects/FindMyBuffet/app.js:15:12)
-->                                                                     ^^^^^^^^^

So your app can't connect to MySQL.

This is usually down to either incorrect hostname/portname in your MySQL driver configuration, the MySQL server not running, or that your MySQL server isn't configured to listen on TCP sockets. See here.

Upvotes: 6

Mithun Satheesh
Mithun Satheesh

Reputation: 27835

You may do a netstat to find out the pid of process running on the port 7005 and then go for a forceful kill with the pid got.

like

 netstat -plten |grep 7005
 kill -9 16085

where 16085 is the pid obtained from prev command. And restart the express app.

reference

How to kill a process running on particular port in Linux?

Upvotes: -1

Related Questions