I’m trying to connect to a MongoDB hosted on mlab. I tried using admin as the authentication db and I also tried to use my own DB as the auth db (though I’m not sure that’s a correct config) but it keeps failing. Using WireShark I can see that Dremio is carrying out a short conversation with my DB server, but it fails to establish a connection. I tried extending the timeout significantly too.
I’ve attached 2 logs - one for each type of attempt.
I finally figured it out, so for the benefit of anybody else looking for similar information:
If you’re not using an mLab dedicated plan, the authentication db is just your regular db name which you’re trying to connect to.
If you’re on a replica set, you have to add a connection string parameter, which is the parameter provided by mLab at the end of the connection string - replicaSet=
You might have to extend the timeout beyond the default 2000ms