How do I connect robomongo to my droplet

August 26, 2015 12.7k views
MongoDB Configuration Management
kris7f076b4780c
By:
kris7f076b4780c

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
  • gagandeep September 5, 2015

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

  • sparqy October 1, 2015

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

  • vincro November 24, 2015

    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.

  • Responsive January 24, 2016

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

    Same question for the SSH bit.

  • kris7f076b4780c January 25, 2016

    I just ended up using AWS

  • lukezin December 7, 2016

    I "kinda" figured it out:
    You have to open the firewall to accept incoming connections on port 22 and port 27017 using ufw (refer to Digital Ocean's ufw tutorial)

    In your droplet:

    $ sudo ufw allow 27017
$ sudo ufw allow 22

    and to check if it worked:

    $ sudo ufw status

    Now you have to change your mongod.conf file:

    $ sudo vim /etc/mongod.conf

    then go to line 23 and it should read:

    bindIp: 127.0.0.1

    change it to:

    bindIp: 0.0.0.0

    (do not add extra lines or spaces to this file, even if it is a comment).

    then run

    $ sudo systemctl restart mongodb
$ sudo systemctl status mongodb

    and it should be active.
    Go to Robomongo under 'Connection' tab:
    Address: your droplet address

    connect normally.
    I "kinda" figured it out because you cannot use this solution in production because it will accept any incoming IP connection to your database; which is not recommended.
    If I figure out how to do it with the tunnel or in a way that accepts only IPs authorized; I'll let you know!

Log In to Comment
3 Answers
asb MOD June 7, 2016

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

Reply
abenedetti June 4, 2017

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.

Reply
desktopwpapp October 18, 2017

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,

Reply
Have another answer? Share your knowledge.

Related Questions