Re: Drill Security Plain Authentication- Error

[James Turton]

You need to provide credentials when starting embedded Drill. Have a 
look at the output of drill-embedded --help and try something like 
drill-embedded -n alice -p top_secret

On 2022/08/22 09:46, Prabhakar Bhosale wrote:
Hi Team,
I am having Drill 1.20.1 in embedded mode and trying to set up plain
authentication using the htpasswd file. After setting up everything as
given in documentation getting error as
Error: Failure in connecting to Drill:
org.apache.drill.exec.rpc.NonTransientRpcException:
javax.security.sasl.SaslException: Server requires authentication using
[PLAIN]. Insufficient credentials?. [Details: Encryption: disabled ,
MaxWrappedSize: 65536 , WrapSizeLimit: 0]. (state=,code=0)

I tied creating htpasswd file both plain password and MD5 but still
same error

Below is my drill-override.conf

drill.exec: {
   cluster-id: "drillbits1",
   zk.connect: "localhost:2181",

   http.memory.heap.failure.threshold = 2,


   impersonation: {
    enabled: true,
    max_chained_user_hops: 3
  },
  security: {
          auth.mechanisms : ["PLAIN"],
           },
  security.user.auth: {
          enabled: true,
          packages += "org.apache.drill.exec.rpc.user.security",
          impl: "htpasswd",
          htpasswd.path:
"/app/archival/drill/apache-drill-1.20.1/conf/htpasswd"
   }

}

Please help

Thanks
Prabhakar