From: garciadeblas <gerardo.garciadeblas@telefonica.com>
Date: Tue, 10 Oct 2023 09:45:57 +0000 (+0200)
Subject: Update osm helm chart to use version 8.0.34 of mysql server
X-Git-Tag: release-v15.0-start~13
X-Git-Url: https://osm.etsi.org/gitweb/?p=osm%2Fdevops.git;a=commitdiff_plain;h=cca4b8e1c75fa9892c49e041623c2749f8f7bc98

Update osm helm chart to use version 8.0.34 of mysql server

Change-Id: I4804d7da812c50283dd0cd3f5398fb4bbb9b93c2
Signed-off-by: garciadeblas <gerardo.garciadeblas@telefonica.com>
---

diff --git a/docker/Keystone/scripts/start.sh b/docker/Keystone/scripts/start.sh
index d7fa2abd..dde1b5ae 100755
--- a/docker/Keystone/scripts/start.sh
+++ b/docker/Keystone/scripts/start.sh
@@ -109,8 +109,10 @@ else
 fi
 
 if [ -z $USER_DB_EXISTS ]; then
-    mysql -h"$DB_HOST" -P"$DB_PORT" -u"$ROOT_DB_USER" -p"$ROOT_DB_PASSWORD" --default_character_set utf8 -e "GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' IDENTIFIED BY '$KEYSTONE_DB_PASSWORD'"
-    mysql -h"$DB_HOST" -P"$DB_PORT" -u"$ROOT_DB_USER" -p"$ROOT_DB_PASSWORD" --default_character_set utf8 -e "GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' IDENTIFIED BY '$KEYSTONE_DB_PASSWORD'"
+    mysql -h"$DB_HOST" -P"$DB_PORT" -u"$ROOT_DB_USER" -p"$ROOT_DB_PASSWORD" --default_character_set utf8 -e "CREATE USER 'keystone'@'localhost' IDENTIFIED BY '$KEYSTONE_DB_PASSWORD'"
+    mysql -h"$DB_HOST" -P"$DB_PORT" -u"$ROOT_DB_USER" -p"$ROOT_DB_PASSWORD" --default_character_set utf8 -e "GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost'"
+    mysql -h"$DB_HOST" -P"$DB_PORT" -u"$ROOT_DB_USER" -p"$ROOT_DB_PASSWORD" --default_character_set utf8 -e "CREATE USER 'keystone'@'%' IDENTIFIED BY '$KEYSTONE_DB_PASSWORD'"
+    mysql -h"$DB_HOST" -P"$DB_PORT" -u"$ROOT_DB_USER" -p"$ROOT_DB_PASSWORD" --default_character_set utf8 -e "GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%'"
 fi
 
 # Setting Keystone database connection
diff --git a/installers/helm/osm/templates/mysql/mysql-statefulset.yaml b/installers/helm/osm/templates/mysql/mysql-statefulset.yaml
index c9b2d161..1a18f4a3 100644
--- a/installers/helm/osm/templates/mysql/mysql-statefulset.yaml
+++ b/installers/helm/osm/templates/mysql/mysql-statefulset.yaml
@@ -49,7 +49,7 @@ spec:
             # readOnlyRootFilesystem: true
             allowPrivilegeEscalation: false
             # runAsNonRoot: true
-          image: mysql:5
+          image: mysql:8.0.34
           imagePullPolicy: {{ .Values.global.image.pullPolicy }}
           ports:
             - containerPort: 3306