Member since
01-31-2019
11
Posts
0
Kudos Received
0
Solutions
02-27-2019
10:43 PM
@Hadoopuser wrote: Hi What are the values to be passed for these parameters SSL= 1
UseSASL=0 Description= Driver= HOST= PORT= Database=dbname AuthMech=4 UID=username PWD=password SSL=1 CAIssuedCertNamesMismatch=1 TrustedCerts= KrbFQDN= KrbRealm= KrbServiceName= TSaslTransportBufSize=1000 RowsFetchedPerBlock=10000 SocketTimeout=0 StringColumnLength=32767 UseNativeQuery=0 <used SASL>
... View more
02-10-2019
10:52 PM
Hi What are the values to be passed for these parameters SSL= 1
UseSASL=0 Description= Driver= HOST= PORT= Database=dbname AuthMech=4 UID=username PWD=password SSL=1 CAIssuedCertNamesMismatch=1 TrustedCerts= KrbFQDN= KrbRealm= KrbServiceName= TSaslTransportBufSize=1000 RowsFetchedPerBlock=10000 SocketTimeout=0 StringColumnLength=32767 UseNativeQuery=0
... View more
02-07-2019
07:32 PM
DBI connect() failed: [unixODBC][Cloudera][ThriftExtension] (5) Error occurred while contacting server: No more data to read.. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server. DBI connect('',...) failed: [unixODBC][Cloudera][KerberosSupport] (0) Error occurred during Kerberos library operation: Preauthentication failed DBI connect('',...) failed: [unixODBC][Cloudera][ThriftExtension] (5) Error occurred while contacting server: No more data to read.. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server. DBI connect('',...) failed: [unixODBC][Cloudera][ThriftExtension] (2) Error occured during authentication.
... View more
02-07-2019
02:13 AM
[unixODBC][Cloudera][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. when Description= Driver= HOST= PORT= Database=dbname AuthMech=4 UID=username PWD=password SSL=1 CAIssuedCertNamesMismatch=1 TrustedCerts= KrbFQDN= KrbRealm= KrbServiceName= TSaslTransportBufSize=1000 RowsFetchedPerBlock=10000 SocketTimeout=0 StringColumnLength=32767 UseNativeQuery=0
... View more
02-07-2019
01:50 AM
TEUtils::DeriveKerberosHostFQDN: Special value _HOST specified for Host FQDN connfiguration. Using abcde for Host FQDN instead. ERROR Connection::SQLConnectW: [Cloudera][ThriftExtension] (2) Error occured during authentication. DSConnecionUtils::ReadConnectionSetting: Successfully read AuthMech from connection string/DSN. DSConnectionUtils::ReadBooleanSetting: +++++ enter +++++ TRACE DSConnectionUtils::ReadSetting: +++++ enter +++++ DEBUG DSConnecionUtils::ReadSetting: Reading UseSASL from connection string/DSN. TRACE DSConnectionUtils::ReadConnectionSetting: +++++ enter +++++ TRACE DSConnectionUtils::ReadConnectionSetting: +++++ enter +++++ DEBUG DSConnecionUtils::ReadConnectionSetting: UseSASL not available from connection string/DSN. Trying the aliases if any. DEBUG DSConnecionUtils::ReadConnectionSetting: No alias available for UseSASL. DEBUG DSConnecionUtils::ReadSetting: UseSASL not available from connection string/DSN. Reading it from driver wide configurations. TRACE DSConnectionUtils::ReadDriverWideSetting: +++++ enter +++++ DEBUG DSConnecionUtils::ReadDriverWideSetting: UseSASL not available from driver-wide configurations. Trying the aliases if any. DEBUG DSConnecionUtils::ReadDriverWideSetting: No alias available for UseSASL. TRACE DSConnectionUtils::ReadUTF8StringSetting: +++++ enter +++++ TRACE DSConnectionUtils::ReadSetting: +++++ enter +++++ DEBUG DSConnecionUtils::ReadSetting: Reading UID from connection string/DSN.
... View more
01-31-2019
11:24 PM
Hi,
I am using Hive/Impala ODBC Connection. I am able to connect with Hive ODBC and not with Impala ODBC
I am getting the following error.
[unixODBC][Cloudera][KerberosSupport] Error occurred during Kerberos library operation: Preauthentication failed (SQL-HY000)
DBI connect('dsnname',username,...) failed: [unixODBC][Cloudera][ThriftExtension] (2) Error occured during authentication. (SQL-28000) .
[unixODBC][Cloudera][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. (SQL-HY000)
What are the parameters i need to check in odbc.ini file?
using same Kinit for Hive and Impala.
How to trouble shoot this issue?
Can anyone help?
Thanks.
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Impala
-
Kerberos