Connecting to mongodb through ssh username/password through nodejs

Question

I am trying to connect to Mongodb through ssh username/password through nodejs as below :

var mongoose = require('mongoose');
var tunnel = require('tunnel-ssh');

var config = {
username : 'xyz',
host: 'xx-xxx-xx.com',
port:22,
password:'xxx',
dstPort:27017,
localPort:27017
};

console.log(tunnel);
var server = tunnel(config, function (error, server) {

if(error){
    console.log("SSH connection error: " + error);
}
console.log(server);
mongoose.connect('mongodb://localhost:27017/myDB');

var db = mongoose.connection;
console.log(db);
db.on('error', console.error.bind(console, 'DB connection error:'));
db.once('open', function() {
    console.log("DB connection successful");
});
});

But I am getting error as below : DB connection error: { MongoError: connection 0 to localhost:27017 timed out

What is the issue here?

gzp___ · Accepted Answer · 2017-12-01 10:56:18Z

3

Probably is because you are missing the 'dstHost'in the config options.

The 'dstHost' must be the destination server url.

from official tunnel-ssh doc

 var config = {
      username:'root',
      Password:'secret',
      host:sshServer,
      port:22,
      dstHost:destinationServer,
      dstPort:27017,
      localHost:'127.0.0.1',
      localPort: 27000
    };

    var tunnel = require('tunnel-ssh');
    tunnel(config, function (error, server) {
      //.... 
    });

answered Dec 1, 2017 at 10:56

gzp___

3883 silver badges13 bronze badges

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

5 Comments

Sowmya Over a year ago

I tried by adding dstHost . But I am getting the same error.

gzp___ Over a year ago

have you also added localHost:'127.0.0.1' to the options ?

Sowmya Over a year ago

Yes I tried adding localHost:'127.0.0.1' also . But getting same result.

gzp___ Over a year ago

can you connect to your local db without tunnelin ? If so then there must be some config missing with your ssh server, have a look at this thread stackoverflow.com/questions/38509995/… maybe you need a private key ?

Sowmya Over a year ago

I can connect to localdb with no errors. I dont have any private key . Through ssh username/password I am able to connect in MongoDB Compass but not from nodejs program

Collectives™ on Stack Overflow

Connecting to mongodb through ssh username/password through nodejs

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related