From de8ec150eb99d3da0d7ed548db71bc132ccfe4ab Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期一, 02 九月 2024 11:26:24 +0800 Subject: [PATCH] 添加se-wgcloud模块 --- docker-compose/wgcloud/application.yml | 84 ++++++++++ docker-compose/mysql/initdb/wgcloud-MySQL.sql | 307 ++++++++++++++++++++++++++++++++++++++ docker-compose/nginx/conf/nginx.conf | 9 + docker-compose/docker-compose.yml | 33 +++ 4 files changed, 428 insertions(+), 5 deletions(-) diff --git a/docker-compose/docker-compose.yml b/docker-compose/docker-compose.yml index 434bca5..75e675b 100644 --- a/docker-compose/docker-compose.yml +++ b/docker-compose/docker-compose.yml @@ -43,7 +43,7 @@ networks: - network-se restart: always - # redis,Redis_s!E_6.2.6 + # redis se-redis: image: redis:latest ports: @@ -52,6 +52,7 @@ - ./redis/data/redis.conf:/data/redis.conf - ./redis/data:/data command: redis-server /data/redis.conf +# command: redis-server --requirepass Redis_s!E_6.2.6 networks: - network-se restart: always @@ -61,16 +62,17 @@ # ports: # - 9204:8080 volumes: + - ./gateway/logs:/logs - ./gateway:/data environment: TZ: Asia/Shanghai entrypoint: java -jar /data/se-gateway.jar --spring.config.location=file:/data/ depends_on: - se-redis + - se-mysql - se-nacos - links: - - se-redis - - se-nacos +# links: +# - se-redis networks: - network-se restart: always @@ -80,12 +82,14 @@ # ports: # - 9200:9200 volumes: + - ./auth/logs:/logs - ./auth:/data environment: TZ: Asia/Shanghai entrypoint: java -jar /data/se-auth.jar --spring.config.location=file:/data/ depends_on: - se-redis + - se-mysql - se-nacos networks: - network-se @@ -96,14 +100,15 @@ # ports: # - 9201:9201 volumes: + - ./system/logs:/logs - ./system:/data environment: TZ: Asia/Shanghai entrypoint: java -jar /data/se-modules-system.jar --spring.config.location=file:/data/ depends_on: - se-redis - - se-nacos - se-mysql + - se-nacos networks: - network-se restart: always @@ -113,15 +118,33 @@ # ports: # - 9300:9300 volumes: + - ./file/logs:/logs - ./file:/data environment: TZ: Asia/Shanghai entrypoint: java -jar /data/se-modules-file.jar --spring.config.location=file:/data/ depends_on: + - se-mysql - se-nacos networks: - network-se restart: always + # se-wgcloud + se-wgcloud: + image: openjdk:8-jre + ports: + - 9999:9999 + volumes: + - ./wgcloud/logs:/log + - ./wgcloud:/data + environment: + TZ: Asia/Shanghai + entrypoint: java -jar /data/wgcloud-server-release.jar --spring.config.location=file:/data/ + depends_on: + - se-mysql + networks: + - network-se + restart: always # nginx se-nginx: image: nginx:latest diff --git a/docker-compose/mysql/initdb/wgcloud-MySQL.sql b/docker-compose/mysql/initdb/wgcloud-MySQL.sql new file mode 100644 index 0000000..24e2f97 --- /dev/null +++ b/docker-compose/mysql/initdb/wgcloud-MySQL.sql @@ -0,0 +1,307 @@ +-- DROP DATABASE IF EXISTS `wgcloud`; + +CREATE DATABASE IF NOT EXISTS `wgcloud` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; + +SET NAMES utf8mb4; +SET FOREIGN_KEY_CHECKS = 0; + +USE `wgcloud`; + +/* +Navicat MySQL Data Transfer + +Source Server : 127.0.0.1 +Source Server Version : 50717 +Source Host : localhost:3306 +Source Database : wgcloud + +Target Server Type : MYSQL +Target Server Version : 50717 +File Encoding : 65001 + +Date: 2021-11-26 20:01:46 +*/ + +SET FOREIGN_KEY_CHECKS=0; + +-- ---------------------------- +-- Table structure for app_info +-- ---------------------------- +DROP TABLE IF EXISTS `APP_INFO`; +CREATE TABLE `APP_INFO` ( + `ID` char(32) NOT NULL, + `HOST_NAME` char(30) DEFAULT NULL, + `APP_PID` char(200) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL, + `APP_NAME` varchar(50) DEFAULT NULL, + `CPU_PER` double(8,2) DEFAULT NULL, + `MEM_PER` double(10,2) DEFAULT NULL, + `APP_TYPE` char(1) DEFAULT NULL, + `STATE` char(1) DEFAULT NULL, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for app_state +-- ---------------------------- +DROP TABLE IF EXISTS `APP_STATE`; +CREATE TABLE `APP_STATE` ( + `ID` char(32) NOT NULL, + `APP_INFO_ID` char(32) DEFAULT NULL, + `CPU_PER` double(8,2) DEFAULT NULL, + `MEM_PER` double(10,2) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL, + PRIMARY KEY (`ID`), + KEY `APP_STAT_INDEX` (`APP_INFO_ID`,`CREATE_TIME`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for cpu_state +-- ---------------------------- +DROP TABLE IF EXISTS `CPU_STATE`; +CREATE TABLE `CPU_STATE` ( + `ID` char(32) NOT NULL, + `HOST_NAME` char(30) DEFAULT NULL, + `USER` char(30) DEFAULT NULL, + `SYS` double(8,2) DEFAULT NULL, + `IDLE` double(8,2) DEFAULT NULL, + `IOWAIT` double(8,2) DEFAULT NULL, + `IRQ` char(30) DEFAULT NULL, + `SOFT` char(30) DEFAULT NULL, + `DATE_STR` char(30) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL, + PRIMARY KEY (`ID`), + KEY `CPU_ACC_HOST_INDEX` (`HOST_NAME`,`CREATE_TIME`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for db_info +-- ---------------------------- +DROP TABLE IF EXISTS `DB_INFO`; +CREATE TABLE `DB_INFO` ( + `ID` char(32) NOT NULL, + `DBTYPE` char(32) DEFAULT NULL, + `USER` varchar(50) DEFAULT NULL, + `PASSWD` varchar(50) DEFAULT NULL, + `IP` char(20) DEFAULT NULL, + `PORT` char(10) DEFAULT NULL, +-- `CREATE_TIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, + `CREATE_TIME` timestamp DEFAULT CURRENT_TIMESTAMP, + `DBNAME` char(50) DEFAULT NULL, + `DB_STATE` char(1) DEFAULT NULL, + `ALIAS_NAME` varchar(50) DEFAULT NULL, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for db_table +-- ---------------------------- +DROP TABLE IF EXISTS `DB_TABLE`; +CREATE TABLE `DB_TABLE` ( + `ID` char(32) NOT NULL, + `TABLE_NAME` varchar(50) DEFAULT NULL, + `WHERE_VAL` varchar(200) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, + `REMARK` varchar(50) DEFAULT NULL, + `TABLE_COUNT` bigint(20) DEFAULT NULL, + `DATE_STR` char(30) DEFAULT NULL, + `DBINFO_ID` char(32) DEFAULT NULL, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for db_table_count +-- ---------------------------- +DROP TABLE IF EXISTS `DB_TABLE_COUNT`; +CREATE TABLE `DB_TABLE_COUNT` ( + `ID` char(32) NOT NULL, + `DB_TABLE_ID` char(32) DEFAULT NULL, + `TABLE_COUNT` bigint(20) DEFAULT NULL, + `DATE_STR` char(30) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for desk_state +-- ---------------------------- +DROP TABLE IF EXISTS `DESK_STATE`; +CREATE TABLE `DESK_STATE` ( + `ID` char(32) NOT NULL, + `HOST_NAME` char(30) DEFAULT NULL, + `FILE_STSTEM` char(50) DEFAULT NULL, + `SIZE` char(30) DEFAULT NULL, + `USED` char(30) DEFAULT NULL, + `AVAIL` char(30) DEFAULT NULL, + `USE_PER` char(10) DEFAULT NULL, + `DATE_STR` char(30) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL, + PRIMARY KEY (`ID`), + KEY `DESK_ACC_HOST_INDEX` (`HOST_NAME`,`CREATE_TIME`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for heath_monitor +-- ---------------------------- +DROP TABLE IF EXISTS `HEATH_MONITOR`; +CREATE TABLE `HEATH_MONITOR` ( + `ID` char(32) NOT NULL, + `APP_NAME` char(50) DEFAULT NULL, + `HEATH_URL` varchar(255) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, + `HEATH_STATUS` char(10) DEFAULT NULL, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for host_info +-- ---------------------------- +DROP TABLE IF EXISTS `HOST_INFO`; +CREATE TABLE `HOST_INFO` ( + `ID` char(32) NOT NULL, + `IP` char(30) DEFAULT NULL, + `PORT` char(20) DEFAULT NULL, + `ROOT` char(50) DEFAULT NULL, + `PASSWD` char(50) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, + `REMARK` varchar(255) DEFAULT NULL, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for intrusion_info +-- ---------------------------- +DROP TABLE IF EXISTS `INTRUSION_INFO`; +CREATE TABLE `INTRUSION_INFO` ( + `ID` char(32) NOT NULL, + `HOST_NAME` char(30) DEFAULT NULL, + `LSMOD` text, + `PASSWD_INFO` varchar(100) DEFAULT NULL, + `CRONTAB` text, + `PROMISC` varchar(100) DEFAULT NULL, + `RPCINFO` text, + `CREATE_TIME` timestamp NULL DEFAULT NULL, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for log_info +-- ---------------------------- +DROP TABLE IF EXISTS `LOG_INFO`; +CREATE TABLE `LOG_INFO` ( + `ID` char(32) NOT NULL, + `HOST_NAME` char(50) DEFAULT NULL, + `INFO_CONTENT` text, + `STATE` char(1) DEFAULT NULL, + `CREATE_TIME` timestamp DEFAULT CURRENT_TIMESTAMP, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for mail_set +-- ---------------------------- +DROP TABLE IF EXISTS `MAIL_SET`; +CREATE TABLE `MAIL_SET` ( + `ID` char(32) COLLATE utf8_unicode_ci NOT NULL, + `SEND_MAIL` char(60) COLLATE utf8_unicode_ci DEFAULT NULL, + `FROM_MAIL_NAME` char(60) COLLATE utf8_unicode_ci DEFAULT NULL, + `FROM_PWD` char(30) COLLATE utf8_unicode_ci DEFAULT NULL, + `SMTP_HOST` char(50) COLLATE utf8_unicode_ci DEFAULT NULL, + `SMTP_PORT` char(30) COLLATE utf8_unicode_ci DEFAULT NULL, + `SMTP_SSL` char(30) COLLATE utf8_unicode_ci DEFAULT NULL, + `TO_MAIL` char(200) COLLATE utf8_unicode_ci DEFAULT NULL, + `CPU_PER` char(30) COLLATE utf8_unicode_ci DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL, + `MEM_PER` char(30) COLLATE utf8_unicode_ci DEFAULT NULL, + `HEATH_PER` char(30) COLLATE utf8_unicode_ci DEFAULT NULL, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +-- ---------------------------- +-- Table structure for mem_state +-- ---------------------------- +DROP TABLE IF EXISTS `MEM_STATE`; +CREATE TABLE `MEM_STATE` ( + `ID` char(32) NOT NULL, + `HOST_NAME` char(30) DEFAULT NULL, + `TOTAL` char(30) DEFAULT NULL, + `USED` char(30) DEFAULT NULL, + `FREE` char(30) DEFAULT NULL, + `USE_PER` double(8,2) DEFAULT NULL, + `DATE_STR` char(30) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL, + PRIMARY KEY (`ID`), + KEY `MEM_ACC_HOST_INDEX` (`HOST_NAME`,`CREATE_TIME`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for netio_state +-- ---------------------------- +DROP TABLE IF EXISTS `NETIO_STATE`; +CREATE TABLE `NETIO_STATE` ( + `ID` char(32) NOT NULL, + `HOST_NAME` char(30) DEFAULT NULL, + `RXPCK` char(30) DEFAULT NULL, + `TXPCK` char(30) DEFAULT NULL, + `RXBYT` char(30) DEFAULT NULL, + `TXBYT` char(30) DEFAULT NULL, + `RXCMP` char(30) DEFAULT NULL, + `TXCMP` char(30) DEFAULT NULL, + `RXMCST` char(30) DEFAULT NULL, + `DATE_STR` char(30) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL, + PRIMARY KEY (`ID`), + KEY `NETIO_ACC_HOST_INDEX` (`HOST_NAME`,`CREATE_TIME`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for system_info +-- ---------------------------- +DROP TABLE IF EXISTS `SYSTEM_INFO`; +CREATE TABLE `SYSTEM_INFO` ( + `ID` char(32) NOT NULL, + `HOST_NAME` char(30) DEFAULT NULL, + `VERSION` char(100) DEFAULT NULL, + `VERSION_DETAIL` char(200) DEFAULT NULL, + `CPU_PER` double(8,2) DEFAULT NULL, + `MEM_PER` double(8,2) DEFAULT NULL, + `CPU_CORE_NUM` char(10) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL, + `CPU_XH` char(150) DEFAULT NULL, + `STATE` char(1) DEFAULT NULL, + `REMARK` varchar(50) DEFAULT NULL, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for sys_load_state +-- ---------------------------- +DROP TABLE IF EXISTS `SYS_LOAD_STATE`; +CREATE TABLE `SYS_LOAD_STATE` ( + `ID` char(32) NOT NULL, + `HOST_NAME` char(30) DEFAULT NULL, + `ONE_LOAD` double(8,2) DEFAULT NULL, + `FIVE_LOAD` double(8,2) DEFAULT NULL, + `FIFTEEN_LOAD` double(8,2) DEFAULT NULL, + `USERS` char(10) DEFAULT NULL, + `DATE_STR` char(30) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL, + PRIMARY KEY (`ID`), + KEY `LOAD_ACC_HOST_INDEX` (`HOST_NAME`,`CREATE_TIME`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for tcp_state +-- ---------------------------- +DROP TABLE IF EXISTS `TCP_STATE`; +CREATE TABLE `TCP_STATE` ( + `ID` char(32) NOT NULL, + `HOST_NAME` char(30) DEFAULT NULL, + `ACTIVE` char(30) DEFAULT NULL, + `PASSIVE` char(30) DEFAULT NULL, + `RETRANS` char(30) DEFAULT NULL, + `DATE_STR` char(30) DEFAULT NULL, + `CREATE_TIME` timestamp NULL DEFAULT NULL, + PRIMARY KEY (`ID`), + KEY `TCP_ACC_HOST_INDEX` (`HOST_NAME`,`CREATE_TIME`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/docker-compose/nginx/conf/nginx.conf b/docker-compose/nginx/conf/nginx.conf index 47c0c36..7582db2 100644 --- a/docker-compose/nginx/conf/nginx.conf +++ b/docker-compose/nginx/conf/nginx.conf @@ -50,6 +50,15 @@ proxy_pass http://se-gateway:8080/; } + location /wgcloud { + proxy_set_header Host $http_host; + proxy_set_header X-Real-IP $remote_addr; + proxy_set_header REMOTE-HOST $remote_addr; + proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; + + proxy_pass http://se-wgcloud:9999/wgcloud; + } + # actuator if ($request_uri ~ "/actuator") { return 403; diff --git a/docker-compose/wgcloud/application.yml b/docker-compose/wgcloud/application.yml new file mode 100644 index 0000000..e0b5bb7 --- /dev/null +++ b/docker-compose/wgcloud/application.yml @@ -0,0 +1,84 @@ +server: + port: 9999 + servlet: + session: + timeout: 120m + context-path: /wgcloud +#鏃ュ織鏂囦欢杈撳嚭璺緞 +logging: + file: + path: ./log +# 鏁版嵁搴� 鐩稿叧璁剧疆 +spring: + application: + name: wgcloud-server + datasource: + driver-class-name: com.mysql.jdbc.Driver + url: jdbc:mysql://se-mysql:3306/wgcloud?characterEncoding=utf-8&characterSetResults=utf8&autoReconnect=true&useSSL=false&allowMultiQueries=true + username: root + password: My_Sql_s!E_v5.7 + # hikari杩炴帴姹犵殑鍙傛暟 鐩稿叧璁剧疆 + hikari: + # 鐢熸晥瓒呮椂 + validationTimeout: 3000 + # 瀹氫箟鑾峰彇杩炴帴鐨勮秴鏃舵椂闂淬�傛渶灏�250ms,榛樿30s + connectionTimeout: 60000 + # 瀹氫箟杩炴帴绌洪棽鏃堕棿銆傛渶灏�10s,榛樿10m + idleTimeout: 60000 + # 瀹氫箟鏈�灏忕殑绌洪棽杩炴帴鏁般�傛帹鑽愪笉璁剧疆銆傛垨涓庢渶澶ц繛鎺ユ暟涓�鑷达紱淇濇寔鍥哄畾鐨勮繛鎺ユ暟鐩� + minimumIdle: 10 + # 瀹氫箟鏈�澶х殑杩炴帴鏁般�傞粯璁�10 + maximumPoolSize: 10 + # 瀹氫箟杩炴帴鐨勬渶澶х敓鍛藉懆鏈熴�傛帹鑽愯缃灞炴�с�傛渶灏�30s锛岄粯璁�30m + maxLifeTime: 60000 + # 浠庤繛鎺ユ睜鑾峰彇鍒拌繛鎺ュ悗锛岃繘琛屾鏌ョ殑鏌ヨ璇彞銆傛帹鑽愯缃灞炴�с�傞粯璁ゅ�间负none + connectionTestQuery: select 1 + mvc: + static-path-pattern: /static/** + thymeleaf: + cache: false + +#Mybatis閰嶇疆 +mybatis: + config-location: classpath:mybatis/mybatis-config.xml + mapper-locations: classpath:mybatis/mapper/*.xml + +#鑷畾涔夐厤缃弬鏁� +base: + #鐧婚檰璐﹀彿admin鐨勫瘑鐮� + admindPwd: 111111 + #閫氫俊token锛宎gent绔拰姝や繚鎸佷竴鑷� + wgToken: wgcloud + #鏄惁寮�鍚叕浼楃湅鏉匡紝yes寮�鍚紝no鍏抽棴锛屽叕浼楃湅鏉块〉闈㈡棤闇�鐧婚檰 + dashView: yes + # 鍒濆鍖栨搷浣� + initTaskTimes: 10000 + # 妫�娴嬩富鏈烘槸鍚﹀凡缁忎笅绾� + hostDownCheckTimes: 10000 + #鏈嶅姟鎺ュ彛鐩戞帶闂撮殧锛屽崟浣嶆绉� + heathTimes: 10000 + #鏁版嵁搴撶洃鎺ч棿闅�,鍗曚綅姣 + dbInfoTimes: 10000 + #鏁版嵁琛ㄧ洃鎺ч棿闅�,鍗曚綅姣 + dbTableTimes: 10000 + # 鎵归噺鎻愪氦鏁版嵁 + commitTaskTimes: 10000 + +#鍛婅閰嶇疆 +mail: + #鍛婅閭欢鎬诲紑鍏筹紝yes寮�鍚紝no鍏抽棴 + allWarnMail: yes + #鐩戞帶涓绘満鍐呭瓨浣跨敤鐜�%鎶ヨ鍊硷紝瓒呰繃姝ゅ�煎嵆鍙戦�侀偖浠舵姤璀� + memWarnVal: 98 + #鐩戞帶涓绘満cpu浣跨敤鐜�%鎶ヨ鍊硷紝瓒呰繃姝ゅ�煎嵆鍙戦�侀偖浠舵姤璀� + cpuWarnVal: 98 + #鍐呭瓨鍛婅閭欢寮�鍏筹紝yes寮�鍚紝no鍏抽棴銆傛�诲紑鍏冲紑鍚悗锛屾澶勮缃墠浼氱敓鏁堛�備互涓嬪紑鍏冲潎閬靛惊姝よ鍒欍�� + memWarnMail: yes + #CPU鍛婅閭欢寮�鍏筹紝yes寮�鍚紝no鍏抽棴 + cpuWarnMail: yes + #涓绘満涓嬬嚎鍛婅閭欢寮�鍏筹紝yes寮�鍚紝no鍏抽棴 + hostDownWarnMail: yes + #杩涚▼涓嬬嚎鍛婅閭欢寮�鍏筹紝yes寮�鍚紝no鍏抽棴 + appDownWarnMail: yes + #鏈嶅姟鎺ュ彛鍛婅閭欢寮�鍏筹紝yes寮�鍚紝no鍏抽棴 + heathWarnMail: yes \ No newline at end of file -- Gitblit v1.9.3