connecting to HIVE secured with LDAP
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 25/100
- Issue type
- Documentation
- Clarity
- Needs clarification
- Activity status
- Stale
- Tech stack
- python
- Domain
- databases, documentation
Research direction
Review PyHive’s LDAP-related connection and authentication behavior and issue #257 first; the report names no source file or test. Reproduce the self-signed-certificate failure, then document a verified setup or clearly record whether LDAP is unsupported, including the truststore requirements.
Written by the indexing model from the issue text.
Description
Hi,
I think previous posts showed that pyhive has issues connecting to an ldap secured cluster (https://github.com/dropbox/PyHive/issues/257). There was mention of a package to fix it (pure-transport by @devinstevenson ). However we failed to have success. The repo mentioned is about 2 years old. Is there any update on this? Does pyhive already support ldap in some way himself and is there a recent/detailed example available on how to do this?
When we connect from an outside server to the ldap secured hive instance (using a self-singed certificate), we get:
thriftpy.transport.TTransportException: TTransportException(type=1, message="Bad status: 3 (b'PLAIN auth failed: javax.security.sasl.AuthenticationException: Error validating LDAP user [Caused by javax.naming.CommunicationException: simple bind failed: aserver.local:636 [Root exception is javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target]]')")
This seems to be an error indicating that the machine from where we are connecting does not trust the certificate that the LDAP-secured cluster with hive is using. We failed to find a detailed description of what to do to fix this (it is often mentioned one shuold add the certificate to the truststore on the machine from where we are connecting).
Thanks for update!
- Dominant language
- Python
- Stars
- 1.7k
- Forks
- 545
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from dropbox/PyHive
-
Difficulty 4/5 3-5 days Newbie friendliness 25/100
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
Difficulty 5/5 Over a week Newbie friendliness 20/100
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
-
enhancement
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100