drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Omernik <j...@omernik.com>
Subject Re: Sqlline Tricks
Date Wed, 03 Feb 2016 22:20:55 GMT
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