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