From 5bc2f648dd8e7a9fe08dd7da9092e642e9c179ad Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: 星期二, 19 三月 2024 09:22:44 +0800
Subject: [PATCH] 修改国泰数据库地址
---
src/main/resources/application-guotai-prod.yml | 128 ++++++++++++++++++++++++++++++++++++++++++
src/main/resources/application-guotai-uat.yml | 2
2 files changed, 129 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/application-guotai-prod.yml b/src/main/resources/application-guotai-prod.yml
new file mode 100644
index 0000000..d84317c
--- /dev/null
+++ b/src/main/resources/application-guotai-prod.yml
@@ -0,0 +1,128 @@
+server:
+ port: 6801
+
+# 数据源配置
+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://106.15.95.149:33306/gt_double_risk?allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC&zeroDateTimeBehavior=CONVERT_TO_NULL&serverTimezone=Asia/Shanghai
+ username: gt_double_risk
+ password: B6CrYp7ZhTNdJF4Y
+
+# 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
+# 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: 127.0.0.1
+ port: 6379
+ password: akj78avauba789a # Redis 服务器密码，默认为空。生产中，一定要设置 Redis 密码！
+ database: 9 # 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: 6802
+# additionalPorts: 6801
+
+# 项目相关配置
+ruoyi:
+ # 名称
+ name: TroubleAndRisk
+ # 版本
+ version: 1.0.3
+ # 版权年份
+ copyrightYear: 2022-2023
+ # 实例演示开关
+ demoEnabled: false
+ # 文件路径 示例（ Windows配置D:/TroubleAndRisk/uploadPath，Linux配置 /home/TroubleAndRisk/uploadPath）
+ # profile: /www/TroubleAndRisk/uploadPath
+ profile: /www/wwwroot/springboot_pro/TroubleAndRisk/upload
+ # 获取ip地址开关
+ addressEnabled: true
\ No newline at end of file
diff --git a/src/main/resources/application-guotai-uat.yml b/src/main/resources/application-guotai-uat.yml
index 5320904..b3badbf 100644
--- a/src/main/resources/application-guotai-uat.yml
+++ b/src/main/resources/application-guotai-uat.yml
@@ -12,7 +12,7 @@
# driver-class-name: com.mysql.cj.jdbc.Driver
#数据库版本5.7
- url: jdbc:mysql://124.221.143.185:23306/gt_double_risk?allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC&zeroDateTimeBehavior=CONVERT_TO_NULL&serverTimezone=Asia/Shanghai
+ url: jdbc:mysql://106.15.95.149:33306/gt_double_risk?allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC&zeroDateTimeBehavior=CONVERT_TO_NULL&serverTimezone=Asia/Shanghai
username: gt_double_risk
password: B6CrYp7ZhTNdJF4Y
--
Gitblit v1.9.2