1 Reply Latest reply on Mar 13, 2014 10:14 AM by jordan.bunker

    Tableau authentication to Cloudera Hadoop fails to authentication LDAP username and password

    Deepak Murthy

      Hello,

       

      Version:

      Tableau 8.1.4 32 bit

      Cloudera Hadoop - 2.05.05.1006 32 bit

       

      When we configure DSN Setup from Cloudera using Hive server2 we can successfully login to Hadoop. (Note we are currently using LDAP authenticatio), we need to provide username and password field here.

       

      When we try to configure same thing in Tableau -> Connect to Data --> Cloudera Hadoop Hive Connection

      Although there is Server name, Type -> HiveServer2 and Authentication - does not have Username and password it only has Username

      On entering only username it fails to authenticate and we receive error in Hadoop cluster as below:

       

       

      4:53:37.926 PM ERROR org.apache.thrift.transport.TSaslTransport

      SASL negotiation failure

      javax.security.sasl.SaslException: Error validating the login [Caused by javax.security.sasl.AuthenticationException: Error validating LDAP user]

        at org.apache.hive.service.auth.PlainSaslServer.evaluateResponse(PlainSaslServer.java:134)

        at org.apache.thrift.transport.TSaslTransport$SaslParticipant.evaluateChallengeOrResponse(TSaslTransport.java:509)

        at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:264)

        at org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTransport.java:1)

        at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:216)

        at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:227)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:662)

      Caused by: javax.security.sasl.AuthenticationException: Error validating LDAP user

        at org.apache.hive.service.auth.LdapAuthenticationProviderImpl.Authenticate(LdapAuthenticationProviderImpl.java:73)

        at org.apache.hive.service.auth.PlainSaslHelper$PlainServerCallbackHandler.handle(PlainSaslHelper.java:63)

        at org.apache.hive.service.auth.PlainSaslServer.evaluateResponse(PlainSaslServer.java:127)

        ... 8 more

       

       

      Inorder for us to continue Tableau reporting using Hadoop, we need you to further fix this issue.

       

      We contacted Hadoop support team and they mentioned to contact Tableau to fix this issue on their end.

       

      Need your help further to fix this issue and provide us the fix.