node.js - Why is node script failing a localhost connect to MySQL -


i can't figure out why script failing connect mysql instance.

i can connect database mysql client on command line, exact same credentials. can connect database remote client, using same credentials.

the database connect script works fine if set parameters remote database.

neither host or socket parameters works through script. make dumb mistakes @ times if one, can't see it.

an outside observer me here.

==================== db connect code

var db = require('./config'); var mysql = require('mysql');  var connection = mysql.createconnection({     host: db.db_parms.host,     port: db.db_parms.port,     user: db.db_parms.user,     password: db.db_parms.password,     database: db.db_parms.context,     debug:true });  connection.connect(function(err) {     if(err){         console.log("sql connect error: " + err);     } else {         console.log("sql connect successful.");     } });  connection.query("select now()", function(error,results,fields) {     console.log("results:" + results);     console.log("fields:" + fields); });   exports.connection = connection;

=== error stack returned:

sql connect error: error: connect econnrefused 127.0.0.1:3307     @ object.exports._errnoexception (util.js:1036:11)     @ exports._exceptionwithhostport (util.js:1059:20)     @ tcpconnectwrap.afterconnect [as oncomplete] (net.js:1080:14)     --------------------     @ protocol._enqueue (/home/kingram/node/apps/fss_register/node_modules/mysql/lib/protocol/protocol.js:141:48)     @ protocol.handshake (/home/kingram/node/apps/fss_register/node_modules/mysql/lib/protocol/protocol.js:52:41)     @ connection.connect (/home/kingram/node/apps/fss_register/node_modules/mysql/lib/connection.js:130:18)     @ object.<anonymous> (/home/kingram/node/apps/fss_register/db/db_connect.js:19:12)     @ module._compile (module.js:556:32)     @ object.module._extensions..js (module.js:565:10)     @ module.load (module.js:473:32)     @ trymoduleload (module.js:432:12)     @ function.module._load (module.js:424:3)     @ module.runmain (module.js:590:10)

========= config.js host = 'localhost':

var db_parms = { host: 'localhost', port: 3307, user:'foo', password:'bar', database:'thisone' }  exports.db_parms = db_parms;

========= config.js host = socket:

host: '/var/run/mysqld/mysqld.sock',

=== error stack returned:

sql connect error: error: getaddrinfo enotfound /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock:3307     @ errnoexception (dns.js:28:10)     @ getaddrinforeqwrap.onlookup [as oncomplete] (dns.js:76:26)     --------------------     @ protocol._enqueue (/home/kingram/node/apps/fss_register/node_modules/mysql/lib/protocol/protocol.js:141:48)     @ protocol.handshake (/home/kingram/node/apps/fss_register/node_modules/mysql/lib/protocol/protocol.js:52:41)     @ connection.connect (/home/kingram/node/apps/fss_register/node_modules/mysql/lib/connection.js:130:18)     @ object.<anonymous> (/home/kingram/node/apps/fss_register/db/db_connect.js:19:12)     @ module._compile (module.js:556:32)     @ object.module._extensions..js (module.js:565:10)     @ module.load (module.js:473:32)     @ trymoduleload (module.js:432:12)     @ function.module._load (module.js:424:3)     @ module.runmain (module.js:590:10)

i'm not sure if error socket permissions issue or not , if relevant.

as turns out, check of my.conf shows bind-addresss set ip of server , not localhost.

setting host: '<ip-address>' fixed issue.


Comments

Post a Comment

Popular posts from this blog

javascript - Create a stacked percentage column -

i have collection of data : var data = [ {"p301a":"10","p301b":"7","p301c":"7","p301d":"3","p301e":"8","p301f":"8","p301g":"8","p301h":"8","p301i":"8","p301j":"8","p301k":"8","p301l":"8","p301m":"8","p301n":"8","p301o":"8","age":"31-40 years","profesion":"2","position":"2"}, {"p301a":"5","p301b":"4","p301c":"4","p301d":"4","p301e":"4","p301f":"4","p301g":"4","p301h":"4","p301i":"4","p301j":"4","p301k":"4...
Read more

Optimising Firebase database by automatically overwriting data -

in firebase app have following structure: posts latest all users can write posts > latest . want limit entries 20 posts save space in database. , posts beyond 20 unnecessary never shown on homepage. how can limit posts 20, when user writes posts > latest posts @ end drop off (be deleted) automatically? this sample should you. you need : const max_log_count = 20; exports.removeold = functions.database.ref('/posts/latest/{postid}').oncreate(event => { const parentref = event.data.ref.parent; return parentref.once('value').then(snapshot => { if (snapshot.numchildren() >= max_log_count) { let childcount = 0; const updates = {}; snapshot.foreach(function(child) { if (++childcount <= snapshot.numchildren() - max_log_count) { updates[child.key] = null; } }); // update parent. removes children. ...
Read more

javascript - Angular UI-Grid customTemplate directive causing rows to load slowly/? -

Image
each grid cell can have more 1 customtemplate loaded. have directive holds watcher on model_col_field listen cell updates on scroll when dom rows updated , recompile celltemplate . without watcher , $compile rows repeat on scroll, showing same set of rows. is there more angular way of approaching or way improve performance? relevant controller code: create gridoptions.data & gridoptions.columndefs : var customtemp = '<div ng-repeat="opt in grid.appscope.colvalueoptionsmodel" ng-init="tempstring=model_col_field.clazz+opt.key;"><comparison-directive dbo="model_col_field" attobj="opt" fff="grid.appscope.getattributetemplate(tempstring)" /></div>'; $scope.gridoptions.columndefs = [ { name:'yindex',pinnedleft:true,celltemplate: customtemp, displayname:'index'}, { name:'col1',celltemplate: customtemp}, { name:'col2',celltemplate: c...
Read more