Re: How to setup user authentication for the WebUI?

2015-11-12 Thread Jacques Nadeau
I see the disconnect. I was responding to the block of text below. The last three bullet points below are false. Administrator Privileges When authentication is enabled, only Drill users who are assigned Drill cluster administrator privileges can perform the following tasks: - Change a sys

Re: How to setup user authentication for the WebUI?

2015-11-12 Thread Kristine Hahn
> > Having that be 404 doesn't seem great either. Right. In this case, users probably won't encounter the problem again. The doc title/URL change occurred before the feature was released. It's likely not a URL that anybody except reviewers like Andries bookmarked. It seemed "right" to change the d

Re: How to setup user authentication for the WebUI?

2015-11-12 Thread Jacques Nadeau
We should be cautious about changing these urls. I don't know about others but I used search to get to the page. Having that be 404 doesn't seem great either. Do we have any way to accommodate redirects in the docs? On Nov 12, 2015 1:00 PM, "Kristine Hahn" wrote: > Fixed: > > https://drill.apache

Re: How to setup user authentication for the WebUI?

2015-11-12 Thread Kristine Hahn
Fixed: https://drill.apache.org/docs/configuring-web-console-and-rest-api-security/ is the correct URL to the page. https://drill.apache.org/docs/configuring-web-ui-and-rest-api-security/ is an obsolete url and is now not found. Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn skype:kris

Re: How to setup user authentication for the WebUI?

2015-11-12 Thread Jacques Nadeau
There is a lot of confusion here. I'll try to clear it up a little bit: - Apache Drill 1.2 does not support web authentication. The Apache Drill docs incorrectly state that it does. (it sounds like maybe Kristine is saying these will be fixed shortly) - MapR has released their own version of Drill

Re: How to setup user authentication for the WebUI?

2015-11-12 Thread Kristine Hahn
The doc link Andries mentioned is an obsolete cached version that should have been (and will be) removed. Please see the recently clarified (thanks Andries!) MapR docs for Web Console security info: http://doc.mapr.com/display/MapR/Starting+the+Web+Console http://doc.mapr.com/display/MapR/Configur

RE: How to setup user authentication for the WebUI?

2015-11-12 Thread Kevin Verhoeven
I have the same problem, using Ubuntu 14.04 and Drill 1.2.0. After following the instructions I am not offered a way to authenticate on the Web UI. The problem is when I run a query using the Web UI I receive the following error: org.apache.drill.exec.rpc.RpcException: HANDSHAKE_VALIDATION : Sta

RE: How to setup user authentication for the WebUI?

2015-11-12 Thread Alfaro, Tony
Andries - Thanks, that's the exact page I was following when I first tried to set it up. drill-env.sh: DRILL_MAX_DIRECT_MEMORY="8G" DRILL_HEAP="4G" export DRILL_JAVA_OPTS="-Xms$DRILL_HEAP -Xmx$DRILL_HEAP -XX:MaxDirectMemorySize=$DRILL_MAX_DIRECT_MEMORY -XX:MaxPermSize=512M -XX:ReservedCodeCach

Re: How to setup user authentication for the WebUI?

2015-11-12 Thread Andries Engelbrecht
Try looking at this page https://drill.apache.org/docs/configuring-web-ui-and-rest-api-security/ I didn't set the http settings you list in drill-override.conf, instead i added this to drill-env.sh export DRILL_JAVA_OPTS="

How to setup user authentication for the WebUI?

2015-11-12 Thread Alfaro, Tony
I've done as the documentation said and installed jpam, user auth works with the command line access tools (bin/drill-conf -n user -p pass), but the webui's don't show a login page, only the data for number of drill bits, the hostnames for each bit, the port addresses, and direct memory numbers.

Re: Apache Drill 1.2 targetting JDBC / postgresql storage

2015-11-12 Thread Kieran Benton
Thanks for your help Jacques! Sorry have been out of action for a couple of days. On 7 November 2015 at 18:27, Jacques Nadeau wrote: > Glad you've made some progress. > > Not sure why your .public is how you have to go about things. > Will have to give that some more thought. At least you're ove

XML in Apache Drill

2015-11-12 Thread Magnus Pierre
Hello Drill Users, A few weeks ago i had the pleasure of writing a small SAX parser for XML that I was using in Storm to convert XML to JSON. Later I decided this would be great to put into Drill, mostly as a work around for the fact that Drill does not have native support for XML yet. With some

ConnectException on SHOW SCHEMAS

2015-11-12 Thread Chris Mathews
This took me a while to discover what the issue was, so to save others time I include the following details. If you have an HDFS storage plugin configured and execute a SHOW SCHEMAS query then you would expect to get something like like this: sqlline -u jdbc:drill:sk=zen-drill-vm 0: jdbc:drill

Fwd: parquet-tools helper script for hadoop access

2015-11-12 Thread Chris Mathews
sorry just realised, should’ve included drill users for info not dev. > Begin forwarded message: > > From: Chris Mathews > Date: 12 November 2015 at 10:43:06 GMT > To: d...@parquet.apache.org > Cc: d...@drill.apache.org > Subject: parquet-tools helper script for hadoop access > > I’ve written a