Error: getaddrinfo ENOENT

[mattwkelly]

I'm using the sample code from the README, but I'm getting "Error: getaddrinfo ENOENT".

var mysql = require('mysql'); var connection = mysql.createConnection({user : '',password : '****',database : '',}); connection.connect();

Thoughts? I've Googled around a bit, but haven't found anything pertinent. Thanks!

[mattwkelly]

Full stack trace:

node.js:201
throw e; // process.nextTick error, or 'error' event on first tick
^
Error: getaddrinfo ENOENT
at errnoException (dns.js:31:11)
at Object.onanswer as oncomplete
--------------------
at Handshake.Sequence (_/playlist_server/node_modules/mysql/lib/protocol/sequences/Sequence.js:15:21)
at new Handshake (__/playlist_server/node_modules/mysql/lib/protocol/sequences/Handshake.js:9:12)
at Protocol.handshake (__/playlist_server/node_modules/mysql/lib/protocol/Protocol.js:36:50)
at Connection.connect (__/playlist_server/node_modules/mysql/lib/Connection.js:36:18)
at Connection.implyConnect (_/playlist_server/node_modules/mysql/lib/Connection.js:135:10)
at Connection.query (__/playlist_server/node_modules/mysql/lib/Connection.js:61:8)
at Object. (_**/playlist_server/app.js:10:12)
at Module._compile (module.js:441:26)
at Object..js (module.js:459:10)
at Module.load (module.js:348:31)

[felixge]

Your server is very likely not listen on port 3306 but on a unix domain socket. Try it with telnet, if this is what your output looks like, you need to figure out the path of the unix socket, and supply that as socketPath:

$ telnet localhost 3306
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
Trying ::1...
telnet: connect to address ::1: Connection refused
Trying fe80::1...
telnet: connect to address fe80::1: Connection refused
telnet: Unable to connect to remote host

[mattwkelly]

Thanks! socketPath fixed it (I found the path in /etc/mysql/my.cnf).

Note that "telnet localhost 3306" returned "telnet: could not resolve localhost 3306/telnet: Name or service not known"

[msingh025]

Error: getaddrinfo ENOENT issue come in different case.
steps .1 create connection using
var pool = mysql.createPool({
connectionLimit : 100, //important
host : 'localhost',
user : 'me',
password : 'me',
database : 'test',
debug : false
});
2: connect network cable it is work fine. while my database is my local machine.
3: after disconnect network cable and start node server.
it is throwing exception as "Error: getaddrinfo ENOENT".
I can not understand , what is dependency on network..

[dougwilson]

This is an issue with Node.js itself, not this module. Please file the issue there.

[dougwilson]

FYI until Node.js fixes this, the work around is to use 127.0.0.1 instead of localhost

[dougwilson]

Here is a very recent Node.js issue about this: nodejs/node-v0.x-archive#25338