About pnmateus

pnmateus · ‎09-18-2024

Hello, This problem happened in python and in PowerBI. Both installations were made from Microsoft Store. For this problem to be solved, I had to uninstall both applications, get the instalation file from the web and install manually.

pnmateus · ‎09-10-2024

I have a VM that kerberos works perfectly. In this VM the log shows the following: Sep 10 09:22:46.050 DEBUG 17524 Simba::ThriftExtension::TEAutoSasl::TEAutoSasl: Is MIT Kerberos installed: false Sep 10 09:22:46.050 DEBUG 17524 Simba::ThriftExtension::TEAutoSasl::TEAutoSasl: use custom plugins: 1 Sep 10 09:22:46.052 DEBUG 17524 Simba::ThriftExtension::TEAutoSasl::TEAutoSasl: callback set Sep 10 09:22:46.056 DEBUG 17524 Simba::ThriftExtension::TEAutoSasl::TEAutoSasl: Sasl inited Sep 10 09:22:46.056 DEBUG 17524 Simba::ThriftExtension::TETSaslClientTransport::TETSaslClientTransport: Using SSPI: true In the VM that works fine thes keys: 1-Is MIT Kerberos installed is True 2- Using SSPI: is false Maybe is this the problem?

pnmateus · ‎09-10-2024

Hello, 1- The ODBC DataSource was created at the system level. 2- The application is running in 64 bit 3- The variable KRB5CCNAME has a path acessible only by the user. 4 - The log from the ODBC driver shows this on failed connection: Sep 10 09:22:46.113 INFO 17524 Simba::ThriftExtension::TETSaslClientTransport::SaslLoggingCallback: ::LogUsername: Username returned by QueryCredentialsAttributes(SECPKG_ATTR_NAMES): userexample@example.com Sep 10 09:22:46.113 ERROR 17524 Simba::ThriftExtension::TETSaslClientTransport::SaslLoggingCallback: ::LogUsername: User name returned by GetUsernameEx(NameUserPrincipal): userexample@example.com Sep 10 09:22:46.234 DEBUG 17524 Simba::ThriftExtension::TETSaslClientTransport::SaslLoggingCallback: Failed to initialize security context: The specified target is unknown or unreachable Note: The ticket was created with another user (userexampleOther@example.com) and the user logged in the machine is userexample@example.com

pnmateus · ‎09-09-2024

Hello everybody, I have a ODBC (DSN=IMPALA_PRD) setup to connect to Impala server through kerberos authentication. I have created the ticket in MIT with success. I've tested the connection with success. However when using the same ODBC connection on a python script or a PowerBI dashboard, it returns the error: ODBC: ERROR [HY000] [Cloudera][DriverSupport] (1110) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct and confirm if SSL should be enabled for the connection.\r\nERROR [HY000] [Cloudera][DriverSupport] (1110) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct and confirm if SSL should be enabled for the connection. For quick test i'm using this simple script: import pyodbc conn_impala = pyodbc.connect(DSN="IMPALA_PRD", autocommit = True) cursor = conn_impala.cursor() Could you please help me solve this riddle? Best regards,

Online	Offline
Last Visited	‎09-19-2024 03:59 AM

Member Since	‎09-09-2024 11:01 AM
Last Visited	‎09-19-2024 03:59 AM
Posts	4
Kudos received	3

Cloudera Community

Re: Connection malfunction ODBC to Impala using Ke...

Re: Connection malfunction ODBC to Impala using Ke...

Re: Connection malfunction ODBC to Impala using Ke...

Re: Connection malfunction ODBC to Impala using Ke...

Connection malfunction ODBC to Impala using Kerber...