CODEWITHSUNDEEP
node.jsconnection-refused
struggleale
struggleale

Reputation: 121

Unhandled rejection SequelizeConnectionRefusedError

I run my server.js file and I have this error:

Unhandled rejection SequelizeConnectionRefusedError: connect ECONNREFUSED 127.0.0.1:4305
at Handshake._callback >   (c:\Users\alexa\WebstormProjects\ToDoSPA\node_modules\sequelize\lib\dialects\mysql\connection-manager.js:76:20)
at Handshake.Sequence.end (c:\Users\alexa\WebstormProjects\ToDoSPA\node_modules\mysql\lib\protocol\sequences\Sequence.js:96:24)
at Protocol.handleNetworkError (c:\Users\alexa\WebstormProjects\ToDoSPA\node_modules\mysql\lib\protocol\Protocol.js:364:14)
at Connection._handleNetworkError (c:\Users\alexa\WebstormProjects\ToDoSPA\node_modules\mysql\lib\Connection.js:384:18)
at emitOne (events.js:77:13)
at Socket.emit (events.js:169:7)
at emitErrorNT (net.js:1253:8)
at doNTCallback2 (node.js:452:9)
at process._tickCallback (node.js:366:17)

I don't understand why I'm getting the above mentioned error.

Upvotes: 12

Views: 29008

Answers (4)

Rif'an Amrozi
Rif'an Amrozi

Reputation: 1

Check your DataBase connection, if you are using localhost, Don't forget to turn on the localhost connection. In my case, after open connection in Postgresql by typing

sudo service postgresql start

it works fine.

Upvotes: 0

Debotos Das
Debotos Das

Reputation: 569

On macOS, I had the same problem. The reason is Postgres service is not properly started. Make sure via running the command- brew services list Status of Postgres one will be yellow(not properly started) and others are green(means properly started)

The solution is for macOS(Run below 3 command one by one in your terminal),

rm -f /usr/local/var/postgres/postmaster.pid
brew services restart postgresql
brew services list

Now you can see hopefully the status of postgresql is green too. Now it will work.

Upvotes: 4

Rama Astadipati
Rama Astadipati

Reputation: 82

Start your database server. It's coming because your database server is not running yet, that's why it refused the connection from app to database.

Upvotes: 5

trquoccuong
trquoccuong

Reputation: 2873

You didn't start your database or wrong database config check db config: var sequelize = new Sequelize(<your config>) or start Database

Upvotes: 7

Related Questions