Drill Security Plain Authentication- Error

[Prabhakar Bhosale]

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