Troubleshoot Planning Analytics ODBC Connector Connections and SSL Certificates

Resolving The Problem

• Confirm certificate file location
  • Review \odbcis\deployment\config.internal.json file
  • Check http tlsCert and tlsKey parameters for certificate file location
  • 
• Ensure certificate files are in the expected format
  • cert (must contain complete certificate chain in file in following order: server, intermediate, root)
    
  • key file (must contain unencrypted private key)
    
  • If you encounter any of the following errors in the odbcis.log, it would indicate a problem with the content of the certificate files:
    • tls: private key does not match public key
    • tls: failed to find any PEM data in key input
• Ensure that the service returns all expected certificates to the browser/client, and that the certificates are valid and resolve all warnings
  • Using OpenSSL, execute the following command and review the output: openssl s_client -debug -showcerts -connect odbcis.host.com:5555
    • Ensure all certificates are correctly returned in the output, if they are not, revisit your certificate file configuration
      *Output below has been truncated to better demonstrate the relevant detail
      
  • In a web browser, navigate to the URL of the service and view the certificate chain
    
  • In PostMan, review the status of the connection after sending a request