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 <cma...@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 > cma...@mapr.com > 215-701-3146 > > On Wed, Feb 3, 2016 at 4:53 PM, John Omernik <j...@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! > > >