Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

JavaScript Install and Use Sequelize CLI

Posted by Mark Riddell
Mark Riddell
15,970 Points

Error when starting local server

I think my error lies in the dependencies, but i've tried installing different versions of bluebird and mysql and haven't found a solution yet. Here's the error.

[nodemon] starting `node ./bin/www`
Unhandled rejection SequelizeConnectionRefusedError: connect ECONNREFUSED 127.0.0.1:3306
    at /Users/markriddell/Desktop/Documents/using-sequelize-orm-with-express/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:123:19
    at tryCatcher (/Users/markriddell/Desktop/Documents/using-sequelize-orm-with-express/node_modules/bluebird/js/release/util.js:16:23)
    at Promise._settlePromiseFromHandler (/Users/markriddell/Desktop/Documents/using-sequelize-orm-with-express/node_modules/bluebird/js/release/promise.js:512:31)
    at Promise._settlePromise (/Users/markriddell/Desktop/Documents/using-sequelize-orm-with-express/node_modules/bluebird/js/release/promise.js:569:18)
    at Promise._settlePromise0 (/Users/markriddell/Desktop/Documents/using-sequelize-orm-with-express/node_modules/bluebird/js/release/promise.js:614:10)
    at Promise._settlePromises (/Users/markriddell/Desktop/Documents/using-sequelize-orm-with-express/node_modules/bluebird/js/release/promise.js:689:18)
    at Async._drainQueue (/Users/markriddell/Desktop/Documents/using-sequelize-orm-with-express/node_modules/bluebird/js/release/async.js:133:16)
    at Async._drainQueues (/Users/markriddell/Desktop/Documents/using-sequelize-orm-with-express/node_modules/bluebird/js/release/async.js:143:10)
    at Immediate.Async.drainQueues [as _onImmediate] (/Users/markriddell/Desktop/Documents/using-sequelize-orm-with-express/node_modules/bluebird/js/release/async.js:17:14)
    at processImmediate (internal/timers.js:461:21)

[nodemon] clean exit - waiting for changes before restart

1 Answer

Tyler McDonald
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Tyler McDonald
Full Stack JavaScript Techdegree Graduate 16,700 Points
Tyler McDonald
.a{fill-rule:evenodd;}techdegree seal-36
Tyler McDonald
Full Stack JavaScript Techdegree Graduate 16,700 Points

I ran across this error as well. I believe the issue stems from the "dialect" within config.json being set to "mysql" instead of "sqlite". Changing each of the dialects manually resolved the error for me.

Hope this helps other running into the issue.