Keep getting encryption error when conneting to datahub ODBC

Product/components used and version/fix level:

tenant id - t21092648
dremio version - 24.3.7-202406042011090043-c57dfdf8
redhat - Red Hat Enterprise Linux release 8.9 (Ootpa)
python - 3.10.9

Detailed explanation of the problem:

I followed this guide - ODBC Driver for Arrow Flight SQL | Dremio Documentation
andrun a python script file that sits in a redhat server. This is the code


import pyodbc
string = (
    "Driver=Arrow Flight SQL ODBC Driver;"
    "ConnectionType=Direct;"
    "HOST=datahub.jp.cumulocity.com;"
    "PORT=32010;"
    "AuthenticationType=plain;"
    "UID=t21092648/**********;"
    "PWD=**********;"  
    "useEncryption=1"
)
conn = pyodbc.connect(string)

and I received these error.

pyodbc.OperationalError: (β€˜08S01’, β€˜[08S01] [Apache Arrow][Flight SQL] (500) Flight returned unavailable error, with message: failed to connect to all addresses. Please ensure your encryption settings match the server. (500) (SQLDriverConnect)’)

Am I missing something?

Hi Darius,

I think support for Arrow flight driver is not enabled yet on this instance. I suggest that you open a support ticket as there is an alternative using the legacy JDBC driver of Dremio,

best regards,
Harald

1 Like

I have just created a ticket for OPS - for internal reference: CO-1609.

The issue is supposed to fixed by now - pls check!

Best regards
Uli

2 Likes

I tried in the windows environment and the dremio connection is now successful! However, the error persist in the redhat server

Hi Darius,

  • did you use the " ODBC Driver for Arrow Flight SQL" vs port flight port 32010 either on Windows and on RedHat?
  • which error message are you seeing when attempting to establish the connection on RedHat?
    Best regards
    Uli

This is the error im seeing in the redhat server.

my odbcinst.ini file

[ODBC Drivers]
Arrow Flight SQL ODBC Driver=Installed

[Arrow Flight SQL ODBC Driver]
Description=ODBC Driver for Arrow Flight SQL developed by Dremio
Driver=/opt/arrow-flight-sql-odbc-driver/lib64/libarrow-odbc.so.0.9.1.168
FileUsage=1
UsageCount=1

my odbc.ini file

[ODBC Data Sources]
Arrow Flight SQL ODBC DSN=Arrow Flight SQL ODBC Driver

[Arrow Flight SQL ODBC DSN]
Description=ODBC Driver DSN for Arrow Flight SQL developed by Dremio
Driver=Arrow Flight SQL ODBC Driver
ConnectionType=Direct
Host=datahub.jp.cumulocity.com
Port=32010
UID=t21092648/*************
PWD=*******************
useEncryption=1

ERROR MESSAGE

Database error: (β€˜08S01’, β€˜[08S01] [Apache Arrow][Flight SQL] (500) Flight returned unavailable error, with message: failed to connect to all addresses. Please ensure your encryption settings match the server. (500) (SQLDriverConnect)’)

Are you really using the β€œArrow Flight SQL ODBC Driver” also on Windows where ODBC access is working?
If so then

  • the cause of your problem is no more located on the server side (as initially when this thread had been started)
  • you have to check for the root cause in your RedHat configuration. However, this is at least beyond my scope: it may be an issue of ODBC cfg on RedHat, of firewall cfg, …