Enable Exasol Admin after updating

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

Introduction

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).

Procedure

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

Step 4: Add the exa_proust_monitor user

In order to generate database health charts and for the connection test function to work, Exasol Admin requires that the exa_proust_monitor user exists in the database. If you are updating from Exasol version 8.31.0 or earlier, you have to manually add this user if it does not exist.

  1. While still connected to the host, open the file /exa/etc/EXAConf in a text editor and copy the value in ExaMonitorUserPassword to your clipboard. This value is a Base64 encoded password.

  2. To disconnect from the host, use Control+D.

  3. Run echo -n '<copied_base64_password>' | base64 -d to convert the encoded password to a plaintext password.

  4. Connect to the database and run the following statements:

    Copy 
    CREATE USER EXA_PROUST_MONITOR IDENTIFIED BY "{plaintext_password}";
    GRANT CREATE SESSION TO EXA_PROUST_MONITOR;
    GRANT SELECT ANY DICTIONARY TO EXA_PROUST_MONITOR;