diff options
| author |   andreasgeissler <andreas-geissler@telekom.de> | 2021-03-17 09:49:59 +0100 |
|---|---|---|
| committer |   Sylvain Desbureaux <sylvain.desbureaux@orange.com> | 2021-03-21 18:30:26 +0000 |
| commit | a72340f91c9d12c9bdcdf8d3b514ac01ec177be7 (patch) | |
| tree | f1ec2f7173aa01e4bc84924fba5b8c76b1bb241e | |
| parent | fde94076e689727e8a2c3c5147ce1242dc225f87 (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
| -rwxr-xr-x | kubernetes/sdnc/resources/config/bin/installSdncDb.sh | 4 |
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; |