@RUNHOME@ /opt/onap/bin
@JAVA_HOME@ /usr/local/openjdk-11
@JAVA@ /usr/local/openjdk-11/bin/java
@JAVA_OPTS@ -Xms256m -Xmx1g
@class_path@ /opt/onap/bin/../lib/animal-sniffer-annotations-1.18.jar /opt/onap/bin/../lib/annotations-2.0.1.jar /opt/onap/bin/../lib/aopalliance-repackaged-2.6.1.jar /opt/onap/bin/../lib/argparse4j-0.8.1.jar /opt/onap/bin/../lib/caffeine-2.8.4.jar /opt/onap/bin/../lib/checker-qual-3.4.0.jar /opt/onap/bin/../lib/classmate-1.5.1.jar /opt/onap/bin/../lib/commons-codec-1.14.jar /opt/onap/bin/../lib/commons-collections-3.2.2.jar /opt/onap/bin/../lib/commons-lang-2.5.jar /opt/onap/bin/../lib/commons-lang3-3.7.jar /opt/onap/bin/../lib/commons-logging-1.1.1.jar /opt/onap/bin/../lib/commons-text-1.8.jar /opt/onap/bin/../lib/dropwizard-configuration-2.0.10.jar /opt/onap/bin/../lib/dropwizard-core-2.0.10.jar /opt/onap/bin/../lib/dropwizard-db-2.0.10.jar /opt/onap/bin/../lib/dropwizard-jackson-2.0.10.jar /opt/onap/bin/../lib/dropwizard-jdbi-2.0.0-rc9.jar /opt/onap/bin/../lib/dropwizard-jersey-2.0.10.jar /opt/onap/bin/../lib/dropwizard-jetty-2.0.10.jar /opt/onap/bin/../lib/dropwizard-lifecycle-2.0.10.jar /opt/onap/bin/../lib/dropwizard-logging-2.0.10.jar /opt/onap/bin/../lib/dropwizard-metrics-2.0.10.jar /opt/onap/bin/../lib/dropwizard-request-logging-2.0.10.jar /opt/onap/bin/../lib/dropwizard-servlets-2.0.10.jar /opt/onap/bin/../lib/dropwizard-util-2.0.10.jar /opt/onap/bin/../lib/dropwizard-validation-2.0.10.jar /opt/onap/bin/../lib/error_prone_annotations-2.3.2.jar /opt/onap/bin/../lib/ezmorph-1.0.6.jar /opt/onap/bin/../lib/failureaccess-1.0.1.jar /opt/onap/bin/../lib/gson-2.8.6.jar /opt/onap/bin/../lib/guava-28.1-jre.jar /opt/onap/bin/../lib/hibernate-validator-6.1.5.Final.jar /opt/onap/bin/../lib/hk2-api-2.6.1.jar /opt/onap/bin/../lib/hk2-locator-2.6.1.jar /opt/onap/bin/../lib/hk2-utils-2.6.1.jar /opt/onap/bin/../lib/holmes-actions-1.3.2.jar /opt/onap/bin/../lib/holmes-rulemgt-1.3.3-SNAPSHOT.jar /opt/onap/bin/../lib/httpclient-4.5.10.jar /opt/onap/bin/../lib/httpcore-4.4.12.jar /opt/onap/bin/../lib/j2objc-annotations-1.3.jar /opt/onap/bin/../lib/jackson-annotations-2.10.4.jar /opt/onap/bin/../lib/jackson-core-2.10.1.jar /opt/onap/bin/../lib/jackson-databind-2.10.1.jar /opt/onap/bin/../lib/jackson-dataformat-yaml-2.10.4.jar /opt/onap/bin/../lib/jackson-datatype-guava-2.10.4.jar /opt/onap/bin/../lib/jackson-datatype-jdk8-2.10.4.jar /opt/onap/bin/../lib/jackson-datatype-joda-2.10.4.jar /opt/onap/bin/../lib/jackson-datatype-jsr310-2.10.4.jar /opt/onap/bin/../lib/jackson-jaxrs-base-2.10.4.jar /opt/onap/bin/../lib/jackson-jaxrs-json-provider-2.10.4.jar /opt/onap/bin/../lib/jackson-module-afterburner-2.10.4.jar /opt/onap/bin/../lib/jackson-module-jaxb-annotations-2.10.4.jar /opt/onap/bin/../lib/jackson-module-parameter-names-2.10.4.jar /opt/onap/bin/../lib/jakarta.activation-1.2.2.jar /opt/onap/bin/../lib/jakarta.activation-api-1.2.2.jar /opt/onap/bin/../lib/jakarta.annotation-api-1.3.5.jar /opt/onap/bin/../lib/jakarta.el-3.0.3.jar /opt/onap/bin/../lib/jakarta.inject-2.6.1.jar /opt/onap/bin/../lib/jakarta.servlet-api-4.0.3.jar /opt/onap/bin/../lib/jakarta.validation-api-2.0.2.jar /opt/onap/bin/../lib/jakarta.ws.rs-api-2.1.6.jar /opt/onap/bin/../lib/jakarta.xml.bind-api-2.3.3.jar /opt/onap/bin/../lib/javassist-3.24.1-GA.jar /opt/onap/bin/../lib/jboss-logging-3.3.2.Final.jar /opt/onap/bin/../lib/jcl-over-slf4j-1.7.30.jar /opt/onap/bin/../lib/jdbi-2.78.jar /opt/onap/bin/../lib/jersey-bean-validation-2.31.jar /opt/onap/bin/../lib/jersey-client-2.31.jar /opt/onap/bin/../lib/jersey-common-2.31.jar /opt/onap/bin/../lib/jersey-container-servlet-2.31.jar /opt/onap/bin/../lib/jersey-container-servlet-core-2.31.jar /opt/onap/bin/../lib/jersey-hk2-2.31.jar /opt/onap/bin/../lib/jersey-media-jaxb-2.31.jar /opt/onap/bin/../lib/jersey-metainf-services-2.31.jar /opt/onap/bin/../lib/jersey-server-2.31.jar /opt/onap/bin/../lib/jetty-continuation-9.4.29.v20200521.jar /opt/onap/bin/../lib/jetty-http-9.4.24.v20191120.jar /opt/onap/bin/../lib/jetty-io-9.4.29.v20200521.jar /opt/onap/bin/../lib/jetty-security-9.4.29.v20200521.jar /opt/onap/bin/../lib/jetty-server-9.4.24.v20191120.jar /opt/onap/bin/../lib/jetty-servlet-9.4.24.v20191120.jar /opt/onap/bin/../lib/jetty-servlets-9.4.29.v20200521.jar /opt/onap/bin/../lib/jetty-setuid-java-1.0.4.jar /opt/onap/bin/../lib/jetty-util-9.4.29.v20200521.jar /opt/onap/bin/../lib/jna-4.5.1.jar /opt/onap/bin/../lib/jna-platform-4.5.1.jar /opt/onap/bin/../lib/joda-time-2.10.6.jar /opt/onap/bin/../lib/json-lib-2.4-jdk15.jar /opt/onap/bin/../lib/jsr305-3.0.2.jar /opt/onap/bin/../lib/jul-to-slf4j-1.7.30.jar /opt/onap/bin/../lib/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar /opt/onap/bin/../lib/log4j-over-slf4j-1.7.30.jar /opt/onap/bin/../lib/logback-access-1.2.3.jar /opt/onap/bin/../lib/logback-classic-1.2.3.jar /opt/onap/bin/../lib/logback-core-1.2.3.jar /opt/onap/bin/../lib/logback-throttling-appender-1.1.0.jar /opt/onap/bin/../lib/lombok-1.18.4.jar /opt/onap/bin/../lib/metrics-annotation-4.1.9.jar /opt/onap/bin/../lib/metrics-core-4.1.9.jar /opt/onap/bin/../lib/metrics-healthchecks-4.1.9.jar /opt/onap/bin/../lib/metrics-jdbi-4.1.0.jar /opt/onap/bin/../lib/metrics-jersey2-4.1.9.jar /opt/onap/bin/../lib/metrics-jetty9-4.1.9.jar /opt/onap/bin/../lib/metrics-jmx-4.1.9.jar /opt/onap/bin/../lib/metrics-json-4.1.9.jar /opt/onap/bin/../lib/metrics-jvm-4.1.9.jar /opt/onap/bin/../lib/metrics-logback-4.1.9.jar /opt/onap/bin/../lib/metrics-servlets-4.1.9.jar /opt/onap/bin/../lib/msb-java-sdk-1.2.5.jar /opt/onap/bin/../lib/okhttp-3.14.1.jar /opt/onap/bin/../lib/okio-1.17.2.jar /opt/onap/bin/../lib/org.osgi.core-4.3.1.jar /opt/onap/bin/../lib/org.osgi.enterprise-4.2.0.jar /opt/onap/bin/../lib/osgi-resource-locator-1.0.3.jar /opt/onap/bin/../lib/postgresql-42.2.13.jar /opt/onap/bin/../lib/profiler-1.1.1.jar /opt/onap/bin/../lib/reflections-0.9.9.jar /opt/onap/bin/../lib/retrofit-2.5.0.jar /opt/onap/bin/../lib/slf4j-api-1.7.25.jar /opt/onap/bin/../lib/snakeyaml-1.26.jar /opt/onap/bin/../lib/tomcat-jdbc-9.0.35.jar /opt/onap/bin/../lib/tomcat-juli-9.0.35.jar /opt/onap/bin/../lib/waffle-jna-1.9.1.jar
SERVICE_IP=fd00:100::a39f
DB_PORT=5432
ENABLE_ENCRYPT=true
KEY_PATH=/opt/app/osaaf/local/org.onap.holmes-rule-mgmt.p12
KEY_PASS=5QSI4SeGdL60vP6B9GmbY7ONPhfgLsG5M4WDSrGfJa8DWIkrETyVWkndw5J93qj2
Initializing the holmes rule management database...
--
-- Copyright 2017 ZTE Corporation.
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
--     http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
\c postgres

/******************CREATE NEW DATABASE AND USER***************************/
CREATE DATABASE holmes;

CREATE ROLE holmes with PASSWORD 'HefxFohiBakx6-' LOGIN;

\encoding UTF8;

/******************DELETE OLD TABLE AND CREATE NEW***************************/
\c holmes;

CREATE TABLE IF NOT EXISTS APLUS_RULE (
  RID VARCHAR(30) NOT NULL,
  NAME VARCHAR(150) NOT NULL,
  CTRLLOOP VARCHAR(150) NOT NULL,
  DESCRIPTION VARCHAR(4000) NULL,
  ENABLE SMALLINT NOT NULL,
  TEMPLATEID BIGINT NOT NULL,
  ENGINEID VARCHAR(20)  NOT NULL,
  ENGINETYPE VARCHAR(20)  NOT NULL,
  CREATOR VARCHAR(20)  NOT NULL,
  CREATETIME TIMESTAMP NOT NULL,
  UPDATOR VARCHAR(20)  NULL,
  UPDATETIME TIMESTAMP NULL,
  PARAMS VARCHAR(4000) NULL,
  CONTENT VARCHAR(20000) NOT NULL,
  VENDOR VARCHAR(100)  NOT NULL,
  ENGINEINSTANCE VARCHAR(100) NOT NULL,
  PACKAGE VARCHAR(255) NULL,
  PRIMARY KEY (RID),
  UNIQUE (NAME)
);

CREATE INDEX IDX_APLUS_RULE_NAME ON APLUS_RULE (NAME);
CREATE INDEX IDX_APLUS_RULE_CTRLLOOP ON APLUS_RULE (CTRLLOOP);
CREATE INDEX IDX_APLUS_RULE_ENABLE ON APLUS_RULE (ENABLE);
CREATE INDEX IDX_APLUS_RULE_TEMPLATEID ON APLUS_RULE (TEMPLATEID);
CREATE INDEX IDX_APLUS_RULE_ENGINEID ON APLUS_RULE (ENGINEID);
CREATE INDEX IDX_APLUS_RULE_ENGINETYPE ON APLUS_RULE (ENGINETYPE);

GRANT ALL PRIVILEGES ON APLUS_RULE TO holmes;
dbname=holmes
user=holmes
password=HefxFohiBakx6-
port=5432
host=holmes-postgres-primary
psql: invalid port number: "'5432'"
psql: invalid port number: "'5432'"
/opt/onap/bin/initDB.sh: 52: [: x: unexpected operator
sql_result=2
Failed to initialize the database!
nginx started.