Created on 02-23-2019 10:42 PM - edited 09-16-2022 07:11 AM
I encountered below error in my laptop while using the ODBC to Get Data in Power BI Desktop.
My environment:
Hadoop
Laptop
/etc/krb5.conf
[libdefaults]
default_realm = CLOUDERA
dns_lookup_kdc = false
dns_lookup_realm = false
ticket_lifetime = 86400
renew_lifetime = 604800
forwardable = true
default_tgs_enctypes = rc4-hmac
default_tkt_enctypes = rc4-hmac
permitted_enctypes = rc4-hmac
udp_preference_limit = 1
kdc_timeout = 3000
[realms]
CLOUDERA = {
kdc = quickstart.cloudera
admin_server = quickstart.cloudera
}
[domain_realm]
Connect to Kerberized Hive thru Microsoft Hive ODBC:
From Power BI, Get Data -> ODBC -> select my ODBC
I entered username and password in Database tab:
username: cloudera
password: cloudera
Error in Power BI while connecting to Hive through the ODBC:
Details: "ODBC: ERROR [HY000] [Microsoft][Hardy] (34) Error from server: SASL(-1): generic failure: Failed to initialize security context: No authority could be contacted for authentication.
.
ERROR [HY000] [Microsoft][Hardy] (34) Error from server: SASL(-1): generic failure: Failed to initialize security context: No authority could be contacted for authentication.
I tested the ODBC in 64 Bit ODBC Admin without any errors. In addition, I am able to use the ODBC in DBeaver.
Please shed some light on this error.
Thank you.
Created 03-06-2019 12:26 AM
Created 03-06-2019 04:59 AM
Yes, no problems. "quickstart.cloudera" is in the hosts file.
Created 03-07-2019 01:31 AM
Created 03-07-2019 09:00 PM
C:\ProgramData\MIT\Kerberos5\krb5.ini
[libdefaults]
default_realm = CLOUDERA
dns_lookup_kdc = false
dns_lookup_realm = false
ticket_lifetime = 86400
renew_lifetime = 604800
forwardable = true
default_tgs_enctypes = rc4-hmac
default_tkt_enctypes = rc4-hmac
permitted_enctypes = rc4-hmac
udp_preference_limit = 1
kdc_timeout = 3000
[realms]
CLOUDERA = {
kdc = quickstart.cloudera
admin_server = quickstart.cloudera
}
Thank you.
Created 03-09-2019 10:57 PM
Created 03-11-2019 08:02 PM
See below.
Volume in drive C is OS Volume Serial Number is 2261-6617 Directory of C:\ProgramData\Anaconda3\Library\bin 10/26/2018 02:44 PM 75,264 krb5.exe 1 File(s) 75,264 bytes Directory of C:\ProgramData\Anaconda3\Library\include 12/20/2018 04:30 PM <DIR> krb5 05/03/2018 07:33 AM 402 krb5.h 1 File(s) 402 bytes Directory of C:\ProgramData\Anaconda3\Library\include\krb5 10/26/2018 02:40 PM 342,049 krb5.h 1 File(s) 342,049 bytes Directory of C:\ProgramData\MIT\Kerberos5 09/13/2018 09:44 PM 394 krb5.ini 1 File(s) 394 bytes Directory of C:\Users\All Users\Anaconda3\Library\bin 10/26/2018 02:44 PM 75,264 krb5.exe 1 File(s) 75,264 bytes Directory of C:\Users\All Users\Anaconda3\Library\include 12/20/2018 04:30 PM <DIR> krb5 05/03/2018 07:33 AM 402 krb5.h 1 File(s) 402 bytes Directory of C:\Users\All Users\Anaconda3\Library\include\krb5 10/26/2018 02:40 PM 342,049 krb5.h 1 File(s) 342,049 bytes Directory of C:\Users\All Users\MIT\Kerberos5 09/13/2018 09:44 PM 394 krb5.ini 1 File(s) 394 bytes Directory of C:\Users\chenc5\AppData\Local\conda\conda\pkgs\krb5-1.16.1-hc04afaa_7\Library\bin 10/26/2018 02:44 PM 75,264 krb5.exe 1 File(s) 75,264 bytes Directory of C:\Users\chenc5\AppData\Local\conda\conda\pkgs\krb5-1.16.1-hc04afaa_7\Library\include 12/20/2018 04:21 PM <DIR> krb5 05/03/2018 07:33 AM 402 krb5.h 1 File(s) 402 bytes Directory of C:\Users\chenc5\AppData\Local\conda\conda\pkgs\krb5-1.16.1-hc04afaa_7\Library\include\krb5 10/26/2018 02:40 PM 342,049 krb5.h 1 File(s) 342,049 bytes Total Files Listed: 11 File(s) 1,253,933 bytes 3 Dir(s) 273,797,316,608 bytes free
Created 03-13-2019 12:16 AM
Created 03-16-2019 07:09 PM
See below.
cat "C:\ProgramData\MIT\Kerberos5\krb5.ini" [libdefaults] default_realm = CLOUDERA dns_lookup_kdc = false dns_lookup_realm = false ticket_lifetime = 86400 renew_lifetime = 604800 forwardable = true default_tgs_enctypes = rc4-hmac default_tkt_enctypes = rc4-hmac permitted_enctypes = rc4-hmac udp_preference_limit = 1 kdc_timeout = 3000 [realms] CLOUDERA = { kdc = quickstart.cloudera admin_server = quickstart.cloudera } cat "C:\Users\All Users\MIT\Kerberos5\krb5.ini" [libdefaults] default_realm = CLOUDERA dns_lookup_kdc = false dns_lookup_realm = false ticket_lifetime = 86400 renew_lifetime = 604800 forwardable = true default_tgs_enctypes = rc4-hmac default_tkt_enctypes = rc4-hmac permitted_enctypes = rc4-hmac udp_preference_limit = 1 kdc_timeout = 3000 [realms] CLOUDERA = { kdc = quickstart.cloudera admin_server = quickstart.cloudera }
Created 03-13-2019 12:27 AM