summaryrefslogtreecommitdiffstats
path: root/kubernetes/sdnc/resources/config/bin/installSdncDb.sh
diff options
context:
space:
mode:
authorandreasgeissler <andreas-geissler@telekom.de>2021-03-17 09:49:59 +0100
committerSylvain Desbureaux <sylvain.desbureaux@orange.com>2021-03-21 18:30:26 +0000
commita72340f91c9d12c9bdcdf8d3b514ac01ec177be7 (patch)
treef1ec2f7173aa01e4bc84924fba5b8c76b1bb241e /kubernetes/sdnc/resources/config/bin/installSdncDb.sh
parentfde94076e689727e8a2c3c5147ce1242dc225f87 (diff)
[SDNC] Check existance of DB user before creation
When installing SDNC in a local DB, the execution of the DB initialisation job fails as the user already exists and granting the privileges to the DB is not executed. This patch will only create the user and DB if not already present. Issue-ID: OOM-2705 Signed-off-by: andreasgeissler <andreas-geissler@telekom.de> Change-Id: Iabfc90829cea1f98181caf3367c8f2b78de96c7f
Diffstat (limited to 'kubernetes/sdnc/resources/config/bin/installSdncDb.sh')
-rwxr-xr-xkubernetes/sdnc/resources/config/bin/installSdncDb.sh4
1 files changed, 2 insertions, 2 deletions
diff --git a/kubernetes/sdnc/resources/config/bin/installSdncDb.sh b/kubernetes/sdnc/resources/config/bin/installSdncDb.sh
index 11ed7f45bf..42abf54444 100755
--- a/kubernetes/sdnc/resources/config/bin/installSdncDb.sh
+++ b/kubernetes/sdnc/resources/config/bin/installSdncDb.sh
@@ -37,8 +37,8 @@ SDNC_DB_DATABASE=${SDNC_DB_DATABASE}
# Create tablespace and user account
mysql -h ${MYSQL_HOST} -u root -p${MYSQL_PASSWORD} mysql <<-END
CREATE DATABASE IF NOT EXISTS ${SDNC_DB_DATABASE};
-CREATE USER '${SDNC_DB_USER}'@'localhost' IDENTIFIED BY '${SDNC_DB_PASSWORD}';
-CREATE USER '${SDNC_DB_USER}'@'%' IDENTIFIED BY '${SDNC_DB_PASSWORD}';
+CREATE USER IF NOT EXISTS '${SDNC_DB_USER}'@'localhost' IDENTIFIED BY '${SDNC_DB_PASSWORD}';
+CREATE USER IF NOT EXISTS '${SDNC_DB_USER}'@'%' IDENTIFIED BY '${SDNC_DB_PASSWORD}';
GRANT ALL PRIVILEGES ON ${SDNC_DB_DATABASE}.* TO '${SDNC_DB_USER}'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON ${SDNC_DB_DATABASE}.* TO '${SDNC_DB_USER}'@'%' WITH GRANT OPTION;
flush privileges;