Failure opening data source using ODBC

Follow

KAKA PI

• March 24, 2020 11:53

ERROR [08001] [OmniSci][OmniSci] (1010) [C:\Users\Jenkins\workspace\mapd-odbc-win\ODBC\Core\MapDPersistentClient.cpp:127]Error occurred while trying to connect: The server's certificate may not be installed. Thrift error = [SSL_get_verify_result(), unable to get local issuer certificate]

0

• 

  KAKA PI

  • March 24, 2020 12:24

  This error occurs when opening the connection, did I miss something?

  0

  Comment actions Permalink
• 

  Randy Zwitch

  • March 24, 2020 12:39

  Hi @KAKA_PI -

  Just from the error message, it suggests to me that your OmniSci instance isn't running SSL. How did you install OmniSci (Docker, tarball, etc.). Also, what language is that (C#?), so that I can try and find someone internally who might be able to help.

  Best, Randy

  0

  Comment actions Permalink
• 

  KAKA PI

  • March 24, 2020 13:31

  Hi Randy

  ODBC installer tool :OmniSciInstall_5.0.0.4.0.000.0000 Client: Windows10 Language:C# Steps: 1)Click installer.exe to install. 2)default C:\Program Files\OmniSci\ODBC. 3)Open ODBC data sources (64 bit). 4)

  Thank you, Zhixin

  0

  Comment actions Permalink
• 

  Candido Dessanti

  • March 25, 2020 08:10

  Have you tried to connect using binary or http protocol?

  0

  Comment actions Permalink
• 

  KAKA PI

  • March 25, 2020 08:31

  Only HTTPS can connect: 1)

  0

  Comment actions Permalink
• 

  KAKA PI

  • March 25, 2020 08:32

  3) Actually not responding

  0

  Comment actions Permalink
• 

  KAKA PI

  • March 25, 2020 08:33

  4)

  0

  Comment actions Permalink
• 

  KAKA PI

  • March 25, 2020 08:33

  2)

  0

  Comment actions Permalink
• 

  Jack Frampton

  • March 25, 2020 22:13

  Hi - can you confirm which protocol your back end server is running? Scanning through your reports it looks like the only protocol you can connect is https

  0

  Comment actions Permalink
• 

  KAKA PI

  • March 26, 2020 09:30

  Yes, my back end server also uses HTTPS protocol. I can use the code in the picture to connect successfully in another windows

  0

  Comment actions Permalink
• 

  KAKA PI

  • March 30, 2020 07:27

  We can successfully connect omnisci using win10, but windows2016 cannot connect. https://global.discourse-cdn.com/business4/uploads/heavyai/original/1X/ccff6ca768323d591d8f53b0a25f66a48769415f.png

  0

  Comment actions Permalink
• 

  Jack Frampton

  • March 30, 2020 09:26

  Hey, Looking back through your messages I think you have a https port and and a binary encrypted port open on the server; which makes it unlikely that the non encrypted ports are open - the server normally works in either encrypted or non-encrypted mode, so I would expect http and binary to not work.

  The https connections seems to be working. The binary encrypted mode error implies the client is starting to form a connection which is then failing. I hope to check the nature of the error message tomorrow

  0

  Comment actions Permalink
• 

  KAKA PI

  • April 02, 2020 11:38

  We now use http connection and can succeed.

  Thanks!

  1

  Comment actions Permalink
• 

  Candido Dessanti

  • April 03, 2020 07:49

  Have you reconfigured the server to allow unencrypted binary and http connections?

  0

  Comment actions Permalink
• 

  KAKA PI

  • April 06, 2020 00:59

  Yes, we have reconfigured the server to allow http connections.

  0

  Comment actions Permalink

Please sign in to leave a comment.