diff options
Diffstat (limited to 'rulemgt-standalone')
| -rw-r--r-- | rulemgt-standalone/linux64-assembly.xml | 31 | ||||
| -rw-r--r-- | rulemgt-standalone/pom.xml | 174 | ||||
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/bin/find_kill_process.bat | 24 | ||||
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/bin/initDB.bat | 34 | ||||
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/bin/initDB.sh | 34 | ||||
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/bin/run.bat | 41 | ||||
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/bin/run.sh | 35 | ||||
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/bin/stop.bat | 34 | ||||
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/bin/stop.sh | 44 | ||||
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/conf/rulemgt.yml | 127 | ||||
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql | 58 | ||||
| -rw-r--r-- | rulemgt-standalone/win64-assembly.xml | 31 |
12 files changed, 667 insertions, 0 deletions
diff --git a/rulemgt-standalone/linux64-assembly.xml b/rulemgt-standalone/linux64-assembly.xml new file mode 100644 index 0000000..4bb9c11 --- /dev/null +++ b/rulemgt-standalone/linux64-assembly.xml @@ -0,0 +1,31 @@ +<!-- + + 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. + +--> +<assembly xmlns="http://maven.apache.org/plugins/maven-assembly-plugin/assembly/1.1.2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://maven.apache.org/plugins/maven-assembly-plugin/assembly/1.1.2 http://maven.apache.org/xsd/assembly-1.1.2.xsd"> + <id>linux64</id> + <formats> + <format>zip</format> + </formats> + <includeBaseDirectory>false</includeBaseDirectory> + <fileSets> + <fileSet> + <directory>target/assembly/linux64</directory> + <outputDirectory></outputDirectory> + </fileSet> + </fileSets> +</assembly> diff --git a/rulemgt-standalone/pom.xml b/rulemgt-standalone/pom.xml new file mode 100644 index 0000000..ea4b985 --- /dev/null +++ b/rulemgt-standalone/pom.xml @@ -0,0 +1,174 @@ +<?xml version="1.0"?> +<!-- + + 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. + +--> +<project xmlns="http://maven.apache.org/POM/4.0.0" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> + <parent> + <groupId>org.openo.holmes.rule-management</groupId> + <artifactId>holmes-rulemgt-parent</artifactId> + <version>1.1.0-SNAPSHOT</version> + </parent> + + <artifactId>holmes-rulemgt-standalone</artifactId> + <modelVersion>4.0.0</modelVersion> + <name>holmes-rulemgt/holmes-rulemgt-standalone</name> + <packaging>pom</packaging> + + <build> + <plugins> + <plugin> + <artifactId>maven-resources-plugin</artifactId> + <executions> + <execution> + <id>copy-resources-${linux64id}</id> + <phase>process-resources</phase> + <goals> + <goal>copy-resources</goal> + </goals> + <configuration> + <outputDirectory>${linux64outputdir}</outputDirectory> + <resources> + <resource> + <directory>src/main/assembly/</directory> + <filtering>false</filtering> + <includes> + <include>**/*</include> + </includes> + <excludes> + <exclude>**/*.bat</exclude> + </excludes> + </resource> + </resources> + <overwrite>true</overwrite> + </configuration> + </execution> + <execution> + <id>copy-resources-${win64id}</id> + <phase>process-resources</phase> + <goals> + <goal>copy-resources</goal> + </goals> + <configuration> + <outputDirectory>${win64outputdir}</outputDirectory> + <resources> + <resource> + <directory>src/main/assembly/</directory> + <filtering>false</filtering> + <includes> + <include>**/*</include> + </includes> + <excludes> + <exclude>**/*.sh</exclude> + </excludes> + </resource> + </resources> + <overwrite>true</overwrite> + </configuration> + </execution> + </executions> + </plugin> + <plugin> + <groupId>org.apache.maven.plugins</groupId> + <artifactId>maven-dependency-plugin</artifactId> + <executions> + <execution> + <id>copy-jar-${linux64id}</id> + <goals> + <goal>copy</goal> + </goals> + <phase>prepare-package</phase> + <configuration> + <artifactItems> + <artifactItem> + <groupId>org.openo.holmes.rule-management</groupId> + <artifactId>holmes-rulemgt</artifactId> + <type>jar</type> + <overWrite>true</overWrite> + <outputDirectory>${linux64outputdir}</outputDirectory> + <destFileName>holmes-rulemgt.jar</destFileName> + </artifactItem> + </artifactItems> + </configuration> + </execution> + <execution> + <id>copy-jar-${win64id}</id> + <goals> + <goal>copy</goal> + </goals> + <phase>prepare-package</phase> + <configuration> + <artifactItems> + <artifactItem> + <groupId>org.openo.holmes.rule-management</groupId> + <artifactId>holmes-rulemgt</artifactId> + <type>jar</type> + <overWrite>true</overWrite> + <outputDirectory>${win64outputdir}</outputDirectory> + <destFileName>holmes-rulemgt.jar</destFileName> + </artifactItem> + </artifactItems> + </configuration> + </execution> + </executions> + </plugin> + <plugin> + <groupId>org.apache.maven.plugins</groupId> + <artifactId>maven-assembly-plugin</artifactId> + <executions> + <execution> + <id>linux64</id> + <configuration> + <descriptors> + <descriptor>linux64-assembly.xml</descriptor> + </descriptors> + <appendAssemblyId>true</appendAssemblyId> + <outputDirectory>target/version</outputDirectory> + </configuration> + <phase>package</phase> + <goals> + <goal>attached</goal> + </goals> + </execution> + <execution> + <id>win64</id> + <configuration> + <descriptors> + <descriptor>win64-assembly.xml</descriptor> + </descriptors> + <appendAssemblyId>true</appendAssemblyId> + <outputDirectory>target/version</outputDirectory> + </configuration> + <phase>package</phase> + <goals> + <goal>attached</goal> + </goals> + </execution> + </executions> + </plugin> + </plugins> + </build> + + <dependencies> + <dependency> + <groupId>org.openo.holmes.rule-management</groupId> + <artifactId>holmes-rulemgt</artifactId> + <version>${project.version}</version> + </dependency> + </dependencies> +</project> diff --git a/rulemgt-standalone/src/main/assembly/bin/find_kill_process.bat b/rulemgt-standalone/src/main/assembly/bin/find_kill_process.bat new file mode 100644 index 0000000..6c61d50 --- /dev/null +++ b/rulemgt-standalone/src/main/assembly/bin/find_kill_process.bat @@ -0,0 +1,24 @@ +@REM
+@REM Copyright 2017 ZTE Corporation.
+@REM
+@REM Licensed under the Apache License, Version 2.0 (the "License");
+@REM you may not use this file except in compliance with the License.
+@REM You may obtain a copy of the License at
+@REM
+@REM http://www.apache.org/licenses/LICENSE-2.0
+@REM
+@REM Unless required by applicable law or agreed to in writing, software
+@REM distributed under the License is distributed on an "AS IS" BASIS,
+@REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+@REM See the License for the specific language governing permissions and
+@REM limitations under the License.
+@REM
+
+echo %1 | findstr %2 >NUL
+echo ERRORLEVEL=%ERRORLEVEL%
+IF ERRORLEVEL 1 goto findend
+for /f "tokens=1" %%a in (%1) do (
+ echo kill %1
+ taskkill /F /pid %%a
+)
+:findend
\ No newline at end of file diff --git a/rulemgt-standalone/src/main/assembly/bin/initDB.bat b/rulemgt-standalone/src/main/assembly/bin/initDB.bat new file mode 100644 index 0000000..f6d83af --- /dev/null +++ b/rulemgt-standalone/src/main/assembly/bin/initDB.bat @@ -0,0 +1,34 @@ +@REM +@REM Copyright 2017 ZTE Corporation. +@REM +@REM Licensed under the Apache License, Version 2.0 (the "License"); +@REM you may not use this file except in compliance with the License. +@REM You may obtain a copy of the License at +@REM +@REM http://www.apache.org/licenses/LICENSE-2.0 +@REM +@REM Unless required by applicable law or agreed to in writing, software +@REM distributed under the License is distributed on an "AS IS" BASIS, +@REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +@REM See the License for the specific language governing permissions and +@REM limitations under the License. +@REM + +@echo off +set HOME=%~dp0 +set user=%1 +set password=%2 +set port=%3 +set host=%4 +echo start init holmes rulemgt db +echo HOME=%HOME% +set main_path=%HOME%..\ +cd /d %main_path% +mysql -u%user% -p%password% -P%port% -h%host% < %main_path%\dbscripts\mysql\openo-holmes_rulemgt-createobj.sql +set "err=%errorlevel%" +if "%err%"=="0" ( + echo init rulemgt db success + ) else ( + echo failed init rulemgt db + pause + )
\ No newline at end of file diff --git a/rulemgt-standalone/src/main/assembly/bin/initDB.sh b/rulemgt-standalone/src/main/assembly/bin/initDB.sh new file mode 100644 index 0000000..f49123d --- /dev/null +++ b/rulemgt-standalone/src/main/assembly/bin/initDB.sh @@ -0,0 +1,34 @@ +#!/bin/bash +# +# 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. +# + +DIRNAME=`dirname $0` +HOME=`cd $DIRNAME/; pwd` +user=$1 +password=$2 +port=$3 +host=$4 +echo "start init holmes rulemgt db" +main_path=$HOME/../ +mysql -u$user -p$password -P$port -h$host <$main_path/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql +sql_result=$? +if [ $sql_result != 0 ] ; then + echo "failed to init rulemgt database!" + exit 1 +fi +echo "init rulemgt success!" +exit 0 + diff --git a/rulemgt-standalone/src/main/assembly/bin/run.bat b/rulemgt-standalone/src/main/assembly/bin/run.bat new file mode 100644 index 0000000..6553c82 --- /dev/null +++ b/rulemgt-standalone/src/main/assembly/bin/run.bat @@ -0,0 +1,41 @@ +@REM
+@REM Copyright 2017 ZTE Corporation.
+@REM
+@REM Licensed under the Apache License, Version 2.0 (the "License");
+@REM you may not use this file except in compliance with the License.
+@REM You may obtain a copy of the License at
+@REM
+@REM http://www.apache.org/licenses/LICENSE-2.0
+@REM
+@REM Unless required by applicable law or agreed to in writing, software
+@REM distributed under the License is distributed on an "AS IS" BASIS,
+@REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+@REM See the License for the specific language governing permissions and
+@REM limitations under the License.
+@REM
+
+@echo off
+title holmes-rulemgt-service
+
+set RUNHOME=%~dp0
+echo ### RUNHOME: %RUNHOME%
+echo ### Starting rulemgt-service
+set main_path=%RUNHOME%..\
+cd /d %main_path%
+set JAVA="%JAVA_HOME%\bin\java.exe"
+set port=8312
+set jvm_opts=-Xms50m -Xmx128m
+rem set jvm_opts=%jvm_opts% -Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,address=%port%,server=y,suspend=n
+set class_path=%main_path%;%main_path%holmes-rulemgt.jar
+echo ### jvm_opts: %jvm_opts%
+echo ### class_path: %class_path%
+
+%JAVA% -classpath %class_path% %jvm_opts% org.openo.holmes.rulemgt.RuleActiveApp server %main_path%conf/rulemgt.yml
+
+IF ERRORLEVEL 1 goto showerror
+exit
+:showerror
+echo WARNING: Error occurred during startup or Server abnormally stopped by way of killing the process,Please check!
+echo After checking, press any key to close
+pause
+exit
\ No newline at end of file diff --git a/rulemgt-standalone/src/main/assembly/bin/run.sh b/rulemgt-standalone/src/main/assembly/bin/run.sh new file mode 100644 index 0000000..0519cc2 --- /dev/null +++ b/rulemgt-standalone/src/main/assembly/bin/run.sh @@ -0,0 +1,35 @@ +# +# 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. +# + +DIRNAME=`dirname $0` +RUNHOME=`cd $DIRNAME/; pwd` +echo @RUNHOME@ $RUNHOME + +echo @JAVA_HOME@ $JAVA_HOME +JAVA="$JAVA_HOME/bin/java" +echo @JAVA@ $JAVA +main_path=$RUNHOME/../ +cd $main_path +JAVA_OPTS="-Xms50m -Xmx128m" +port=8312 +#JAVA_OPTS="$JAVA_OPTS -Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,address=$port,server=y,suspend=n" +echo @JAVA_OPTS@ $JAVA_OPTS + +class_path="$main_path/:$main_path/holmes-rulemgt.jar" +echo @class_path@ $class_path + +"$JAVA" $JAVA_OPTS -classpath "$class_path" org.openo.holmes.rulemgt.RuleActiveApp server "$main_path/conf/rulemgt.yml" + diff --git a/rulemgt-standalone/src/main/assembly/bin/stop.bat b/rulemgt-standalone/src/main/assembly/bin/stop.bat new file mode 100644 index 0000000..ca7b4ff --- /dev/null +++ b/rulemgt-standalone/src/main/assembly/bin/stop.bat @@ -0,0 +1,34 @@ +@REM
+@REM Copyright 2017 ZTE Corporation.
+@REM
+@REM Licensed under the Apache License, Version 2.0 (the "License");
+@REM you may not use this file except in compliance with the License.
+@REM You may obtain a copy of the License at
+@REM
+@REM http://www.apache.org/licenses/LICENSE-2.0
+@REM
+@REM Unless required by applicable law or agreed to in writing, software
+@REM distributed under the License is distributed on an "AS IS" BASIS,
+@REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+@REM See the License for the specific language governing permissions and
+@REM limitations under the License.
+@REM
+
+@echo off
+title stopping engine-d-service
+
+set HOME=%~dp0
+set Main_Class="org.openo.holmes.rulemgt.RuleActiveApp"
+
+echo ================== engine-d-service info =============================================
+echo HOME=$HOME
+echo Main_Class=%Main_Class%
+echo ===============================================================================
+
+echo ### Stopping engine-d-service
+cd /d %HOME%
+
+for /f "delims=" %%i in ('"%JAVA_HOME%\bin\jcmd"') do (
+ call find_kill_process "%%i" %Main_Class%
+)
+exit
\ No newline at end of file diff --git a/rulemgt-standalone/src/main/assembly/bin/stop.sh b/rulemgt-standalone/src/main/assembly/bin/stop.sh new file mode 100644 index 0000000..f9e07a4 --- /dev/null +++ b/rulemgt-standalone/src/main/assembly/bin/stop.sh @@ -0,0 +1,44 @@ +#!/bin/bash +# +# 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. +# + +DIRNAME=`dirname $0` +HOME=`cd $DIRNAME/; pwd` +Main_Class="org.openo.holmes.rulemgt.RuleActiveApp" + +echo ================== engine-d-service info ============================================= +echo HOME=$HOME +echo Main_Class=$Main_Class +echo =============================================================================== +cd $HOME; pwd + +echo @WORK_DIR@ $HOME + +function save_service_pid(){ + service_pid=`ps -ef | grep $Main_Class | grep -v grep | awk '{print $2}'` + echo @service_pid@ $service_pid +} + +function kill_service_process(){ + ps -p $service_pid + if [ $? == 0 ]; then + kill -9 $service_pid + fi +} + +save_service_pid; +echo @C_CMD@ kill -9 $service_pid +kill_service_process;
\ No newline at end of file diff --git a/rulemgt-standalone/src/main/assembly/conf/rulemgt.yml b/rulemgt-standalone/src/main/assembly/conf/rulemgt.yml new file mode 100644 index 0000000..91d6eb4 --- /dev/null +++ b/rulemgt-standalone/src/main/assembly/conf/rulemgt.yml @@ -0,0 +1,127 @@ +apidescription: ZTE Holmes rule Management rest API + +# use the simple server factory if you only want to run on a single port +#server: +# type: simple +# connector: +# type: http +# port: 12003 + +server: + type: simple + rootPath: '/api/correlation-mgt/v1/*' + applicationContextPath: / + adminContextPath: /admin + connector: + type: http + port: 12004 + +# Logging settings. +logging: + + # The default level of all loggers. Can be OFF, ERROR, WARN, INFO, DEBUG, TRACE, or ALL. + level: INFO + + # Logger-specific levels. + loggers: + + # Sets the level for 'com.example.app' to DEBUG. + com.example: DEBUG + + appenders: + - type: console + threshold: INFO + timeZone: UTC + logFormat: "%d{yyyy-MM-dd HH:mm:ss SSS} %-5p [%c][%t] - %m%n" + - type: file + threshold: INFO + logFormat: "%d{yyyy-MM-dd HH:mm:ss SSS} %-5p [%c][%t] - %m%n" + currentLogFilename: ../logs/fm-relation.log + archivedLogFilenamePattern: ../logs/zip/fm-relation-%d{yyyy-MM-dd}.log.gz + archivedFileCount: 7 + # - type: socketJson + threshold: INFO + # autoDiscover: false + # logstashServiceName: logstash + # logstashServiceVersion: v1 + +#database +database: + driverClass: com.mysql.jdbc.Driver + user: root + password: root + #url: jdbc:mysql://${db_ip}:${db_port}/mysql?useUnicode=relationtesttrue&characterEncoding=UTF8 + url: jdbc:mysql://localhost:3306/relationtest?useUnicode=true&characterEncoding=UTF8 + properties: + charSet: UTF-8 + maxWaitForConnection: 1s + validationQuery: "/* MyService Health Check */ SELECT 1" + minSize: 8 + maxSize: 100 + checkConnectionWhileIdle: false + evictionInterval: 10s + minIdleTime: 1s + #dbServiceName: dbService + # dbServiceVersion: v1 + +#mqConfig: +# brokerIp: 127.0.0.1 +# brokerPort: 61616 +# autoDiscover: false +# mqServiceName: activemq +# mqServiceVersion: v1 +# +#cacheConfig: +# cacheServerIp: 10.74.156.206 +# cacheServerPort: 27017 +# autoDiscover: false +# cacheServiceName: mongodbService +# cacheServiceVersion: v1 +# asNamespace: zenap +# type: mongodb +# userName: zenap +# password: zenap +# +# the micro service ip + +#msbClientConfig: + # msbSvrIp: 10.74.156.206 + # msbSvrPort: 10081 + +#kafkaClientConf: +# bootstrapServers: 10.74.151.190:9092 +# autoDiscover: true +# kafkaServiceName: kafka +# kafkaServiceVersion: v1 +# consumerConf: +# properties: +# value.deserializer: org.apache.kafka.common.serialization.StringDeserializer +# producerConf: +# properties: +# value.serializer: org.apache.kafka.common.serialization.StringSerializer +# +#zkConfig: +# connectString: 10.74.151.195:2181 +# retryPolicy: +# type: boundedExponentialBackoff +# baseSleepTimeMs: 50 +# maxSleepTimeMs: 500 +# maxRetries: 3 +# sessionTimeout: 60 +# connectionTimeout: 15 +# autoDiscover: true +# zkServiceName: zk +# zkServiceVersion: v1 +# +#ftpServiceConfig: +# type: ftp +# pasv: false +# userName: uep +# userPassword: U_tywg_2008_ftp +# ftpServerAddress: 10.74.148.251 +# ftpServerPort: 20021 +# ftpsServerAddress: 10.74.148.251 +# ftpsServerPort: 20021 +# sftpServerAddress: 10.74.148.251 +# sftpServerPort: 20021 +# diff --git a/rulemgt-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql b/rulemgt-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql new file mode 100644 index 0000000..c8ba2bd --- /dev/null +++ b/rulemgt-standalone/src/main/assembly/dbscripts/mysql/openo-holmes_rulemgt-createobj.sql @@ -0,0 +1,58 @@ +--
+-- 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.
+--
+/******************drop old database and user***************************/
+use mysql;
+drop database IF EXISTS holmes;
+delete from user where User='holmes';
+FLUSH PRIVILEGES;
+
+/******************create new database and user***************************/
+create database holmes CHARACTER SET utf8;
+
+GRANT ALL PRIVILEGES ON holmes.* TO 'holmes'@'%' IDENTIFIED BY 'holmes' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON mysql.* TO 'holmes'@'%' IDENTIFIED BY 'holmes' WITH GRANT OPTION;
+
+GRANT ALL PRIVILEGES ON catalog.* TO 'holmes'@'localhost' IDENTIFIED BY 'holmes' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON mysql.* TO 'holmes'@'localhost' IDENTIFIED BY 'holmes' WITH GRANT OPTION;
+FLUSH PRIVILEGES;
+
+use holmes;
+set Names 'utf8';
+/******************delete old table and create new***************************/
+use holmes;
+DROP TABLE IF EXISTS aplus_rule;
+CREATE TABLE aplus_rule (
+ rid varchar(30) NOT NULL,
+ name varchar(150) NOT NULL,
+ description varchar(4000) DEFAULT NULL,
+ enable int(1) NOT NULL,
+ templateID int(10) NOT NULL,
+ engineType varchar(20) NOT NULL,
+ creator varchar(20) NOT NULL,
+ createTime datetime NOT NULL,
+ updator varchar(20) DEFAULT NULL,
+ updateTime datetime DEFAULT NULL,
+ params varchar(4000) DEFAULT NULL,
+ content varchar(4000) NOT NULL,
+ vendor varchar(100) NOT NULL,
+ package varchar(255) NULL,
+ PRIMARY KEY (rid),
+ UNIQUE KEY name (name),
+ KEY IDX_APLUS_RULE_ENABLE (enable),
+ KEY IDX_APLUS_RULE_TEMPLATEID (templateID),
+ KEY IDX_APLUS_RULE_ENGINETYPE (engineType)
+)
+
diff --git a/rulemgt-standalone/win64-assembly.xml b/rulemgt-standalone/win64-assembly.xml new file mode 100644 index 0000000..daa3177 --- /dev/null +++ b/rulemgt-standalone/win64-assembly.xml @@ -0,0 +1,31 @@ +<!-- + + 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. + +--> +<assembly xmlns="http://maven.apache.org/plugins/maven-assembly-plugin/assembly/1.1.2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://maven.apache.org/plugins/maven-assembly-plugin/assembly/1.1.2 http://maven.apache.org/xsd/assembly-1.1.2.xsd"> + <id>win64</id> + <formats> + <format>zip</format> + </formats> + <includeBaseDirectory>false</includeBaseDirectory> + <fileSets> + <fileSet> + <directory>target/assembly/win64</directory> + <outputDirectory></outputDirectory> + </fileSet> + </fileSets> +</assembly> |