[ https://issues.apache.org/jira/browse/RANGER-1713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Qiang Zhang updated RANGER-1713: -------------------------------- Description: Hive testConnection failed after open ldap authentication in Hive. Scenarios 1.when Hive used SIIMPLE authentication testConnection is ok. 2.When Hive used LDAP authentication testConnection is failed. Modify Hive-site.xml <property> <name>hive.server2.authentication</name> <value>LDAP</value> </property> <property> <name>hive.server2.authentication.ldap.url</name> <value>ldap://192.168.10.101 ldap://192.168.10.102</value> <description> LDAP connection URL </description> </property><property> <name>hive.server2.authentication.ldap.baseDN</name> <value>ou=People,dc=hive,dc=com</value> <description> LDAP base DN </description> </property> Result: Unable to retrieve any files using given parameters, You can still save the repository and start creating policies, but you would not be able to use autocomplete for resource names. Check ranger_admin.log for more info. org.apache.ranger.plugin.client.HadoopException: Unable to connect to Hive Thrift Server instance.. Unable to connect to Hive Thrift Server instance.. Could not open client transport with JDBC Uri: jdbc:hive2://10.43.182.241:10000: Peer indicated failure: Error validating the login. Peer indicated failure: Error validating the login. 3.Reason: Connection parameter password is incorrect .(Do not need to undertake the MD5 encryption password). 4.Solution: Use MD5 PasswordUtils decryption password. was: Hive testConnection failed after open ldap authentication in Hive. Scenarios 1.when Hive used SIIMPLE authentication testConnection is ok. 2.When Hive used LDAP authentication testConnection is failed. Modify Hive-site.xml <property> <name>hive.server2.authentication</name> <value>LDAP</value> </property> <property> <name>hive.server2.authentication.ldap.url</name> <value>ldap://192.168.10.101 ldap://192.168.10.102</value> <description> LDAP connection URL </description> </property><property> <name>hive.server2.authentication.ldap.baseDN</name> <value>ou=People,dc=hive,dc=com</value> <description> LDAP base DN </description> </property> Result: Unable to retrieve any files using given parameters, You can still save the repository and start creating policies, but you would not be able to use autocomplete for resource names. Check ranger_admin.log for more info. org.apache.ranger.plugin.client.HadoopException: Unable to connect to Hive Thrift Server instance.. Unable to connect to Hive Thrift Server instance.. Could not open client transport with JDBC Uri: jdbc:hive2://10.43.182.241:10000: Peer indicated failure: Error validating the login. Peer indicated failure: Error validating the login. Reason:Connection parameter password is incorrect .(Do not need to undertake the MD5 encryption password). Solution: use MD5 decryption password. > Hive testConnection failed after used ldap authentication in Hive. > ------------------------------------------------------------------ > > Key: RANGER-1713 > URL: https://issues.apache.org/jira/browse/RANGER-1713 > Project: Ranger > Issue Type: Bug > Components: plugins > Affects Versions: master > Reporter: Qiang Zhang > Assignee: Qiang Zhang > Attachments: > 0001-RANGER-1713-Hive-testConnection-failed-after-open-ld.patch, > HiveTestConnectionFailAfterLDAP.png > > > Hive testConnection failed after open ldap authentication in Hive. > Scenarios > 1.when Hive used SIIMPLE authentication testConnection is ok. > 2.When Hive used LDAP authentication testConnection is failed. > Modify Hive-site.xml > <property> > <name>hive.server2.authentication</name> > <value>LDAP</value> > </property> > <property> > <name>hive.server2.authentication.ldap.url</name> > <value>ldap://192.168.10.101 ldap://192.168.10.102</value> > <description> > LDAP connection URL > </description> > </property><property> > <name>hive.server2.authentication.ldap.baseDN</name> > <value>ou=People,dc=hive,dc=com</value> > <description> > LDAP base DN > </description> > </property> > Result: > Unable to retrieve any files using given parameters, You can still save the > repository and start creating policies, but you would not be able to use > autocomplete for resource names. Check ranger_admin.log for more info. > org.apache.ranger.plugin.client.HadoopException: Unable to connect to Hive > Thrift Server instance.. Unable to connect to Hive Thrift Server instance.. > Could not open client transport with JDBC Uri: > jdbc:hive2://10.43.182.241:10000: Peer indicated failure: Error validating > the login. Peer indicated failure: Error validating the login. > 3.Reason: Connection parameter password is incorrect .(Do not need to > undertake the MD5 encryption password). > 4.Solution: Use MD5 PasswordUtils decryption password. -- This message was sent by Atlassian JIRA (v6.4.14#64029)