HUE | Cannot use Hive and Impala query editors | Bad status: 3 (Error validating the login)

0 votes
35 views
asked Aug 30, 2017 in Hadoop by admin (4,410 points)
Summary

Symptoms

Hue logs are showing error messages like these:

[05/Apr/2017 12:09:32 -0400] conf ERROR Failed to authenticate to Impalad, check authentication configurations.
Traceback (most recent call last):
File "/opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hue/apps/impala/src/impala/conf.py", line 186, in config_validator
server.get_databases()
File "/opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/dbms.py", line 149, in get_databases
databases = self.client.get_databases(schemaName=database_names)
File "/opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 1117, in get_databases
return [table[col] for table in self._client.get_databases(schemaName)]
...
[05/Apr/2017 12:29:01 -0400] conf ERROR Failed to authenticate to HiveServer2, check authentication configurations.
Traceback (most recent call last):
…
File "/opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hue/apps/beeswax/src/beeswax/conf.py", line 211, in config_validator
server.get_databases()
File "/opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/dbms.py", line 149, in get_databases
databases = self.client.get_databases(schemaName=database_names)
File "/opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 1117, in get_databases
return [table[col] for table in self._client.get_databases(schemaName)]
...
StructuredThriftTransportException: Bad status: 3 (Error validating the login) (code THRIFTTRANSPORT): TTransportException('Bad status: 3 (Error validating the login)',)

Applies To
  • CDH 5.x
  • LDAP authentication enabled for HS2 or for Impala
  • Hue uses LDAP to connect to HS2 or to Impala ("ldap_password" has been set under [desktop] section of Hue configuration)
Cause

If Hue configuration contains

[desktop] 
ldap_password=xxxx

then this password will be used to connect to HiveServer2 and to Impala with the username of "hue" (default username).

This symptom happens usually when "hue" account was locked/expired in the LDAP server.

Instructions

Check in the LDAP server whether the "hue" user is locked, disabled or has an expired password. If this is the case then: 

  • Stop all the Hue servers
  • Reset the password for the "hue" user in the LDAP user (unlock it)
  • If the password has been changed for the "hue" user in LDAP then apply the new password in the Hue configuration
  • Start Hue servers

Please log in or register to answer this question.

...