Cannot connect to replica set via mongo compass

Thanachai_Namphairoj · 2022-05-30T07:35:00.643Z

{
_id: ‘rs0’,
version: 1,
term: 47,
members: [
{
_id: 0,
host: ‘masternode:27017’,
arbiterOnly: false,
buildIndexes: true,
hidden: false,
priority: 1,
tags: {},
secondaryDelaySecs: Long(“0”),
votes: 1
},
{
_id: 1,
host: ‘client1:27017’,
arbiterOnly: false,
buildIndexes: true,
hidden: false,
priority: 1,
tags: {},
secondaryDelaySecs: Long(“0”),
votes: 1
},
{
_id: 2,
host: ‘client2:27017’,
arbiterOnly: false,
buildIndexes: true,
hidden: false,
priority: 1,
tags: {},
secondaryDelaySecs: Long(“0”),
votes: 1
}
],
protocolVersion: Long(“1”),
writeConcernMajorityJournalDefault: true,
settings: {
chainingAllowed: true,
heartbeatIntervalMillis: 2000,
heartbeatTimeoutSecs: 10,
electionTimeoutMillis: 10000,
catchUpTimeoutMillis: -1,
catchUpTakeoverDelayMillis: 30000,
getLastErrorModes: {},
getLastErrorDefaults: { w: 1, wtimeout: 0 },
replicaSetId: ObjectId(“627e2cebd23c7aae01154b0b”)
}
}>
This is rs.config()

Ramachandra_Tummala · 2022-05-30T07:52:24.736Z

Can you connect by hostname instead IP?
Are other 2 nodes pingable and resolving to the ips you are using
Also output of cat /etc/hosts

Thanachai_Namphairoj · 2022-05-30T08:00:08.331Z

Here is the cat of /etc/hosts

image692×400 19.8 KB

I had tried using the hostname instead of IPs and it resulted in the same error.

Yes, every node can ping to each other using ping hostname and the ip is all correct.

Ramachandra_Tummala · 2022-05-30T08:26:07.128Z

Looks ok
Did you try to connect to your replica set using hostnames in your connect string?

Thanachai_Namphairoj · 2022-05-30T08:29:07.970Z

Yes I did. It gives me the same error

image915×835 57.5 KB

steevej · 2022-05-30T13:19:01.196Z

ENOTFOUND means that the host name masternode cannot be found.

In one of your previous post, you shown that you can ping masternode and the other 2 hosts of your replica set.

The only conclusion I can think of, is that you are not running Compass from the same machine as the one you used to run the ping commands.

The host names of your replica set must be DNS resolvable from all machines you are using to access the replica set. They should all resolve to IP addresses that are routed from all machines you are using to access the replica set.

Thanachai_Namphairoj · 2022-05-31T07:43:25.703Z

That might be the case because I run the replicaset on 3 separate VMs. Are there any ways for me to allow compass on my pc to be able to access to the set? I tried using ufw allow from 0.0.0.0/0 on every single VM but it still doesn’t work

steevej · 2022-05-31T13:14:21.082Z

Thanachai_Namphairoj:

compass on my pc to be able to access to the set

Sure there is. But I can only rephrase what I wrote in my previous post. The host names use in the replica set must be know by you PC and your PC must be able to route traffic to the corresponding IP addresses.

Networking, including host and domain name resolution and routing is complex. I recommend using Atlas. You would be up and running a replica set in no time.

devops_learning · 2022-11-03T16:27:20.181Z

Thank you steevej .even iam also facing same issue.

rliu · 2023-02-02T01:20:21.044Z

I have the same issue that running replica set within local docker containers while failing to connect with my local Compass outside of the docker containers.

I failed to use Atlas because my company blocked 27017 port for security reasons. To request the other team to whitelist 27017 for Atlas usage is not a option in my situation.

Since Mongo provided a detailed procedure for deploy Mongo Cluster in docker, I would hope Mongo can also provides a detailed procedure that helps out how local Compass (outside of container) connect replica sets within docker container.

steevej · 2023-02-02T21:15:00.928Z

rliu:

I would hope Mongo can also provides a detailed procedure that helps out how local Compass (outside of container) connect replica sets within docker container.

They did not specify how to connect because there is nothing special to do. The information is already there.

From the link you supplied you created a replica set named myReplicaSet which has 3 nodes, the nodes are named mongo1, mongo2 and mongo3, and they all listen on port 27017. The URI to connect to a replica set is of the form:

mongodb://[username:password@]host1[:port1][,...hostN[:portN]][/[defaultauthdb][?options]]

Just have to replace host1, …, hostN with your hosts. You may leave the port number since you are using the default one.

Running all instances of your replica set within the same physical host is risky. Because if you loose your machine you loose your data.

rliu · 2023-02-02T22:02:49.936Z

I appreciate the connection string page you shared here.

However the same issue repeated as this post-owner posted here. The views of this post has been at 4.3k in this forum, one of the most review posts here, and the same questions repeated over other technical forum too so that seems like a lot of people like me has the same issue even though we followed that connection string format.

I had been read many other posts all over internet like yours, unfortunately none of them works. That’s why I am still hoping Mongo can provide a procedure instruction.

I am doing POC for now so creating cluster inside one local machine is not my current concern for now. But thank you for the help though.

steevej · 2023-02-02T23:20:11.905Z

rliu:

none of them works

If the following connection string does not work please provide the error you are getting.

mongodb://mongo1,mongo2,mongo3/?replicaSet=myReplicaSet

What base OS are you using?

rliu · 2023-02-02T23:53:56.032Z

I appreciate your patient. Still doesn’t work

My OS is:
|Edition|Windows 10 Pro|

So far I had failed trying on the connection strings:

mongodb://localhost:27017,localhost:27018,localhost:27019/?replicaSet=myReplicaSet&tls=false

mongodb://mongo1:27017,mongo2:27018,mongo3:27019/?replicaSet=myReplicaSet&tls=false

mongodb://mongo1:27017,mongo2:27018,mongo3:27019/?replicaSet=myReplicaSet&readPreference=primary&appname=MongoDB%20Compass&directConnection=false&ssl=false

mongodb://172.20.0.1:27017,172.20.0.2:27018,172.20.0.3:27019/?replicaSet=myReplicaSet&readPreference=primary&directConnection=false&ssl=false

The above docker container IP addresses acquired by command

docker inspect container_id (9f64ba814343)

And more or less the /options here and there where I prefer not to exhaust all of my trials. The Compass always returns me error:

getaddrinfo ENOTFOUND mongo1/2/3

Note: I followed the Mongo instruction so we have common ground here at least.

steevej · 2023-02-03T02:54:08.102Z

rliu:

mongodb://localhost:27017,localhost:27018,localhost:27019/?replicaSet=myReplicaSet&tls=false

This is not what I proposed. The replica set is not configured as as localhost. So you are specifying the wrong host. From the link you supplied the replica set is:

docker exec -it mongo1 mongosh --eval "rs.initiate({
 _id: \"myReplicaSet\",
 members: [
   {_id: 0, host: \"mongo1\"},
   {_id: 1, host: \"mongo2\"},
   {_id: 2, host: \"mongo3\"}
 ]
})"

rliu:

mongodb://mongo1:27017,mongo2:27018,mongo3:27019/?replicaSet=myReplicaSet&tls=false

This is again not what I proposed. I mentioned

steevej:

the nodes are named mongo1, mongo2 and mongo3, and they all listen on port 27017

and

steevej:

You may leave the port number since you are using the default one.

So you are mentioning the wrong ports.

rliu:

mongodb://mongo1:27017,mongo2:27018,mongo3:27019/?replicaSet=myReplicaSet&readPreference=primary&appname=MongoDB%20Compass&directConnection=false&ssl=false

As already mentioned you are specifying the wrong ports.

rliu:

mongodb://172.20.0.1:27017,172.20.0.2:27018,172.20.0.3:27019/?replicaSet=myReplicaSet&readPreference=primary&directConnection=false&ssl=false

I have mentioned that your replica set, if configured like the link you shared is configured with

steevej:

the nodes are named mongo1, mongo2 and mongo3

So with 127.0.0.1 you are mentioning the wrong hosts.

The conclusion is that you have tried many things. The one thing you have not tried is the one I have mentioned:

steevej:

If the following connection string does not work please provide the error you are getting.
mongodb://mongo1,mongo2,mongo3/?replicaSet=myReplicaSet

Since you have tried many things except the one I shared I am not too sure that you

rliu:

followed the Mongo instruction

because you do not follow the only suggestion I offer. Please share the output of

docker ps 
and
docker exec -it mongo1 mongosh --eval "rs.status()"

Hopefully, they match what is documented in the link you shared.

Share the screenshot of the connection string that generated the Compass error

rliu:

getaddrinfo ENOTFOUND mongo1/2/3

Optionwiz · 2023-07-01T02:34:30.408Z

I had the same issue as the OP and it has been brought up many times here and on SF.

In digging in to my situation I was running a 3 node replicaset with docker-compose in docker for Mac and trying to connect with Compass. Was getting the never ending ENOTFOUND <dns_service_name>.

When adding all 3 localhost entries to Compass with different ports I noticed in the replicaset logs that Compass actually connected to all 3 nodes using localhost but then changed the connection to dns_service_name and disconnected, giving the ENOTFOUND error. The replicasets connect to each other using that dns_service_name. I tried modifying the replicaset init to reflect localhost and also 127.0.0.1 and then they couldnt connect to each other.

Perhaps there is a way to create a new replicaset init file that enables localhost in Compass but dns_service_name between replicasets? IDK

I ended up adding all 3 dns_service_name entries to my etc/hosts file on my MacOS dev host.

127.0.0.1 rs101
127.0.0.1 rs102
127.0.0.1 rs103

Then had to flush the dns with this
sudo dscacheutil -flushcache; sudo killall -HUP mDNSResponder

After all of that I connected with this in Compass:

mongodb://rs101:27017,rs102:28017,rs103:29017/?replicaSet=rs&ssl=false&authMechanism=DEFAULT&serverSelectionTimeoutMS=2000

There are other ways to do this such as adding a Nginx Reverse Proxy to the Docker-Compose file but this was quicker.

Hope this helps someone save a lot of wasted hours debugging that ENOTFOUND error.

Jerimiah_Ham · 2023-07-05T05:29:13.621Z

I used a similar technique to connect Compass to a remote server that had 3 instances of Mongo running as a replicated set with docker-compose. In my case, I modified /etc/hosts file to add the remote IP of the server hosting the docker containers as aliases for each named instance of mongo1, mongo2, and mongo3

± % more /etc/hosts                                                                                                  !5622
##
# Host Database
#
# localhost is used to configure the loopback interface
# when the system is booting.  Do not change this entry.
##
127.0.0.1       localhost
255.255.255.255 broadcasthost
::1             localhost
192.168.1.141   mongo1
192.168.1.141   mongo2
192.168.1.141   mongo3

Omer_Erden · 2024-02-24T00:30:51.541Z

mongodb://root:example@mongo1,mongo2,mongo3/?replicaSet=rs0 this solved my problem with username and password provided

Dharmendra_Verma · 2024-04-26T16:44:16.996Z

I also had the similar issue when I was trying to run replica set using the docker compose, I was not able to connect to the database,

This worked out for me, I added this into the /etc/hosts file

127.0.0.1       mongo1
127.0.0.1       mongo2
127.0.0.1       mongo3

then connected using
mongodb://root:example@mongo1,mongo2,mongo3/?replicaSet=rs0

RichardDev · 2024-08-21T21:52:48.190Z

The work around that doesn’t need anyone changing their hosts file is to ask devs to modify their connection string for their DB managing software of preference to use the following string:

mongodb://localhost:27017/?replicaSet=local&directConnection=true

Really strange how the flag lets the db actually reply to the connection request as it was listening correctly on the given port. Anyway, much better than fiddling with the hosts file.