Return-Path: X-Original-To: apmail-drill-commits-archive@www.apache.org Delivered-To: apmail-drill-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EA0F918B92 for ; Thu, 1 Oct 2015 22:44:53 +0000 (UTC) Received: (qmail 34893 invoked by uid 500); 1 Oct 2015 22:44:53 -0000 Delivered-To: apmail-drill-commits-archive@drill.apache.org Received: (qmail 34855 invoked by uid 500); 1 Oct 2015 22:44:53 -0000 Mailing-List: contact commits-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: commits@drill.apache.org Delivered-To: mailing list commits@drill.apache.org Received: (qmail 34842 invoked by uid 99); 1 Oct 2015 22:44:53 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Oct 2015 22:44:53 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id AADE7E1552; Thu, 1 Oct 2015 22:44:53 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: bridgetb@apache.org To: commits@drill.apache.org Date: Thu, 01 Oct 2015 22:44:53 -0000 Message-Id: <3dd1d62c24c44bd98b68abc51cdacb9b@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [1/2] drill git commit: updating user auth doc to include procedure for hiding password when connecting to drill Repository: drill Updated Branches: refs/heads/gh-pages 0cfc6b620 -> 70415f269 updating user auth doc to include procedure for hiding password when connecting to drill Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/118e3eb6 Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/118e3eb6 Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/118e3eb6 Branch: refs/heads/gh-pages Commit: 118e3eb6fa07b13ae9de1d2214baaa745a0886f6 Parents: 0cfc6b6 Author: Bridget Bevens Authored: Thu Oct 1 15:08:19 2015 -0700 Committer: Bridget Bevens Committed: Thu Oct 1 15:08:19 2015 -0700 ---------------------------------------------------------------------- .../075-configuring-user-authentication.md | 24 ++++++++++++++++++-- 1 file changed, 22 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/118e3eb6/_docs/configure-drill/075-configuring-user-authentication.md ---------------------------------------------------------------------- diff --git a/_docs/configure-drill/075-configuring-user-authentication.md b/_docs/configure-drill/075-configuring-user-authentication.md index 8013800..7b495dc 100755 --- a/_docs/configure-drill/075-configuring-user-authentication.md +++ b/_docs/configure-drill/075-configuring-user-authentication.md @@ -23,10 +23,30 @@ When authentication is enabled, only Drill users who are assigned Drill cluster When user authentication is enabled, each user that accesses the Drillbit process through a client, such as SQLLine, must provide their username and password for access. -When launching SQLLine, a user must include the `–n` and `–p` parameters with their username and password in the SQLLine argument: +A user can include the `–n` and `–p` parameters with their username and password when launching SQLLine, as shown in the following example: `sqlline –u jdbc:drill:zk=10.10.11.112:5181 –n bob –p bobdrill` - When a user connects to Drill from a BI tool, such as Tableau, the MapR Drill ODBC driver prompts the user for their username and password: +Alternatively, a user can launch SQLLine and then issue the `!connect` command to hide the password, as shown in the following procedure: + +1. Start SQLLine, by running the sqlline script. On Linux, for example: + + bobsmachine:~$ /etc/drill/bin/sqlline + apache drill 1.2.0 + "a drill in the hand is better than two in the bush" + +2. At the sqlline prompt, enter the `!connect` command followed by `jdbc:drill:zk=zk=[:][,[:]... ]`. For example: +3. + sqlline> !connect jdbc:drill:zk=localhost:2181 + scan complete in 1385ms +3. At the prompts, enter a user name and password. +4. + Enter username for jdbc:drill:zk=localhost:2181: bob + Enter password for jdbc:drill:zk=localhost:2181: ************* + + The password is hidden as it is typed. + + +When a user connects to Drill from a BI tool, such as Tableau, the MapR Drill ODBC driver prompts the user for their username and password: ![ODBC Driver]({{site.baseurl}}/docs/img/UserAuth_ODBC_Driver.png)