MongoDB - non-SSL connection
When adding a data connection to to a MongoDB instance I am repeatedly getting the following error:
Failed to authenticate. Verify the credentials and try again. Timed out after 30000 ms while waiting for a server that matches ReadPreferenceServerSelector{readPreference=primary}. Client view of cluster state is {type=UNKNOWN, servers=[{address=<my_server>.<my_provider>.com:<port_number>, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketWriteException: Exception sending message}, caused by {javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake}, caused by {java.io.EOFException: SSL peer shut down incorrectly}}]
Is there a requirement that all connection be SSL?
I know the connector is listed as Beta but I didn't see anything anywhere confirmingthat SSL is required.
Comments
-
Based on our experiance pretty sure SSL is required.
1 -
Thanks for following up. It would be valuable to know if there is an option to use non-SSL or if it is on the roadmap. It is holding back reporting on a project and the current work around is to write a custom API and then call that API via Google Sheets and then hook Domo into Google Sheets. It is a bit hacky and direct DB access would be easier to build, maintain, and diagnose.
Thanks.
0 -
It could be possible but there a couple roadblocks. A) It requires a separate service/machine to run the job. (this is a frequently updated data set),
Said box needs to be Windows based - everything here is Linux & Mac, and C) ETL and post processing would still be required before getting into Domo - like what I have to do now with the GSheets.
Knowing that MongoDB support is already in there, just with no option for non-SSL, seems like a MUCH easier customer-wide fix rather than requiring customers to jump through hoops.
0 -
The workaround for 1 and 2 (which is what we do) is have VM with Windows 7 or Windows 10 just for Workbench to run. It's fairly cheap and easy to get working.
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 510 Automate
- 114 Apps
- 388 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive