summaryrefslogtreecommitdiffstats
path: root/rulemgt-standalone/src/main/assembly/bin
diff options
context:
space:
mode:
authorGuangrong Fu <fu.guangrong@zte.com.cn>2017-09-05 16:46:26 +0800
committerGuangrong Fu <fu.guangrong@zte.com.cn>2017-09-05 17:20:51 +0800
commit6481057c46c57f389e0fb17b7065941ed28299b8 (patch)
tree0ce960a5283f9da0df74edb971f6ce4ac371a633 /rulemgt-standalone/src/main/assembly/bin
parent2def6b625452293a345ae73c4b91abaf9e728d72 (diff)
Change the DB from MySQL to PostgreSQL
Change-Id: If3e82cca0b27c5e486762b22305c1575d76789fe Issue-ID: HOLMES-49 Signed-off-by: Guangrong Fu <fu.guangrong@zte.com.cn>
Diffstat (limited to 'rulemgt-standalone/src/main/assembly/bin')
-rw-r--r--rulemgt-standalone/src/main/assembly/bin/initDB.sh9
-rw-r--r--rulemgt-standalone/src/main/assembly/bin/run.sh4
2 files changed, 8 insertions, 5 deletions
diff --git a/rulemgt-standalone/src/main/assembly/bin/initDB.sh b/rulemgt-standalone/src/main/assembly/bin/initDB.sh
index 6ec9947..c9b5705 100644
--- a/rulemgt-standalone/src/main/assembly/bin/initDB.sh
+++ b/rulemgt-standalone/src/main/assembly/bin/initDB.sh
@@ -23,13 +23,16 @@ port=$3
host=$4
echo "start init holmes rulemgt db"
main_path=$HOME/..
-cat $main_path/dbscripts/mysql/onap-holmes_rulemgt-createobj.sql
+cat $main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql
echo "user="$user
-echo "password"$password
+echo "password="$password
echo "port="$port
echo "host="$host
-mysql -u$user -p$password -P$port -h$host <$main_path/dbscripts/mysql/onap-holmes_rulemgt-createobj.sql
+export PGPASSWORD=$password
+psql -U $user -p $port -h $host -f $main_path/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql
+psql -U $user -p $port -h $host -d holmes --command 'select * from aplus_rule;'
sql_result=$?
+unset PGPASSWORD
cat "sql_result="$sql_result
if [ $sql_result != 0 ] ; then
echo "failed to init rulemgt database!"
diff --git a/rulemgt-standalone/src/main/assembly/bin/run.sh b/rulemgt-standalone/src/main/assembly/bin/run.sh
index 4b36f72..2142059 100644
--- a/rulemgt-standalone/src/main/assembly/bin/run.sh
+++ b/rulemgt-standalone/src/main/assembly/bin/run.sh
@@ -31,14 +31,14 @@ echo @JAVA_OPTS@ $JAVA_OPTS
class_path="$main_path/:$main_path/holmes-rulemgt.jar"
echo @class_path@ $class_path
-sed -i "s|url:.*|url: jdbc:mysql://$URL_JDBC/holmes|" "$main_path/conf/rulemgt.yml"
+sed -i "s|url:.*|url: jdbc:postgresql://$URL_JDBC/holmes|" "$main_path/conf/rulemgt.yml"
sed -i "s|msbServerAddr:.*|msbServerAddr: http://$MSB_ADDR|" "$main_path/conf/rulemgt.yml"
export SERVICE_IP=`hostname -i`
echo SERVICE_IP=${SERVICE_IP}
-./bin/initDB.sh root rootpass 3306 "${URL_JDBC%:*}"
+./bin/initDB.sh holmes holmespwd 5432 "${URL_JDBC%:*}"
"$JAVA" $JAVA_OPTS -classpath "$class_path" org.onap.holmes.rulemgt.RuleActiveApp server "$main_path/conf/rulemgt.yml"