commit cca4b8e1c75fa9892c49e041623c2749f8f7bc98
author garciadeblas <gerardo.garciadeblas@telefonica.com> Tue Oct 10 11:45:57 2023 +0200
committer garciadeblas <gerardo.garciadeblas@telefonica.com> Thu Oct 19 11:36:41 2023 +0200
tree e895f96bd1a596c609ed747bf9b60c74dd89f4f8
parent 34824fcfc823c7446ed5708a0a8e02950c369209

Update osm helm chart to use version 8.0.34 of mysql server

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

docker/Keystone/scripts/start.sh

diff --git a/docker/Keystone/scripts/start.sh b/docker/Keystone/scripts/start.sh
index d7fa2ab..dde1b5a 100755
--- a/docker/Keystone/scripts/start.sh
+++ b/docker/Keystone/scripts/start.sh
@@ -109,8 +109,10 @@
 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

installers/helm/osm/templates/mysql/mysql-statefulset.yaml

diff --git a/installers/helm/osm/templates/mysql/mysql-statefulset.yaml b/installers/helm/osm/templates/mysql/mysql-statefulset.yaml
index c9b2d16..1a18f4a 100644
--- a/installers/helm/osm/templates/mysql/mysql-statefulset.yaml
+++ b/installers/helm/osm/templates/mysql/mysql-statefulset.yaml
@@ -49,7 +49,7 @@
             # readOnlyRootFilesystem: true
             allowPrivilegeEscalation: false
             # runAsNonRoot: true
-          image: mysql:5
+          image: mysql:8.0.34
           imagePullPolicy: {{ .Values.global.image.pullPolicy }}
           ports:
             - containerPort: 3306