question Re: HiveServer2, is StartTLS an option for user authentication using OpenLDAP? in Support Questions

HiveServer2, is StartTLS an option for user authentication using OpenLDAP?

Steve206 — Fri, 16 Sep 2022 14:12:25 GMT

Hi all,

Currently using CDH 5.14.4 and looking to enable user authention on HiveServer2 using OpenLDAP. The two connection options I'm seeing are LDAP and LDAPS, but we currently don't have LDAPS configured with our OpenLDAP server. Hue supports LDAP with StartTLS so I figured Hive would too. I'm wondering if StartTLS is an option that I'm not finding documentation for or if its not supported.

Thanks for your help!

Re: HiveServer2, is StartTLS an option for user authentication using OpenLDAP?

Consult — Wed, 06 Mar 2019 11:04:37 GMT

Hello @Steve206,

Yup, you are right mate. Most of the documentation that I came across talks about ldaps implementation support for hs2.

Thinking loud here.. hypothetically if there was an option and with above setup of no-ssl on ad server. starttls secure connection neg. will fail anyways and it will be a standard connection.

There is an option to write pluggable class and then set authentication to custom.

Hope that helps.

Re: HiveServer2, is StartTLS an option for user authentication using OpenLDAP?

Harsh J — Thu, 07 Mar 2019 00:30:09 GMT

Currently Hive's connections to LDAP do not support the StartTLS extension [1]. This does make sense as a feature request however, could you log your request over at https://issues.apache.org/jira/projects/HIVE please?

[1] - https://github.com/apache/hive/blob/master/service/src/java/org/apache/hive/service/auth/ldap/LdapSearchFactory.java#L52-L62

Re: HiveServer2, is StartTLS an option for user authentication using OpenLDAP?

Steve206 — Thu, 07 Mar 2019 16:19:37 GMT

Thanks for the quick response. I'll look at enabling LDAPS before writing anything custom. I was being optimistic with only wanting to support StartTLS on OpenLDAP but we'll most likely come across another application at some point that only works with LDAPS.

Re: HiveServer2, is StartTLS an option for user authentication using OpenLDAP?

Steve206 — Thu, 07 Mar 2019 16:21:16 GMT

Thank you for the confirmation. Yes, I'll make a feature request.