Hi Divya, Thanks for sharing the log. I looked into it and it looks like your active directory setup might have some issues. So for ODBC Driver or native Drill client the handshake timeout is 5 seconds. ODBC Driver is sending the user information correctly to Drillbit and Drillbit is receiving it as well and authenticating with AD setup using PAM module. But it looks like that authentication itself is taking 9 seconds and by then client is just timing out. You can try increasing your timeout to 30 seconds for now which is default for JDBC client (information share below).
Found 2 instances of ODBC client connection in drillbit.log file both shows same behavior: Case1: 2018-05-10 02:01:04,913 [UserServer-1] TRACE o.a.drill.exec.rpc.user.UserServer - User domain\user on connection /1.2.3.4:5678 is likely using an older client. 2018-05-10 02:01:12,756 [UserServer-1] TRACE o.a.drill.exec.rpc.user.UserServer - Authenticated domain\user successfully using PLAIN from /1.2.3.4:5678 Case 2: 2018-05-10 02:01:27,827 [UserServer-1] TRACE o.a.drill.exec.rpc.user.UserServer - User domain\user on connection /1.2.3.4:9876 is likely using an older client. 2018-05-10 02:01:36,868 [UserServer-1] TRACE o.a.drill.exec.rpc.user.UserServer - Authenticated domain\user successfully using PLAIN from /1.2.3.4:9876 To update handshake timeout for ODBC Driver you can follow below steps mentioned by Robert Wu: ----------------- If you need to modify the handshake timeout value ------------------ You can set the HandshakeTimeout value in the AdvancedProperties field in the ODBC driver. The default value is 5 seconds. https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_odbc-2Dconfiguration-2Dreference_&d=DwIGaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=jLGlh_B4vWlLfnyeHlQa6GZGAO66Udd5Sn4AmSyYoyw&s=Em6_F73xfpZ1emouB3Q7_znT3H53sVYHR9cp685AuWY&e= Are you connecting to drillbit using Tableau's " Other Databases (ODBC)" connector or the "Apache Drill" connector? If you are using the "Other Databases (ODBC)" connector in Tableau: And connecting via DSN: Please open the ODBC Administrator (make sure it’s the correct bitness) and click on the "System DSN" tab. Then, click on "MapR Drill" and then click the "Configure..." button on the right. Then, please modify the default HandshakeTimeout value from 5 seconds to your preference. Then, click the ok button to save the setting. And connecting via Driver: A configuration popup window should appear when you try to connect. Add HandshakeTimeout=<value> in the AdvancedProperties field. If you are using the Apache Drill connector in Tableau: Then you would need to create a custom settings file for Tableau to pick up this information. Thanks, Sorabh ________________________________ From: Sorabh Hamirwasia <shamirwa...@mapr.com> Sent: Wednesday, May 9, 2018 2:49:24 PM To: Divya Gehlot Cc: user@drill.apache.org Subject: Re: tableau drill connection - handshake time out error Hi Divya, Thanks for sharing the logs unfortunately I don't see any additional information in it. Can you please try following: 1) Enable trace logging on Drillbit side for Rpc package? You can do so by adding below block in logback.xml file location under conf directory and then restart the Drillbit process. 2) Enable DrillClient logging which can be done from ODBC Data Source Administrator-->configure--> LoggingOptions-->Choose logging level to LOG_TRACE and provide a directory to write log files. Please share logging captured from step 1 and 2 and also configuration file to know more about the setup. <logger name="org.apache.drill.exec.rpc" additivity="false"> <level value="trace" /> <appender-ref ref="FILE" /> </logger> Thanks, Sorabh ________________________________ From: Divya Gehlot <divya.htco...@gmail.com> Sent: Tuesday, May 8, 2018 8:29:26 PM To: Sorabh Hamirwasia Cc: user@drill.apache.org Subject: Re: tableau drill connection - handshake time out error Hi Sorabh, On the machine where Tableau Desktop is installed , I am able to login through Drill Explorer . Neither able to login throug tableau desktop nor tableau server. I did enabled ODBC tracing and here is link[1] of the tracing log . Here is the error which I could see at tableau side [MapR][Drill] (40) Handshake timed out (HandshakeTimeout=5) while trying to connect to local=xxx.xxx.xxx:31010.[2] Check whether Drillbit is running in a healthy state or increase the timeout. Unable to connect to the server "xxxx.xxx.xxx".[2] Check that the server is running and that you have access privileges to the requested database. [1] https://urldefense.proofpoint.com/v2/url?u=https-3A__pastebin.com_kcwCsPDa&d=DwIGaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=4rAl0MAaWrR7jHy7qndgtI46f68veOYfOFDjwNdTGVQ&s=WH-SIQyAmLaNeQ4QE3ov4Woozrc5Wfs5skhli6CDick&e=<https://urldefense.proofpoint.com/v2/url?u=https-3A__pastebin.com_kcwCsPDa&d=DwMFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=vBD-1LbMWUnMeiw3ltxJM2woojrJcry15nhWKxDVMKU&s=UFzN26yrHAc_XjKzK4a_8KmaRd1aSbtfKSmopOPL17A&e=> [2]Removed the Domain name. Thanks, Divya On 9 May 2018 at 00:55, Sorabh Hamirwasia <shamirwa...@mapr.com<mailto:shamirwa...@mapr.com>> wrote: Hi Divya, If you are seeing no logs on server side (considering logging is not disabled) that means issue is on the client side setup. It can be either on Tableau or with the ODBC driver itself. In your previous thread you mentioned the setup was working fine when using Drill Explorer. If you were using the same driver then that points to Tableau side of issue. Can you provide error which you are seeing on client side ? Also can you try enable logging [1] for ODBC driver to see if it provides any other information. [1]: https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.microsoft.com_en-2Dus_sql_odbc_admin_setting-2Dtracing-2Doptions-3Fview-3Dsql-2Dserver-2D2017&d=DwIGaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=4rAl0MAaWrR7jHy7qndgtI46f68veOYfOFDjwNdTGVQ&s=by6d99G5_QM2qSr_0eQMVgHVXjNDNoGnLaUCC9PL9m8&e=<https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.microsoft.com_en-2Dus_sql_odbc_admin_setting-2Dtracing-2Doptions-3Fview-3Dsql-2Dserver-2D2017&d=DwMFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=vBD-1LbMWUnMeiw3ltxJM2woojrJcry15nhWKxDVMKU&s=Wp6UcHNQiLoP7aeJ4KVRWCxsTaWjsT4Pf1l37780PH4&e=> Thanks, Sorabh ________________________________ From: Divya Gehlot <divya.htco...@gmail.com<mailto:divya.htco...@gmail.com>> Sent: Tuesday, May 8, 2018 3:05 AM To: user@drill.apache.org<mailto:user@drill.apache.org>; Sorabh Hamirwasia Subject: Re: tableau drill connection - handshake time out error Hi, I don't see any entry in drillbit.log and drillbit.out file when I try log in through tableau. I tried with Tableau desktop(10.2) and tableau Server (10.5).None worked for me . Its the 3 node MapR 5.2 having Drill 1.10.0 version . Thanks, Divya On 4 May 2018 at 01:30, Sorabh Hamirwasia <shamirwa...@mapr.com<mailto:shamirwa...@mapr.com>> wrote: Hi Divya, Can you please share the error seen on client side and also debug/error logs from server side (from drillbit.log and drillbit.out) ? Also what is the setup of your environment ? Are you using Tableau Server or Desktop version ? Thanks, Sorabh ________________________________ From: Divya Gehlot <divya.htco...@gmail.com<mailto:divya.htco...@gmail.com>> Sent: Wednesday, May 2, 2018 9:23:45 PM To: user@drill.apache.org<mailto:user@drill.apache.org> Subject: Re: tableau drill connection - handshake time out error Hi , Facing strange issue . Apache Drill is connected to Active directory .I am able to connect apache Drill through Web UI and Drill Explorer using my account,but unable to connect to Apache Drill through Tableau using my account getting handshake error . However If I use some other account to connect through Apache Drill in Tableau , able to connect successfully. What could be the reason that I am unable to connect Apache Drill through Tableau. Has anybody face this issue . I am yet to figure out whether its a Drill issue or Tableau. Appreciate the help ! Thanks, Divya On 2 May 2018 at 22:06, Andries Engelbrecht <aengelbre...@mapr.com<mailto:aengelbre...@mapr.com>> wrote: > Check the health of your storage plugins on the drillbit/server/cluster > side. > Run a show schemas in sqlline on the drillbit and see how long it takes to > get back. > > > --Andries > > On 5/2/18, 3:24 AM, "Divya Gehlot" > <divya.htco...@gmail.com<mailto:divya.htco...@gmail.com>> wrote: > > Hi Robert, > Thanks for the response. > It was all working while earlier . I am getting this error past couple > of > days . > As you mentioned check the drill bit health and state of the server > environment . > Which configurations do I need check ? Can you please elaborate more. > I am successfuly able to connevt to Drill through Drill explorer and > through Web UI of Apache Drill . > Earlier I was able to connect Drill through tableau without making > changes > to Drill configurations . > I haven't made any changes to Drill configurations also. > Wondering what triggering handshake error. > > > > Grateful for your help ! > > Thanks, > Divya > > > > On 2 May 2018 at 17:08, Robert Wu > <r...@magnitude.com<mailto:r...@magnitude.com>> wrote: > > > Hi Divya, > > > > Normally 5 second default for the client server handshake is enough > for > > most setup. > > Since you mentioned that this incident is out of the ordinary, I > would > > double check the health of the drillbit and the state of the server > > environment. > > > > ------------------ If you need to modify the handshake timeout value > > ------------------ > > You can set the HandshakeTimeout value in the AdvancedProperties > field in > > the ODBC driver. The default value is 5 seconds. > > https://urldefense.proofpoint.com/v2/url?u=https-3A__drill. > apache.org_docs_odbc-2Dconfiguration-2Dreference_&d=DwIFaQ&c= > cskdkSMqhcnjZxdQVpwTXg&r=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU&m= > JWJb4hdyVwAb6BMNHqmYIDRzArDhsA6FtipM3pFd_HE&s= > TF03KzLjSs9F5UwHg3cjsviPr36hGSYh3tVfjL0H-KQ&e= > > > > Are you connecting to drillbit using Tableau's " Other Databases > (ODBC)" > > connector or the "Apache Drill" connector? > > > > If you are using the "Other Databases (ODBC)" connector in Tableau: > > And connecting via DSN: > > Please open the ODBC Administrator (make sure it’s > the > > correct bitness) and click on the "System DSN" tab. > > Then, click on "MapR Drill" and then click the > > "Configure..." button on the right. > > Then, please modify the default HandshakeTimeout > value > > from 5 seconds to your preference. > > Then, click the ok button to save the setting. > > > > And connecting via Driver: > > A configuration popup window should appear when you > try to > > connect. Add HandshakeTimeout=<value> in the AdvancedProperties > field. > > > > If you are using the Apache Drill connector in Tableau: > > Then you would need to create a custom settings file for > Tableau > > to pick up this information. > > > > Best regards, > > > > Rob > > > > -----Original Message----- > > From: Divya Gehlot > <divya.htco...@gmail.com<mailto:divya.htco...@gmail.com>> > > Sent: Wednesday, May 2, 2018 12:11 AM > > To: user@drill.apache.org<mailto:user@drill.apache.org> > > Subject: tableau drill connection - handshake time out error > > > > Hi , > > I am connecting Apache Drill through Tableau 10.X version . > > I was able to connect successfully for this while Now all of sudden > I am > > getting handshake timeout error when I try connect drill through > tableau. > > Error : > > [MapR][Drill] (40) Handshake timed out (HandshakeTimeout=5) while > trying > > to connect to local=xx.xx.xx.x:31010. Check whether Drillbit is > running in > > a healthy state or increase the timeout. > > > > I try adding below configurations in drill-overide.conf also > #Optional > > handshakeTimeout in milliseconds. Default is 10000 ms (10 > > seconds) > > handshakeTimeout: 60000, > > > > but it didnt help. > > > > Appreciate the help ! > > > > Thanks, > > Divya > > > > >
