Configure SSL / TLS on Connection

For the server on which you want to use SSL/TLS make sure to check the box on server settings: "Use kdb+ TLS"

QStudio Add Server Dialog

Add Certificate to Keystore

To connect and validate the server, the java used to launch QStudio should have the certificate added to it's keystore. To do this:

  1. Find the java you are using to run QStudio.
    • If you installed QStudio this folder will be at C:\Program Files (x86)\TimeStored.com\jre\lib\security
    • If you are using the builtin java type where java on windows or which java on linux to find it's location.
  2. (Windows) Open admin command line there using cmd and right-click "run as admin".
  3. Run keytool to import certificate:
    ..\..\bin\keytool -import -trustcacerts -keystore cacerts -storepass changeit -noprompt -alias yourAliasName -file path\to\certificate.cer

See also KX SSL docs

"PKIX path building failed"

This error likely means your version of java does not contain the certificate required to validate your data connection or to make an HTTP request. See the instructions above.