KNOWLEDGE BASE

Error when connecting to Cloudera Impala in Tableau Desktop: " SSL_CTX_load_verify_locations: bad decrypt"


Published: 21 Mar 2017
Last Modified Date: 01 Nov 2017

Issue

When connecting to Cloudera with Impala and SSL, an error may occur: 
[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; Improper Link; system lib; system lib

Environment

  • Tableau Desktop 10.1.1
  • Windows Server 2012
  • Cloudera Hadoop Hive

Cause

When connecting to Cloudera with Impala and SSL specified, Tableau Desktop uses the connectstring value "AuthMech=4". This is the value to declare that username and password are being used along with SSL. However in some cases SSL needs to be explicitly declared in addition to this AuthMech value.
Did this article resolve the issue?