hue can't connect to hive over TLS

[#1]

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

[#2]

@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.h...

[#3]

@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

[#4 · Accepted solution]

@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.

[#5]

ITS GOOD