Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

CA Certificates Error when trying to connect with Impala Driver LINUX

Solved Go to solution
Highlighted

CA Certificates Error when trying to connect with Impala Driver LINUX

New Contributor

I followed the instructions here for setting up and configuring the Impala driver on Linux.  When I test the connection using the isql command line utility I get the following error:

 

 

[S1000][unixODBC][Cloudera][DriverSupport] (1140) Unable to load CA certificates from certs file location.  Please ensure the file exists, has read permission, and has the correct PEM format.
[ISQL]ERROR: Could not SQLConnect

 

 

 

My odbc.ini looks like this: 

 

 

[ODBC Data Sources]

[hadoop]
  Driver=Cloudera ODBC Driver for Impala 64-bit
  AllowHostNameCNMismatch=1
  AllowSelfSignedServerCert=1
  AuthMec=3
  CheckCertRevocation=1
  DelegateKrbCreds=0
  Host={myhost}
  KrbFQDN=_HOST
  KrbRealm={myrealm}
  KrbServiceName=impala
  Min_TLS=1.2
  Port=21050
  ServicePrincipalCanonicalization=1
  SSL=1
  TrustedCerts=/opt/cloudera/impalaodbc/lib/64/cacerts.pem
  UseKeytab=0
  UseOnlySSPI=1
  UseSASL=1
  UseSystemTrustStore=1

 

 

 

And the permission on /opt/cloudera/imapalaodbc/lib/64/cacerts.pem is set to 777: 

 

 

 

-rwxrwxrwx 1 userXXX groupXXX 246K Dec 31  2018 /opt/cloudera/impalaodbc/lib/64/cac                     erts.pem

 

 

 

Can anyone help resolve this error?  The cacerts.pem file has the right permission and the file certainly exists. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: CA Certificates Error when trying to connect with Impala Driver LINUX

New Contributor

Oops.  Reading the docs it mentions "UseSystemTrustStore" is only valid for windows.  Removing this value from by odbc.ini fixes this issue.

View solution in original post

1 REPLY 1
Highlighted

Re: CA Certificates Error when trying to connect with Impala Driver LINUX

New Contributor

Oops.  Reading the docs it mentions "UseSystemTrustStore" is only valid for windows.  Removing this value from by odbc.ini fixes this issue.

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here