Member since
05-05-2017
2
Posts
0
Kudos Received
0
Solutions
05-16-2017
05:22 PM
Hi @Vipin Rathor, Thanks for the answer. After some more digging, we saw that Simba fixed a problem with TLS 1.2 on Hive ODBC driver version 2.1.7: http://cdn.simba.com/products/Hive/doc/Simba_Hive_ODBC_ReleaseNotes.txt After installing the 2.1.7 ODBC driver, we retried the connection and everything was working. Thanks for your support. Reza
... View more
05-05-2017
09:29 PM
Hi HCC, I'm working with a customer to help them connect to hive using ODBC and all was working well until recently, the Admins reconfigured Knox to require only TLSv1.2. Since then, the connection to Knox is failing as follows: echo "show databases" | isql -v -d, Knox
[S1000][unixODBC][Hortonworks][ThriftExtension] (6) Error occurred while contacting server: SSL_connect: error code: 0. This could be because you are trying to establish a SSL connection to a server that does not have SSL enabled.
[ISQL]ERROR: Could not SQLConnect
Here is the /etc/odbc.ini file: [Knox] HiveServerType=2
Driver =/usr/lib/hive/lib/native/Linux-amd64-64/libhortonworkshiveodbc64.so
Host=xxxxx.xxx
PORT=8443
UID=xxxxx
PWD=xxxxxxx
AuthMech=3
Schema=default
SSL=1
TrustedCerts=/somepath/certificate.cer
HTTPPath=gateway/default/hive
ThriftTransport=2
UseNativeQuery=1
CAIssuedCertNamesMismatch=1 Any ideas, how to configure the Client to use TLSv1.2?
... View more
Labels:
- Labels:
-
Apache Knox