drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Matta <cma...@mapr.com>
Subject Re: Sqlline Tricks
Date Wed, 03 Feb 2016 22:23:34 GMT
How about this bash script I just whipped up for a workaround for now?

#!/bin/bash
   USERNAME=$1
   PASSWORD=$2

   if [[ -z $USERNAME ]];
   then
       echo "Please enter at least a username"
       exit 1
   fi

   if [[ -z $PASSWORD ]];
   then
       read -s -p "Enter Password for ${USERNAME}: " PASSWORD
       echo ""
   fi

   /opt/mapr/drill/drill-1.4.0/bin/sqlline -u jdbc:drill: -n $USERNAME
-p $PASSWORD

​

Chris Matta
cmatta@mapr.com
215-701-3146

On Wed, Feb 3, 2016 at 5:20 PM, John Omernik <john@omernik.com> wrote:

> LOL So I did.
>
> I saw them as two things. "Not putting the password at the command line"
> vs. Specifying the Connect string URL without user or pass and then getting
> prompted... but in reality they really are the same thing aren't they?
>
>
>
> On Wed, Feb 3, 2016 at 4:18 PM, Keys Botzum <kbotzum@maprtech.com> wrote:
>
> > Did you already open a JIRA on this?
> >
> > https://issues.apache.org/jira/browse/DRILL-3880
> >
> >
> > Keys
> > _______________________________
> > Keys Botzum
> > Senior Principal Technologist
> > kbotzum@maprtech.com <mailto:kbotzum@maprtech.com>
> > 443-718-0098
> > MapR Technologies
> > http://www.mapr.com <http://www.mapr.com/>
> > > On Feb 3, 2016, at 5:14 PM, John Omernik <john@omernik.com> wrote:
> > >
> > > Ya, Andries, that's effectively what I did with my script, I passed the
> > url
> > > with -u, but without the username and password provided on the command
> > > line, I get an auth error.  If there truly is no way to ask for
> > > username/password when providing auth string, I may open a JIRA on
> that,
> > I
> > > think it would be a helpful feature. Right now my work around is to use
> > the
> > > bash script to echo out what they need to type to get into drill :)
> > >
> > >
> > >
> > > On Wed, Feb 3, 2016 at 4:03 PM, Christopher Matta <cmatta@mapr.com>
> > wrote:
> > >
> > >> The only way I know of getting sqlline to ask for a password is to run
> > the
> > >> !connect command after starting the shell:
> > >>
> > >> $ /opt/mapr/drill/drill-1.4.0/bin/sqlline
> > >> apache drill 1.4.0
> > >> "a drill in the hand is better than two in the bush"
> > >> sqlline> !connect jdbc:drill:
> > >> scan complete in 427ms
> > >> Enter username for jdbc:drill:: cmatta
> > >> Enter password for jdbc:drill:: **************
> > >>
> > >> I’m not sure how to send that string to the sqlline shell once it’s
> > opened
> > >> though..
> > >> ​
> > >>
> > >> Chris Matta
> > >> cmatta@mapr.com
> > >> 215-701-3146
> > >>
> > >> On Wed, Feb 3, 2016 at 4:53 PM, John Omernik <john@omernik.com>
> wrote:
> > >>
> > >>> Hey all, I am trying to "Ease" my users into using drill.
> > >>>
> > >>> One thing that I'd like to automate for them is the initial
> connection,
> > >>> basically, my zk string
> > >>>
> > >>> jdbc:drill:zk:zknode1:5181,zknode2:5181,zknode3:5181
> > >>>
> > >>> Is a bit of pain, in addition, my users have to find sqlline, so what
> > if
> > >> I
> > >>> change versions etc... my idea was to put an executable script in
> > >> /usr/sbin
> > >>> named zetadrill (zeta is a nod To Mr. Scott!)
> > >>>
> > >>> Basically, that has the path and I hoped the connect string so users
> > >> would
> > >>> not have to find my sqlline, nor would they have to know/remember
> > >> zookeeper
> > >>> information. Ideal world: They'd type zetadrill and it would say
> > "Please
> > >>> enter Username" "Please enter password" and they'd be good to go.
> > >>>
> > >>> So I tried using -u flag.
> > >>>
> > >>> When I do that (without a username and password) it fails out on me,
> > >>> basically telling me that auth failed (invalid user credentials).
> > >>>
> > >>> I obviously can't put a username and password in the script, running
> > the
> > >>> connect with -u and -n (no password) results in the same failure.
> > >>>
> > >>> I guess I am asking: Is there any way to provide a connection string,
> > and
> > >>> then have sqlline prompt for credentials? This would make the user
> exp
> > so
> > >>> much better.
> > >>>
> > >>> Thanks in advanced!
> > >>>
> > >>
> >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message