Unable to connect to Atlas mongo
Added ssl true
Also added IP access list whitelisting for the mongo-bi connector instance.
The error from /logs/mongosqld.log
2023-10-09T06:36:33.047+0000 W SCHEMA [manager] error initializing schema: unable to execute command: server selection error: context deadline exceeded, current topology: { Type: ReplicaSetNoPrimary, Servers: [{ Addr: pl-0-eastus2-azure.9dybe.mongodb.net:1024, Type: Unknown, Average RTT: 0, Last error: connection() error occured during connection handshake: context deadline exceeded }, { Addr: pl-0-eastus2-azure.9dybe.mongodb.net:1025, Type: Unknown, Average RTT: 0, Last error: connection() error occured during connection handshake: context deadline exceeded }, { Addr: pl-0-eastus2-azure.9dybe.mongodb.net:1026, Type: Unknown, Average RTT: 0, Last error: connection() error occured during connection handshake: context deadline exceeded }, ] }
Trying to run
mongosqld version: v2.14.11
git version: 5070114f09366f9d61a9de205596ef733f704d5b
openssl version: OpenSSL 3.0.2 15 Mar 2022
openssl build version: OpenSSL 3.0.2 15 Mar 2022
Running on ubuntu 22.04 container image.
From the container able to run mongosh:
mongosh mongodb+srv://@cluster-pl-0.8dyde.mongodb.net/testdb
Mongo version used is 5.0.21 for Mongo atlas.
Why should the SSL connection from mongo-bi-connector to mongo atlas fail
Anyother configuration to be done ?