Skip to main content
Topics#Tableau Desktop & Web AuthoringSandip Sharma の質問
Sandip Sharma が「#Tableau Desktop & Web Authoring」で質問
2021年5月11日 10:56

handshake error: unable to authenticate conversation 0: sasl conversation error: unable to authenticate using mechanism "SCRAM-SHA-1" - Mongo dB with Tableau

Hi All,

 

I am experiencing issue while connecting mongodb with auth in tableau using mongo dB BI connector and getting following error.

 

handshake error: unable to authenticate conversation 0: sasl conversation error: unable to authenticate using mechanism "SCRAM-SHA-1"

 

Use Case:

  1. We have tableau server hosted on Ubuntu 18.04 64 bit in AWS cloud.
  2. We have mongo dB hosted in AWS in other VM with authentication enabled
  3. Have installed mongo dB BI connector in Tableau server and configured according to the need of mongo dB server. BI connector is able to reach to server easily.

Note: due to security reason we cannot share the full screen shot but last row is important which shows that BI connector reached to mongo dB server

 

4 . When we are trying to connect using Tableau Desktop or Tableau Server directly we are getting following error in BI connector and Tableau.

 

handshake error: unable to authenticate conversation 0: sasl conversation error: unable to authenticate using mechanism BI Connector

Mongo error TableauNote: There is no issue with the user ID and password as we are using the same cred in BI connector which is working fine.

4 件の回答
  1. Sandip Sharma
    2021年6月2日 11:55

    @Ciara Brennan​ : I am able to solve this issue after lots of struggle, finally got to know that Mongo obdc drive (Latest one 1.4) has some issue in supporting SCRAM-SHA-1 SSL. Tried using different driver (1.1) it started working.

回答を記入...
0/9000