Hi James, Thanks for the details, in my previous email I forgot to mention the command I used to start the drill. Below is the command I was using *./sqlline –u 'jdbc:drill:zk=local:2181' –n 'uuse_name' –p 'password'*
I tried with the command you gave and still getting the same error message. REgards Prabhakar On Mon, Aug 22, 2022 at 7:43 PM James Turton <[email protected]> wrote: > 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 > > > >
