KNOWLEDGE BASE

SSL_CTX_load_verify_locations: bad decrypt; No such process; no such file; system lib


Published: 04 Nov 2019
Last Modified Date: 05 Nov 2019

Issue

When trying to publish a live data source to Tableau Server (or share it with another Tableau Desktop user) from an SSL-enabled Hive-type database (e.g. Cloudera) , you may get the following error:

"Unable to connect to the ODBC Data Source. Check that the necessary drivers are installed and that the connection properties are valid.

[Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: SSL_CTX_load_verify_locations: bad decrypt; bad decrypt; bad decrypt; bad decrypt; bad decrypt; bad decrypt; bad decrypt; bad decrypt; bad decrypt; bad decrypt; bad decrypt; bad decrypt; No such process; no such file; system lib

Unable to connect to the Cloudera Hadoop server "Database.URL.Here". Check that the server is running and that you have access privileges to the requested database."



 

Environment

  • Tableau Server 2018.3.5
  • Hadoop Hive
  • cacerts.pem file in use (or similar)

Resolution

Ensure that the cacerts.pem file (or similar) that holds the certificates used to form a connection to the Hive database is in the proper location. It needs to be at the same absolute path that is was on the Tableau Desktop computer that formed the data source.

 

Cause

Hadoop Hive sometimes uses a locally stored .pem file to house certificates used as part of the connection process.  The data source formed in Tableau Desktop has a reference to the absolute path of that .pem file.  If the .pem file is in a different place, or does not exist, the drivers will be unable to find it and we get the error noted in this article.
Did this article resolve the issue?