SZH
2023-03-18 e2f289eb7df9a20857dfad8a90e573a80f88cd39
变更生产环境数据库
已修改3个文件
已添加1个文件
139 ■■■■■ 文件已修改
src/main/resources/application-guotai-uat.yml 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/application-louge.yml 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/application-show.yml 124 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/application.yml 3 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
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
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
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
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
  # 文件上传