Bad status: 3 (PLAIN auth failed: Error validating LDAP user)

You may see the following error after logging into the Hue web interface if you have enabled LDAP and Kerberos on your cluster: “Bad status: 3 (PLAIN auth failed: Error validating LDAP user). Additionally, you may not be able to view the Hive tables. This happens because the Hive service uses LDAP to authenticate the Hue service instead of Kerberos. To resolve this issue, you must set the value of the hive.server2.authentication to KERBEROS in the Hue hive-site.xml configuration using Cloudera Manager.

  1. Log into Cloudera Manager as an Administrator.
  2. Go to Clusters > $Hue service > Configuration > Hue Server Advanced Configuration Snippet (Safety Valve) for hive-site.xml.
  3. Click View as XML and add the following lines in the text box:
    <property>
        <name>hive.server2.authentication</name>
        <value>KERBEROS</value>
    </property>
    Alternatively, you can click the Add icon to enable the Editor mode and specify hive.server2.authentication in the Name field and KERBEROS in the Value field.
  4. Click Save Changes.
  5. The hive.server2.authentication property is appended to the hive/conf/hive-site.xml file.
  6. Restart the Hue service.