Enable Exasol Admin after updating

This article explains how to enable Exasol Admin if you are updating from an earlier version of Exasol.

In new installations of Exasol 2025.1 and later, Exasol Admin can be enabled in the deployment configuration during the installation procedure. If you are updating to Exasol 2025.1.0 or later from an earlier rolling release version of Exasol 8, you have to manually enable Exasol Admin after the update.

This procedure uses Exasol Deployment Tool (c4).

Step 1: Update Exasol to the latest version

Update Exasol to the latest version following the instructions in Update Procedure (command line).

If the parameter CCC_UPDATE_CCC is set to false in the configuration for your deployment, you will not be able to enable Exasol Admin after the update.

To set the parameter to true, use --ccc-update-ccc true with the c4 update cluster command.

Step 2: Set the admin password for Exasol Admin

  1. Connect to the node where you want to host Exasol Admin using c4 connect -i PLAY_ID -s host -n NODE_ID.

    Example:
    Copy 
    c4 connect -i c3275f84 -s host -n 11

  2. When connected to the node, find out the local play ID using c4 ps --local -e '.[].play.id'.

    Example:
    Copy 
    $ c4 ps --local -e '.[].play.id'
    cb58f289-ba1c-47e6-a632-7b85ac1ee921

  3. Set the password for the Exasol Admin user using the following command:

    Copy 
    c4 local reconf --ccc-adminui-admin-password-hash "$(c4 pwdhash -c -i <<< "<new_password>" | tr -d '\n'  | base64) "<local_play_id>"
    Example:
    Copy 
    c4 local reconf --ccc-adminui-admin-password-hash "$(c4 pwdhash -c -i <<< "secretPassword123456" | tr -d '\n'  | base64) "cb58f289-ba1c-47e6-a632-7b85ac1ee921"

Step 3: Enable the UI service

  1. To enable the exasol-admin-ui service, use the following command (while still connected to the node that will host Exasol Admin):

    sudo systemctl enable --now "exasol-admin-ui.service"

  2. Check that the service is running:

    sudo systemctl status exasol-admin-ui.service

  3. Disconnect from the node using Control-D.

Step 4: Open the ports required to access adminUI

To open the required ports for the UI, use the following command on the jump host:

c4 reconf --ccc-adminui-start-server true <play id>

Example:
Copy 
c4 reconf --ccc-adminui-start-server true c3275f84