You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Prabhakar Bhosale <bh...@gmail.com> on 2022/08/22 07:46:39 UTC

Drill Security Plain Authentication- Error

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

Re: Drill Security Plain Authentication- Error

Posted by Prabhakar Bhosale <bh...@gmail.com>.
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 <dz...@apache.org> 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
> >
>
>

Re: Drill Security Plain Authentication- Error

Posted by James Turton <dz...@apache.org>.
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
>