I'm new to retool and trying to connect to my MongoDB atlas database.
When using the connection string: mongodb+srv://rutgerhofste:<password>@serverlessinstance2.8mwqy.mongodb.net/myFirstDatabase?retryWrites=true&w=majority
replace the password
replace the database with database name
I get the error:
Saving failed. Text record must only set authSource or replicaSet
I googled the error but cannot find the answer. I follow the tutorial
Hi @rutgerhofste thanks for reaching out with this! Based on the instance hostname within the connection string you provided, I think the answer is probably Yes; but just to confirm: is the MongoDB instance that you're connecting to a part of the new MongoDB Atlas Serverless platform?
Got it, thanks for the confirmations/insights @rutgerhofste and @Dax911! I've been able to successfully reproduce this issue – I'm unable to successfully establish a connection to my MongoDB Atlas serverless instance from Retool (version 2.80.2) and observe the same error message. I've filed an internal bug ticket to have this behavior addressed – while we're not in a position to provide a fix timeline quite yet, I'll be sure to provide updates via this thread accordingly Please don't hesitate to let us know if you have any other related questions or updates in the meantime too though!
Unfortunately we need to test for and address some potential migration issues before making changes to the underlying SDK, and haven't been able to prioritize this work to support connecting to Mongodb Atlas Serverless yet. It is still in our queue of work to be done and this thread is linked internally, but we don't have an updated timeline at the moment
Hey @philipp! The SDK update would include some breaking changes for common query patterns in Retool which raises the difficulty of implementing support for Serverless MongoDB. As a result we don't have a timeline on when we'd be able to add in support for Serverless, and will only be able to connect to Dedicated or Shared clusters in the meantime.
We'll keep monitoring this thread and prioritizing that larger scale migration against work on other new resource types and authentication methods. Please chime in here with a +1 if you are coming across this as a blocker getting spun up!
Hi @hosseink! We currently support Mongo Atlas Clusters but not Mongo Atlas Serverless Instances. We're still hoping to add support for serverless in the future, but have updated the title of that section on our docs to clarify.
Hey @hsyyid! Stepping in here to let you know that we upgraded our Mongo driver to now support Atlas serverless instances. I believe the change is still behind a flag, but I can enable it for your org! Let me know if you're interesting
Any news? When creating a mongodb serverless resource the following error appears: "Unable to connect. Error: Text record must only set authSource or replicaSet "
but only in the self hosted version of retool