Failed to load list of databases

Question

I want to connect to a remote database using Robomongo. I can connect to to database but an error says that:
Failed to load list of databases

What should I do?

having same problem. It was been working previously but now stopped. "Cannot connect to the MongoDB at xx.xx.xx.xx:443. Error: Failed to execute "listdatabases" command." — arvindwill, Mar 07 '17 at 05:54
I've noticed this happens when I'm using certain versions of the official `mongo` docker images. Since this error is a permissions thing, it seems like there is some inconsistency with how their images are built when it comes to authentication. — heez, Oct 29 '18 at 20:27
Had this issue when connecting to Mongo 4.1.6 in docker via Robo 3T. Worked fined with dockerized mongo 3.4.18 though. — Patrik Stas, Dec 22 '18 at 12:38

score 59 · Answer 1 · answered Sep 26 '19 at 08:04

59

It took me 7 days to figure it out. When I have upgraded to Robo 3T version 1.3. it started working just fine. My previous version was 1.2.

Good to know if you are having this issue.

answered Sep 26 '19 at 08:04

storagemode11

760
3
8

8

This should really, really be upvoted more since this solved everything for me as well. No auth, no nothing, just connect to the exposed port and it worked. Thanks a lot. – nickelman Oct 15 '19 at 18:07
1

Saving my life in 2020. Thanks!! :) – nam Jan 16 '20 at 04:24
This works like a charm! Thank you! This answer should be Accepted and Upwoted! – Exodium Jul 02 '20 at 03:13
my robomongo was 0.9 version because I installed it from the Snap store! – Amin Shojaei Dec 28 '20 at 10:31
This answer is from god himself. Also, what the actual heck Robo 3T :/ – codeness93 May 11 '21 at 19:02

score 9 · Answer 2 · answered Oct 18 '16 at 17:16

9

In my experience, it is related to failed database user/password authentication. So probably your IP connection to server is successful but you failed to connect to db. I suggest to double check your database username/password and try again.

And better to show what is inside "Show error details".

answered Oct 18 '16 at 17:16

Gokhan Simsek

253
1
4

There is not any passwords available! Do I have to set a password? – ehsan shirzadi Oct 24 '16 at 09:08
Can you also share "Error Details", and which remote database are you using? For example for Mongo Atlas, you should define database user/password. – Gokhan Simsek Oct 31 '16 at 15:30
No details! only this error! the details says again the same error – ehsan shirzadi Oct 31 '16 at 20:34
There is error details, you are missing, you should click "Show error details" – Gokhan Simsek Nov 01 '16 at 08:53
2

did anyone solve this problem? cause i'm running into the same issue after setting up mongodb on a vps at digital ocean. I can connect remotely, i can connect through ssh tunnel too, but I can't connect normally. The authentication fails, and the details of the error is : "network error while attempting to run command 'buildInfo' ". I've tried everything.. – Radioreve Feb 10 '17 at 06:49

score 9 · Answer 3 · edited May 23 '17 at 11:54

9

Go to Connection Settings -> Authentication - Provide Database name, username, password - Now test the connection I ran into the same issue, then I provided the above info which solved my issue

Refer: (Vaibhav's post) Point 3.Populate DB name and username and password How to connect Robomongo to MongoDB

edited May 23 '17 at 11:54

Community

1
1

answered Apr 28 '17 at 16:43

srk

91
1
4

score 4 · Answer 4 · edited Jan 03 '21 at 22:56

4

This is because whatever user you are connecting as does not have the privileges to list the databases.

https://docs.mongodb.com/manual/reference/built-in-roles/

Note that a user/role can connect and interact with a specific database/collection, but in order for Robomongo to list out the databases/collections, you need to let it connect to your database using a user that has listDatabases privileges.

check that your user has read/write & list all Databases privileges.

edited Jan 03 '21 at 22:56

ofir_aghai

2,223
1
28
33

answered Oct 27 '17 at 05:16

Jooeun Lee

331
4
18

2

u can use this to grant privileges https://stackoverflow.com/questions/22638258/create-superuser-in-mongo – HMagdy Jan 15 '18 at 19:43

score 4 · Answer 5 · answered May 07 '20 at 19:13

4

I have faced the same problem after updating the MongoDB version from 3.6 to 4.2 and previously I was using the Robo 3T version 1.2. So I just updated the Robo 3T version from 1.2 to 1.3 and it's started working again.

answered May 07 '20 at 19:13

Keshav Lodhi

1,010
1
8
12

Zhenya · Answer 6 · 2018-08-13T17:09:17.500

I had the same error ("failed to load a list of databases"). Due to some reason all my databases and collections got removed. Apparently, Robomongo couldn't handle the situation when there are no databases/collections available on the server.

To solve the issue, I connected to Mongo Shell, created a database, and created a collection there:

mongo (start mongo shell)
use local (create database named local)
db.createCollection("somename")

After that, I could connect to the Mongo server

Update: I've faced this issue again, and this time it has been caused by the fact that it was a new Mongo installation on a virtual machine, and connections from other hosts weren't allowed, so I had to modify bindIP from 127.0.0.1 to 0.0.0.0 in /etc/mongod.conf

net:
   bindIp: 0.0.0.0
   port: 27017

and restart mongo sudo service mongod restart

Evelyn · Answer 7 · 2019-10-01T14:56:51.023

Got the same issue when using mongodb version v4.2.0, but the auth settings don't help. Keep getting the following logs when connecting from Robo 3T(i.e.mongoRobo).

2019-09-30T16:41:52.286-0400 I  NETWORK  [listener] connection accepted from 127.0.0.1:53862 #1 (1 connection now open)
2019-09-30T16:41:52.286-0400 I  NETWORK  [conn1] received client metadata from 127.0.0.1:53862 conn1: { application: { name: "robo3t" }, driver: { name: "MongoDB Internal Client", version: "3.4.3-10-g865d2fb" }, os: { type: "Darwin", name: "Mac OS X", architecture: "x86_64", version: "17.7.0" } }
2019-09-30T16:41:52.292-0400 E  -        [conn1] Assertion: Location34348: cannot translate opcode 2010 src/mongo/rpc/message.h 120
2019-09-30T16:41:52.292-0400 I  NETWORK  [conn1] DBException handling request, closing client connection: Location34348: cannot translate opcode 2010
2019-09-30T16:41:52.292-0400 I  NETWORK  [conn1] end connection 127.0.0.1:53862 (0 connections now open)

Finally resolved it by upgrading Robo 3T to v1.3(mac)

you can write your solution as an answer, if you have resolved it (and mark it as accepted solution), so that others can see the way to solve this problem. — Sourabh Bhagat, Sep 30 '19 at 21:10

score 1 · Answer 8 · answered Oct 02 '19 at 18:14

1

I just found out that I have to upgrade to the latest version that supports latest version of MongoDB. It worked without any authentication.

answered Oct 02 '19 at 18:14

Mohammad Adam

36
2

This is as well as storagemode11 answer the answer to solve this issue. – nickelman Oct 15 '19 at 18:08

score 0 · Answer 9 · answered Oct 27 '17 at 04:23

If you are using mongod --auth --dbpath /data/db1 command to start MongoDB, remove --auth and start it.

mongod --dbpath /data/db1

Now Robomongo will be able to connect without authentication. But starting without authentication is not safe. So take another terminal and create a user for your db using mongo command as described in this article.

use myDB
db.createUser(
  {
    user: "myUserAdmin",
    pwd: "abc123",
    roles: [ { role: "dbAdminAnyDatabase", db: "admin" } ]
  }
)

Now restart your MongoDB with --auth. Connect with Robomongo after configuring above authentication details in its connection settings.

mongod --auth --dbpath /data/db1

score 0 · Answer 10 · answered Dec 20 '17 at 23:48

0

I had the same problem (using Robomongo), then, I created an user with his password to connect to the database, and now It is working ok

answered Dec 20 '17 at 23:48

Pablo Ezequiel Inchausti

6,869
4
23
37

score 0 · Answer 11 · answered Jun 12 '20 at 15:28

0

In my case i changed the configurations of my connection:

You go to: Manager connection >> Edit >> authentication >> rename to database to: admin

when I loaded the my connection all databases appeared.

answered Jun 12 '20 at 15:28

Fábio Rodrigues Fonseca

139
1
4

score 0 · Answer 12 · answered Feb 18 '21 at 12:16

0

Start mongod process. Start mongo process.

On the mongo shell you have opened type first rs.status() then rs.initiate() then rs.status().

answered Feb 18 '21 at 12:16

Justice Bringer

597
6
19

score 0 · Answer 13 · edited Mar 26 '21 at 14:40

0

My version is 1.4.3 Robo3T.

What worked for me is;

Go to MongoDB Connections and edit related connection
Go to Connection Settings
Under Authentication tab check the "Manually Specify visible databases" and fill in the dbName you need to access.

It should fix.

edited Mar 26 '21 at 14:40

Syscall

16,959
9
22
41

answered Mar 26 '21 at 14:28

oguz

161
1
6

Failed to load list of databases

13 Answers13