Hi, I am using opensearch 2.3.0 When I try to configure ODBC driver with SSL I get error like on the screenshot: [image] What caught my attention is that in error message port number is reduced to 920. When I change opensearch.yml config to plugins.security.ssl.http.enabled: false I can succ…

I tried an older version of this driver (v1.4.0) and despite some issues with it described here - [BUG] OpenSearch ODBC client will not connect to OpenSearch cluster · Issue #8 · opensearch-project/sql-odbc · GitHub - I was able to successfully connect. [image]

[image] apt: What caught my attention is that in error message port number is reduced to 920. Hi @apt , have you tried providing the port as per below? [image] Best, mj

Hi! Thank you for your reply. I tried to remove port and HTTP from host. Unfortunately I am still not able to connect. [image]

What stands out, to me, is that the port in your error pop-up is 920 not 9200.

Is your OpenSearch cluster on HTTP or HTTPS? Would you mind sharing your opensearch.yml file? Thanks, mj

Hi, Like I wrote before when plugins.security.ssl.http.enabled: false - there is no error and I can succesfully connect when plugins.security.ssl.http.enabled: true - the error pop-up # ======================== OpenSearch Configuration ========================= # # NOTE: OpenSearch comes with …

I tried installing the ODBC driver on PROD env. where the hostname is slightly shorter. It seems that the issue with missing last digit in port number in error message is misleading. Now I get the same error message with full port number. Still am not able to connect with SSL enabled. opensearch[…

[image] apt: Received no response from url Hi @apt , I had a closer look at it, and looks like you will need to configure the following driver options using a DSN or connection string: a) UseSSL - boolean (0 or 1) Default false (0) - you need to set it to 1 b) HostnameVerification - boolea…

Hi @Mantas , Do you mean Advanced Option tab? This is how it is configured. The Enable SSL option is set automatically when I add https:// in host name. I’ve tried various options, but nothing helps. [image]

I think there is still some bug in version 1.5.0 [image]

@apt , thanks for sharing your findings - that is good to know. Best, mj

Error when trying to connect ODBC SSL

Plugins SQL

Mantas April 19, 2024, 1:31pm 2

Hi @apt,

have you tried providing the port as per below?

Best,
mj

Topic		Replies	Views
OpenSearch SQL ODBC Driver Connection Error SQL troubleshoot , configure	2	1169	February 3, 2023
ODBC Connection is not Working for MS Excel Open Source Elasticsearch and Kibana configure	4	647	March 9, 2022
OpenSearch 3.5 with custom TLS works via browser and curl but ODBC driver fails to connect (no response from server version query) OpenSearch troubleshoot	2	20	March 3, 2026
While install opensearch2.12.0 its shows fail to connect the port 9200 Security install	34	2020	April 2, 2025
How to configure ODBC driver to connect to elasticsearch SQL	1	2146	August 27, 2020

Error when trying to connect ODBC SSL

Related topics