Did you already open a JIRA on this? https://issues.apache.org/jira/browse/DRILL-3880
Keys _______________________________ Keys Botzum Senior Principal Technologist [email protected] <mailto:[email protected]> 443-718-0098 MapR Technologies http://www.mapr.com <http://www.mapr.com/> > On Feb 3, 2016, at 5:14 PM, John Omernik <[email protected]> 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 <[email protected]> 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 >> [email protected] >> 215-701-3146 >> >> On Wed, Feb 3, 2016 at 4:53 PM, John Omernik <[email protected]> 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! >>> >>
