Hello I’m trying to connect a DigitalOcean Managed...
# replication-troubleshootings
Stratos Giouldasis
10/25/2022, 2:55 PMHello I’m trying to connect a DigitalOcean Managed MongoDB which has a DNS Seed List connection string, I have tried:
• connecting with standalone by passing the hostname of the first server in the replica set
• connecting with Replica Set by passing the hostnames (I only have 1 server in the replica set, so only one server)
• connecting with MongoDB Atlas and just providing hostname/dbname?tls=true&authSource=admin&replicaSet=db-mongodb-shared
Stratos Giouldasis
10/25/2022, 2:57 PMOn all 3 scenarios I test connection and it works
Stratos Giouldasis
10/25/2022, 2:57 PMThen I reach “We are fetching the schema of your data source.”
Stratos Giouldasis
10/25/2022, 2:57 PMScreenshot 2022-10-25 at 17.57.36.png
Stratos Giouldasis
10/25/2022, 2:58 PMOn all 3 scenarios the same error happens
Stratos Giouldasis
10/25/2022, 2:59 PMI tried with
adminStratos Giouldasis
10/25/2022, 3:04 PMI have set the authSource=admin from day 1 but it just seems to ignore it - is there a way to pass the connection string directly instead of using these forms? then I could control how this is read from the inputs to the server
u
user
10/25/2022, 3:11 PMHi! It looks like right now the MongoDB source connector only accepts the Standard Connection String Format:
https://www.mongodb.com/docs/manual/reference/connection-string/?_ga=2.166037693.2064241928.1654681455-80498819.1654681453#standard-connection-string-format
Could you please open a connection request for this in GitHub?
s
Stratos Giouldasis
10/25/2022, 3:17 PM@Nataly Merezhuk (Airbyte) I see here it supports other methods too https://docs.airbyte.com/integrations/sources/mongodb-v2/
Stratos Giouldasis
10/25/2022, 3:17 PMMy mongodb instance is Replica Set
Stratos Giouldasis
10/25/2022, 3:17 PMand works like MongoDB Atlas
u
user
10/25/2022, 6:44 PMI see! Apologies, I misread a piece of documentation.
It looks like this is an issue with the MongoDB user. Just to double check, did you follow the docs when creating the user for this connection?
https://docs.airbyte.com/integrations/sources/mongodb-v2#create-users
Here's another issue that was dealing with this:
https://github.com/airbytehq/airbyte/issues/8752#issuecomment-1019887350
s
Stratos Giouldasis
10/26/2022, 10:22 AMHmm ok I’ll have a look over the next days and get back to you on that
3 Views