ODBC failed connection to remote ES server

Hi,
I'm trying to connect to my remote server, where i have ES and all my data, with the ODBC driver to pull data to excel in my PC.
When i try to configure the remote connection in the ODBC data sources, i receive this error:

Mon Apr  4 12:14:38 2022 - [ERROR] dbc_curl_perform()@connect.c:684 [DBC@0x0000000155650060] libcurl: failed to perform.
Mon Apr  4 12:14:38 2022 - [ERROR] dbc_curl_perform()@connect.c:724 [DBC@0x0000000155650060] libcurl: failure code 35, message: SSL connect error.
Mon Apr  4 12:14:38 2022 - [ERROR] dbc_curl_post_diag()@connect.c:350 [DBC@0x0000000155650060] libcurl: failure code 35, message: SSL connect error.
Mon Apr  4 12:14:38 2022 - [ERROR] dbc_curl_post_diag()@connect.c:371 [DBC@0x0000000155650060] libcurl failure message: SSL connect error (code:35; schannel: next InitializeSecurityContext failed: SEC_E_INVALID_TOKEN (0x80090308) - Token fornito alla funzione non valido.)..

Not very clear why the connection failed just from that message.
If you point a browser to the URL, do you get the same error? Are there any relevant logs in the system event log?
You can also try to lower the security level under the Security tab to narrow down which of the validation steps fail.

Fri Apr  8 15:24:27 2022 - [INFO] filelog_new()@log.c:269 driver version: 8.1.2(v8.0.0-12-g499a3a6+,u,r).
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1220 [DBC@0x000000115D9203C0] connection security level: 1.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1231 [DBC@0x000000115D9203C0] CA path: ``.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1261 [DBC@0x000000115D9203C0] connection SQL cusor closing URL: `https://mysite.com/_sql/close`.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1272 [DBC@0x000000115D9203C0] connection SQL query URL: `https://mysite.com/_sql/close`.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1297 [DBC@0x000000115D9203C0] connection root URL: `https://mysite.com/`.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1310 [DBC@0x000000115D9203C0] connection UID: `username`.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1320 [DBC@0x000000115D9203C0] connection PWD: <redacted>.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1326 
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1564 [DBC@0x000000115D9203C0] varchar limit: 0.
Fri Apr  8 15:24:27 2022 - [DE[DBC@0x000000115D9203C0] follow: true.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1344 [DBC@0x000000115D9203C0] timeout: 0.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1411 [DBC@0x000000115D9203C0] proxy disabled.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1436 [DBC@0x000000115D9203C0] max body size: 104857600.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1468 [DBC@0x000000115D9203C0] fetch_size: 1000.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1484 [DBC@0x000000115D9203C0] pack JSON: false.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1496 [DBC@0x000000115D9203C0] compression: 2 (auto).
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1500 [DBC@0x000000115D9203C0] apply TZ: false.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1503 [DBC@0x000000115D9203C0] early execution: true.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1529 [DBC@0x000000115D9203C0] multifield lenient: true.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1533 [DBC@0x000000115D9203C0] index include frozen: false.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1536 [DBC@0x000000115D9203C0] auto escape PVA: true.
Fri Apr  8 15:24:27 2022 - [INFO] config_dbc()@connect.c:1564 [DBC@0x000000115D9203C0] varchar limit: 0.
Fri Apr  8 15:24:27 2022 - [DEBUG] dbc_curl_init()@connect.c:653 [DBC@0x000000115D9203C0] libcurl: new handle 0x000001FF6C20CA80.
Fri Apr  8 15:24:27 2022 - [DEBUG] dbc_curl_set_url()@connect.c:434 [DBC@0x000000115D9203C0] URL type set to: 3.
Fri Apr  8 15:24:27 2022 - [ERROR] dbc_curl_perform()@connect.c:684 [DBC@0x000000115D9203C0] libcurl: failed to perform.
Fri Apr  8 15:24:27 2022 - [ERROR] dbc_curl_perform()@connect.c:724 [DBC@0x000000115D9203C0] libcurl: failure code 35, message: SSL connect error.
Fri Apr  8 15:24:27 2022 - [ERROR] dbc_curl_post_diag()@connect.c:350 [DBC@0x000000115D9203C0] libcurl: failure code 35, message: SSL connect error.
Fri Apr  8 15:24:27 2022 - [ERROR] dbc_curl_post_diag()@connect.c:371 [DBC@0x000000115D9203C0] libcurl failure message: SSL connect error (code:35; schannel: next InitializeSecurityContext failed: SEC_E_INVALID_TOKEN (0x80090308) - Token fornito alla funzione non valido.)..
Fri Apr  8 15:24:27 2022 - [DEBUG] post_diagnostic()@error.c:53 [DBC@0x000000115D9203C0] diagnostic message: `[Elastic][EsODBC 8.1.2(v8.0.0-12-g499a3a6+,u,r) Driver]SSL connect error (code:35; schannel: next InitializeSecurityContext failed: SEC_E_INVALID_TOKEN (0x80090308) - Token fornito alla funzione non valido.).` [208], native code: 35.
Fri Apr  8 15:24:27 2022 - [DEBUG] cleanup_curl()@connect.c:381 [DBC@0x000000115D9203C0] libcurl: handle 0x000001FF6C20CA80 cleanup.
Fri Apr  8 15:24:27 2022 - [DEBUG] write_wstr()@util.c:534 [DBC@0x000000115D9203C0] copying 208 wchars (`[Elastic][EsODBC 8.1.2(v8.0.0-12-g499a3a6+,u,r) Driver]SSL connect error (code:35; schannel: next InitializeSecurityContext failed: SEC_E_INVALID_TOKEN (0x80090308) - Token fornito alla funzione non valido.).`) into buffer @0x000000115D92E620, of 2048B len; out-len @0x0000000000000000.
Fri Apr  8 15:24:27 2022 - [INFO] write_wstr()@util.c:546 [DBC@0x000000115D9203C0] NULL required-space-buffer provided.

Fri Apr  8 15:28:08 2022 - [ERROR] attach_error()@queries.c:1075 [STMT@0x000001FF6C19DDC0] request failed with 403 (body len: 245).
Fri Apr  8 15:28:08 2022 - [ERROR] attach_error_cbor()@queries.c:886 [STMT@0x000001FF6C19DDC0] request fail msg: [63] `security_exception: current license is non-compliant for [odbc]`.

This error indicates that your Elasticsearch deployment isn't licensed for the use of ODBC. You might need to at least activate a trial license.

But since you've got here: did you figure out the SSL connection issue? Or did you skip encryption altogether? Is a browser showing the same connection issues, or does that work?

Regarding your logs from previous post, that helps to see the security setting, thanks, but I was wondering if there are any relevant entries in the Windows system event log.

The ssl issue was skipped, the problem is that my deployment isn't licensed for the use of ODBC, thanks!

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.