Update System Database and Privacera Portal Datasource Password¶

When you update the internal user password for the "privacera" user in MariaDB, you must also update the corresponding password in the Privacera Portal configuration. The Privacera Portal uses this password to connect to MariaDB, and if the passwords do not match, the Portal will be unable to establish database connections, resulting in service failures.

Steps¶

Step 1: SSH into Privacera Instance¶

SSH into the instance where Privacera is installed.

Step 2: Get All Pods Details¶

Get the list of all pods in your namespace:

1

kubectl get pods -n <namespace>

Step 3: Access MariaDB Pod Shell¶

Go inside the MariaDB pod shell:

1

kubectl exec -it <mariadb-pod-name> -n <namespace> -- bash

Replace mariadb-pod-name with the actual name of your MariaDB pod from Step 2.

Step 4: Update Internal User Password¶

Login with the root user and password, then update the internal "privacera" user password:

1
2

ALTER USER 'privacera'@'%' IDENTIFIED BY '<new-password>';
exit;  # Exit from MariaDB root user session

Replace <new-password> with your desired new password.

Step 5: Verify Login with New Password and Exit¶

Test the login with the new password and internal user "privacera":

1

mariadb -u privacera -p

Enter the new password when prompted. If login is successful, exit from both the MariaDB client session and the pod:

1
2

exit;  # Exit from MariaDB client session
exit;  # Exit from MariaDB pod shell

Step 6: Update Privacera Portal Datasource Password¶

Edit the Privacera Portal configuration file:

1

vi ~/privacera/privacera-manager/config/custom-vars/vars.portal.yml

Update the PRIVACERA_PORTAL_DATASOURCE_PASSWORD value with your new password:

1

PRIVACERA_PORTAL_DATASOURCE_PASSWORD: <new-password>

Step 7: Update the Instance¶

Step 1 - Setup which generates the helm charts. This step usually takes few minutes.

1
2

cd ~/privacera/privacera-manager
./privacera-manager.sh setup

1
2

cd ~/privacera/privacera-manager
./pm_with_helm.sh upgrade

1
2

cd ~/privacera/privacera-manager
./privacera-manager.sh post-install