Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ECONNREFUSED 127.0.0.1:3306 #8246

Closed
ifvictr opened this issue Apr 2, 2017 · 5 comments

Comments

@ifvictr
Copy link

commented Apr 2, 2017

Issue Summary

Ghost throws an ECONNREFUSED on npm start --production.

Steps to Reproduce

  1. Install Ghost 0.11.7 (not sure if this issue occurs elsewhere.
  2. Run npm install --production.
  3. Run npm start --production.

Any other info e.g. Why do you consider this to be a bug? What did you expect to happen instead?
It should start Ghost without any problems. Instead, I get this jumble:

> ghost@0.11.7 start /var/www/ghost
> node index.js

WARNING: Ghost is attempting to use a direct method to send email. 
It is recommended that you explicitly configure an email service.
Help and documentation can be found at http://support.ghost.org/mail.


ERROR: connect ECONNREFUSED 127.0.0.1:3306 
 
 Error: connect ECONNREFUSED 127.0.0.1:3306
    at Object.exports._errnoException (util.js:870:11)
    at exports._exceptionWithHostPort (util.js:893:20)
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1063:14)
    --------------------
    at Protocol._enqueue (/var/www/ghost/node_modules/mysql/lib/protocol/Protocol.js:110:48)
    at Protocol.handshake (/var/www/ghost/node_modules/mysql/lib/protocol/Protocol.js:42:41)
    at Connection.connect (/var/www/ghost/node_modules/mysql/lib/Connection.js:98:18)
    at /var/www/ghost/node_modules/knex/lib/dialects/mysql/index.js:106:18
    at Promise._execute (/var/www/ghost/node_modules/bluebird/js/release/debuggability.js:300:9)
    at Promise._resolveFromExecutor (/var/www/ghost/node_modules/bluebird/js/release/promise.js:481:18)
    at new Promise (/var/www/ghost/node_modules/bluebird/js/release/promise.js:77:14)
    at Client_MySQL.acquireRawConnection (/var/www/ghost/node_modules/knex/lib/dialects/mysql/index.js:104:12)
    at Object.create (/var/www/ghost/node_modules/knex/lib/client.js:231:16)
    at Pool._createResource (/var/www/ghost/node_modules/generic-pool/lib/generic-pool.js:325:17)
    at Pool._ensureMinimum (/var/www/ghost/node_modules/generic-pool/lib/generic-pool.js:363:12)
    at new Pool (/var/www/ghost/node_modules/generic-pool/lib/generic-pool.js:156:8)
    at Client_MySQL.initializePool (/var/www/ghost/node_modules/knex/lib/client.js:261:17)
    at Client_MySQL.Client (/var/www/ghost/node_modules/knex/lib/client.js:108:12)
    at new Client_MySQL (/var/www/ghost/node_modules/knex/lib/dialects/mysql/index.js:62:20)
    at Knex (/var/www/ghost/node_modules/knex/lib/index.js:60:34)
    at Object.<anonymous> (/var/www/ghost/core/server/data/db/connection.js:55:20)
    at Module._compile (module.js:410:26)
    at Object.Module._extensions..js (module.js:417:10)
    at Module.load (module.js:344:32)
    at Function.Module._load (module.js:301:12)
    at Module.require (module.js:354:17)
    at require (internal/module.js:12:17) 

Technical details:

  • Ghost Version: 0.11.7
  • Node Version: 4.2.6
  • Browser/OS: Google Chrome Version 57.0.2987.133 (64-bit), Ubuntu 16.04 (64-bit)
  • Database: mysql 5.7.17-0ubuntu0.16.04.1
@kevinansfield

This comment has been minimized.

Copy link
Contributor

commented Apr 2, 2017

Hey @ifvictr, sorry to hear you're having issues. The error you've supplied is saying your MySQL server isn't running or is not listening on 127.0.0.1 - it might be configured to use a socket rather than TCP in which case you'll need to update the mysql details in your config.json file.

This doesn't sound like a bug but rather an install issue, the best place to get support for install issues is in the #help channel on our Slack community - the real-time nature is much more conducive to walking through installation problems 😄

I'm going to close this issue as there's no bug as far as I can tell, we can re-open if there's an actual bug found rather than a configuration problem.

@ifvictr

This comment has been minimized.

Copy link
Author

commented Apr 2, 2017

@kevinansfield Actually, the problem has been resolved. Just had to add socketPath with the value /var/run/mysqld/mysqld.sock to the database configurations.

@valterh4ck3r

This comment has been minimized.

Copy link

commented Sep 20, 2017

Same problem.

@david-zaletanski

This comment has been minimized.

Copy link

commented Nov 21, 2017

FYI I had the same issue. A bit more specific instructions for anyone else who may not know where to put the property... fixed by opening config.production.json in the ghost directory and adding property just below the..
"client": "mysql",
"connection": {

The line:
"socketPath": "/var/run/mysqld/mysqld.sock",

@1c7

This comment has been minimized.

Copy link

commented Jan 10, 2019

I am using Ghost 2.9.1, got the same problem today
image

I just run ghost restart. it work for me

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
5 participants
You can’t perform that action at this time.