Nodejs - mysql2 stream connection and remote host

Question

I need to query a mysql database from one server. The mysql database is located on another network. I can only connect to this network from a specific server.

I need to create a tunnel from server 1, into server 2 and use this tunnel to connect to my mysql database.

This is my current code. This allows me to connect to server 2's local mysql server, but not to a remote mysql server.

var Client = require('ssh2').Client,
mysql = require('mysql2'),

var client = new Client();
var ssh = client.connect({
  host: config.server_tunnel.dstHost,
  port: 22,
  username: config.server_tunnel.username,
  privateKey: config.server_tunnel.privateKey
});

ssh.forwardOut('127.0.0.1', 12345, '127.0.0.1', 3306, function (err, stream) {
   mysql.createConnection({
    user: config.database.username,
    password: config.database.password,
    database: config.database.database,
    stream: stream,
    host: 'remote.host.com'
  });
});

robertklep · Accepted Answer · 2017-10-05 15:05:26Z

1

Instead of passing host to mysql.createConnection(), try making the tunnel connect to it:

ssh.forwardOut('127.0.0.1', 12345, 'remote.host.com', 3306, ...);

answered Oct 5, 2017 at 15:05

robertklep

205k38 gold badges421 silver badges413 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CharliePrynn Over a year ago

Perfect, that makes total sense now you've pointed it out. Thank you.

Collectives™ on Stack Overflow

Nodejs - mysql2 stream connection and remote host

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related