question Re: hue can't connect to hive over TLS in Support Questions

hue can't connect to hive over TLS

abdebja — Wed, 07 Dec 2022 16:59:12 GMT

Hello all,

I have a problem with connection from hue to hive and hdfs.

For hive i have this error :

HTTPSConnectionPool(host='fqdn', port=10001): Max retries exceeded with url: /cliservice/ (Caused by SSLError(SSLError("bad handshake: Error([('SSL routines', 'ssl3_get_server_certificate', 'certificate verify failed')],)",),))

for hdfs :

Accès impossible : /user/svc_data. HTTPSConnectionPool(host='fqdn', port=14000): Max retries exceeded with url: /webhdfs/v1/user/svc_dataiku?op=GETFILESTATUS&user.name=hue&doas=svc_dataiku (Caused by SSLError(SSLError("bad handshake: Error([('SSL routines', 'ssl3_get_server_certificate', 'certificate verify failed')],)",),))

Need help please.

Regards

Re: hue can't connect to hive over TLS

steven-matison — Fri, 09 Dec 2022 13:39:46 GMT

@abdebja Have you completed HUE configuration for SSL of each services host(s)?

The docs are as follows:

https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/securing-hue/topics/hue-configuring-tls-ssl.html

Re: hue can't connect to hive over TLS

DianaTorres — Mon, 12 Dec 2022 19:44:05 GMT

@abdebja Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks

Re: hue can't connect to hive over TLS

Kartik_Agarwal — Sun, 18 Dec 2022 03:54:39 GMT

@abdebja Can you update, the config "Hue TLS/SSL Server CA Certificate (PEM Format)" with the root certificate value: /etc/security/serverKeys/cacert.crt

If you found that the provided solution(s) assisted you with your query, please take a moment to login and click Accept as Solution below each response that helped.

Re: hue can't connect to hive over TLS

PerNielsen — Sun, 18 Dec 2022 08:06:18 GMT

ITS GOOD