Keycloak admin console becomes inaccessible after changing the theme

Due to the upstream Keycloack issue, the Keycloak admin console becomes inaccessible after changing the theme to base using the Themes tab.

To apply the issue resolution:

1. Obtain the MySQL admin password:

   kubectl get secret -n kaas mariadb-dbadmin-password -o yaml | awk '/MYSQL_DBADMIN_PASSWORD/ {print $2}' | base64 -d
   

2. Connect to the MariaDB server:

   kubectl exec -it -n kaas mariadb-server-0 -- mysql -h localhost -u root -p
   

3. Update the Keycloak database for the following themes:

   • ADMIN_THEME

   • ACCOUNT_THEME

   • EMAIL_THEME

   • LOGIN_THEME

   For example:

   use keycloak;
   update REALM set ADMIN_THEME = REPLACE(ADMIN_THEME, 'base','keycloak');
   

4. Restart Keycloak:

   kubectl scale sts -n kaas --replicas=0 iam-keycloak
   kubectl scale sts -n kaas --replicas=3 iam-keycloak