From user-return-9379-apmail-drill-user-archive=drill.apache.org@drill.apache.org Thu Jun 14 16:27:16 2018 Return-Path: X-Original-To: apmail-drill-user-archive@www.apache.org Delivered-To: apmail-drill-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D50F0180FE for ; Thu, 14 Jun 2018 16:27:16 +0000 (UTC) Received: (qmail 47361 invoked by uid 500); 14 Jun 2018 16:27:16 -0000 Delivered-To: apmail-drill-user-archive@drill.apache.org Received: (qmail 47247 invoked by uid 500); 14 Jun 2018 16:27:16 -0000 Mailing-List: contact user-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@drill.apache.org Delivered-To: mailing list user@drill.apache.org Received: (qmail 47230 invoked by uid 99); 14 Jun 2018 16:27:15 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Jun 2018 16:27:15 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 501AA180906 for ; Thu, 14 Jun 2018 16:27:15 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.499 X-Spam-Level: ** X-Spam-Status: No, score=2.499 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, KAM_NUMSUBJECT=0.5, RCVD_IN_DNSWL_NONE=-0.0001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=mapr.onmicrosoft.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 9h6WuJPML3AI for ; Thu, 14 Jun 2018 16:27:12 +0000 (UTC) Received: from NAM04-SN1-obe.outbound.protection.outlook.com (mail-eopbgr700126.outbound.protection.outlook.com [40.107.70.126]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id F1C795F169 for ; Thu, 14 Jun 2018 16:27:10 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mapr.onmicrosoft.com; s=selector1-mapr-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=uLt35FS8HIiNt37CDfEQ+PVnK8ON9MdaLEk2KjVHBkQ=; b=gbY11AH5lnijeWVwa0KNpcQTGnR9c86jsDms5KoLGEVIJXN77nalCcDmL62pkMzVBHtm/3Lb0drxEDBGShPwcK15y9bQgyYH4hH/wPpUIOcGNBaawaYistYwQcHHrwK9YUZUjXZeMiUWGCcg2fxTMRN8eYbCQ7ayZ2GTMPJp+IY= Received: from MWHPR16MB1373.namprd16.prod.outlook.com (10.175.3.147) by MWHPR16MB1376.namprd16.prod.outlook.com (10.175.3.150) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.863.16; Thu, 14 Jun 2018 16:27:02 +0000 Received: from MWHPR16MB1373.namprd16.prod.outlook.com ([fe80::55db:e0b3:f3d8:530e]) by MWHPR16MB1373.namprd16.prod.outlook.com ([fe80::55db:e0b3:f3d8:530e%11]) with mapi id 15.20.0863.016; Thu, 14 Jun 2018 16:27:02 +0000 From: Sorabh Hamirwasia To: "user@drill.apache.org" CC: "adesegun.adeyemo@interswitchgroup.com" Subject: Re: Unable to run Drill queries on Drill1.13 Thread-Topic: Unable to run Drill queries on Drill1.13 Thread-Index: AdQDumxZZBnMrPJRReW0c4Rm1cT8YwAEj/4AAAvW5hs= Date: Thu, 14 Jun 2018 16:27:02 +0000 Message-ID: References: <5df04a5031094a67be2bc46cfa7e626d@mailserver2013.Interswitchng.com>, In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=shamirwasia@mapr.com; x-originating-ip: [66.194.15.49] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;MWHPR16MB1376;7:Wtyhu0YzN0BTEsXPGPQCFCJ16HKd7wcC6hCDVguuSg0uwXRwGbr6y8GKpVvUkKvuI5n6Px62faZ3cmZfVZ04k7g5kIU9h2Y3DiIap9ZEjACEIk7FWbgcKvEVEYjEzEbl7LPcuPQXPt1bA2c7Mv8zr4wLQVE/xL64/1sB1mZgU46VpD3/MBfM+0mkRPbl8W6dN+Z4jM2Wg+2BehtLLSko0Ke0u7nZUmg9OA2bKRF2S7sdJbIDwtnrgQ2sUgRGhj2D x-ms-exchange-antispam-srfa-diagnostics: SOS; x-ms-office365-filtering-correlation-id: c52d2317-0456-47ba-72cb-08d5d213a933 x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(4652020)(5600026)(711020)(4534165)(4627221)(201703031133081)(201702281549075)(2017052603328)(7153060)(7193020);SRVR:MWHPR16MB1376; x-ms-traffictypediagnostic: MWHPR16MB1376: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(10436049006162)(85827821059158)(21532816269658); x-ms-exchange-senderadcheck: 1 x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040522)(2401047)(5005006)(8121501046)(3231254)(944501410)(52105095)(10201501046)(3002001)(93006095)(93001095)(149027)(150027)(6041310)(20161123564045)(20161123560045)(20161123562045)(201703131423095)(201702281528075)(20161123555045)(201703061421075)(201703061406153)(20161123558120)(6072148)(201708071742011)(7699016);SRVR:MWHPR16MB1376;BCL:0;PCL:0;RULEID:;SRVR:MWHPR16MB1376; x-forefront-prvs: 0703B549E4 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(346002)(366004)(396003)(39850400004)(376002)(39380400002)(53754006)(199004)(189003)(316002)(4326008)(6246003)(14454004)(76176011)(606006)(7696005)(478600001)(86362001)(575784001)(236005)(99286004)(6436002)(59450400001)(229853002)(6116002)(55016002)(6606003)(6306002)(54896002)(3846002)(9686003)(66066001)(5640700003)(966005)(53546011)(6506007)(53936002)(33656002)(6916009)(3280700002)(8936002)(7736002)(3660700001)(102836004)(81156014)(1730700003)(26005)(105586002)(74316002)(2906002)(81166006)(476003)(11346002)(446003)(5250100002)(2351001)(5660300001)(486006)(97736004)(2501003)(8676002)(68736007)(106356001)(2900100001)(25786009)(186003)(19627405001)(5890100001);DIR:OUT;SFP:1102;SCL:1;SRVR:MWHPR16MB1376;H:MWHPR16MB1373.namprd16.prod.outlook.com;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;A:1;MX:1; received-spf: None (protection.outlook.com: mapr.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: DB3Byv5ktlljqwPgvq6pIB67UpB3nghpNSePjTdgWfJeOSdQyCLC7GwHsVhZjSwmoyfjt5uqiRaup93ijf+XrylD6sk4D8H5tzLHlnwgXiypqFr1AjR7a0mEdl8+NmphgPtx8eheUyUEf3Sny/31H93TsdqUciCJgWiyEmzLpM1ll6DBz0QnZZHNiKiLZeKc spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_MWHPR16MB13730313925C08A31845F5D5DA7D0MWHPR16MB1373namp_" MIME-Version: 1.0 X-OriginatorOrg: mapr.com X-MS-Exchange-CrossTenant-Network-Message-Id: c52d2317-0456-47ba-72cb-08d5d213a933 X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Jun 2018 16:27:02.6074 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 2573c0c8-6f2a-4418-a58a-a742cf6415fb X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR16MB1376 --_000_MWHPR16MB13730313925C08A31845F5D5DA7D0MWHPR16MB1373namp_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Peter, Since you mentioned seeing a username textbox I think you are using WebUI t= o run query. Your setup must be unsecure with impersonation enabled. You ca= n disable impersonation on Drillbit side by removing all the settings under= drill.exec.impersonation block from drill-override.conf file [1]. However = in that case all the queries will be executed as Drill process user. [1]: https://drill.apache.org/docs/configuring-user-impersonation/ Thanks, Sorabh ________________________________ From: Vitalii Diravka Sent: Thursday, June 14, 2018 3:44:30 AM To: user@drill.apache.org Cc: adesegun.adeyemo@interswitchgroup.com Subject: Re: Unable to run Drill queries on Drill1.13 Hi Peter, Do you use User Authentication [1]? What kind of? Could you share please drill-override.conf file and connection string, which you are using to connect to the drillbit? anonymous user has not access to perform your query. You should specify username in connecting string [2], which has that access= . If you don't need User Impersonation [3] and Authentication you can disable it in drill-override.conf file and restart drillbits. [1] https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__drill.apache.org= _docs_configuring-2Duser-2Dauthentication_&d=3DDwIFaQ&c=3DcskdkSMqhcnjZxdQV= pwTXg&r=3DgRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=3DGPL0sdNzx7XgeVyJg= xfNbGMGYc5lUn3dl9DXCTJAM6w&s=3Dz9fYdK_nptwRrowW211dyC5YHwLMfBKF2sO3HeNCJok&= e=3D [2] https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__drill.apache.org_doc= s_configuring-2Dplain-2Dauthentication_-23connecting-2Dwith-2Dsqlline&d=3DD= wIFaQ&c=3DcskdkSMqhcnjZxdQVpwTXg&r=3DgRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxv= hTlQg&m=3DGPL0sdNzx7XgeVyJgxfNbGMGYc5lUn3dl9DXCTJAM6w&s=3D29Yvp919v2jK7b4WD= NdYpeYUFyWxN4fQwRJHzRwdOzA&e=3D [3] https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__drill.apache.org= _docs_configuring-2Duser-2Dimpersonation_&d=3DDwIFaQ&c=3DcskdkSMqhcnjZxdQVp= wTXg&r=3DgRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=3DGPL0sdNzx7XgeVyJgx= fNbGMGYc5lUn3dl9DXCTJAM6w&s=3DilIOBEKHbMIYpAUNn7Rz9s49knO1teYLGCrHH7DMfgU&e= =3D Kind regards Vitalii On Thu, Jun 14, 2018 at 11:36 AM Peter Edike < peter.edike@interswitchgroup.com> wrote: > Hello Everyone, > > > > Please I am trying to run a simple query on my drill installation. I keep > getting the following error > > > > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > IOException: Error getting user info for current user, anonymous Setup > failed for null Fragment 1:31 [Error Id: > ee07252c-597e-4602-a06e-583bedd4eaff on BGDTEST5.INTERSWITCH.COM:31010] > > > > I always see a username text box but I don=92t quite like the fact that I > must enter a username to run queries. How can I disable this behavior > > > > > ------------------------------ > > *Peter Edike* > Senior Software Engineer > Research and Development > Group Shared Technology > > *Office NO: * > *Mobile NO: * > *Email:* peter.edike@interswitchgroup.com > Interswitch Limited > 1648C Oko-Awo Street, Victoria Island Lagos > Customer Contact Centre 0700-9065000 > *=FC* *https://urldefense.proofpoint.com/v2/url?u=3Dhttp-3A__www.interswi= tchgroup.com-2A&d=3DDwIFaQ&c=3DcskdkSMqhcnjZxdQVpwTXg&r=3DgRpEl0WzXE3EMrwj0= KFbZXGXRyadOthF2jlYxvhTlQg&m=3DGPL0sdNzx7XgeVyJgxfNbGMGYc5lUn3dl9DXCTJAM6w&= s=3DB54Yvuv9MD1SoVRLGv6cYYSFRYXJ-tVGliWz3klRyME&e=3D > > > > This e-mail and all attachments transmitted with it remain the property > of Interswitch Limited , the information contained herein are private > confidential and intended solely for the use of the addressee. If you hav= e > received this e-mail in error, kindly notify the sender. If you are not t= he > addressee, you should not disseminate, distribute or copy this e-mail. > Kindly notify Interswitch immediately by email if you have received this > email in error and delete this email and any attachment from your system > Emails cannot be guaranteed to be secure or error free as the message and > any attachments could be intercepted, corrupted, lost, delayed, incomplet= e > or amended. the contents of this email or its attachments have been scann= ed > for all viruses and all reasonable measures have been taken to ensure tha= t > no viruses are present. Interswitch Limited and its subsidiaries do not > accept liability for damage caused by this email or any attachments.This > message has been marked as *CONFIDENTIAL *on *Thursday, June 14, 2018* @ = *9:35:50 > AM* > > > --_000_MWHPR16MB13730313925C08A31845F5D5DA7D0MWHPR16MB1373namp_--