@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/antlr-runtime-3.5.2.jar /opt/onap/bin/../lib/antlr4-runtime-4.9.jar /opt/onap/bin/../lib/aopalliance-repackaged-3.0.3.jar /opt/onap/bin/../lib/caffeine-2.9.3.jar /opt/onap/bin/../lib/checker-qual-3.5.0.jar /opt/onap/bin/../lib/commons-codec-1.15.jar /opt/onap/bin/../lib/commons-collections-3.2.2.jar /opt/onap/bin/../lib/commons-lang3-3.12.0.jar /opt/onap/bin/../lib/drools-compiler-7.62.0.Final.jar /opt/onap/bin/../lib/drools-core-7.62.0.Final.jar /opt/onap/bin/../lib/drools-core-dynamic-7.62.0.Final.jar /opt/onap/bin/../lib/drools-core-reflective-7.62.0.Final.jar /opt/onap/bin/../lib/drools-ecj-7.62.0.Final.jar /opt/onap/bin/../lib/drools-mvel-7.62.0.Final.jar /opt/onap/bin/../lib/drools-templates-7.62.0.Final.jar /opt/onap/bin/../lib/ecj-4.5.1.jar /opt/onap/bin/../lib/error_prone_annotations-2.3.2.jar /opt/onap/bin/../lib/failureaccess-1.0.1.jar /opt/onap/bin/../lib/geantyref-1.3.11.jar /opt/onap/bin/../lib/gson-2.8.6.jar /opt/onap/bin/../lib/guava-28.1-jre.jar /opt/onap/bin/../lib/hk2-api-3.0.3.jar /opt/onap/bin/../lib/hk2-locator-3.0.3.jar /opt/onap/bin/../lib/hk2-utils-3.0.3.jar /opt/onap/bin/../lib/holmes-actions-1.4.4.jar /opt/onap/bin/../lib/holmes-engine-d-1.3.8-SNAPSHOT.jar /opt/onap/bin/../lib/j2objc-annotations-1.3.jar /opt/onap/bin/../lib/jackson-annotations-2.13.3.jar /opt/onap/bin/../lib/jackson-core-2.13.3.jar /opt/onap/bin/../lib/jackson-databind-2.13.3.jar /opt/onap/bin/../lib/jackson-module-jakarta-xmlbind-annotations-2.13.3.jar /opt/onap/bin/../lib/jakarta.activation-1.2.2.jar /opt/onap/bin/../lib/jakarta.activation-api-2.1.0.jar /opt/onap/bin/../lib/jakarta.annotation-api-2.1.1.jar /opt/onap/bin/../lib/jakarta.inject-api-2.0.1.jar /opt/onap/bin/../lib/jakarta.validation-api-2.0.2.jar /opt/onap/bin/../lib/jakarta.ws.rs-api-3.1.0.jar /opt/onap/bin/../lib/jakarta.xml.bind-api-4.0.0.jar /opt/onap/bin/../lib/javassist-3.24.1-GA.jar /opt/onap/bin/../lib/javax.activation-api-1.2.0.jar /opt/onap/bin/../lib/javax.servlet-api-4.0.1.jar /opt/onap/bin/../lib/jaxb-api-2.3.1.jar /opt/onap/bin/../lib/jdbi3-core-3.19.0.jar /opt/onap/bin/../lib/jdbi3-postgres-3.19.0.jar /opt/onap/bin/../lib/jdbi3-sqlobject-3.19.0.jar /opt/onap/bin/../lib/jersey-client-3.0.5.jar /opt/onap/bin/../lib/jersey-common-3.0.5.jar /opt/onap/bin/../lib/jersey-container-servlet-core-3.0.5.jar /opt/onap/bin/../lib/jersey-entity-filtering-3.0.5.jar /opt/onap/bin/../lib/jersey-hk2-3.0.5.jar /opt/onap/bin/../lib/jersey-media-json-jackson-3.0.5.jar /opt/onap/bin/../lib/jersey-server-3.0.5.jar /opt/onap/bin/../lib/jsr305-3.0.2.jar /opt/onap/bin/../lib/jul-to-slf4j-1.7.36.jar /opt/onap/bin/../lib/kie-api-7.62.0.Final.jar /opt/onap/bin/../lib/kie-internal-7.62.0.Final.jar /opt/onap/bin/../lib/kie-memory-compiler-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-commons-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-maven-support-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-project-datamodel-api-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-project-datamodel-commons-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-xstream-7.62.0.Final.jar /opt/onap/bin/../lib/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar /opt/onap/bin/../lib/log4j-api-2.17.2.jar /opt/onap/bin/../lib/log4j-to-slf4j-2.17.2.jar /opt/onap/bin/../lib/logback-classic-1.2.11.jar /opt/onap/bin/../lib/logback-core-1.2.11.jar /opt/onap/bin/../lib/lombok-1.18.16.jar /opt/onap/bin/../lib/msb-java-sdk-1.2.5.jar /opt/onap/bin/../lib/mvel2-2.4.13.Final.jar /opt/onap/bin/../lib/mxparser-1.2.2.jar /opt/onap/bin/../lib/okhttp-3.14.1.jar /opt/onap/bin/../lib/okio-1.17.2.jar /opt/onap/bin/../lib/osgi-resource-locator-1.0.3.jar /opt/onap/bin/../lib/postgresql-42.3.6.jar /opt/onap/bin/../lib/reflections-0.9.9.jar /opt/onap/bin/../lib/slf4j-api-1.7.25.jar /opt/onap/bin/../lib/snakeyaml-1.30.jar /opt/onap/bin/../lib/spring-aop-5.3.22.jar /opt/onap/bin/../lib/spring-beans-5.3.22.jar /opt/onap/bin/../lib/spring-boot-2.7.2.jar /opt/onap/bin/../lib/spring-boot-autoconfigure-2.7.2.jar /opt/onap/bin/../lib/spring-boot-starter-2.7.2.jar /opt/onap/bin/../lib/spring-boot-starter-logging-2.7.2.jar /opt/onap/bin/../lib/spring-boot-starter-tomcat-2.7.2.jar /opt/onap/bin/../lib/spring-boot-starter-web-2.7.2.jar /opt/onap/bin/../lib/spring-context-5.3.22.jar /opt/onap/bin/../lib/spring-core-5.3.22.jar /opt/onap/bin/../lib/spring-expression-5.3.22.jar /opt/onap/bin/../lib/spring-jcl-5.3.22.jar /opt/onap/bin/../lib/spring-jdbc-5.3.22.jar /opt/onap/bin/../lib/spring-tx-5.3.22.jar /opt/onap/bin/../lib/spring-web-5.3.22.jar /opt/onap/bin/../lib/spring-webmvc-5.3.22.jar /opt/onap/bin/../lib/tomcat-embed-core-9.0.65.jar /opt/onap/bin/../lib/tomcat-embed-el-9.0.65.jar /opt/onap/bin/../lib/tomcat-embed-websocket-9.0.65.jar /opt/onap/bin/../lib/xmlpull-1.1.3.1.jar /opt/onap/bin/../lib/xstream-1.4.19.jar DB_PORT=5432 SERVICE_IP=10.233.65.35 ENABLE_ENCRYPT=true KEY_PATH=/opt/onap/bin/../conf/holmes.keystore KEY_PASS=holmes server: port: 9102 servlet: context-path: /api/holmes-engine-mgmt/v1 ssl: key-store: /opt/onap/bin/../conf/holmes.keystore key-store-password: holmes #PKCS12 key-store-type: JKS logging: config: classpath:logback-spring.xml spring: application: name: Holmes Engine Management datasource: dirver-class-name: org.postgresql.Driver url: jdbc:postgresql://tcp-pgset-primary:5432/holmes username: holmes password: JudiTirv3~Kuho mvc: throw-exception-if-no-handler-found: trueInitializing the holmes engine 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 'JudiTirv3~Kuho' LOGIN; \encoding UTF8; /******************CREATE NEW TABLE***************************/ \c holmes; CREATE TABLE IF NOT EXISTS ALARM_INFO ( EVENTID VARCHAR(150) NOT NULL, EVENTNAME VARCHAR(150) NOT NULL, ALARMISCLEARED SMALLINT NOT NULL, ROOTFLAG SMALLINT NOT NULL, STARTEPOCHMICROSEC BIGINT NOT NULL, LASTEPOCHMICROSEC BIGINT NOT NULL, SOURCEID VARCHAR(150) NOT NULL, SOURCENAME VARCHAR(150) NOT NULL, SEQUENCE SMALLINT NOT NULL, PRIMARY KEY (EVENTID, SEQUENCE, SOURCENAME) ); CREATE TABLE IF NOT EXISTS ENGINE_ENTITY ( ID VARCHAR(150) NOT NULL, IP VARCHAR(128) NOT NULL, PORT SMALLINT NOT NULL, LASTMODIFIED BIGINT NOT NULL, PRIMARY KEY (ID) ); GRANT ALL PRIVILEGES ON ALARM_INFO TO holmes; GRANT ALL PRIVILEGES ON ENGINE_ENTITY TO holmes; dbname=holmes user=holmes password=JudiTirv3~Kuho port=5432 host=tcp-pgset-primary You are now connected to database "postgres" as user "holmes". psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:19: ERROR: permission denied to create database psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:21: ERROR: permission denied to create role You are now connected to database "holmes" as user "holmes". psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:39: NOTICE: relation "alarm_info" already exists, skipping CREATE TABLE psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:47: NOTICE: relation "engine_entity" already exists, skipping CREATE TABLE GRANT GRANT eventid | eventname | alarmiscleared | rootflag | startepochmicrosec | lastepochmicrosec | sourceid | sourcename | sequence ---------+-----------+----------------+----------+--------------------+-------------------+----------+------------+---------- (0 rows) sql_result=0 The database is initialized successfully! . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.7.2) 2022-11-22 01:43:17 113 INFO [org.onap.holmes.engine.EngineDActiveApp][main][][] - Starting EngineDActiveApp using Java 11.0.6 on onap-holmes-engine-mgmt-dcbb49bc8-vwxtq with PID 53 (/opt/onap/lib/holmes-engine-d-1.3.8-SNAPSHOT.jar started by onap in /opt/onap) 2022-11-22 01:43:17 118 INFO [org.onap.holmes.engine.EngineDActiveApp][main][][] - No active profile set, falling back to 1 default profile: "default" 2022-11-22 01:43:19 198 INFO [org.springframework.boot.web.embedded.tomcat.TomcatWebServer][main][][] - Tomcat initialized with port(s): 9102 (https) 2022-11-22 01:43:19 214 INFO [org.apache.coyote.http11.Http11NioProtocol][main][][] - Initializing ProtocolHandler ["https-jsse-nio-9102"] 2022-11-22 01:43:19 215 INFO [org.apache.catalina.core.StandardService][main][][] - Starting service [Tomcat] 2022-11-22 01:43:19 216 INFO [org.apache.catalina.core.StandardEngine][main][][] - Starting Servlet engine: [Apache Tomcat/9.0.65] 2022-11-22 01:43:19 331 INFO [org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/api/holmes-engine-mgmt/v1]][main][][] - Initializing Spring embedded WebApplicationContext 2022-11-22 01:43:19 332 INFO [org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext][main][][] - Root WebApplicationContext: initialization completed in 2122 ms