KNOWLEDGE BASE

Error "ssl is required when using cleartext authentication" When Connecting to MongoDB BI Connector


Published: 13 May 2020
Last Modified Date: 14 May 2020

Issue

When connecting to the MongoDB BI Connector, the following error may occur:

Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.
Error Code: 37CE01A3
There was an unknown connection error to the database. The error message below has additional information, but you might need to ask the database administrator to review the database logs.
[MySQL][ODBC 8.0(w) Driver]ssl is required when using cleartext authentication
Unable to connect to the MongoDB BI Connector server "
<server name>". Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Desktop
  • MongoDB BI Connector

Resolution

To troubleshoot this error, try the following options:

Option 1

Start mongosqld without the --auth option.
 

Option 2

Start mongosqld with the --auth flag along with a required SSL certificate necessary to authenticate the BI Connector to clients, e.g.
--auth --sslPEMKeyFile=/mongosqld-server.pem

 

Cause

For security purposes, pass-through authentication (with --auth enabled) requires that an encrypted SSL connection is made between the BI Connector and Tableau. 

Additional Information

One way to create the .pem file is to run the shell script provided in the MongoDB tutorial for Connecting Tableau to MongoDB.
Did this article resolve the issue?