How to connect Robomongo to MongoDB

Question

I am have MongoDB and Robomongo in my running system, and I am using Robomongo as the client.

I have installed MongoDB on a different system which I am treating as server, and I want to connect Robomongo of my system (as a client) to MongoDB on another system (server). What steps should I follow to achieve the same?

I am using the machine name, as the system's IP address is not static. But even if I use the system's IP address, I get the same error:

connect failed, can't connect couldn't connect to server W7IN05200067D:27017"

I am connecting to it directly, and I am not using any authentication.

score 59 · Answer 1 · edited Feb 13 '21 at 13:38

59

I was able to connect Robomongo to a remote instance of MongoDB running on Mongo Labs using the connection string as follows:

Download the latest version of Robomongo. I downloaded 0.9 RC6 from here.
From the connection string, populate the server address and port numbers as follows.
Populate DB name and username and password as follows under the authentication tab.
Test the connection.

edited Feb 13 '21 at 13:38

Peter Mortensen

28,342
21
95
123

answered Mar 11 '16 at 08:50

Vaibhav

2,227
1
20
28

Worked like a charm! Thanks for the great explanation – Daan Dec 13 '17 at 16:01

score 20 · Answer 2 · edited Feb 13 '21 at 13:40

Note: Commenting out bind_ip can make your system vulnerable to security flaws. Please see Security Checklist. It is a better idea to add more IP addresses than to open up your system to everything.

You need to edit your /etc/mongod.conf file's bind_ip variable to include the IP of the computer you're using, or eliminate it altogether.

I was able to connect using the following mongod.conf file. I commented out bind_ip and uncommented port.

# mongod.conf

# Where to store the data.

# Note: if you run MongoDB as a non-root user (recommended) you may
# need to create and set permissions for this directory manually.
# E.g., if the parent directory isn't mutable by the MongoDB user.

dbpath=/var/lib/mongodb

# Where to log
logpath=/var/log/mongodb/mongod.log

logappend=true

port = 27017

# Listen to local interface only. Comment out to listen on all
interfaces.

#bind_ip = 127.0.0.1


# Disables write-ahead journaling
# nojournal = true

# Enables periodic logging of CPU utilization and I/O wait
#cpu = true

# Turn on/off security.  Off is currently the default
#noauth = true

#auth = true

# Verbose logging output.
#verbose = true

# Inspect all client data for validity on receipt (useful for
# developing drivers)
#objcheck = true

# Enable db quota management
#quota = true

# Set oplogging level where n is
#   0=off (default)
#   1=W
#   2=R
#   3=both
#   7=W+some reads
#diaglog = 0

# Ignore query hints
#nohints = true

# Enable the HTTP interface (Defaults to port 28017).
#httpinterface = true

# Turns off server-side scripting.  This will result in greatly limited
# functionality
#noscripting = true

# Turns off table scans.  Any query that would do a table scan fails.
#notablescan = true

# Disable data file preallocation.
#noprealloc = true

# Specify .ns file size for new databases.
# nssize = <size>

# Replication Options
# In replicated MongoDB databases, specify the replica set name here
#replSet=setname

# Maximum size in megabytes for replication operation log
#oplogSize=1024

# Path to a key file storing authentication info for connections
# between replica set members
#keyFile=/path/to/keyfile

Don't forget to restart the mongod service before trying to connect:

service mongod restart

From Robomongo, I used the following connection settings:

Connection Tab:

Address: [VPS IP] : 27017

SSH Tab:

SSH Address: [VPS IP] : 22
SSH User Name: [Username for sudo enabled user]
SSH Auth Method: Password
User Password: Supersecret

I don't have `etc` folder and `mongod.conf` in my Mongo folder. Do you know, was Mongo installed wrong on my machine or should it be added somehow? — Yuri Dorokhov, Aug 10 '16 at 15:50
@YuriDorokhov sorry for the delayed response, /etc folder is in the root directory of your Linux installation not in the your Mongo folder. — ShahNewazKhan, Aug 14 '16 at 15:49
Do not EVER comment out `bind_ip = 127.0.0.1`!!!!! You can add other IPs to it, but if you comment out bind_ip you are creating a potential security vulnerability allowing public access to your mongodb server. @ShahNewazKhan Please modify your post. See mongodb security checklist here https://docs.mongodb.com/manual/administration/security-checklist/#limit-network-exposure — xiaolin, Jan 05 '17 at 17:16
@linxtion thanks for the heads up, I have updated my answer accordingly — ShahNewazKhan, Jan 06 '17 at 18:55

score 6 · Answer 3 · edited Feb 13 '21 at 13:44

6

First you have to run the mongod command in your terminal. Make sure the command executes properly.
Then in a new terminal tab run the mongo command.
Then open the Robomongo GUI and create a new connection with the default settings.

edited Feb 13 '21 at 13:44

Peter Mortensen

28,342
21
95
123

answered Apr 25 '17 at 18:53

Manvender Singh Rathore

1,076
11
17

1

I have been having this issue and looking for answers for hours... This literally solved my problem. Thank you so much. – Eray T Nov 06 '18 at 03:37

score 4 · Answer 4 · edited Feb 13 '21 at 13:16

4

It looks like Robomongo does not yet work with MongoDB 3:

Can't Connect to Mongo 3.0 DB server #771

edited Feb 13 '21 at 13:16

Peter Mortensen

28,342
21
95
123

answered May 07 '15 at 10:25

alexander_ch

347
4
12

What is the alternative then ? – Dec 17 '15 at 14:02

score 3 · Answer 5 · edited Feb 13 '21 at 13:35

3

Currently, Robomongo 0.8.x doesn't work with MongoDB 3.0:

For now, don't use Robomongo. For me, the best solution is to use MongoChef.

edited Feb 13 '21 at 13:35

Peter Mortensen

28,342
21
95
123

answered Oct 05 '15 at 09:25

DonFabiolas

349
6
15

score 2 · Answer 6 · edited Feb 13 '21 at 13:13

2

Here's what we do:

Create a new connection, set the name, IP address and the appropriate port:
Set up authentication, if required
Optionally set up other available settings for SSL, SSH, etc.
Save and connect

edited Feb 13 '21 at 13:13

Peter Mortensen

28,342
21
95
123

answered Feb 05 '15 at 04:37

sepehr

13,648
5
73
111

Narrow down the situation by using the IP for now. What port the remote mongod server is using? Is this the default 27017? Is the problem specific to robomongo?! Can you connect using `mongo` shell? You might need to change SSL/SSH settings. – sepehr Feb 05 '15 at 06:00

Jag · Answer 7 · 2021-02-23T06:46:39.137

2

If there is no authentication enabled (username/password) and still unable to connect. Just use localhost and default port. Click Test and Save, if test connection is successful.

Regards Jagdish

edited Feb 23 '21 at 06:46

answered Jul 22 '17 at 09:13

Jag

75
1
6

I would like keep my original answer and without any edits and with Typos.... – Jag Feb 23 '21 at 06:47

score 0 · Answer 8 · edited Feb 13 '21 at 13:36

Robomongo 0.8.5 definitely works with MongoDB 3.X (mine version of MongoDB is 3.0.7, the newest one).

The following steps should be done to connect to the MongoDB server:

Install MongoDB server (on Windows, Linux, etc. Your choice)
Run the MongoDB server. Don't set net.bind_ip = 127.0.0.1 if you want the client to connect to the server by server's own IP address!
Connect to the server from Robomongo with the server IP address + set authentication if needed.

score 0 · Answer 9 · edited Feb 13 '21 at 13:46

0

I exported the following connection from Studio 3T:

mongodb://youn-nosql-grej-test:xxxyyyzzz@youn-nosql-grej-test.documents.azure.com:10255/admin?3t.uriVersion=2&3t.certificatePreference=RootCACert:accept_any&3t.databases=admin&3t.connectionMode=direct&3t.useClientCertPassword=false&3t.connection.name=Grej-Test&readPreference=primary&ssl=true

And I filled it in in the following screens:

edited Feb 13 '21 at 13:46

Peter Mortensen

28,342
21
95
123

answered Mar 20 '19 at 10:48

DanielV

1,396
2
26
48

score -2 · Answer 10 · edited Feb 13 '21 at 13:43

Comment out the /etc/mongod.conf file's bind_ip
Download https://download.robomongo.org/0.9.0-rc9/windows/robomongo-0.9.0-rc9-windows-x86_64-0bb5668.exe
Connection tab:

3.1 Name (whatever)

3.2 Address (IP address of the server) : Port number (27017)
SSH tab (I used my normal PuTTY connection details)

4.1 SSH Address: (IP address of server)

4.2 SSH User Name (User Name)

4.3 User Password (password)

How to connect Robomongo to MongoDB

10 Answers10

Linked

Related