diff options
| -rw-r--r-- | standalone/src/main/assembly/bin/run.sh | 2 | ||||
| -rw-r--r-- | standalone/src/main/assembly/resources/bin/initDB.sh | 19 |
2 files changed, 13 insertions, 8 deletions
diff --git a/standalone/src/main/assembly/bin/run.sh b/standalone/src/main/assembly/bin/run.sh index 57b49897..679fc208 100644 --- a/standalone/src/main/assembly/bin/run.sh +++ b/standalone/src/main/assembly/bin/run.sh @@ -25,7 +25,7 @@ sleep 10 echo "usecase-ui database init script start..." dbScript="$main_path/resources/bin/initDB.sh" chmod 755 $dbScript -source $dbScript postgres postgres 127.0.0.1 5432 postgres +source $dbScript 127.0.0.1 5432 postgres postgres postgres echo "usecase-ui database init script finished normally..." JAVA_PATH="$JAVA_HOME/bin/java" diff --git a/standalone/src/main/assembly/resources/bin/initDB.sh b/standalone/src/main/assembly/resources/bin/initDB.sh index a7ee1eed..8c4cc8b8 100644 --- a/standalone/src/main/assembly/resources/bin/initDB.sh +++ b/standalone/src/main/assembly/resources/bin/initDB.sh @@ -17,17 +17,22 @@ echo "setting database init parameters" main_path="/home/uui" -user=$1 -password=$2 -host=$3 -port=$4 -dbname=$5 +host=$1 +port=$2 +dbname=$3 +user=$4 +password=$5 + +echo "setting postgres database password" +su - $user <<EOF +psql --command "alter user $user with password '$password';" +EOF echo "start create usecase-ui database..." dbscripts_path="$main_path/resources/dbscripts/postgres" psql "host=$host port=$port user=$user password=$password dbname=$dbname" -f $dbscripts_path/uui_create_db.sql sql_result=$? -if [ $sql_result!=0 ] then +if [ $sql_result!=0 ]; then echo "failed to create usecase-ui database!" exit 1 else @@ -37,7 +42,7 @@ fi echo "start create usecase-ui tables..." psql "host=$host port=$port user=$user password=$password dbname=$dbname" -f $dbscripts_path/uui_create_table.sql sql_result=$? -if [ $sql_result!=0 ] then +if [ $sql_result!=0 ]; then echo "failed to create usecase-ui table!" exit 1 else |