Connect DBeaver to Trino with HTTPS Protocol

Communication between Trino and a client can be secured with HTTPS protocol. config.properties Trino setup file located in /etc/trino folder includes the information necessary for establishing a connection to DBeaver. Java Keystore file contains a public key which is required to connect DBeaver to Trino cluster secured with SSL/TLS. Also, it is possible to disable SSL verification.

Setup

1. This step can be skipped if SSL verification is disabled (option 2 below) in a connection. Find a file defined in http-server.https.keystore.path variable. The file can be in two formats: Java keystore (.jks) or certificate (.pem). Java keystore works for DBeaver. Certificate can be converted into Java keystore as well. It is recommended to remove private key from Java keystore. Place the file in any location where accessible by DBeaver . It might be C:\DBeaver DBeaver root folder.

2. Create Trino connection.

   

3. Replace Host with your Trino coordinator FQDN and port with your Trino HTTPS one, and add user name on Main tab.

   

4. Switch to Driver properties tab.

   

5. Change SSL property to true on Driver properties tab.

   

6. Add properties on Driver properties tab.

   Option 1 with SSL verification

   

   User properties

   • SSLKeyStorePath: path to Java Keystore file, for example, C:\DBeaver\java_keystore_file.jks.
   • SSLKeyStorePassword: Java Keystore file password

   Option 2 without SSL verification

   

   User properties

   • SSLVerification: NONE

7. Test connection.

   Success

   

   Failure

   

Resources

• Trino JDBC driver