Error validating LDAP user

You may see an “Bad status: 3 (PLAIN auth failed: Error validating LDAP user) error message after logging into the Hue web interface, if you have enabled LDAP and Kerberos on your cluster. 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 + 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.