Configuring SSL Connections
Note:
In this documentation, "SSL" indicates both TLS (Transport Layer Security) and SSL (Secure Sockets Layer). The connector supports industry-standard versions of TLS/SSL.
If you are connecting to a Presto server that has SSL enabled, you can configure the connector to connect to an SSL-enabled socket. When connecting to a server over SSL, the connector uses one-way authentication to verify the identity of the server. Before configuring SSL in the connector, make sure that you have a TrustStore containing a signed, trusted SSL certificate for verifying the identity of the server.
You provide the configuration information to the connector in the connection URL. For more information about the syntax of the connection URL, see Building the Connection URL.
Note:
If Kerberos is enabled, then SSL is automatically enabled. Make sure to configure the connector to use an appropriate TrustStore.
To configure an SSL connection:
- If you are not using Kerberos, LDAP, or Password File authentication, then set the
SSLproperty to1. - Set the
SSLTrustStorePathproperty to the full path of the TrustStore that you want to use. - Set the
SSLTrustStorePwdproperty to your password for accessing the TrustStore.
For example:
jdbc:presto://192.168.203.141:8080;SSL=1;SSLTrustStorePath=C:\\Documents\\Presto_TrustCerts.jks;SSLTrustStorePwd=simba123
To configure a two-way SSL connection:
- If you are not using Kerberos, LDAP, or Password File authentication, then set the
SSLproperty to2. - Set the
SSLKeyStorePathproperty to the full path of the KeyStore that you want to use. - Set the
SSLKeyStorePwdproperty to your password for accessing the KeyStore.
For example:
jdbc:presto://192.168.203.141:8080;SSL=2;SSLKeyStorePath=C:\\Documents\\Presto_KeyCerts.jks;SSLKeyStorePwd=simba123