# Keep getting encryption error when conneting to datahub ODBC
**URL:** https://community.cumulocity.com/t/keep-getting-encryption-error-when-conneting-to-datahub-odbc/7257
**Category:** Forum
**Tags:** odbc, data-hub, cumulocity
**Created:** [October 21, 2024, 8:46am UTC](https://community.cumulocity.com/t/keep-getting-encryption-error-when-conneting-to-datahub-odbc/7257 "2024-10-21T08:46:11Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Darius\_Lim](https://community.cumulocity.com/u/Darius_Lim)
#### Post date: [October 21, 2024, 8:46am UTC](https://community.cumulocity.com/t/keep-getting-encryption-error-when-conneting-to-datahub-odbc/7257/1 "2024-10-21T08:46:11Z")
#### _ **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 - [Arrow Flight SQL ODBC | Dremio Documentation](https://docs.dremio.com/current/sonar/client-applications/drivers/arrow-flight-sql-odbc-driver/)
andrun a python script file that sits in a redhat server. This is the code
```auto
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?
---
### Author:  [@Harald\_Meyer](https://community.cumulocity.com/u/Harald_Meyer)
#### Post date: [October 21, 2024, 9:01am UTC](https://community.cumulocity.com/t/keep-getting-encryption-error-when-conneting-to-datahub-odbc/7257/2 "2024-10-21T09:01:16Z")
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
---
### Author:  [@Ulrich\_Post](https://community.cumulocity.com/u/Ulrich_Post)
#### Post date: [October 21, 2024, 12:12pm UTC](https://community.cumulocity.com/t/keep-getting-encryption-error-when-conneting-to-datahub-odbc/7257/3 "2024-10-21T12:12:14Z")
I have just created a ticket for OPS - for internal reference: CO-1609.
---
### Author:  [@Ulrich\_Post](https://community.cumulocity.com/u/Ulrich_Post)
#### Post date: [October 24, 2024, 8:44am UTC](https://community.cumulocity.com/t/keep-getting-encryption-error-when-conneting-to-datahub-odbc/7257/4 "2024-10-24T08:44:40Z")
> [@Ulrich\_Post](#):
>
> CO-1609
The issue is supposed to fixed by now - pls check!
Best regards
Uli
---
### Author:  [@Darius\_Lim](https://community.cumulocity.com/u/Darius_Lim)
#### Post date: [October 25, 2024, 4:39am UTC](https://community.cumulocity.com/t/keep-getting-encryption-error-when-conneting-to-datahub-odbc/7257/5 "2024-10-25T04:39:45Z")
> [@Ulrich\_Post](#):
>
> Uli
I tried in the windows environment and the dremio connection is now successful! However, the error persist in the redhat server
---
### Author:  [@Ulrich\_Post](https://community.cumulocity.com/u/Ulrich_Post)
#### Post date: [October 25, 2024, 5:59am UTC](https://community.cumulocity.com/t/keep-getting-encryption-error-when-conneting-to-datahub-odbc/7257/6 "2024-10-25T05:59:28Z")
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
---
### Author:  [@Darius\_Lim](https://community.cumulocity.com/u/Darius_Lim)
#### Post date: [October 25, 2024, 6:37am UTC](https://community.cumulocity.com/t/keep-getting-encryption-error-when-conneting-to-datahub-odbc/7257/7 "2024-10-25T06:37:19Z")
This is the error im seeing in the redhat server.
my odbcinst.ini file
```auto
[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
```auto
[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)’)
---
### Author:  [@Ulrich\_Post](https://community.cumulocity.com/u/Ulrich_Post)
#### Post date: [October 25, 2024, 8:28am UTC](https://community.cumulocity.com/t/keep-getting-encryption-error-when-conneting-to-datahub-odbc/7257/8 "2024-10-25T08:28:55Z")
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, …
---
### Author:  [@system](https://community.cumulocity.com/u/system)
#### Post date: [April 23, 2025, 8:29am UTC](https://community.cumulocity.com/t/keep-getting-encryption-error-when-conneting-to-datahub-odbc/7257/9 "2025-04-23T08:29:19Z")
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.