Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Getting Error While accessing Hive through Hue

avatar
Contributor

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.

10 REPLIES 10

avatar
Contributor