From c04c868f843c7f5b3ba7d81dbddc9fb0504fb5b8 Mon Sep 17 00:00:00 2001 From: GuangrongFu Date: Wed, 10 Mar 2021 10:22:20 +0800 Subject: [PATCH] Init DB Using envsubst Change-Id: Idefe8a70f9ca2634516cf9212372e74505ad91cd Issue-ID: HOLMES-396 Signed-off-by: GuangrongFu --- engine-d-standalone/src/main/assembly/bin/initDB.sh | 6 +++--- engine-d-standalone/src/main/assembly/bin/run.sh | 2 +- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/engine-d-standalone/src/main/assembly/bin/initDB.sh b/engine-d-standalone/src/main/assembly/bin/initDB.sh index 9571e59..3d2e8bc 100644 --- a/engine-d-standalone/src/main/assembly/bin/initDB.sh +++ b/engine-d-standalone/src/main/assembly/bin/initDB.sh @@ -26,7 +26,7 @@ echo "Initializing the holmes engine management database..." main_path=$HOME/.. # if deployed using helm, use the helm-generated configuration file. -if [[ -d /opt/hemconfig ]]; then +if [ -d /opt/hemconfig ]; then cp /opt/hemconfig/onap-holmes_engine-createobj.sql "$main_path/dbscripts/postgresql/onap-holmes_engine-createobj.sql" else sed -i "s|DBNAME|$dbname|g" "$main_path/dbscripts/postgresql/onap-holmes_engine-createobj.sql" @@ -42,7 +42,7 @@ echo "password=$password" echo "port=$port" echo "host=$host" -if [[ -z `env | grep PGPASSWORD` ]]; then +if [ -z `env | grep PGPASSWORD` ]; then export PGPASSWORD=$password need_unset=1 fi @@ -51,7 +51,7 @@ psql -U "$user" -p "$port" -h "$host" -d "$dbname" -f $main_path/dbscripts/postg psql -U "$user" -p "$port" -h "$host" -d "$dbname" --command 'select * from alarm_info;' sql_result=$? -if [[ $need_unset -eq 1 ]]; then +if [ $need_unset -eq 1 ]; then unset PGPASSWORD fi diff --git a/engine-d-standalone/src/main/assembly/bin/run.sh b/engine-d-standalone/src/main/assembly/bin/run.sh index 0969273..4a528d8 100644 --- a/engine-d-standalone/src/main/assembly/bin/run.sh +++ b/engine-d-standalone/src/main/assembly/bin/run.sh @@ -49,7 +49,7 @@ if [ -z ${DB_NAME} ]; then fi # if deployed using helm, use the helm-generated configuration file. -if [[ -d /opt/hemconfig ]]; then +if [ -d /opt/hemconfig ]; then cp /opt/hemconfig/engine-d.yml "$main_path/conf/engine-d.yml" else sed -i "s|url:.*|url: jdbc:postgresql://$URL_JDBC/$DB_NAME|" "$main_path/conf/engine-d.yml" -- 2.16.6