Module does not work in Node.js 0.6 (was: ECONNREFUSED)

[EgidioCaprino]

Hello.

I'm trying to connect to MySQL server in this way.

var config = require('./config.js'),
    mysql = require('./node_modules/mysql/index.js'),
    csv = require('./node_modules/csv/index.js'),
    fs = require('fs');

console.log(config.db);

var db = mysql.createConnection(config.db);
db.connect();

but I get this error:

{ [Error: connect ECONNREFUSED]
  code: 'ECONNREFUSED',
  errno: 'ECONNREFUSED',
  syscall: 'connect',
  fatal: true }

I tried all the solution on the web but nothing worked.

[jdrydn]

Interesting how you're loading the mysql module - why not:

var mysql = require("mysql");

[sidorares]

1. Do you run mysql server locally? 2) can you connect to it with command line client (with "-h 127.0.0.1" switch)? 3) what is output of ps ax |grep mysqld?

[EgidioCaprino]

@jdrydn I load it in that way because npm install mysql put it in subdirectory of the project.

@sidorares The server is local and I can connect to it by CLI (mysql -u user -p db -h 127.0.0.1). This is the output of ps ax |grep mysqld

root@host2:~# ps ax |grep mysqld
 7384 ?        Ssl    7:05 /usr/sbin/mysqld
30539 pts/0    S+     0:00 grep --color=auto mysqld

Thank you guys.

[jdrydn]

Yeh, NPM installs modules to a node_modules folder - See http://nodejs.org/api/modules.html#modules_loading_from_node_modules_folders ;)

(Therefore, require("mysql") resolves to /node_modules/mysql/index.js ;) technically)
(Also, if you have multiple Node projects, all using the same module, you can put node_modules folders up the hierarchy so multiple projects share the same modules 👍 )

[EgidioCaprino]

@jdrydn do you think this is the problem? What do you mean exactly with up the hierarchy?

[jdrydn]

No, I think the problem lies in your database config, especially if you can connect over the CLI, could you comment with the object you have at config.db (obviously blanking out usernames and password ;)). I'm just commenting on the way you seem to have pulled in the mysql module, which I've never seen used like that before!

[jdrydn]

I.e. Mine often looks like:

    var config = {
        database: {
            host: "localhost",
            user: "myawesomeuser",
            password: "mysecurepassword",
            database: "thedatabase"
        }
    };

    var mysql = require("mysql");

    var connection = mysql.createConnection(config.database);

[EgidioCaprino]

Thank you. This is the definition of config.db.

exports.db = {
    host: '127.0.0.1',
    user: 'user',
    password: 'passwd',
    database: 'zadmin_shopriparando'
};

[EgidioCaprino]

What settings do you think are wrong with my DB?

[jdrydn]

What I would do, for debugging irritating connection issues like this, is put the contents of the example (https://github.com/felixge/node-mysql#introduction) into a file testdatabase.js, fill in your connection details, and try running that on it's own ($ node testdatabase.js).

Do you still get a connection issue?

---

Edit: If no, then perhaps it's a problem with your user not being able to access your database? Check the privileges of of your database, make sure the user can do stuff on the database.

[EgidioCaprino]

The problem persists. I tried with

var mysql = require('mysql');
var connection = mysql.createConnection({
    host : 'testdb',
    user: 'me',
    password: 'beryqeqes',
    database: 'zadmin_testdb'
});

connection.connect();

but I get the same error. I do not know if it matters, but we use ZPanel to manage databases and users.

[jdrydn]

Take off the database parameter, can you connect to the MySQL server?

[EgidioCaprino]

No. Same error :(

[tgvashworth]

Possibly stupid question but: you do actually have a mysql server running, right?

@jdrydn sup ;)

[EgidioCaprino]

@PhUU sure. I can also connect to the database through CLI, with the same credentials I use in the script.