Oracle Cloud Infrastructure Documentation
Try Free Tier

Configuring and Accessing Trino in a Secure Cluster

A Highly Available (HA) cluster is also secure. Trino interface in a secure cluster uses password file authentication. The username and password credentials used to log into the interface are validated against usernames and passwords stored in a password file.

Password files are created using the Apache Server htpasswd utility. Passwords in the password file are securely hashed using a bcrypt algorithm.

To access the Trino interface in a secure cluster:

  1. Create login credentials in the password file. SSH to the first master node (mn0) of your ODH cluster as opc user.
  2. Run the following command as the root user. 
    htpasswd -B -C 10 /etc/trino/conf/password.db user-name
  3. When prompted, enter a password for your username.
  4. Open a browser window and enter the following URL: 
    https://coordinator-ip-address:7778
    7778 is the default port and configured in the http-server.http.port config file located at /etc/trino/conf/config.properties in the master node. coordinator-ip-address is the IP address of the master node where the Trino coordinator is running.
  5. Provide the username and password you configured earlier and sign in to the Trino interface.

If SSL is enabled in the secure cluster, ensure that Trino is restarted from the Apache Ambari interface after completing the steps of Trino SSL enablement.

Was this article helpful?