Failure to connect using SSH tunnel about ssh HOT 6 CLOSED

I note I have the same problem when I run the same code on Mac: the tunneling command claims connection, but I get no connection to the MongoDB with a socket timeout message.

from ssh.

Do you get the same issue if you use my mongodb server? For example as described here: https://jeroen.github.io/mongolite/connecting-to-mongodb.html#ssh-tunnel

from ssh.

I can connect to the server via mongo() just fine, but I can't test the port forward without SSH credentials to dev.opencpu.org.

from ssh.

Right, I meant using your own ssh server, but that public mongo server.

from ssh.

I'm not sure if I'm doing this right

session <- ssh::ssh_connect("USER@MY_SERVER")
ssh::ssh_tunnel(session, port = 22087, target = "mongo.opencpu.org:43942")
/ Waiting for connetion on port 22087...

Then

> con <- mongo("mtcars", url = "mongodb://MY_SERVER:22087/jeroen_test")
Error: No suitable servers found (`serverSelectionTryOnce` set): [connection refused calling ismaster on 'MY_SERVER:22087']

I think the connection refused error means I'm doing something wrong here, rather than the timeout problem I saw above.

from ssh.

OK I see the problem now. To connect to an ssh tunnel, you need to connect to the machine where you started the tunnel, and not MY_SERVER. It is then tunneled from your R process hosting the ssh tunnel, through the ssh-server, to the target host.

So your first step is OK, but in the second step you need to connect to localhost:

con <- mongo("mtcars", url = "mongodb://readwrite:test@localhost:22087/jeroen_test")

from ssh.