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
SSL
property to1
. - Set the
SSLTrustStorePath
property to the full path of the TrustStore that you want to use. - Set the
SSLTrustStorePwd
property 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
SSL
property to2
. - Set the
SSLKeyStorePath
property to the full path of the KeyStore that you want to use. - Set the
SSLKeyStorePwd
property 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