apache drill - plain configuration

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
0
down vote

favorite












I installed apache-drill Mode distribution only one machine (CentOS) with the requirement it needs: java8-ZooKeeper quorum.



I configured user authentication with plain security but I can not login through web API or SQLLine. I have followed the documentation in this link https://drill.apache.org/docs/configuring-plain-security



I created a username "admin2" with password and I identify Users to Serve as Drill Admins



enter image description here



Here is the configuration apache-drill-1.11.0/conf/drill-override.conf



drill.exec: 
cluster-id: "drillbits1",
zk.connect: "127.0.0.1:2181",
http.ssl_enabled: true,
encryption.sasl.enabled: true,
encryption.sasl.max_wrapped_size: 65536,
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: "pam",
pam_profiles: [ "sudo", "admin2" ]





When I try to logging and I have the following in /var/log/secure:



**pam_unix(sudo:auth): authentication failure; logname= uid=0 euid=0 tty= ruser= rhost= user=admin2**






share|improve this question


























    up vote
    0
    down vote

    favorite












    I installed apache-drill Mode distribution only one machine (CentOS) with the requirement it needs: java8-ZooKeeper quorum.



    I configured user authentication with plain security but I can not login through web API or SQLLine. I have followed the documentation in this link https://drill.apache.org/docs/configuring-plain-security



    I created a username "admin2" with password and I identify Users to Serve as Drill Admins



    enter image description here



    Here is the configuration apache-drill-1.11.0/conf/drill-override.conf



    drill.exec: 
    cluster-id: "drillbits1",
    zk.connect: "127.0.0.1:2181",
    http.ssl_enabled: true,
    encryption.sasl.enabled: true,
    encryption.sasl.max_wrapped_size: 65536,
    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: "pam",
    pam_profiles: [ "sudo", "admin2" ]





    When I try to logging and I have the following in /var/log/secure:



    **pam_unix(sudo:auth): authentication failure; logname= uid=0 euid=0 tty= ruser= rhost= user=admin2**






    share|improve this question
























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I installed apache-drill Mode distribution only one machine (CentOS) with the requirement it needs: java8-ZooKeeper quorum.



      I configured user authentication with plain security but I can not login through web API or SQLLine. I have followed the documentation in this link https://drill.apache.org/docs/configuring-plain-security



      I created a username "admin2" with password and I identify Users to Serve as Drill Admins



      enter image description here



      Here is the configuration apache-drill-1.11.0/conf/drill-override.conf



      drill.exec: 
      cluster-id: "drillbits1",
      zk.connect: "127.0.0.1:2181",
      http.ssl_enabled: true,
      encryption.sasl.enabled: true,
      encryption.sasl.max_wrapped_size: 65536,
      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: "pam",
      pam_profiles: [ "sudo", "admin2" ]





      When I try to logging and I have the following in /var/log/secure:



      **pam_unix(sudo:auth): authentication failure; logname= uid=0 euid=0 tty= ruser= rhost= user=admin2**






      share|improve this question














      I installed apache-drill Mode distribution only one machine (CentOS) with the requirement it needs: java8-ZooKeeper quorum.



      I configured user authentication with plain security but I can not login through web API or SQLLine. I have followed the documentation in this link https://drill.apache.org/docs/configuring-plain-security



      I created a username "admin2" with password and I identify Users to Serve as Drill Admins



      enter image description here



      Here is the configuration apache-drill-1.11.0/conf/drill-override.conf



      drill.exec: 
      cluster-id: "drillbits1",
      zk.connect: "127.0.0.1:2181",
      http.ssl_enabled: true,
      encryption.sasl.enabled: true,
      encryption.sasl.max_wrapped_size: 65536,
      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: "pam",
      pam_profiles: [ "sudo", "admin2" ]





      When I try to logging and I have the following in /var/log/secure:



      **pam_unix(sudo:auth): authentication failure; logname= uid=0 euid=0 tty= ruser= rhost= user=admin2**








      share|improve this question













      share|improve this question




      share|improve this question








      edited Dec 14 '17 at 15:03









      Patrick Mevzek

      2,0381721




      2,0381721










      asked Dec 14 '17 at 14:12









      flicker

      11




      11

























          active

          oldest

          votes











          Your Answer







          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "106"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          convertImagesToLinks: false,
          noModals: false,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );








           

          draft saved


          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f410879%2fapache-drill-plain-configuration%23new-answer', 'question_page');

          );

          Post as a guest



































          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes










           

          draft saved


          draft discarded


























           


          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f410879%2fapache-drill-plain-configuration%23new-answer', 'question_page');

          );

          Post as a guest













































































          Popular posts from this blog

          How to check contact read email or not when send email to Individual?

          Displaying single band from multi-band raster using QGIS

          How many registers does an x86_64 CPU actually have?