ODBC failed connection to remote ES server

Simone1 · April 4, 2022, 10:22am

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.)..

bogdan.pintea · April 7, 2022, 3:21pm

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.

Simone1 · April 8, 2022, 1:27pm

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.

Simone1 · April 8, 2022, 1:30pm

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]`.

bogdan.pintea · April 14, 2022, 5:47pm

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.

Simone1 · April 15, 2022, 12:03pm

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

system · May 13, 2022, 12:04pm

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

Topic		Replies	Views
ODBC failed connection to remote ES server Elasticsearch jdbc	2	303	October 18, 2022
Elasticsearch and Power bi connection through ODBC driver Elasticsearch docker	7	611	March 14, 2023
ODBC Driver for elasticsearch Elasticsearch jdbc	9	314	February 26, 2024
ODBC connection to elastic Elasticsearch	15	6299	May 1, 2019
Elasticsearch SQL ODBC Driver error of all shards failed Elasticsearch elastic-stack-sql	8	1433	May 5, 2021

ODBC failed connection to remote ES server

Related Topics