From e2f289eb7df9a20857dfad8a90e573a80f88cd39 Mon Sep 17 00:00:00 2001
From: SZH <szh_hello@163.com>
Date: 星期六, 18 三月 2023 12:07:13 +0800
Subject: [PATCH] 变更生产环境数据库
---
src/main/resources/application-show.yml | 124 +++++++++++++++++++++++++++++++++++++++++
src/main/resources/application-louge.yml | 2
src/main/resources/application-guotai-uat.yml | 10 ++-
src/main/resources/application.yml | 3
4 files changed, 132 insertions(+), 7 deletions(-)
diff --git a/src/main/resources/application-guotai-uat.yml b/src/main/resources/application-guotai-uat.yml
index 72922f8..bdd014a 100644
--- a/src/main/resources/application-guotai-uat.yml
+++ b/src/main/resources/application-guotai-uat.yml
@@ -12,11 +12,13 @@
# driver-class-name: com.mysql.cj.jdbc.Driver
#数据库版本5.7
- url: jdbc:mysql://121.239.169.27:49037/safeplatform.luoan.uat?allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=true&serverTimezone=UTC&zeroDateTimeBehavior=CONVERT_TO_NULL&serverTimezone=Asia/Shanghai
- username: gkhy_safeplatform
- password: afaQW90b!#n1
+ url: jdbc:mysql://sinanoaq.com:23306/trouble_and_risk.guotai?allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC&zeroDateTimeBehavior=CONVERT_TO_NULL&serverTimezone=Asia/Shanghai
+ username: riskctrl_gk
+ password: Csa8@g89cajnDFd7
-
+# url: jdbc:mysql://124.221.179.102:3306/testqhs?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8
+# username: testqhs
+# password: raD2AEaccLRsaFrB
# 数据库版本8
# url: jdbc:mysql://121.239.169.27:49031/safeplatform.luoan.uat?allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=true&serverTimezone=UTC&zeroDateTimeBehavior=CONVERT_TO_NULL&serverTimezone=Asia/Shanghai
diff --git a/src/main/resources/application-louge.yml b/src/main/resources/application-louge.yml
index 1eab553..888c21a 100644
--- a/src/main/resources/application-louge.yml
+++ b/src/main/resources/application-louge.yml
@@ -10,7 +10,7 @@
druid:
# 主库数据源
master:
- url: jdbc:mysql://124.221.179.102:3306/testqhs?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
+ url: jdbc:mysql://124.221.179.102:3306/testqhs?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8
username: testqhs
password: raD2AEaccLRsaFrB
diff --git a/src/main/resources/application-show.yml b/src/main/resources/application-show.yml
new file mode 100644
index 0000000..36052c3
--- /dev/null
+++ b/src/main/resources/application-show.yml
@@ -0,0 +1,124 @@
+server:
+ port: 6601
+
+# 数据源配置
+spring:
+ datasource:
+ type: com.alibaba.druid.pool.DruidDataSource
+ driverClassName: com.mysql.cj.jdbc.Driver
+ druid:
+ # 主库数据源
+ master:
+# driver-class-name: com.mysql.cj.jdbc.Driver
+
+ #数据库版本5.7
+# url: jdbc:mysql://121.239.169.27:49037/safeplatform.luoan.uat?allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=true&serverTimezone=UTC&zeroDateTimeBehavior=CONVERT_TO_NULL&serverTimezone=Asia/Shanghai
+# username: gkhy_safeplatform
+# password: afaQW90b!#n1
+
+ url: jdbc:mysql://124.221.179.102:3306/testqhs?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8
+ username: testqhs
+ password: raD2AEaccLRsaFrB
+
+# 数据库版本8
+ # url: jdbc:mysql://121.239.169.27:49031/safeplatform.luoan.uat?allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=true&serverTimezone=UTC&zeroDateTimeBehavior=CONVERT_TO_NULL&serverTimezone=Asia/Shanghai
+# username: gkhy_safeplatform_guotai
+# password: user@GJLSJ828
+
+# url: jdbc:mysql://localhost:3306/trouble_and_risk.guotai?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
+# username: root
+# password: root
+
+# url: jdbc:mysql://localhost:17716/trouble_and_risk?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
+# username: trouble_and_risk
+# password: Bw44sxzyiE8SdWzJ
+
+# url: jdbc:mysql://192.168.10.201:3306/trouble_and_risk?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
+# username: trouble_and_risk
+# password: LYGstJAYc85jkF7H
+
+ # 从库数据源
+ slave:
+ # 从数据源开关/默认关闭
+ enabled: false
+ url:
+ username:
+ password:
+ # 初始连接数
+ initialSize: 5
+ # 最小连接池数量
+ minIdle: 10
+ # 最大连接池数量
+ maxActive: 20
+ # 配置获取连接等待超时的时间
+ maxWait: 60000
+ # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
+ timeBetweenEvictionRunsMillis: 60000
+ # 配置一个连接在池中最小生存的时间，单位是毫秒
+ minEvictableIdleTimeMillis: 300000
+ # 配置一个连接在池中最大生存的时间，单位是毫秒
+ maxEvictableIdleTimeMillis: 900000
+ # 配置检测连接是否有效
+ validationQuery: SELECT 1 FROM DUAL
+ testWhileIdle: true
+ testOnBorrow: false
+ testOnReturn: false
+ webStatFilter:
+ enabled: true
+ statViewServlet:
+ enabled: true
+ # 设置白名单，不填则允许所有访问
+ allow:
+ url-pattern: /druid/*
+ # 控制台管理用户名和密码
+ login-username:
+ login-password:
+ filter:
+ stat:
+ enabled: true
+ # 慢SQL记录
+ log-slow-sql: true
+ slow-sql-millis: 1000
+ merge-sql: true
+ wall:
+ config:
+ multi-statement-allow: true
+
+ # redis
+ redis:
+ host: 192.168.30.107
+ port: 6362
+ password: aHIAC88NB98t8bju89 # Redis 服务器密码，默认为空。生产中，一定要设置 Redis 密码！
+ database: 0 # Redis 数据库号，默认为 0
+ timeout: 15000 # Redis 连接超时时间，单位：毫秒。
+ lettuce:
+ pool:
+ max-active: 4
+ # 对应 RedisProperties.Jedis 内部类
+ jedis:
+ pool:
+ max-active: 4 # 连接池最大连接数，默认为 8 。使用负数表示没有限制 同一时间最大只能执行8条sql语句，每执行一条语句就会建立一个连接
+ max-idle: 4 # 默认连接数最大空闲的连接数，默认为 8 。使用负数表示没有限制。
+ min-idle: 0 # 默认连接池最小空闲的连接数，默认为 0 。允许设置 0 和 正数。
+ max-wait: -1
+
+http:
+ # HTTP端口，39559
+ additionalPorts: 8014
+# additionalPorts: 6801
+
+# 项目相关配置
+ruoyi:
+ # 名称
+ name: TroubleAndRisk
+ # 版本
+ version: 1.0.3
+ # 版权年份
+ copyrightYear: 2021
+ # 实例演示开关
+ demoEnabled: false
+ # 文件路径 示例（ Windows配置D:/TroubleAndRisk/uploadPath，Linux配置 /home/TroubleAndRisk/uploadPath）
+ # profile: /www/TroubleAndRisk/uploadPath
+ profile: /home/troubleAndRisk/upload
+ # 获取ip地址开关
+ addressEnabled: true
\ No newline at end of file
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index fd1bf3b..123ecf8 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -52,9 +52,8 @@
time-zone: GMT+8
date-format: yyyy-MM-dd HH:mm:ss
profiles:
-# active: guotai-uat
+ active: guotai-uat
# druid使用的数据库是5.7.28，过高的版本，可能有部分函数不支持
- active: druid
# active: uat
# active: uat8
# 文件上传
--
Gitblit v1.9.2