Version 1.10.1 ODBC doesn't work?

Plugins SQL
1

Hi, I tried the following ODBC settings but doesn’t work. Please help. I verified with curl command without error.

image
image860×890 28.5 KB

Screenshot 2020-10-11 at 10.00.32 PM

Screenshot 2020-10-11 at 10.00.52 PM
Screenshot 2020-10-11 at 10.00.52 PM992×370 24.6 KB

Screenshot 2020-10-11 at 10.08.49 PM
Screenshot 2020-10-11 at 10.08.49 PM2052×1536 304 KB

2

I post more information hopefully anyone can help.

Verify elasticsearch connection and plugins:

C:> curl -u admin:admin -k https://es1:9200/_cat/plugins?pretty
es1 opendistro-anomaly-detection 1.10.1.0
es1 opendistro-job-scheduler 1.10.1.0
es1 opendistro-knn 1.10.1.0
es1 opendistro_alerting 1.10.1.2
es1 opendistro_index_management 1.10.1.1
es1 opendistro_performance_analyzer 1.10.1.0
es1 opendistro_security 1.10.1.0
es1 opendistro_sql 1.10.1.1

ODBC Test Connection log file:

mylog.c[logs_on_off]234: mylog_on=7 qlog_on=7
start_logging:Global.debug&commlog=7&7
mylog.c[InitializeLogging]533: Log Output Dir: C:\Users\FTLJ\Desktop
es_odbc.c[DllMain]111: exe name=odbcad32
dlg_specif[CC_conninfo_init]452: entering opt=2
setup.c[ParseAttributes]584: aszKey=‘DSN’, value=‘ODFE SQL ODBC DSN’
dlg_specif[copyConnAttributes]145: key=‘DSN’ value=‘ODFE SQL ODBC DSN’
dlg_specif[CC_conninfo_init]452: entering opt=3
dlg_specif[getDSNinfo]224: drivername=elasticsearchodbc
setup.c[ParseAttributes]584: aszKey=‘DSN’, value=‘ODFE SQL ODBC DSN’
dlg_specif[copyConnAttributes]145: key=‘DSN’ value=‘ODFE SQL ODBC DSN’
setup.c[test_connection]440: conn_string=DRIVER=elasticsearchodbc;server=https://es1;database=elasticsearch;port=9200;UID=admin;PWD=admin;auth=BASIC;region=;useSSL=1;hostnameVerification=0;logLevel=7;logOutput=C:\Users\FTLJ\Desktop;responseTimeout=10;fetchSize=-1;
odbcapi30.[SQLAllocHandle]33: entering
environ.c[ESAPI_AllocEnv]44: entering
environ.c[ESAPI_AllocEnv]60: leaving phenv=0000000000317930
odbcapi30.[SQLSetEnvAttr]431: entering att=200,3
odbcapi30.[SQLAllocHandle]33: entering
connection[ESAPI_AllocConnect]63: entering…
connection[ESAPI_AllocConnect]66: **** henv = 0000000000317930, conn = 000000000032BFB0
environ.c[EN_add_connection]502: entering self = 0000000000317930, conn = 000000000032BFB0
environ.c[EN_add_connection]531: added at 0, conn->henv = 0000000000317930, conns[0]->henv = 0000000000317930
odbcapiw.c[SQLDriverConnectW]122: entering
win_unicod[ucs2_to_utf8]126: 00000000001CB2A0 ilen=-3 newlen=224 olen=224 utf8str=DRIVER=elasticsearchodbc;server=https://es1;database=elasticsearch;port=9200;UID=admin;PWD=admin;auth=BASIC;region=;useSSL=1;hostnameVerification=0;logLevel=7;logOutput=C:\Users\FTLJ\Desktop;responseTimeout=10;fetchSize=-1;
misc.c[make_string]115: malloc size=224
misc.c[make_string]117: str=0000000000306DB0
dlg_specif[CC_conninfo_init]452: entering opt=2
drvconn.c[dconn_get_attributes]223: our_connect_string = ‘DRIVER=elasticsearchodbc;server=https://es1;database=elasticsearch;port=9200;UID=admin;PWD=xxxxx;auth=BASIC;region=;useSSL=1;hostnameVerification=0;logLevel=7;logOutput=C:\Users\FTLJ\Desktop;responseTimeout=10;fetchSize=-1;’
dlg_specif[getDSNinfo]224: drivername=elasticsearchodbc
drvconn.c[dconn_get_attributes]223: our_connect_string = ‘DRIVER=elasticsearchodbc;server=https://es1;database=elasticsearch;port=9200;UID=admin;PWD=xxxxx;auth=BASIC;region=;useSSL=1;hostnameVerification=0;logLevel=7;logOutput=C:\Users\FTLJ\Desktop;responseTimeout=10;fetchSize=-1;’
dlg_specif[copyConnAttributes]145: key=‘DRIVER’ value=‘elasticsearchodbc’
dlg_specif[copyConnAttributes]145: key=‘server’ value=‘https://es1’
dlg_specif[copyConnAttributes]145: key=‘database’ value=‘elasticsearch’ not found
dlg_specif[copyConnAttributes]145: key=‘port’ value=‘9200’
dlg_specif[copyConnAttributes]145: key=‘UID’ value=‘admin’
dlg_specif[copyConnAttributes]121: key=‘PWD’ value=‘xxxxxxxx’
dlg_specif[copyConnAttributes]145: key=‘auth’ value=‘BASIC’
dlg_specif[copyConnAttributes]145: key=‘region’ value=‘’
dlg_specif[copyConnAttributes]145: key=‘useSSL’ value=‘1’
dlg_specif[copyConnAttributes]145: key=‘hostnameVerification’ value=‘0’
dlg_specif[copyConnAttributes]145: key=‘logLevel’ value=‘7’
dlg_specif[copyConnAttributes]145: key=‘logOutput’ value=‘C:\Users\FTLJ\Desktop’
dlg_specif[copyConnAttributes]145: key=‘responseTimeout’ value=‘10’
dlg_specif[copyConnAttributes]145: key=‘fetchSize’ value=‘-1’
mylog.c[logs_on_off]234: mylog_on=7 qlog_on=7
mylog.c[logs_on_off]234: mylog_on=7 qlog_on=7
start_logging:Global.debug&commlog=7&7
mylog.c[InitializeLogging]533: Log Output Dir: C:\Users\FTLJ\Desktop
es_communi[ESCommunication::LogMsg]793: Initializing Aws API.
es_communi[ESCommunication::LogMsg]793: Verifying connection options.
es_communi[ESCommunication::LogMsg]793: Required connection option are valid.
es_communi[ESCommunication::LogMsg]793: Starting DB connection.
es_communi[ESCommunication::LogMsg]793: Attempting to establish DB connection.
es_communi[ESCommunication::LogMsg]793: Checking for SQL plugin
es_communi[ESCommunication::LogMsg]793: Client error: ‘Encountered network error when sending http request’.
es_communi[ESCommunication::LogMsg]793: Failed to establish connection to DB.
es_communi[ESCommunication::LogMsg]793: Dropping DB connection.
connection[CC_set_error_statements]553: entering self=000000000032BFB0
connection[CC_log_error]641: CONN ERROR: func=LIBES_connect, desc=‘’, errnum=202, errmsg=‘Connection error: [Open Distro For Elasticsearch][SQL ODBC Driver][SQL Plugin] Connection error: Failed to establish connection to DB.’
connection[CC_log_error]644: ------------------------------------------------------------
connection[CC_log_error]647: henv=0000000000317930, conn=000000000032BFB0, status=0, num_stmts=16
connection[CC_log_error]649: esconn=0000000000000000, stmts=0000000000302A10, lobj_type=-999
es_communi[ESCommunication::LogMsg]793: Shutting down Aws API.
connection[CC_log_error]641: CONN ERROR: func=ESAPI_DriverConnect, desc=‘Error from CC_Connect’, errnum=202, errmsg=‘Connection error: [Open Distro For Elasticsearch][SQL ODBC Driver][SQL Plugin] Connection error: Failed to establish connection to DB.’
connection[CC_log_error]644: ------------------------------------------------------------
connection[CC_log_error]647: henv=0000000000317930, conn=000000000032BFB0, status=0, num_stmts=16
connection[CC_log_error]649: esconn=0000000000000000, stmts=0000000000302A10, lobj_type=-999
odbcapi30w[SQLGetDiagRecW]197: entering
es_api30.c[ESAPI_GetDiagRec]39: entering type=2 rec=1
environ.c[ESAPI_ConnectError]228: entering hdbc=000000000032BFB0 <512>
connection[CC_get_error]618: entering
connection[CC_get_error]630: leaving
environ.c[ESAPI_ConnectError]245: CC_get_error: status = 202, msg = #Connection error: [Open Distro For Elasticsearch][SQL ODBC Driver][SQL Plugin] Connection error: Failed to establish connection to DB.#
environ.c[ESAPI_ConnectError]332: szSqlState = ‘08001’,len=134, szError=‘Connection error: [Open Distro For Elasticsearch][SQL ODBC Driver][SQL Plugin] Connection error: Failed to establish connection to DB.’
es_api30.c[ESAPI_GetDiagRec]60: leaving 0
win_unicod[utf8_to_ucs2_lf]244: ilen=134 bufcount=512 string=Connection error: [Open Distro For Elasticsearch][SQL ODBC Driver][SQL Plugin] Connection error: Failed to establish connection to DB. ocount=134
odbcapi30.[SQLFreeHandle]219: entering
connection[ESAPI_FreeConnect]207: entering…hdbc=000000000032BFB0
connection[CC_Destructor]314: entering self=000000000032BFB0
connection[CC_cleanup]413: entering self=000000000032BFB0
connection[CC_set_error_statements]553: entering self=000000000032BFB0
connection[CC_log_error]641: CONN ERROR: func=CC_cleanup, desc=‘’, errnum=1, errmsg=‘Connection not open’
connection[CC_log_error]644: ------------------------------------------------------------
connection[CC_log_error]647: henv=0000000000317930, conn=000000000032BFB0, status=0, num_stmts=16
connection[CC_log_error]649: esconn=0000000000000000, stmts=0000000000302A10, lobj_type=-999
connection[CC_cleanup]428: after LIBES_disconnect
dlg_specif[CC_conninfo_init]452: entering opt=1
connection[CC_cleanup]494: leaving
connection[CC_Destructor]321: after CC_Cleanup
connection[CC_Destructor]332: after free statement holders
connection[CC_Destructor]343: leaving
connection[ESAPI_FreeConnect]225: leaving…
odbcapi30.[SQLFreeHandle]219: entering
environ.c[ESAPI_FreeEnv]69: entering env=0000000000317930
environ.c[EN_Destructor]442: entering self=0000000000317930
environ.c[EN_Destructor]465: clearing conns count=128
environ.c[EN_Destructor]477: leaving rv=1
environ.c[ESAPI_FreeEnv]72: ok
es_odbc.c[DllMain]118: DETACHING odfesqlodbc.dll