diff options
Diffstat (limited to 'rulemgt-standalone/src/main/assembly/bin')
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/bin/initDB.sh | 9 | ||||
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/bin/run.sh | 4 |
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" |