Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

LDAP with Hive issue - Unable to search for user in two different OU's

LDAP with Hive issue - Unable to search for user in two different OU's

New Contributor

Hi folks,

 

Currently using CDH 5.4.7. The idea is to get beeline authentication integrated with OpenLDAP.

This is working fine too. But only for a single OU.

 

Say I want hive to search in 2 ou's how do I do this?

 

I have currently set the following properties:

hive.server2.authentication.ldap.url

hive.server2.authentication.ldap.baseDN  - This is set to ou=people,dc=exampe,dc=com

Also I have added a snippet to be reflected on the hive-site.xml 

 

<property>
<name>hive.server2.authentication.ldap.userDNPattern</name>
<value>uid={0},ou=People,dc=example,dc=com:uid={0},ou=Service Accounts,dc=example,dc=com</value>
</property>

 

I have tried different combinations with uid=%s, uid={0}, specifying to the uid with the baseDN, but of no use.

Am i missing something here?

 

Thanks

1 REPLY 1

Re: LDAP with Hive issue - Unable to search for user in two different OU's

New Contributor

If the post above is not clear:
This is the summary:
User JohnDoe wants access to Hive.

The current OU is ou=people, but user John is a part of the ou=Service Accounts. Login is failing as hive is only looking at ou people. How can I add another ou in the properties, so that a search for the user is done.

 

Thanks.