When trying to connect from Windows based client applications such as Tableau Desktop, Power BI Desktop or even Arrow Flight ODBC, with Dremio being configured to use HTTPS (encryption) and a signed SSL certificate, users may run in to issues connecting to Dremio due to root/intermediate certificate or network/environment related issues. Whilst it's pretty straightforward to run common openssl s_client commands on Linux systems, by default OpenSSL is not installed on Windows so this article aims to detail an easy way to test the SSL connection from Windows to help eliminate the certificate, client and/or Dremio.
All versions of Dremio.
The below steps will help to troubleshoot connection issues with dremio when trying to connect from Windows client applications.
1) Download the attached "openssl-1.0.2j-fips-x86_64" package
2) Create OpenSSL folder in C:\
3) Copy openssl-1.0.2j-fips-x86_64\OpenSSL\bin\openssl.cnf to C:\OpenSSL
4) CD in to \OpenSSL\bin and run '
openssl.exe version' to verify the version e.g
OpenSSL 1.0.2j-fips 26 Sep 2016
5) Now run the below openssl commands against the relevant JDBC (31010) or Arrow flight ODBC (32010) port i.e:
openssl s_client -connect <dremio hostname>:32010
openssl s_client -showcerts -connect <dremio hostname>:32010