OpenSearch SQL ODBC Driver Connection Error

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):

opensearch-sql-odbc-win64-1.4.0.0

Describe the issue:

After I install the ODBC driver, I get an error when testing my connection:

“[OpenSearch][SQL ODBC Driver][SQL Plugin] Connection Error: SQL plugin is not available, please install the SQL plugin to use this driver.”

Configuration:

Host and port fields are correct, with basic authentication configured. “Enable SSL” is also checked in Advanced Options.

Relevant Logs or Screenshots:

image

Hi
Can you try prepend URL by https:// prefix? Does this work?
Can you disable SSL on your server and try connecting? Consider changing your password after that.
To disable SSL add or edit the following line in config/opensearch.yml:

plugins.security.ssl.http.enabled: false

Changing the IP in opensearch.yml to the host IP worked.

1 Like