Hi Peter, Since you mentioned seeing a username textbox I think you are using WebUI to run query. Your setup must be unsecure with impersonation enabled. You can 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 <[email protected]> Sent: Thursday, June 14, 2018 3:44:30 AM To: [email protected] Cc: [email protected] 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=https-3A__drill.apache.org_docs_configuring-2Duser-2Dauthentication_&d=DwIFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=GPL0sdNzx7XgeVyJgxfNbGMGYc5lUn3dl9DXCTJAM6w&s=z9fYdK_nptwRrowW211dyC5YHwLMfBKF2sO3HeNCJok&e= [2] https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_configuring-2Dplain-2Dauthentication_-23connecting-2Dwith-2Dsqlline&d=DwIFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=GPL0sdNzx7XgeVyJgxfNbGMGYc5lUn3dl9DXCTJAM6w&s=29Yvp919v2jK7b4WDNdYpeYUFyWxN4fQwRJHzRwdOzA&e= [3] https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_configuring-2Duser-2Dimpersonation_&d=DwIFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=GPL0sdNzx7XgeVyJgxfNbGMGYc5lUn3dl9DXCTJAM6w&s=ilIOBEKHbMIYpAUNn7Rz9s49knO1teYLGCrHH7DMfgU&e= Kind regards Vitalii On Thu, Jun 14, 2018 at 11:36 AM Peter Edike < [email protected]> 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’t 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:* [email protected] > Interswitch Limited > 1648C Oko-Awo Street, Victoria Island Lagos > Customer Contact Centre 0700-9065000 > *ü* > *https://urldefense.proofpoint.com/v2/url?u=http-3A__www.interswitchgroup.com-2A&d=DwIFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=GPL0sdNzx7XgeVyJgxfNbGMGYc5lUn3dl9DXCTJAM6w&s=B54Yvuv9MD1SoVRLGv6cYYSFRYXJ-tVGliWz3klRyME&e= > > <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.interswitchgroup.com_&d=DwIFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=GPL0sdNzx7XgeVyJgxfNbGMGYc5lUn3dl9DXCTJAM6w&s=3ujPESaQaewlnqba4XGbM6TwqwrtHRtW75paR98GcRg&e=> > > <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.thevervelife.ng_&d=DwIFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=GPL0sdNzx7XgeVyJgxfNbGMGYc5lUn3dl9DXCTJAM6w&s=I3PFW1WOzH-1ss0SMal3JiuxODDtH4_6GSGVtezxwSc&e=> > > 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 have > received this e-mail in error, kindly notify the sender. If you are not the > 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, incomplete > or amended. the contents of this email or its attachments have been scanned > for all viruses and all reasonable measures have been taken to ensure that > 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* > > >
