From 71a281bb8df312213cb231c9eb8a46caf2566432 Mon Sep 17 00:00:00 2001 From: statta Date: Thu, 7 May 2020 11:10:28 -0400 Subject: [PATCH 1/1] Update Docker Release version Modify Update DB script. Issue-ID: PORTAL-900, PORTAL-894 Signed-off-by: statta Change-Id: I224826ef027e38d88f035fcef64969137154fd4d (cherry picked from commit 65d1504ec789ee67496f66f985520aab58c5e4df) --- kubernetes/portal/charts/portal-app/values.yaml | 2 +- .../charts/portal-mariadb/resources/config/mariadb/oom_updates.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/kubernetes/portal/charts/portal-app/values.yaml b/kubernetes/portal/charts/portal-app/values.yaml index 8d18fd0dbd..01bc0dab93 100644 --- a/kubernetes/portal/charts/portal-app/values.yaml +++ b/kubernetes/portal/charts/portal-app/values.yaml @@ -32,7 +32,7 @@ global: # application image repository: nexus3.onap.org:10001 -image: onap/portal-app:3.2.0 +image: onap/portal-app:3.2.1 pullPolicy: Always #AAF local config diff --git a/kubernetes/portal/charts/portal-mariadb/resources/config/mariadb/oom_updates.sql b/kubernetes/portal/charts/portal-mariadb/resources/config/mariadb/oom_updates.sql index 13b319c76a..7502e9322a 100644 --- a/kubernetes/portal/charts/portal-mariadb/resources/config/mariadb/oom_updates.sql +++ b/kubernetes/portal/charts/portal-mariadb/resources/config/mariadb/oom_updates.sql @@ -78,7 +78,7 @@ update fn_app set app_username='aaiui', app_password='4LK69amiIFtuzcl6Gsv97Tt7ML /* Replace spaces with underscores for role names to match AAF role names */ -UPDATE fn_role SET role_name= REPLACE(role_name, ' ', '_') WHERE active_yn= 'Y'; +UPDATE fn_role SET role_name= REPLACE(role_name, ' ', '_') WHERE active_yn= 'Y' AND role_id NOT IN (999); /* -- 2.16.6