Hi,
We are using HDP-2.3.4.0 and Hue-3.8 in our environment. We have enabled SSL for Hiveserver2. We haven't enabled SSL for Hue.
Now, when we are trying to access SSL enabled Hive through Hue we are getting following error:
Error!
Failed to retrieve tables for database: default
[Errno 185090050] _ssl.c:344: error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib
In hue.ini, under besswax I set following:
[[ssl]]
# SSL communication enabled for this server. (optional since Hue 3.8)
enabled=true
# Path to Certificate Authority certificates.
cacerts=/home/dev/hive-certificate/ca-chaincert.pem
# Choose whether Hue should validate certificates received from the server.
validate=true
ca-chaincert.pem has following certificates:
echo -n | openssl s_client -connect hadmgrndcc03-2.test.org:10001 | sed -ne '/-BEGIN CERTIFICATE-/,/-END CERTIFICATE-/p' > hadmgrndcc03-2.test.org.pem
keytool -import -alias hadmgrndcc03-2.test.org -file hadmgrndcc03-2.test.org.pem -keystore ca-chaincert.pem
keytool -import -alias rootca -file rootca -keystore ca-chaincert.pem
keytool -import -alias intermediate -file intermediate -keystore ca-chaincert.pem
How to access SSL enabled Hive through Hue? What configurations needs to be done?
Please suggest.
Thanks.
