How do I connect robomongo to my droplet

August 26, 2015 14.1k views
MongoDB Configuration Management

I cannot seem to figure out how to connect my local tool "Robomongo" to my droplet running "Ubuntu MongoDB 3.0.5 on 14.04"

6 comments
  • Did you manage to figure it out? I am at the exact stage right now.

  • I am also looking for a solution for this, please advice, thanks in advance!

  • in the "Connection" panel:
    Address - localhost
    Port - 27017

    in the "SSH" panel:
    Address - <your_ip_or_fqdn>:22
    and use a private key auth.

    This will connect via port 22 and redirect traffic sent to port 27017

    Mongo on your droplet is set to respond only to traffic from localhost which is where the ssh tunnel comes in handy. Running db.serverCmdLineOpts() from the mongoshell will tell you what it is bound to.

  • Dam this isnt working for me. Is the address localhost or my domain name?

    Same question for the SSH bit.

  • I just ended up using AWS

  • Show 1 more comments
3 Answers

This question was answered by @vincro:

in the "Connection" panel:
Address - localhost
Port - 27017

in the "SSH" panel:
Address - <your_ip_or_fqdn>:22
and use a private key auth.

This will connect via port 22 and redirect traffic sent to port 27017

Mongo on your droplet is set to respond only to traffic from localhost which is where the ssh tunnel comes in handy. Running db.serverCmdLineOpts() from the mongoshell will tell you what it is bound to.

View the original comment

Here's the robomongo (v 1.0.0) setup:

Connection tab

  • Address: localhost
  • Port: 27017

Authentication tab

  • "Perform Authentication" is turned off

Advanced tab

  • Default Database is left blank

SSL tab

  • "Use SSL Protocol" is not checked

SSH tab

  • "Use SSH tunnel" is checked
  • "SSH Address" first field is my server's IP address, second field is the port "22" as was default
  • "SSH User Name": your private key enabled user
  • "SSH Auth Method": Set to Private Key
  • "Private Key": Click the ... button to select your file
  • "Passphrase": left blank or filled as you prefer

Beware that the private key should be in OpenSSH format. If it is the case you may convert a putty key (ppk) with the "Putty Gen" app.

Additional details and tips here.

You can use ssh tunnel:

ssh -p <sshport> username@sshhost -L 27017:127.0.0.1:27017

That's if you use the default 27017 port,

Have another answer? Share your knowledge.