/* Navicat Premium Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 80019 Source Host : localhost:3306 Source Schema : nacos Target Server Type : MySQL Target Server Version : 80019 File Encoding : 65001 Date: 10/07/2024 09:43:37 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for config_info -- ---------------------------- DROP TABLE IF EXISTS `config_info`; CREATE TABLE `config_info` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id', `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content', `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5', `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间', `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间', `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user', `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip', `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段', `c_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `c_use` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `effect` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `c_schema` text CHARACTER SET utf8 COLLATE utf8_bin NULL, `encrypted_data_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '加密key', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_configinfo_datagrouptenant`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 72 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of config_info -- ---------------------------- INSERT INTO `config_info` VALUES (55, 'application.yaml', 'DEFAULT_GROUP', 'spring:\r\n main:\r\n allow-circular-references: true # 允许循环依赖，因为项目是三层架构，无法避免这个情况。\r\n allow-bean-definition-overriding: true # 允许 Bean 覆盖，例如说 Feign 等会存在重复定义的服务\r\n\r\n # Servlet 配置\r\n servlet:\r\n # 文件上传相关配置项\r\n multipart:\r\n max-file-size: 16MB # 单个文件大小\r\n max-request-size: 32MB # 设置总上传的文件大小\r\n mvc:\r\n pathmatch:\r\n matching-strategy: ANT_PATH_MATCHER # 解决 SpringFox 与 SpringBoot 2.6.x 不兼容的问题，参见 SpringFoxHandlerProviderBeanPostProcessor 类\r\n\r\n # Jackson 配置项\r\n jackson:\r\n serialization:\r\n write-dates-as-timestamps: true # 设置 LocalDateTime 的格式，使用时间戳\r\n write-date-timestamps-as-nanoseconds: false # 设置不使用 nanoseconds 的格式。例如说 1611460870.401，而是直接 1611460870401\r\n write-durations-as-timestamps: true # 设置 Duration 的格式，使用时间戳\r\n fail-on-empty-beans: false # 允许序列化无属性的 Bean\r\n\r\n # Cache 配置项\r\n cache:\r\n type: REDIS\r\n redis:\r\n time-to-live: 1h # 设置过期时间为 1 小时\r\n\r\n--- #################### 接口文档配置 ####################\r\n\r\nspringdoc:\r\n api-docs:\r\n enabled: true # 1. 是否开启 Swagger 接文档的元数据\r\n path: /v3/api-docs\r\n swagger-ui:\r\n enabled: true # 2.1 是否开启 Swagger 文档的官方 UI 界面\r\n path: /swagger-ui.html\r\n default-flat-param-object: true # 参见 https://doc.xiaominfo.com/docs/faq/v4/knife4j-parameterobject-flat-param 文档\r\n\r\nknife4j:\r\n enable: true # 2.2 是否开启 Swagger 文档的 Knife4j UI 界面\r\n setting:\r\n language: zh_cn\r\n\r\n# MyBatis Plus 的配置项\r\nmybatis-plus:\r\n configuration:\r\n map-underscore-to-camel-case: true # 虽然默认为 true ，但是还是显示去指定下。\r\n global-config:\r\n db-config:\r\n id-type: NONE # “智能”模式，基于 IdTypeEnvironmentPostProcessor + 数据源的类型，自动适配成 AUTO、INPUT 模式。\r\n # id-type: AUTO # 自增 ID，适合 MySQL 等直接自增的数据库\r\n # id-type: INPUT # 用户输入 ID，适合 Oracle、PostgreSQL、Kingbase、DB2、H2 数据库\r\n # id-type: ASSIGN_ID # 分配 ID，默认使用雪花算法。注意，Oracle、PostgreSQL、Kingbase、DB2、H2 数据库时，需要去除实体类上的 @KeySequence 注解\r\n logic-delete-value: 1 # 逻辑已删除值(默认为 1)\r\n logic-not-delete-value: 0 # 逻辑未删除值(默认为 0)\r\n banner: false # 关闭控制台的 Banner 打印\r\n type-aliases-package: ${iailab.info.base-package}.dal.dataobject\r\n encryptor:\r\n password: XDV71a+xqStEA3WH # 加解密的秘钥，可使用 https://www.imaegoo.com/2020/aes-key-generator/ 网站生成\r\n\r\nmybatis-plus-join:\r\n banner: false # 关闭控制台的 Banner 打印\r\n\r\n# Spring Data Redis 配置\r\nspring:\r\n data:\r\n redis:\r\n repositories:\r\n enabled: false # 项目未使用到 Spring Data Redis 的 Repository，所以直接禁用，保证启动速度\r\n\r\n# VO 转换（数据翻译）相关\r\neasy-trans:\r\n is-enable-global: true # 启用全局翻译（拦截所有 SpringMVC ResponseBody 进行自动翻译 )。如果对于性能要求很高可关闭此配置，或通过 @IgnoreTrans 忽略某个接口\r\n is-enable-cloud: false # 禁用 TransType.RPC 微服务模式\r\n\r\n--- #################### RPC 远程调用相关配置 ####################\r\n\r\n--- #################### 消息队列相关 ####################\r\n\r\n# rocketmq 配置项，对应 RocketMQProperties 配置类\r\nrocketmq:\r\n # Producer 配置项\r\n producer:\r\n group: ${spring.application.name}_PRODUCER # 生产者分组\r\n\r\nspring:\r\n # Kafka 配置项，对应 KafkaProperties 配置类\r\n kafka:\r\n # Kafka Producer 配置项\r\n producer:\r\n acks: 1 # 0-不应答。1-leader 应答。all-所有 leader 和 follower 应答。\r\n retries: 3 # 发送失败时，重试发送的次数\r\n value-serializer: org.springframework.kafka.support.serializer.JsonSerializer # 消息的 value 的序列化\r\n # Kafka Consumer 配置项\r\n consumer:\r\n auto-offset-reset: earliest # 设置消费者分组最初的消费进度为 earliest 。可参考博客 https://blog.csdn.net/lishuangzhe7047/article/details/74530417 理解\r\n value-deserializer: org.springframework.kafka.support.serializer.JsonDeserializer\r\n properties:\r\n spring.json.trusted.packages: \'*\'\r\n # Kafka Consumer Listener 监听器配置\r\n listener:\r\n missing-topics-fatal: false # 消费监听接口监听的主题不存在时，默认会报错。所以通过设置为 false ，解决报错\r\n\r\n--- #################### 定时任务相关配置 ####################\r\n\r\nxxl:\r\n job:\r\n executor:\r\n appname: ${spring.application.name} # 执行器 AppName\r\n logpath: ${user.home}/logs/xxl-job/${spring.application.name} # 执行器运行日志文件存储磁盘路径\r\n accessToken: default_token # 执行器通讯TOKEN\r\n\r\n--- #################### 验证码相关配置 ####################\r\n\r\naj:\r\n captcha:\r\n jigsaw: classpath:images/jigsaw # 滑动验证，底图路径，不配置将使用默认图片；以 classpath: 开头，取 resource 目录下路径\r\n pic-click: classpath:images/pic-click # 滑动验证，底图路径，不配置将使用默认图片；以 classpath: 开头，取 resource 目录下路径\r\n cache-type: redis # 缓存 local/redis...\r\n cache-number: 1000 # local 缓存的阈值,达到这个值，清除缓存\r\n timing-clear: 180 # local定时清除过期缓存(单位秒),设置为0代表不执行\r\n type: blockPuzzle # 验证码类型 default两种都实例化。 blockPuzzle 滑块拼图 clickWord 文字点选\r\n water-mark: iailab # 右下角水印文字(我的水印)，可使用 https://tool.chinaz.com/tools/unicode.aspx 中文转 Unicode，Linux 可能需要转 unicode\r\n interference-options: 0 # 滑动干扰项(0/1/2)\r\n req-frequency-limit-enable: false # 接口请求次数一分钟限制是否开启 true|false\r\n req-get-lock-limit: 5 # 验证失败5次，get接口锁定\r\n req-get-lock-seconds: 10 # 验证失败后，锁定时间间隔\r\n req-get-minute-limit: 30 # get 接口一分钟内请求数限制\r\n req-check-minute-limit: 60 # check 接口一分钟内请求数限制\r\n req-verify-minute-limit: 60 # verify 接口一分钟内请求数限制\r\n\r\n--- #################### 平台相关配置 ####################\r\n\r\niailab:\r\n info:\r\n version: 1.0.0\r\n base-package: com.iailab.module.system\r\n web:\r\n admin-ui:\r\n url: http://dashboard.iailab.iocoder.cn # Admin 管理后台 UI 的地址\r\n swagger:\r\n title: 管理后台\r\n description: 提供管理员管理的所有功能\r\n version: ${iailab.info.version}\r\n base-package: ${iailab.info.base-package}\r\n captcha:\r\n enable: true # 验证码的开关，默认为 true；\r\n tenant: # 多租户相关配置项\r\n enable: true\r\n ignore-urls:\r\n - /admin-api/system/tenant/get-id-by-name # 基于名字获取租户，不许带租户编号\r\n - /admin-api/system/tenant/get-by-website # 基于域名获取租户，不许带租户编号\r\n - /admin-api/system/captcha/get-image # 获取图片验证码，和租户无关\r\n - /admin-api/system/captcha/get # 获取图片验证码，和租户无关\r\n - /admin-api/system/captcha/check # 校验图片验证码，和租户无关\r\n - /admin-api/system/sms/callback/* # 短信回调接口，无法带上租户编号\r\n - /rpc-api/system/tenant/valid # 防止递归。避免调用 /rpc-api/system/tenant/valid 接口时，又去触发 /rpc-api/system/tenant/valid 去校验\r\n - /rpc-api/system/tenant/id-list # 获得租户列表的时候，无需传递租户编号\r\n - /rpc-api/system/oauth2/token/check # 访问令牌校验时，无需传递租户编号；主要解决上传文件的场景，前端不会传递 tenant-id！\r\n ignore-tables:\r\n - system_tenant\r\n - system_tenant_package\r\n - system_dict_data\r\n - system_dict_type\r\n - system_error_code\r\n - system_menu\r\n - system_sms_channel\r\n - system_sms_template\r\n - system_sms_log\r\n - system_sensitive_word\r\n - system_oauth2_client\r\n - system_mail_account\r\n - system_mail_template\r\n - system_mail_log\r\n - system_notify_template\r\n sms-code: # 短信验证码相关的配置项\r\n expire-times: 10m\r\n send-frequency: 1m\r\n send-maximum-quantity-per-day: 10\r\n begin-code: 9999 # 这里配置 9999 的原因是，测试方便。\r\n end-code: 9999 # 这里配置 9999 的原因是，测试方便。\r\n\r\ndebug: false', '35f2867f44d5442ad723ea6ad4f70e1c', '2024-06-20 09:00:22', '2024-06-20 09:00:22', NULL, '0:0:0:0:0:0:0:1', '', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', NULL, NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (56, 'application-local.yaml', 'DEFAULT_GROUP', '--- #################### 数据库相关配置 ####################\nspring:\n # 数据源配置项\n autoconfigure:\n exclude:\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\n - de.codecentric.boot.admin.client.config.SpringBootAdminClientAutoConfiguration # 禁用 Spring Boot Admin 的 Client 的自动配置\n datasource:\n druid: # Druid 【监控】相关的全局配置\n web-stat-filter:\n enabled: true\n stat-view-servlet:\n enabled: true\n allow: # 设置白名单，不填则允许所有访问\n url-pattern: /druid/*\n login-username: # 控制台管理用户名和密码\n login-password:\n filter:\n stat:\n enabled: true\n log-slow-sql: true # 慢 SQL 记录\n slow-sql-millis: 100\n merge-sql: true\n wall:\n config:\n multi-statement-allow: true\n dynamic: # 多数据源配置\n druid: # Druid 【连接池】相关的全局配置\n initial-size: 1 # 初始连接数\n min-idle: 1 # 最小连接池数量\n max-active: 20 # 最大连接池数量\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\n test-while-idle: true\n test-on-borrow: false\n test-on-return: false\n primary: master\n datasource:\n master:\n url: jdbc:mysql://127.0.0.1:3306/iailab-platform?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\n # url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=true&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai # MySQL Connector/J 5.X 连接的示例\n # url: jdbc:postgresql://127.0.0.1:5432/ruoyi-vue-pro # PostgreSQL 连接的示例\n # url: jdbc:oracle:thin:@127.0.0.1:1521:xe # Oracle 连接的示例\n # url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ruoyi-vue-pro # SQLServer 连接的示例\n # url: jdbc:dm://10.211.55.4:5236?schema=RUOYI_VUE_PRO # DM 连接的示例\n username: root\n password: 123456\n # username: sa # SQL Server 连接的示例\n # password: JSm:g(*%lU4ZAkz06cd52KqT3)i1?H7W # SQL Server 连接的示例\n # username: SYSDBA # DM 连接的示例\n # password: SYSDBA # DM 连接的示例\n slave: # 模拟从库，可根据自己需要修改\n lazy: true # 开启懒加载，保证启动速度\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true\n username: root\n password: 123456\n\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\n redis:\n host: 127.0.0.1 # 地址\n port: 6379 # 端口\n database: 0 # 数据库索引\n password: 123456 # 密码，建议生产环境开启\n\n--- #################### MQ 消息队列相关配置 ####################\n\n# rocketmq 配置项，对应 RocketMQProperties 配置类\nrocketmq:\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\n\nspring:\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\n rabbitmq:\n host: 127.0.0.1 # RabbitMQ 服务的地址\n port: 5672 # RabbitMQ 服务的端口\n username: guest # RabbitMQ 服务的账号\n password: guest # RabbitMQ 服务的密码\n # Kafka 配置项，对应 KafkaProperties 配置类\n kafka:\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\n\n--- #################### 定时任务相关配置 ####################\n\nxxl:\n job:\n enabled: true # 是否开启调度中心，默认为 true 开启\n admin:\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\n\n--- #################### 服务保障相关配置 ####################\n\n# Lock4j 配置项\nlock4j:\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\n\n--- #################### 监控相关配置 ####################\n\n# Actuator 监控端点的配置项\nmanagement:\n endpoints:\n web:\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\n exposure:\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\n\n# Spring Boot Admin 配置项\nspring:\n boot:\n admin:\n # Spring Boot Admin Client 客户端的相关配置\n client:\n instance:\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\n\n# 日志文件配置\nlogging:\n level:\n # 配置自己写的 MyBatis Mapper 打印日志\n com.iailab.module.system.dal.mysql: debug\n com.iailab.module.system.dal.mysql.sensitiveword.SensitiveWordMapper: INFO # 配置 SensitiveWordMapper 的日志级别为 info\n com.iailab.module.system.dal.mysql.sms.SmsChannelMapper: INFO # 配置 SmsChannelMapper 的日志级别为 info\n\n--- #################### 微信公众号、小程序相关配置 ####################\nwx:\n mp: # 公众号配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-mp-spring-boot-starter/README.md 文档\n # app-id: wx041349c6f39b268b # 测试号（牛希尧提供的）\n # secret: 5abee519483bc9f8cb37ce280e814bd0\n app-id: wx5b23ba7a5589ecbb # 测试号（自己的）\n secret: 2a7b3b20c537e52e74afd395eb85f61f\n # app-id: wxa69ab825b163be19 # 测试号（Kongdy 提供的）\n # secret: bd4f9fab889591b62aeac0d7b8d8b4a0\n # 存储配置，解决 AccessToken 的跨节点的共享\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wx # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n miniapp: # 小程序配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-miniapp-spring-boot-starter/README.md 文档\n # appid: wx62056c0d5e8db250 # 测试号（牛希尧提供的）\n # secret: 333ae72f41552af1e998fe1f54e1584a\n appid: wx63c280fe3248a3e7 # wenhualian的接口测试号\n secret: 6f270509224a7ae1296bbf1c8cb97aed\n # appid: wxc4598c446f8a9cb3 # 测试号（Kongdy 提供的）\n # secret: 4a1a04e07f6a4a0751b39c3064a92c8b\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wa # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n\n--- #################### 平台相关配置 ####################\n\n# 平台配置项，设置当前项目所有自定义的配置\niailab:\n env: # 多环境的配置项\n tag: ${HOSTNAME}\n captcha:\n enable: false # 本地环境，暂时关闭图片验证码，方便登录等接口的测试\n security:\n mock-enable: true\n xss:\n enable: false\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\n pay:\n pay-notify-url: http://niubi.natapp1.cc/api/pay/order/notify\n pay-return-url: http://niubi.natapp1.cc/api/pay/order/return\n refund-notify-url: http://niubi.natapp1.cc/api/pay/refund/notify\n access-log: # 访问日志的配置项\n enable: false\n demo: false # 关闭演示模式\n\njustauth:\n enabled: true\n type:\n DINGTALK: # 钉钉\n client-id: dingvrnreaje3yqvzhxg\n client-secret: i8E6iZyDvZj51JIb0tYsYfVQYOks9Cq1lgryEjFRqC79P3iJcrxEwT6Qk2QvLrLI\n ignore-check-redirect-uri: true\n WECHAT_ENTERPRISE: # 企业微信\n client-id: wwd411c69a39ad2e54\n client-secret: 1wTb7hYxnpT2TUbIeHGXGo7T0odav1ic10mLdyyATOw\n agent-id: 1000004\n ignore-check-redirect-uri: true\n # noinspection SpringBootApplicationYaml\n WECHAT_MINI_APP: # 微信小程序\n client-id: ${wx.miniapp.appid}\n client-secret: ${wx.miniapp.secret}\n ignore-check-redirect-uri: true\n ignore-check-state: true # 微信小程序，不会使用到 state，所以不进行校验\n WECHAT_MP: # 微信公众号\n client-id: ${wx.mp.app-id}\n client-secret: ${wx.mp.secret}\n ignore-check-redirect-uri: true\n cache:\n type: REDIS\n prefix: \'social_auth_state:\' # 缓存前缀，目前只对 Redis 缓存生效，默认 JUSTAUTH::STATE::\n timeout: 24h # 超时时长，目前只对 Redis 缓存生效，默认 3 分钟\n', '0856d0b9bbe03a7b53a7894dbe11d7e0', '2024-06-20 09:00:59', '2024-07-03 02:54:22', 'nacos', '0:0:0:0:0:0:0:1', 'local-config', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', '', '', '', 'yaml', '', ''); INSERT INTO `config_info` VALUES (67, 'application-dev.yaml', 'DEFAULT_GROUP', '--- #################### 数据库相关配置 ####################\r\nspring:\r\n # 数据源配置项\r\n autoconfigure:\r\n exclude:\r\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\r\n datasource:\r\n druid: # Druid 【监控】相关的全局配置\r\n web-stat-filter:\r\n enabled: true\r\n stat-view-servlet:\r\n enabled: true\r\n allow: # 设置白名单，不填则允许所有访问\r\n url-pattern: /druid/*\r\n login-username: # 控制台管理用户名和密码\r\n login-password:\r\n filter:\r\n stat:\r\n enabled: true\r\n log-slow-sql: true # 慢 SQL 记录\r\n slow-sql-millis: 100\r\n merge-sql: true\r\n wall:\r\n config:\r\n multi-statement-allow: true\r\n dynamic: # 多数据源配置\r\n druid: # Druid 【连接池】相关的全局配置\r\n initial-size: 5 # 初始连接数\r\n min-idle: 10 # 最小连接池数量\r\n max-active: 20 # 最大连接池数量\r\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\r\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\r\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\r\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\r\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\r\n test-while-idle: true\r\n test-on-borrow: false\r\n test-on-return: false\r\n primary: master\r\n datasource:\r\n master:\r\n url: jdbc:mysql://127.0.0.1:3306/iailab-platform?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\r\n username: root\r\n password: 123456\r\n slave: # 模拟从库，可根据自己需要修改 # 模拟从库，可根据自己需要修改\r\n lazy: true # 开启懒加载，保证启动速度\r\n url: jdbc:mysql://127.0.0.1:3306/iailab-platform?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\r\n username: root\r\n password: 123456\r\n\r\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\r\n redis:\r\n host: 127.0.0.1 # 地址\r\n port: 6379 # 端口\r\n database: 1 # 数据库索引\r\n password: 123456 # 密码，建议生产环境开启\r\n\r\n--- #################### MQ 消息队列相关配置 ####################\r\n\r\n# rocketmq 配置项，对应 RocketMQProperties 配置类\r\nrocketmq:\r\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\r\n\r\nspring:\r\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\r\n rabbitmq:\r\n host: 127.0.0.1 # RabbitMQ 服务的地址\r\n port: 5672 # RabbitMQ 服务的端口\r\n username: guest # RabbitMQ 服务的账号\r\n password: guest # RabbitMQ 服务的密码\r\n # Kafka 配置项，对应 KafkaProperties 配置类\r\n kafka:\r\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\r\n\r\n--- #################### 定时任务相关配置 ####################\r\nxxl:\r\n job:\r\n admin:\r\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\r\n\r\n--- #################### 服务保障相关配置 ####################\r\n\r\n# Lock4j 配置项\r\nlock4j:\r\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\r\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\r\n\r\n--- #################### 监控相关配置 ####################\r\n\r\n# Actuator 监控端点的配置项\r\nmanagement:\r\n endpoints:\r\n web:\r\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\r\n exposure:\r\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\r\n\r\n# Spring Boot Admin 配置项\r\nspring:\r\n boot:\r\n admin:\r\n # Spring Boot Admin Client 客户端的相关配置\r\n client:\r\n instance:\r\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\r\n # Spring Boot Admin Server 服务端的相关配置\r\n context-path: /admin # 配置 Spring\r\n\r\n--- #################### 平台相关配置 ####################\r\n\r\n# 平台配置项，设置当前项目所有自定义的配置\r\niailab:\r\n xss:\r\n enable: false\r\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\r\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\r\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\r\n demo: true # 开启演示模式\r\n', '9f26684015d3eff63033fbf295929f8a', '2024-06-27 06:07:56', '2024-06-27 06:07:56', NULL, '0:0:0:0:0:0:0:1', '', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', NULL, NULL, NULL, 'yaml', NULL, ''); -- ---------------------------- -- Table structure for config_info_aggr -- ---------------------------- DROP TABLE IF EXISTS `config_info_aggr`; CREATE TABLE `config_info_aggr` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id', `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id', `datum_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'datum_id', `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '内容', `gmt_modified` datetime NOT NULL COMMENT '修改时间', `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_configinfoaggr_datagrouptenantdatum`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC, `datum_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '增加租户字段' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of config_info_aggr -- ---------------------------- -- ---------------------------- -- Table structure for config_info_beta -- ---------------------------- DROP TABLE IF EXISTS `config_info_beta`; CREATE TABLE `config_info_beta` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id', `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id', `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name', `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content', `beta_ips` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'betaIps', `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5', `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间', `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间', `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user', `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip', `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段', `encrypted_data_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '加密key', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_configinfobeta_datagrouptenant`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_beta' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of config_info_beta -- ---------------------------- -- ---------------------------- -- Table structure for config_info_tag -- ---------------------------- DROP TABLE IF EXISTS `config_info_tag`; CREATE TABLE `config_info_tag` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id', `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id', `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id', `tag_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_id', `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name', `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content', `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5', `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间', `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间', `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user', `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip', `encrypted_data_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '加密key', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_configinfotag_datagrouptenanttag`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC, `tag_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_tag' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of config_info_tag -- ---------------------------- -- ---------------------------- -- Table structure for config_tags_relation -- ---------------------------- DROP TABLE IF EXISTS `config_tags_relation`; CREATE TABLE `config_tags_relation` ( `id` bigint NOT NULL COMMENT 'id', `tag_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_name', `tag_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tag_type', `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id', `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id', `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id', `nid` bigint NOT NULL AUTO_INCREMENT, PRIMARY KEY (`nid`) USING BTREE, UNIQUE INDEX `uk_configtagrelation_configidtag`(`id` ASC, `tag_name` ASC, `tag_type` ASC) USING BTREE, INDEX `idx_tenant_id`(`tenant_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_tag_relation' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of config_tags_relation -- ---------------------------- -- ---------------------------- -- Table structure for group_capacity -- ---------------------------- DROP TABLE IF EXISTS `group_capacity`; CREATE TABLE `group_capacity` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID', `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群', `quota` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值', `usage` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量', `max_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值', `max_aggr_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数，，0表示使用默认值', `max_aggr_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值', `max_history_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量', `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间', `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_group_id`(`group_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '集群、各Group容量信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of group_capacity -- ---------------------------- -- ---------------------------- -- Table structure for his_config_info -- ---------------------------- DROP TABLE IF EXISTS `his_config_info`; CREATE TABLE `his_config_info` ( `id` bigint UNSIGNED NOT NULL, `nid` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name', `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00', `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00', `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL, `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `op_type` char(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段', `encrypted_data_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '加密key', PRIMARY KEY (`nid`) USING BTREE, INDEX `idx_gmt_create`(`gmt_create` ASC) USING BTREE, INDEX `idx_gmt_modified`(`gmt_modified` ASC) USING BTREE, INDEX `idx_did`(`data_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 90 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '多租户改造' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of his_config_info -- ---------------------------- INSERT INTO `his_config_info` VALUES (1, 50, 'jeecg-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: root\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\n # flyway配置\n flyway:\n # 是否启用flyway\n enabled: false\n # 编码格式，默认UTF-8\n encoding: UTF-8\n # 迁移sql脚本文件存放路径，官方默认db/migration\n locations: classpath:flyway/sql/mysql\n # 迁移sql脚本文件名称的前缀，默认V\n sql-migration-prefix: V\n # 迁移sql脚本文件名称的分隔符，默认2个下划线__\n sql-migration-separator: __\n # 避免带${}sql执行失败\n placeholder-prefix: \'#(\'\n placeholder-suffix: )\n # 迁移sql脚本文件名称的后缀\n sql-migration-suffixes: .sql\n # 迁移时是否进行校验，默认true\n validate-on-migrate: true\n # 当迁移发现数据库非空且存在没有元数据的表时，自动执行基准迁移，新建schema_version表\n baseline-on-migrate: true\n # 是否关闭要清除已有库下的表功能,生产环境必须为true,否则会删库，非常重要！！！\n clean-disabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n mode: dev\n is_verify_token: false\n verify_methods: remove,delete,save,add,update\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', '9470508426a24b33019d4e699b9a2452', '2010-05-05 00:00:00', '2024-06-11 16:08:11', NULL, '0:0:0:0:0:0:0:1', 'U', '', ''); INSERT INTO `his_config_info` VALUES (2, 51, 'jeecg.yaml', 'DEFAULT_GROUP', '', 'server:\n tomcat:\n max-swallow-size: -1\n error:\n include-exception: true\n include-stacktrace: ALWAYS\n include-message: ALWAYS\n compression:\n enabled: true\n min-response-size: 1024\n mime-types: application/javascript,application/json,application/xml,text/html,text/xml,text/plain,text/css,image/*\nmanagement:\n health:\n mail:\n enabled: false\n endpoints:\n web:\n exposure:\n include: \"*\"\n health:\n sensitive: true\n endpoint:\n health:\n show-details: ALWAYS\nspring:\n servlet:\n multipart:\n max-file-size: 10MB\n max-request-size: 10MB\n mail:\n host: smtp.163.com\n username: jeecgos@163.com\n password: ??\n properties:\n mail:\n smtp:\n auth: true\n starttls:\n enable: true\n required: true\n quartz:\n job-store-type: jdbc\n initialize-schema: embedded\n auto-startup: false\n startup-delay: 1s\n overwrite-existing-jobs: true\n properties:\n org:\n quartz:\n scheduler:\n instanceName: MyScheduler\n instanceId: AUTO\n jobStore:\n class: org.springframework.scheduling.quartz.LocalDataSourceJobStore\n driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate\n tablePrefix: QRTZ_\n isClustered: true\n misfireThreshold: 12000\n clusterCheckinInterval: 15000\n threadPool:\n class: org.quartz.simpl.SimpleThreadPool\n threadCount: 10\n threadPriority: 5\n threadsInheritContextClassLoaderOfInitializingThread: true\n jackson:\n date-format: yyyy-MM-dd HH:mm:ss\n time-zone: GMT+8\n aop:\n proxy-target-class: true\n activiti:\n check-process-definitions: false\n async-executor-activate: false\n job-executor-activate: false\n jpa:\n open-in-view: false\n freemarker:\n suffix: .ftl\n content-type: text/html\n charset: UTF-8\n cache: false\n prefer-file-system-access: false\n template-loader-path:\n - classpath:/templates\n mvc:\n static-path-pattern: /**\n pathmatch:\n matching-strategy: ant_path_matcher\n resource:\n static-locations: classpath:/static/,classpath:/public/\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\nmybatis-plus:\n mapper-locations: classpath*:org/jeecg/modules/**/xml/*Mapper.xml\n global-config:\n banner: false\n db-config:\n id-type: ASSIGN_ID\n table-underline: true\n configuration:\n call-setters-on-nulls: true', '2117a96ba08e8fd0f66825e87416af27', '2010-05-05 00:00:00', '2024-06-11 16:09:40', NULL, '0:0:0:0:0:0:0:1', 'U', '', ''); INSERT INTO `his_config_info` VALUES (1, 52, 'jeecg-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n wall:\n selectWhereAlwayTrueCheck: false\n stat:\n merge-sql: true\n slow-sql-millis: 5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: root\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\n # flyway配置\n flyway:\n # 是否启用flyway\n enabled: false\n # 编码格式，默认UTF-8\n encoding: UTF-8\n # 迁移sql脚本文件存放路径，官方默认db/migration\n locations: classpath:flyway/sql/mysql\n # 迁移sql脚本文件名称的前缀，默认V\n sql-migration-prefix: V\n # 迁移sql脚本文件名称的分隔符，默认2个下划线__\n sql-migration-separator: __\n # 避免带${}sql执行失败\n placeholder-prefix: \'#(\'\n placeholder-suffix: )\n # 迁移sql脚本文件名称的后缀\n sql-migration-suffixes: .sql\n # 迁移时是否进行校验，默认true\n validate-on-migrate: true\n # 当迁移发现数据库非空且存在没有元数据的表时，自动执行基准迁移，新建schema_version表\n baseline-on-migrate: true\n # 是否关闭要清除已有库下的表功能,生产环境必须为true,否则会删库，非常重要！！！\n clean-disabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n mode: dev\n is_verify_token: false\n verify_methods: remove,delete,save,add,update\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', '94714fd1a1fa85b145a2485b418b2dc7', '2010-05-05 00:00:00', '2024-06-11 16:11:46', NULL, '0:0:0:0:0:0:0:1', 'U', '', ''); INSERT INTO `his_config_info` VALUES (1, 53, 'jeecg-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n wall:\n selectWhereAlwayTrueCheck: false\n stat:\n merge-sql: true\n slow-sql-millis: 5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: root\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\n # flyway配置\n flyway:\n # 是否启用flyway\n enabled: false\n # 编码格式，默认UTF-8\n encoding: UTF-8\n # 迁移sql脚本文件存放路径，官方默认db/migration\n locations: classpath:flyway/sql/mysql\n # 迁移sql脚本文件名称的前缀，默认V\n sql-migration-prefix: V\n # 迁移sql脚本文件名称的分隔符，默认2个下划线__\n sql-migration-separator: __\n # 避免带${}sql执行失败\n placeholder-prefix: \'#(\'\n placeholder-suffix: )\n # 迁移sql脚本文件名称的后缀\n sql-migration-suffixes: .sql\n # 迁移时是否进行校验，默认true\n validate-on-migrate: true\n # 当迁移发现数据库非空且存在没有元数据的表时，自动执行基准迁移，新建schema_version表\n baseline-on-migrate: true\n # 是否关闭要清除已有库下的表功能,生产环境必须为true,否则会删库，非常重要！！！\n clean-disabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n firewall:\n dataSourceSafe: false\n lowCodeMode: dev\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys,/sys/sendChangePwdSms,/sys/user/sendChangePhoneSms,/sys/sms,/desform/api/sendVerifyCode\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n saasMode:\n firewall:\n dataSourceSafe: false\n lowCodeMode: dev\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', '26be1aa1e8c351f1d55b7a58a62a513f', '2010-05-05 00:00:00', '2024-06-11 16:12:48', NULL, '0:0:0:0:0:0:0:1', 'U', '', ''); INSERT INTO `his_config_info` VALUES (20, 54, 'jeecg-gateway-dev.yaml', 'DEFAULT_GROUP', '', 'jeecg:\n route:\n config:\n #type:database nacos yml\n data-type: database\n data-id: jeecg-gateway-router\nspring:\n redis:\n database: 0\n host: jeecg-boot-redis\n port: 6379\n password:', 'd65267ddfda1b0c0f4462606195d1a5a', '2010-05-05 00:00:00', '2024-06-11 16:13:15', NULL, '0:0:0:0:0:0:0:1', 'U', '', ''); INSERT INTO `his_config_info` VALUES (3, 55, 'jeecg-gateway-router.json', 'DEFAULT_GROUP', '', '[{\n \"id\": \"jeecg-system\",\n \"order\": 0,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/sys/**\",\n \"_genkey_1\": \"/jmreport/**\",\n \"_genkey_3\": \"/online/**\",\n \"_genkey_4\": \"/generic/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb://jeecg-system\"\n}, {\n \"id\": \"jeecg-demo\",\n \"order\": 1,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/mock/**\",\n \"_genkey_1\": \"/test/**\",\n \"_genkey_2\": \"/bigscreen/template1/**\",\n \"_genkey_3\": \"/bigscreen/template2/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb://jeecg-demo\"\n}, {\n \"id\": \"jeecg-system-websocket\",\n \"order\": 2,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/websocket/**\",\n \"_genkey_1\": \"/newsWebsocket/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb:ws://jeecg-system\"\n}, {\n \"id\": \"jeecg-demo-websocket\",\n \"order\": 3,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/vxeSocket/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb:ws://jeecg-demo\"\n}]', 'be6548051d99309d7fa5ac4398404201', '2010-05-05 00:00:00', '2024-06-11 16:15:50', NULL, '0:0:0:0:0:0:0:1', 'U', '', ''); INSERT INTO `his_config_info` VALUES (37, 56, 'jeecg-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: root\n driver-class-name: com.mysql.cj.jdbc.Driver\n data:\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\n # flyway配置\n flyway:\n # 是否启用flyway\n enabled: false\n # 编码格式，默认UTF-8\n encoding: UTF-8\n # 迁移sql脚本文件存放路径，官方默认db/migration\n locations: classpath:flyway/sql/mysql\n # 迁移sql脚本文件名称的前缀，默认V\n sql-migration-prefix: V\n # 迁移sql脚本文件名称的分隔符，默认2个下划线__\n sql-migration-separator: __\n # 避免带${}sql执行失败\n placeholder-prefix: \'#(\'\n placeholder-suffix: )\n # 迁移sql脚本文件名称的后缀\n sql-migration-suffixes: .sql\n # 迁移时是否进行校验，默认true\n validate-on-migrate: true\n # 当迁移发现数据库非空且存在没有元数据的表时，自动执行基准迁移，新建schema_version表\n baseline-on-migrate: true\n # 是否关闭要清除已有库下的表功能,生产环境必须为true,否则会删库，非常重要！！！\n clean-disabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n mode: dev\n is_verify_token: false\n verify_methods: remove,delete,save,add,update\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', 'b765a09fb69244b2ce53675d8bed71c0', '2010-05-05 00:00:00', '2024-06-11 16:22:38', NULL, '0:0:0:0:0:0:0:1', 'U', 'efc4e412-b1a1-498f-ba01-b31807649a9a', ''); INSERT INTO `his_config_info` VALUES (38, 57, 'jeecg.yaml', 'DEFAULT_GROUP', '', 'server:\n undertow:\n # 平替 tomcat server.tomcat.max-swallow-siz， undertow该值默认为-1\n # max-http-post-size: 10MB\n worker-threads: 16 # 4核CPU标准配置\n buffers:\n websocket: 8192 # WebSocket缓冲 以字节为单位，这里设置为8 KB\n io: 16384 # IO操作缓冲 以字节为单位，这里设置为16 KB\n error:\n include-exception: true\n include-stacktrace: ALWAYS\n include-message: ALWAYS\n compression:\n enabled: true\n min-response-size: 1024\n mime-types: application/javascript,application/json,application/xml,text/html,text/xml,text/plain,text/css,image/*\nmanagement:\n health:\n mail:\n enabled: false\n endpoints:\n web:\n exposure:\n include: \"*\"\n health:\n sensitive: true\n endpoint:\n health:\n show-details: ALWAYS\nspring:\n servlet:\n multipart:\n max-file-size: 10MB\n max-request-size: 10MB\n mail:\n host: smtp.163.com\n username: jeecgos@163.com\n password: ??\n properties:\n mail:\n smtp:\n auth: true\n starttls:\n enable: true\n required: true\n quartz:\n job-store-type: jdbc\n initialize-schema: embedded\n auto-startup: false\n startup-delay: 1s\n overwrite-existing-jobs: true\n properties:\n org:\n quartz:\n scheduler:\n instanceName: MyScheduler\n instanceId: AUTO\n jobStore:\n class: org.springframework.scheduling.quartz.LocalDataSourceJobStore\n driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate\n tablePrefix: QRTZ_\n isClustered: true\n misfireThreshold: 12000\n clusterCheckinInterval: 15000\n threadPool:\n class: org.quartz.simpl.SimpleThreadPool\n threadCount: 10\n threadPriority: 5\n threadsInheritContextClassLoaderOfInitializingThread: true\n jackson:\n date-format: yyyy-MM-dd HH:mm:ss\n time-zone: GMT+8\n aop:\n proxy-target-class: true\n activiti:\n check-process-definitions: false\n async-executor-activate: false\n job-executor-activate: false\n jpa:\n open-in-view: false\n freemarker:\n suffix: .ftl\n content-type: text/html\n charset: UTF-8\n cache: false\n prefer-file-system-access: false\n template-loader-path:\n - classpath:/templates\n mvc:\n static-path-pattern: /**\n pathmatch:\n matching-strategy: ant_path_matcher\n resource:\n static-locations: classpath:/static/,classpath:/public/\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot3.autoconfigure.DruidDataSourceAutoConfigure\nmybatis-plus:\n mapper-locations: classpath*:org/jeecg/modules/**/xml/*Mapper.xml\n global-config:\n banner: false\n db-config:\n id-type: ASSIGN_ID\n table-underline: true\n configuration:\n call-setters-on-nulls: true', 'f8c2b79e4939e0d2860ab70f5d098d99', '2010-05-05 00:00:00', '2024-06-11 16:24:11', NULL, '0:0:0:0:0:0:0:1', 'U', 'efc4e412-b1a1-498f-ba01-b31807649a9a', ''); INSERT INTO `his_config_info` VALUES (37, 58, 'jeecg-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n wall:\n selectWhereAlwayTrueCheck: false\n stat:\n merge-sql: true\n slow-sql-millis: 5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: root\n driver-class-name: com.mysql.cj.jdbc.Driver\n data:\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\n # flyway配置\n flyway:\n # 是否启用flyway\n enabled: false\n # 编码格式，默认UTF-8\n encoding: UTF-8\n # 迁移sql脚本文件存放路径，官方默认db/migration\n locations: classpath:flyway/sql/mysql\n # 迁移sql脚本文件名称的前缀，默认V\n sql-migration-prefix: V\n # 迁移sql脚本文件名称的分隔符，默认2个下划线__\n sql-migration-separator: __\n # 避免带${}sql执行失败\n placeholder-prefix: \'#(\'\n placeholder-suffix: )\n # 迁移sql脚本文件名称的后缀\n sql-migration-suffixes: .sql\n # 迁移时是否进行校验，默认true\n validate-on-migrate: true\n # 当迁移发现数据库非空且存在没有元数据的表时，自动执行基准迁移，新建schema_version表\n baseline-on-migrate: true\n # 是否关闭要清除已有库下的表功能,生产环境必须为true,否则会删库，非常重要！！！\n clean-disabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n firewall:\n dataSourceSafe: false\n lowCodeMode: dev\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n saasMode:\n firewall:\n dataSourceSafe: false\n lowCodeMode: dev\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\n ai-chat:\n enabled: false\n apiKey: \"？？？？\"\n apiHost: \"https://api.openai.com\"\n timeout: 60\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', '48b8e585e0ef50d650d7f209b47515ae', '2010-05-05 00:00:00', '2024-06-11 16:24:46', NULL, '0:0:0:0:0:0:0:1', 'U', 'efc4e412-b1a1-498f-ba01-b31807649a9a', ''); INSERT INTO `his_config_info` VALUES (39, 59, 'jeecg-gateway-router.json', 'DEFAULT_GROUP', '', '[{\n \"id\": \"jeecg-system\",\n \"order\": 0,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/sys/**\",\n \"_genkey_1\": \"/jmreport/**\",\n \"_genkey_3\": \"/online/**\",\n \"_genkey_4\": \"/generic/**\",\n \"_genkey_5\": \"/oauth2/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb://jeecg-system\"\n}, {\n \"id\": \"jeecg-demo\",\n \"order\": 1,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/mock/**\",\n \"_genkey_1\": \"/test/**\",\n \"_genkey_2\": \"/bigscreen/template1/**\",\n \"_genkey_3\": \"/bigscreen/template2/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb://jeecg-demo\"\n}, {\n \"id\": \"jeecg-system-websocket\",\n \"order\": 2,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/websocket/**\",\n \"_genkey_1\": \"/newsWebsocket/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb:ws://jeecg-system\"\n}, {\n \"id\": \"jeecg-demo-websocket\",\n \"order\": 3,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/vxeSocket/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb:ws://jeecg-demo\"\n}]', '31f84dba476cdd96c86fc54a264f34a8', '2010-05-05 00:00:00', '2024-06-11 16:25:56', NULL, '0:0:0:0:0:0:0:1', 'U', 'efc4e412-b1a1-498f-ba01-b31807649a9a', ''); INSERT INTO `his_config_info` VALUES (41, 60, 'jeecg-gateway-dev.yaml', 'DEFAULT_GROUP', '', 'jeecg:\n route:\n config:\n #type:database nacos yml\n data-type: database\n data-id: jeecg-gateway-router\nspring:\n data:\n redis:\n database: 0\n host: jeecg-boot-redis\n port: 6379\n password:', '490a384cd67a369a14e34d0e9fa33c18', '2010-05-05 00:00:00', '2024-06-11 16:26:12', NULL, '0:0:0:0:0:0:0:1', 'U', 'efc4e412-b1a1-498f-ba01-b31807649a9a', ''); INSERT INTO `his_config_info` VALUES (1, 61, 'jeecg-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n wall:\n selectWhereAlwayTrueCheck: false\n stat:\n merge-sql: true\n slow-sql-millis: 5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: root\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\n # flyway配置\n flyway:\n # 是否启用flyway\n enabled: false\n # 编码格式，默认UTF-8\n encoding: UTF-8\n # 迁移sql脚本文件存放路径，官方默认db/migration\n locations: classpath:flyway/sql/mysql\n # 迁移sql脚本文件名称的前缀，默认V\n sql-migration-prefix: V\n # 迁移sql脚本文件名称的分隔符，默认2个下划线__\n sql-migration-separator: __\n # 避免带${}sql执行失败\n placeholder-prefix: \'#(\'\n placeholder-suffix: )\n # 迁移sql脚本文件名称的后缀\n sql-migration-suffixes: .sql\n # 迁移时是否进行校验，默认true\n validate-on-migrate: true\n # 当迁移发现数据库非空且存在没有元数据的表时，自动执行基准迁移，新建schema_version表\n baseline-on-migrate: true\n # 是否关闭要清除已有库下的表功能,生产环境必须为true,否则会删库，非常重要！！！\n clean-disabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n firewall:\n dataSourceSafe: false\n lowCodeMode: dev\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys,/sys/sendChangePwdSms,/sys/user/sendChangePhoneSms,/sys/sms,/desform/api/sendVerifyCode\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n saasMode:\n firewall:\n dataSourceSafe: false\n lowCodeMode: dev\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\n ai-chat:\n enabled: false\n apiKey: \"？？？？\"\n apiHost: \"https://api.openai.com\"\n timeout: 60\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', '6798f061954635382277d6a7e2641a4b', '2010-05-05 00:00:00', '2024-06-11 16:26:59', NULL, '0:0:0:0:0:0:0:1', 'U', '', ''); INSERT INTO `his_config_info` VALUES (0, 62, 'application.yaml', 'DEFAULT_GROUP', '', 'spring:\r\n main:\r\n allow-circular-references: true # 允许循环依赖，因为项目是三层架构，无法避免这个情况。\r\n allow-bean-definition-overriding: true # 允许 Bean 覆盖，例如说 Feign 等会存在重复定义的服务\r\n\r\n # Servlet 配置\r\n servlet:\r\n # 文件上传相关配置项\r\n multipart:\r\n max-file-size: 16MB # 单个文件大小\r\n max-request-size: 32MB # 设置总上传的文件大小\r\n mvc:\r\n pathmatch:\r\n matching-strategy: ANT_PATH_MATCHER # 解决 SpringFox 与 SpringBoot 2.6.x 不兼容的问题，参见 SpringFoxHandlerProviderBeanPostProcessor 类\r\n\r\n # Jackson 配置项\r\n jackson:\r\n serialization:\r\n write-dates-as-timestamps: true # 设置 LocalDateTime 的格式，使用时间戳\r\n write-date-timestamps-as-nanoseconds: false # 设置不使用 nanoseconds 的格式。例如说 1611460870.401，而是直接 1611460870401\r\n write-durations-as-timestamps: true # 设置 Duration 的格式，使用时间戳\r\n fail-on-empty-beans: false # 允许序列化无属性的 Bean\r\n\r\n # Cache 配置项\r\n cache:\r\n type: REDIS\r\n redis:\r\n time-to-live: 1h # 设置过期时间为 1 小时\r\n\r\n--- #################### 接口文档配置 ####################\r\n\r\nspringdoc:\r\n api-docs:\r\n enabled: true # 1. 是否开启 Swagger 接文档的元数据\r\n path: /v3/api-docs\r\n swagger-ui:\r\n enabled: true # 2.1 是否开启 Swagger 文档的官方 UI 界面\r\n path: /swagger-ui.html\r\n default-flat-param-object: true # 参见 https://doc.xiaominfo.com/docs/faq/v4/knife4j-parameterobject-flat-param 文档\r\n\r\nknife4j:\r\n enable: true # 2.2 是否开启 Swagger 文档的 Knife4j UI 界面\r\n setting:\r\n language: zh_cn\r\n\r\n# MyBatis Plus 的配置项\r\nmybatis-plus:\r\n configuration:\r\n map-underscore-to-camel-case: true # 虽然默认为 true ，但是还是显示去指定下。\r\n global-config:\r\n db-config:\r\n id-type: NONE # “智能”模式，基于 IdTypeEnvironmentPostProcessor + 数据源的类型，自动适配成 AUTO、INPUT 模式。\r\n # id-type: AUTO # 自增 ID，适合 MySQL 等直接自增的数据库\r\n # id-type: INPUT # 用户输入 ID，适合 Oracle、PostgreSQL、Kingbase、DB2、H2 数据库\r\n # id-type: ASSIGN_ID # 分配 ID，默认使用雪花算法。注意，Oracle、PostgreSQL、Kingbase、DB2、H2 数据库时，需要去除实体类上的 @KeySequence 注解\r\n logic-delete-value: 1 # 逻辑已删除值(默认为 1)\r\n logic-not-delete-value: 0 # 逻辑未删除值(默认为 0)\r\n banner: false # 关闭控制台的 Banner 打印\r\n type-aliases-package: ${iailab.info.base-package}.dal.dataobject\r\n encryptor:\r\n password: XDV71a+xqStEA3WH # 加解密的秘钥，可使用 https://www.imaegoo.com/2020/aes-key-generator/ 网站生成\r\n\r\nmybatis-plus-join:\r\n banner: false # 关闭控制台的 Banner 打印\r\n\r\n# Spring Data Redis 配置\r\nspring:\r\n data:\r\n redis:\r\n repositories:\r\n enabled: false # 项目未使用到 Spring Data Redis 的 Repository，所以直接禁用，保证启动速度\r\n\r\n# VO 转换（数据翻译）相关\r\neasy-trans:\r\n is-enable-global: true # 启用全局翻译（拦截所有 SpringMVC ResponseBody 进行自动翻译 )。如果对于性能要求很高可关闭此配置，或通过 @IgnoreTrans 忽略某个接口\r\n is-enable-cloud: false # 禁用 TransType.RPC 微服务模式\r\n\r\n--- #################### RPC 远程调用相关配置 ####################\r\n\r\n--- #################### 消息队列相关 ####################\r\n\r\n# rocketmq 配置项，对应 RocketMQProperties 配置类\r\nrocketmq:\r\n # Producer 配置项\r\n producer:\r\n group: ${spring.application.name}_PRODUCER # 生产者分组\r\n\r\nspring:\r\n # Kafka 配置项，对应 KafkaProperties 配置类\r\n kafka:\r\n # Kafka Producer 配置项\r\n producer:\r\n acks: 1 # 0-不应答。1-leader 应答。all-所有 leader 和 follower 应答。\r\n retries: 3 # 发送失败时，重试发送的次数\r\n value-serializer: org.springframework.kafka.support.serializer.JsonSerializer # 消息的 value 的序列化\r\n # Kafka Consumer 配置项\r\n consumer:\r\n auto-offset-reset: earliest # 设置消费者分组最初的消费进度为 earliest 。可参考博客 https://blog.csdn.net/lishuangzhe7047/article/details/74530417 理解\r\n value-deserializer: org.springframework.kafka.support.serializer.JsonDeserializer\r\n properties:\r\n spring.json.trusted.packages: \'*\'\r\n # Kafka Consumer Listener 监听器配置\r\n listener:\r\n missing-topics-fatal: false # 消费监听接口监听的主题不存在时，默认会报错。所以通过设置为 false ，解决报错\r\n\r\n--- #################### 定时任务相关配置 ####################\r\n\r\nxxl:\r\n job:\r\n executor:\r\n appname: ${spring.application.name} # 执行器 AppName\r\n logpath: ${user.home}/logs/xxl-job/${spring.application.name} # 执行器运行日志文件存储磁盘路径\r\n accessToken: default_token # 执行器通讯TOKEN\r\n\r\n--- #################### 验证码相关配置 ####################\r\n\r\naj:\r\n captcha:\r\n jigsaw: classpath:images/jigsaw # 滑动验证，底图路径，不配置将使用默认图片；以 classpath: 开头，取 resource 目录下路径\r\n pic-click: classpath:images/pic-click # 滑动验证，底图路径，不配置将使用默认图片；以 classpath: 开头，取 resource 目录下路径\r\n cache-type: redis # 缓存 local/redis...\r\n cache-number: 1000 # local 缓存的阈值,达到这个值，清除缓存\r\n timing-clear: 180 # local定时清除过期缓存(单位秒),设置为0代表不执行\r\n type: blockPuzzle # 验证码类型 default两种都实例化。 blockPuzzle 滑块拼图 clickWord 文字点选\r\n water-mark: iailab # 右下角水印文字(我的水印)，可使用 https://tool.chinaz.com/tools/unicode.aspx 中文转 Unicode，Linux 可能需要转 unicode\r\n interference-options: 0 # 滑动干扰项(0/1/2)\r\n req-frequency-limit-enable: false # 接口请求次数一分钟限制是否开启 true|false\r\n req-get-lock-limit: 5 # 验证失败5次，get接口锁定\r\n req-get-lock-seconds: 10 # 验证失败后，锁定时间间隔\r\n req-get-minute-limit: 30 # get 接口一分钟内请求数限制\r\n req-check-minute-limit: 60 # check 接口一分钟内请求数限制\r\n req-verify-minute-limit: 60 # verify 接口一分钟内请求数限制\r\n\r\n--- #################### 平台相关配置 ####################\r\n\r\niailab:\r\n info:\r\n version: 1.0.0\r\n base-package: com.iailab.module.system\r\n web:\r\n admin-ui:\r\n url: http://dashboard.iailab.iocoder.cn # Admin 管理后台 UI 的地址\r\n swagger:\r\n title: 管理后台\r\n description: 提供管理员管理的所有功能\r\n version: ${iailab.info.version}\r\n base-package: ${iailab.info.base-package}\r\n captcha:\r\n enable: true # 验证码的开关，默认为 true；\r\n tenant: # 多租户相关配置项\r\n enable: true\r\n ignore-urls:\r\n - /admin-api/system/tenant/get-id-by-name # 基于名字获取租户，不许带租户编号\r\n - /admin-api/system/tenant/get-by-website # 基于域名获取租户，不许带租户编号\r\n - /admin-api/system/captcha/get-image # 获取图片验证码，和租户无关\r\n - /admin-api/system/captcha/get # 获取图片验证码，和租户无关\r\n - /admin-api/system/captcha/check # 校验图片验证码，和租户无关\r\n - /admin-api/system/sms/callback/* # 短信回调接口，无法带上租户编号\r\n - /rpc-api/system/tenant/valid # 防止递归。避免调用 /rpc-api/system/tenant/valid 接口时，又去触发 /rpc-api/system/tenant/valid 去校验\r\n - /rpc-api/system/tenant/id-list # 获得租户列表的时候，无需传递租户编号\r\n - /rpc-api/system/oauth2/token/check # 访问令牌校验时，无需传递租户编号；主要解决上传文件的场景，前端不会传递 tenant-id！\r\n ignore-tables:\r\n - system_tenant\r\n - system_tenant_package\r\n - system_dict_data\r\n - system_dict_type\r\n - system_error_code\r\n - system_menu\r\n - system_sms_channel\r\n - system_sms_template\r\n - system_sms_log\r\n - system_sensitive_word\r\n - system_oauth2_client\r\n - system_mail_account\r\n - system_mail_template\r\n - system_mail_log\r\n - system_notify_template\r\n sms-code: # 短信验证码相关的配置项\r\n expire-times: 10m\r\n send-frequency: 1m\r\n send-maximum-quantity-per-day: 10\r\n begin-code: 9999 # 这里配置 9999 的原因是，测试方便。\r\n end-code: 9999 # 这里配置 9999 的原因是，测试方便。\r\n\r\ndebug: false', '35f2867f44d5442ad723ea6ad4f70e1c', '2010-05-05 00:00:00', '2024-06-20 09:00:22', NULL, '0:0:0:0:0:0:0:1', 'I', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (0, 63, 'application-local.yaml', 'DEFAULT_GROUP', '', '--- #################### 数据库相关配置 ####################\r\nspring:\r\n # 数据源配置项\r\n autoconfigure:\r\n exclude:\r\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\r\n - de.codecentric.boot.admin.client.config.SpringBootAdminClientAutoConfiguration # 禁用 Spring Boot Admin 的 Client 的自动配置\r\n datasource:\r\n druid: # Druid 【监控】相关的全局配置\r\n web-stat-filter:\r\n enabled: true\r\n stat-view-servlet:\r\n enabled: true\r\n allow: # 设置白名单，不填则允许所有访问\r\n url-pattern: /druid/*\r\n login-username: # 控制台管理用户名和密码\r\n login-password:\r\n filter:\r\n stat:\r\n enabled: true\r\n log-slow-sql: true # 慢 SQL 记录\r\n slow-sql-millis: 100\r\n merge-sql: true\r\n wall:\r\n config:\r\n multi-statement-allow: true\r\n dynamic: # 多数据源配置\r\n druid: # Druid 【连接池】相关的全局配置\r\n initial-size: 1 # 初始连接数\r\n min-idle: 1 # 最小连接池数量\r\n max-active: 20 # 最大连接池数量\r\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\r\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\r\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\r\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\r\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\r\n test-while-idle: true\r\n test-on-borrow: false\r\n test-on-return: false\r\n primary: master\r\n datasource:\r\n master:\r\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\r\n # url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=true&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai # MySQL Connector/J 5.X 连接的示例\r\n # url: jdbc:postgresql://127.0.0.1:5432/ruoyi-vue-pro # PostgreSQL 连接的示例\r\n # url: jdbc:oracle:thin:@127.0.0.1:1521:xe # Oracle 连接的示例\r\n # url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ruoyi-vue-pro # SQLServer 连接的示例\r\n # url: jdbc:dm://10.211.55.4:5236?schema=RUOYI_VUE_PRO # DM 连接的示例\r\n username: root\r\n password: 123456\r\n # username: sa # SQL Server 连接的示例\r\n # password: JSm:g(*%lU4ZAkz06cd52KqT3)i1?H7W # SQL Server 连接的示例\r\n # username: SYSDBA # DM 连接的示例\r\n # password: SYSDBA # DM 连接的示例\r\n slave: # 模拟从库，可根据自己需要修改\r\n lazy: true # 开启懒加载，保证启动速度\r\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true\r\n username: root\r\n password: 123456\r\n\r\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\r\n redis:\r\n host: 127.0.0.1 # 地址\r\n port: 6379 # 端口\r\n database: 0 # 数据库索引\r\n #password: 123456 # 密码，建议生产环境开启\r\n\r\n--- #################### MQ 消息队列相关配置 ####################\r\n\r\n# rocketmq 配置项，对应 RocketMQProperties 配置类\r\nrocketmq:\r\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\r\n\r\nspring:\r\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\r\n rabbitmq:\r\n host: 127.0.0.1 # RabbitMQ 服务的地址\r\n port: 5672 # RabbitMQ 服务的端口\r\n username: guest # RabbitMQ 服务的账号\r\n password: guest # RabbitMQ 服务的密码\r\n # Kafka 配置项，对应 KafkaProperties 配置类\r\n kafka:\r\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\r\n\r\n--- #################### 定时任务相关配置 ####################\r\n\r\nxxl:\r\n job:\r\n enabled: false # 是否开启调度中心，默认为 true 开启\r\n admin:\r\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\r\n\r\n--- #################### 服务保障相关配置 ####################\r\n\r\n# Lock4j 配置项\r\nlock4j:\r\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\r\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\r\n\r\n--- #################### 监控相关配置 ####################\r\n\r\n# Actuator 监控端点的配置项\r\nmanagement:\r\n endpoints:\r\n web:\r\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\r\n exposure:\r\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\r\n\r\n# Spring Boot Admin 配置项\r\nspring:\r\n boot:\r\n admin:\r\n # Spring Boot Admin Client 客户端的相关配置\r\n client:\r\n instance:\r\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\r\n\r\n# 日志文件配置\r\nlogging:\r\n level:\r\n # 配置自己写的 MyBatis Mapper 打印日志\r\n com.iailab.module.system.dal.mysql: debug\r\n com.iailab.module.system.dal.mysql.sensitiveword.SensitiveWordMapper: INFO # 配置 SensitiveWordMapper 的日志级别为 info\r\n com.iailab.module.system.dal.mysql.sms.SmsChannelMapper: INFO # 配置 SmsChannelMapper 的日志级别为 info\r\n\r\n--- #################### 微信公众号、小程序相关配置 ####################\r\nwx:\r\n mp: # 公众号配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-mp-spring-boot-starter/README.md 文档\r\n # app-id: wx041349c6f39b268b # 测试号（牛希尧提供的）\r\n # secret: 5abee519483bc9f8cb37ce280e814bd0\r\n app-id: wx5b23ba7a5589ecbb # 测试号（自己的）\r\n secret: 2a7b3b20c537e52e74afd395eb85f61f\r\n # app-id: wxa69ab825b163be19 # 测试号（Kongdy 提供的）\r\n # secret: bd4f9fab889591b62aeac0d7b8d8b4a0\r\n # 存储配置，解决 AccessToken 的跨节点的共享\r\n config-storage:\r\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\r\n key-prefix: wx # Redis Key 的前缀\r\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\r\n miniapp: # 小程序配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-miniapp-spring-boot-starter/README.md 文档\r\n # appid: wx62056c0d5e8db250 # 测试号（牛希尧提供的）\r\n # secret: 333ae72f41552af1e998fe1f54e1584a\r\n appid: wx63c280fe3248a3e7 # wenhualian的接口测试号\r\n secret: 6f270509224a7ae1296bbf1c8cb97aed\r\n # appid: wxc4598c446f8a9cb3 # 测试号（Kongdy 提供的）\r\n # secret: 4a1a04e07f6a4a0751b39c3064a92c8b\r\n config-storage:\r\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\r\n key-prefix: wa # Redis Key 的前缀\r\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\r\n\r\n--- #################### 平台相关配置 ####################\r\n\r\n# 平台配置项，设置当前项目所有自定义的配置\r\niailab:\r\n env: # 多环境的配置项\r\n tag: ${HOSTNAME}\r\n captcha:\r\n enable: false # 本地环境，暂时关闭图片验证码，方便登录等接口的测试\r\n security:\r\n mock-enable: true\r\n xss:\r\n enable: false\r\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\r\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\r\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\r\n pay:\r\n pay-notify-url: http://niubi.natapp1.cc/api/pay/order/notify\r\n pay-return-url: http://niubi.natapp1.cc/api/pay/order/return\r\n refund-notify-url: http://niubi.natapp1.cc/api/pay/refund/notify\r\n access-log: # 访问日志的配置项\r\n enable: false\r\n demo: false # 关闭演示模式\r\n\r\njustauth:\r\n enabled: true\r\n type:\r\n DINGTALK: # 钉钉\r\n client-id: dingvrnreaje3yqvzhxg\r\n client-secret: i8E6iZyDvZj51JIb0tYsYfVQYOks9Cq1lgryEjFRqC79P3iJcrxEwT6Qk2QvLrLI\r\n ignore-check-redirect-uri: true\r\n WECHAT_ENTERPRISE: # 企业微信\r\n client-id: wwd411c69a39ad2e54\r\n client-secret: 1wTb7hYxnpT2TUbIeHGXGo7T0odav1ic10mLdyyATOw\r\n agent-id: 1000004\r\n ignore-check-redirect-uri: true\r\n # noinspection SpringBootApplicationYaml\r\n WECHAT_MINI_APP: # 微信小程序\r\n client-id: ${wx.miniapp.appid}\r\n client-secret: ${wx.miniapp.secret}\r\n ignore-check-redirect-uri: true\r\n ignore-check-state: true # 微信小程序，不会使用到 state，所以不进行校验\r\n WECHAT_MP: # 微信公众号\r\n client-id: ${wx.mp.app-id}\r\n client-secret: ${wx.mp.secret}\r\n ignore-check-redirect-uri: true\r\n cache:\r\n type: REDIS\r\n prefix: \'social_auth_state:\' # 缓存前缀，目前只对 Redis 缓存生效，默认 JUSTAUTH::STATE::\r\n timeout: 24h # 超时时长，目前只对 Redis 缓存生效，默认 3 分钟\r\n', 'efd6e4e7c21f4511a0af2f8e2be17ad4', '2010-05-05 00:00:00', '2024-06-20 09:00:59', NULL, '0:0:0:0:0:0:0:1', 'I', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (0, 64, 'bootstrap.yaml', 'DEFAULT_GROUP', '', 'spring:\r\n application:\r\n name: system-server\r\n\r\n profiles:\r\n active: local\r\n\r\nserver:\r\n port: 48081\r\n\r\n# 日志文件配置。注意，如果 logging.file.name 不放在 bootstrap.yaml 配置文件，而是放在 application.yaml 中，会导致出现 LOG_FILE_IS_UNDEFINED 文件\r\nlogging:\r\n file:\r\n name: ${user.home}/logs/${spring.application.name}.log # 日志文件名，全路径\r\n', 'b3e314a9256c0f228682135358701901', '2010-05-05 00:00:00', '2024-06-20 09:11:35', NULL, '0:0:0:0:0:0:0:1', 'I', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (0, 65, 'bootstrap-local.yaml', 'DEFAULT_GROUP', '', '--- #################### 注册中心相关配置 ####################\r\n\r\nspring:\r\n cloud:\r\n nacos:\r\n server-addr: @nacos.server@\r\n discovery:\r\n namespace: @nacos.namespace@ # 命名空间。这里使用 dev 开发环境\r\n metadata:\r\n version: 1.0.0 # 服务实例的版本号，可用于灰度发布\r\n\r\n--- #################### 配置中心相关配置 ####################\r\n\r\nspring:\r\n cloud:\r\n nacos:\r\n # Nacos Config 配置项，对应 NacosConfigProperties 配置属性类\r\n config:\r\n server-addr: @nacos.server@ # Nacos 服务器地址\r\n namespace: @nacos.namespace@ # 命名空间 dev 的ID，不能直接使用 dev 名称。创建命名空间的时候需要指定ID为 dev，这里使用 dev 开发环境\r\n group: DEFAULT_GROUP # 使用的 Nacos 配置分组，默认为 DEFAULT_GROUP\r\n name: ${spring.application.name} # 使用的 Nacos 配置集的 dataId，默认为 spring.application.name\r\n file-extension: yaml # 使用的 Nacos 配置集的 dataId 的文件拓展名，同时也是 Nacos 配置集的配置格式，默认为 properties\r\n', '2ab4eecc9e3ac290d518d54dd7a12656', '2010-05-05 00:00:00', '2024-06-20 09:11:55', NULL, '0:0:0:0:0:0:0:1', 'I', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (1, 66, 'jeecg-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n wall:\n selectWhereAlwayTrueCheck: false\n stat:\n merge-sql: true\n slow-sql-millis: 5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: root\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\n flyway:\n enabled: false\n encoding: UTF-8\n locations: classpath:flyway/sql/mysql\n sql-migration-prefix: V\n sql-migration-separator: __\n placeholder-prefix: \'#(\'\n placeholder-suffix: )\n sql-migration-suffixes: .sql\n validate-on-migrate: true\n baseline-on-migrate: true\n clean-disabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n firewall:\n dataSourceSafe: false\n lowCodeMode: dev\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys,/sys/sendChangePwdSms,/sys/user/sendChangePhoneSms,/sys/sms,/desform/api/sendVerifyCode\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n saasMode:\n firewall:\n dataSourceSafe: false\n lowCodeMode: dev\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\n ai-chat:\n enabled: false\n apiKey: \"？？？？\"\n apiHost: \"https://api.openai.com\"\n timeout: 60\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', '703b0207484e9ae01c54469bdd1b200b', '2010-05-05 00:00:00', '2024-06-20 09:21:34', NULL, '0:0:0:0:0:0:0:1', 'D', '', ''); INSERT INTO `his_config_info` VALUES (2, 67, 'jeecg.yaml', 'DEFAULT_GROUP', '', 'server:\n tomcat:\n max-swallow-size: -1\n error:\n include-exception: true\n include-stacktrace: ALWAYS\n include-message: ALWAYS\n compression:\n enabled: true\n min-response-size: 1024\n mime-types: application/javascript,application/json,application/xml,text/html,text/xml,text/plain,text/css,image/*\nmanagement:\n health:\n mail:\n enabled: false\n endpoints:\n web:\n exposure:\n include: \"*\"\n health:\n sensitive: true\n endpoint:\n health:\n show-details: ALWAYS\nspring:\n servlet:\n multipart:\n max-file-size: 10MB\n max-request-size: 10MB\n mail:\n host: smtp.163.com\n username: jeecgos@163.com\n password: ??\n properties:\n mail:\n smtp:\n auth: true\n starttls:\n enable: true\n required: true\n quartz:\n job-store-type: jdbc\n initialize-schema: embedded\n auto-startup: false\n startup-delay: 1s\n overwrite-existing-jobs: true\n properties:\n org:\n quartz:\n scheduler:\n instanceName: MyScheduler\n instanceId: AUTO\n jobStore:\n class: org.springframework.scheduling.quartz.LocalDataSourceJobStore\n driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate\n tablePrefix: QRTZ_\n isClustered: true\n misfireThreshold: 12000\n clusterCheckinInterval: 15000\n threadPool:\n class: org.quartz.simpl.SimpleThreadPool\n threadCount: 10\n threadPriority: 5\n threadsInheritContextClassLoaderOfInitializingThread: true\n jackson:\n date-format: yyyy-MM-dd HH:mm:ss\n time-zone: GMT+8\n aop:\n proxy-target-class: true\n activiti:\n check-process-definitions: false\n async-executor-activate: false\n job-executor-activate: false\n jpa:\n open-in-view: false\n freemarker:\n suffix: .ftl\n content-type: text/html\n charset: UTF-8\n cache: false\n prefer-file-system-access: false\n template-loader-path:\n - classpath:/templates\n mvc:\n static-path-pattern: /**\n pathmatch:\n matching-strategy: ant_path_matcher\n resource:\n static-locations: classpath:/static/,classpath:/public/\n autoconfigure:\n exclude:\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n - org.springframework.boot.autoconfigure.flyway.FlywayAutoConfiguration\nmybatis-plus:\n mapper-locations: classpath*:org/jeecg/**/xml/*Mapper.xml\n global-config:\n banner: false\n db-config:\n id-type: ASSIGN_ID\n table-underline: true\n configuration:\n call-setters-on-nulls: true', '94dbdad61f7e2e3ace5a4fc07bb8c2a2', '2010-05-05 00:00:00', '2024-06-20 09:21:34', NULL, '0:0:0:0:0:0:0:1', 'D', '', ''); INSERT INTO `his_config_info` VALUES (3, 68, 'jeecg-gateway-router.json', 'DEFAULT_GROUP', '', '[{\n \"id\": \"jeecg-system\",\n \"order\": 0,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/sys/**\",\n \"_genkey_1\": \"/jmreport/**\",\n \"_genkey_3\": \"/online/**\",\n \"_genkey_4\": \"/generic/**\",\n \"_genkey_5\": \"/drag/**\",\n \"_genkey_6\": \"/actuator/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb://jeecg-system\"\n}, {\n \"id\": \"jeecg-demo\",\n \"order\": 1,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/mock/**\",\n \"_genkey_1\": \"/test/**\",\n \"_genkey_2\": \"/bigscreen/template1/**\",\n \"_genkey_3\": \"/bigscreen/template2/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb://jeecg-demo\"\n}, {\n \"id\": \"jeecg-system-websocket\",\n \"order\": 2,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/websocket/**\",\n \"_genkey_1\": \"/newsWebsocket/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb:ws://jeecg-system\"\n}, {\n \"id\": \"jeecg-demo-websocket\",\n \"order\": 3,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/vxeSocket/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb:ws://jeecg-demo\"\n}]', '708c0948118bdb96bdfaa87200a14432', '2010-05-05 00:00:00', '2024-06-20 09:21:34', NULL, '0:0:0:0:0:0:0:1', 'D', '', ''); INSERT INTO `his_config_info` VALUES (11, 69, 'jeecg-sharding.yaml', 'DEFAULT_GROUP', '', 'spring:\n shardingsphere:\n datasource:\n names: ds0\n ds0:\n driverClassName: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai\n username: root\n password: root\n type: com.alibaba.druid.pool.DruidDataSource\n props:\n sql-show: true\n rules:\n sharding:\n binding-tables: sys_log\n key-generators:\n snowflake:\n type: SNOWFLAKE\n props:\n worker-id: 123\n sharding-algorithms:\n table-classbased:\n props:\n strategy: standard\n algorithmClassName: org.jeecg.modules.test.sharding.algorithm.StandardModTableShardAlgorithm\n type: CLASS_BASED\n tables:\n sys_log:\n actual-data-nodes: ds0.sys_log$->{0..1}\n table-strategy:\n standard:\n sharding-algorithm-name: table-classbased\n sharding-column: log_type', 'a93fa455c32cd37ca84631d2bbe13005', '2010-05-05 00:00:00', '2024-06-20 09:21:34', NULL, '0:0:0:0:0:0:0:1', 'D', '', ''); INSERT INTO `his_config_info` VALUES (20, 70, 'jeecg-gateway-dev.yaml', 'DEFAULT_GROUP', '', 'jeecg:\n route:\n config:\n #type:database nacos yml\n data-type: database\n data-id: jeecg-gateway-router\nspring:\n redis:\n database: 0\n host: jeecg-boot-redis\n port: 6379\n password:\nknife4j:\n production: false', '98e211c54b43a73f7189d92f1c77f815', '2010-05-05 00:00:00', '2024-06-20 09:21:34', NULL, '0:0:0:0:0:0:0:1', 'D', '', ''); INSERT INTO `his_config_info` VALUES (22, 71, 'jeecg-sharding-multi.yaml', 'DEFAULT_GROUP', '', 'spring:\n shardingsphere:\n datasource:\n names: ds0,ds1\n ds0:\n driverClassName: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai\n type: com.alibaba.druid.pool.DruidDataSource\n username: root\n password: root\n ds1:\n driverClassName: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot2?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai\n type: com.alibaba.druid.pool.DruidDataSource\n username: root\n password: root\n props:\n sql-show: true\n rules:\n replica-query:\n load-balancers:\n round-robin:\n type: ROUND_ROBIN\n props:\n default: 0\n data-sources:\n prds:\n primary-data-source-name: ds0\n replica-data-source-names: ds1\n load-balancer-name: round_robin\n sharding:\n binding-tables:\n - sys_log\n key-generators:\n snowflake:\n type: SNOWFLAKE\n props:\n worker-id: 123\n sharding-algorithms:\n table-classbased:\n props:\n strategy: standard\n algorithmClassName: org.jeecg.modules.test.sharding.algorithm.StandardModTableShardAlgorithm\n type: CLASS_BASED\n database-inline:\n type: INLINE\n props:\n algorithm-expression: ds$->{operate_type % 2}\n tables:\n sys_log:\n actual-data-nodes: ds$->{0..1}.sys_log$->{0..1}\n database-strategy:\n standard:\n sharding-column: operate_type\n sharding-algorithm-name: database-inline\n table-strategy:\n standard:\n sharding-algorithm-name: table-classbased\n sharding-column: log_type', '0fc2b030ca8c0008f148c84ecbd2a8c7', '2010-05-05 00:00:00', '2024-06-20 09:21:34', NULL, '0:0:0:0:0:0:0:1', 'D', '', ''); INSERT INTO `his_config_info` VALUES (56, 72, 'application-local.yaml', 'DEFAULT_GROUP', '', '--- #################### 数据库相关配置 ####################\r\nspring:\r\n # 数据源配置项\r\n autoconfigure:\r\n exclude:\r\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\r\n - de.codecentric.boot.admin.client.config.SpringBootAdminClientAutoConfiguration # 禁用 Spring Boot Admin 的 Client 的自动配置\r\n datasource:\r\n druid: # Druid 【监控】相关的全局配置\r\n web-stat-filter:\r\n enabled: true\r\n stat-view-servlet:\r\n enabled: true\r\n allow: # 设置白名单，不填则允许所有访问\r\n url-pattern: /druid/*\r\n login-username: # 控制台管理用户名和密码\r\n login-password:\r\n filter:\r\n stat:\r\n enabled: true\r\n log-slow-sql: true # 慢 SQL 记录\r\n slow-sql-millis: 100\r\n merge-sql: true\r\n wall:\r\n config:\r\n multi-statement-allow: true\r\n dynamic: # 多数据源配置\r\n druid: # Druid 【连接池】相关的全局配置\r\n initial-size: 1 # 初始连接数\r\n min-idle: 1 # 最小连接池数量\r\n max-active: 20 # 最大连接池数量\r\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\r\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\r\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\r\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\r\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\r\n test-while-idle: true\r\n test-on-borrow: false\r\n test-on-return: false\r\n primary: master\r\n datasource:\r\n master:\r\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\r\n # url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=true&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai # MySQL Connector/J 5.X 连接的示例\r\n # url: jdbc:postgresql://127.0.0.1:5432/ruoyi-vue-pro # PostgreSQL 连接的示例\r\n # url: jdbc:oracle:thin:@127.0.0.1:1521:xe # Oracle 连接的示例\r\n # url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ruoyi-vue-pro # SQLServer 连接的示例\r\n # url: jdbc:dm://10.211.55.4:5236?schema=RUOYI_VUE_PRO # DM 连接的示例\r\n username: root\r\n password: 123456\r\n # username: sa # SQL Server 连接的示例\r\n # password: JSm:g(*%lU4ZAkz06cd52KqT3)i1?H7W # SQL Server 连接的示例\r\n # username: SYSDBA # DM 连接的示例\r\n # password: SYSDBA # DM 连接的示例\r\n slave: # 模拟从库，可根据自己需要修改\r\n lazy: true # 开启懒加载，保证启动速度\r\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true\r\n username: root\r\n password: 123456\r\n\r\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\r\n redis:\r\n host: 127.0.0.1 # 地址\r\n port: 6379 # 端口\r\n database: 0 # 数据库索引\r\n #password: 123456 # 密码，建议生产环境开启\r\n\r\n--- #################### MQ 消息队列相关配置 ####################\r\n\r\n# rocketmq 配置项，对应 RocketMQProperties 配置类\r\nrocketmq:\r\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\r\n\r\nspring:\r\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\r\n rabbitmq:\r\n host: 127.0.0.1 # RabbitMQ 服务的地址\r\n port: 5672 # RabbitMQ 服务的端口\r\n username: guest # RabbitMQ 服务的账号\r\n password: guest # RabbitMQ 服务的密码\r\n # Kafka 配置项，对应 KafkaProperties 配置类\r\n kafka:\r\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\r\n\r\n--- #################### 定时任务相关配置 ####################\r\n\r\nxxl:\r\n job:\r\n enabled: false # 是否开启调度中心，默认为 true 开启\r\n admin:\r\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\r\n\r\n--- #################### 服务保障相关配置 ####################\r\n\r\n# Lock4j 配置项\r\nlock4j:\r\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\r\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\r\n\r\n--- #################### 监控相关配置 ####################\r\n\r\n# Actuator 监控端点的配置项\r\nmanagement:\r\n endpoints:\r\n web:\r\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\r\n exposure:\r\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\r\n\r\n# Spring Boot Admin 配置项\r\nspring:\r\n boot:\r\n admin:\r\n # Spring Boot Admin Client 客户端的相关配置\r\n client:\r\n instance:\r\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\r\n\r\n# 日志文件配置\r\nlogging:\r\n level:\r\n # 配置自己写的 MyBatis Mapper 打印日志\r\n com.iailab.module.system.dal.mysql: debug\r\n com.iailab.module.system.dal.mysql.sensitiveword.SensitiveWordMapper: INFO # 配置 SensitiveWordMapper 的日志级别为 info\r\n com.iailab.module.system.dal.mysql.sms.SmsChannelMapper: INFO # 配置 SmsChannelMapper 的日志级别为 info\r\n\r\n--- #################### 微信公众号、小程序相关配置 ####################\r\nwx:\r\n mp: # 公众号配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-mp-spring-boot-starter/README.md 文档\r\n # app-id: wx041349c6f39b268b # 测试号（牛希尧提供的）\r\n # secret: 5abee519483bc9f8cb37ce280e814bd0\r\n app-id: wx5b23ba7a5589ecbb # 测试号（自己的）\r\n secret: 2a7b3b20c537e52e74afd395eb85f61f\r\n # app-id: wxa69ab825b163be19 # 测试号（Kongdy 提供的）\r\n # secret: bd4f9fab889591b62aeac0d7b8d8b4a0\r\n # 存储配置，解决 AccessToken 的跨节点的共享\r\n config-storage:\r\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\r\n key-prefix: wx # Redis Key 的前缀\r\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\r\n miniapp: # 小程序配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-miniapp-spring-boot-starter/README.md 文档\r\n # appid: wx62056c0d5e8db250 # 测试号（牛希尧提供的）\r\n # secret: 333ae72f41552af1e998fe1f54e1584a\r\n appid: wx63c280fe3248a3e7 # wenhualian的接口测试号\r\n secret: 6f270509224a7ae1296bbf1c8cb97aed\r\n # appid: wxc4598c446f8a9cb3 # 测试号（Kongdy 提供的）\r\n # secret: 4a1a04e07f6a4a0751b39c3064a92c8b\r\n config-storage:\r\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\r\n key-prefix: wa # Redis Key 的前缀\r\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\r\n\r\n--- #################### 平台相关配置 ####################\r\n\r\n# 平台配置项，设置当前项目所有自定义的配置\r\niailab:\r\n env: # 多环境的配置项\r\n tag: ${HOSTNAME}\r\n captcha:\r\n enable: false # 本地环境，暂时关闭图片验证码，方便登录等接口的测试\r\n security:\r\n mock-enable: true\r\n xss:\r\n enable: false\r\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\r\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\r\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\r\n pay:\r\n pay-notify-url: http://niubi.natapp1.cc/api/pay/order/notify\r\n pay-return-url: http://niubi.natapp1.cc/api/pay/order/return\r\n refund-notify-url: http://niubi.natapp1.cc/api/pay/refund/notify\r\n access-log: # 访问日志的配置项\r\n enable: false\r\n demo: false # 关闭演示模式\r\n\r\njustauth:\r\n enabled: true\r\n type:\r\n DINGTALK: # 钉钉\r\n client-id: dingvrnreaje3yqvzhxg\r\n client-secret: i8E6iZyDvZj51JIb0tYsYfVQYOks9Cq1lgryEjFRqC79P3iJcrxEwT6Qk2QvLrLI\r\n ignore-check-redirect-uri: true\r\n WECHAT_ENTERPRISE: # 企业微信\r\n client-id: wwd411c69a39ad2e54\r\n client-secret: 1wTb7hYxnpT2TUbIeHGXGo7T0odav1ic10mLdyyATOw\r\n agent-id: 1000004\r\n ignore-check-redirect-uri: true\r\n # noinspection SpringBootApplicationYaml\r\n WECHAT_MINI_APP: # 微信小程序\r\n client-id: ${wx.miniapp.appid}\r\n client-secret: ${wx.miniapp.secret}\r\n ignore-check-redirect-uri: true\r\n ignore-check-state: true # 微信小程序，不会使用到 state，所以不进行校验\r\n WECHAT_MP: # 微信公众号\r\n client-id: ${wx.mp.app-id}\r\n client-secret: ${wx.mp.secret}\r\n ignore-check-redirect-uri: true\r\n cache:\r\n type: REDIS\r\n prefix: \'social_auth_state:\' # 缓存前缀，目前只对 Redis 缓存生效，默认 JUSTAUTH::STATE::\r\n timeout: 24h # 超时时长，目前只对 Redis 缓存生效，默认 3 分钟\r\n', 'efd6e4e7c21f4511a0af2f8e2be17ad4', '2010-05-05 00:00:00', '2024-06-20 09:28:42', 'nacos', '0:0:0:0:0:0:0:1', 'U', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (56, 73, 'application-local.yaml', 'DEFAULT_GROUP', '', '--- #################### 数据库相关配置 ####################\nspring:\n # 数据源配置项\n autoconfigure:\n exclude:\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\n - de.codecentric.boot.admin.client.config.SpringBootAdminClientAutoConfiguration # 禁用 Spring Boot Admin 的 Client 的自动配置\n datasource:\n druid: # Druid 【监控】相关的全局配置\n web-stat-filter:\n enabled: true\n stat-view-servlet:\n enabled: true\n allow: # 设置白名单，不填则允许所有访问\n url-pattern: /druid/*\n login-username: # 控制台管理用户名和密码\n login-password:\n filter:\n stat:\n enabled: true\n log-slow-sql: true # 慢 SQL 记录\n slow-sql-millis: 100\n merge-sql: true\n wall:\n config:\n multi-statement-allow: true\n dynamic: # 多数据源配置\n druid: # Druid 【连接池】相关的全局配置\n initial-size: 1 # 初始连接数\n min-idle: 1 # 最小连接池数量\n max-active: 20 # 最大连接池数量\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\n test-while-idle: true\n test-on-borrow: false\n test-on-return: false\n primary: master\n datasource:\n master:\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\n # url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=true&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai # MySQL Connector/J 5.X 连接的示例\n # url: jdbc:postgresql://127.0.0.1:5432/ruoyi-vue-pro # PostgreSQL 连接的示例\n # url: jdbc:oracle:thin:@127.0.0.1:1521:xe # Oracle 连接的示例\n # url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ruoyi-vue-pro # SQLServer 连接的示例\n # url: jdbc:dm://10.211.55.4:5236?schema=RUOYI_VUE_PRO # DM 连接的示例\n username: root\n password: 123456\n # username: sa # SQL Server 连接的示例\n # password: JSm:g(*%lU4ZAkz06cd52KqT3)i1?H7W # SQL Server 连接的示例\n # username: SYSDBA # DM 连接的示例\n # password: SYSDBA # DM 连接的示例\n slave: # 模拟从库，可根据自己需要修改\n lazy: true # 开启懒加载，保证启动速度\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true\n username: root\n password: 123456\n\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\n redis:\n host: 127.0.0.1 # 地址\n port: 6379 # 端口\n database: 0 # 数据库索引\n password: 123456 # 密码，建议生产环境开启\n\n--- #################### MQ 消息队列相关配置 ####################\n\n# rocketmq 配置项，对应 RocketMQProperties 配置类\nrocketmq:\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\n\nspring:\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\n rabbitmq:\n host: 127.0.0.1 # RabbitMQ 服务的地址\n port: 5672 # RabbitMQ 服务的端口\n username: guest # RabbitMQ 服务的账号\n password: guest # RabbitMQ 服务的密码\n # Kafka 配置项，对应 KafkaProperties 配置类\n kafka:\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\n\n--- #################### 定时任务相关配置 ####################\n\nxxl:\n job:\n enabled: false # 是否开启调度中心，默认为 true 开启\n admin:\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\n\n--- #################### 服务保障相关配置 ####################\n\n# Lock4j 配置项\nlock4j:\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\n\n--- #################### 监控相关配置 ####################\n\n# Actuator 监控端点的配置项\nmanagement:\n endpoints:\n web:\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\n exposure:\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\n\n# Spring Boot Admin 配置项\nspring:\n boot:\n admin:\n # Spring Boot Admin Client 客户端的相关配置\n client:\n instance:\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\n\n# 日志文件配置\nlogging:\n level:\n # 配置自己写的 MyBatis Mapper 打印日志\n com.iailab.module.system.dal.mysql: debug\n com.iailab.module.system.dal.mysql.sensitiveword.SensitiveWordMapper: INFO # 配置 SensitiveWordMapper 的日志级别为 info\n com.iailab.module.system.dal.mysql.sms.SmsChannelMapper: INFO # 配置 SmsChannelMapper 的日志级别为 info\n\n--- #################### 微信公众号、小程序相关配置 ####################\nwx:\n mp: # 公众号配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-mp-spring-boot-starter/README.md 文档\n # app-id: wx041349c6f39b268b # 测试号（牛希尧提供的）\n # secret: 5abee519483bc9f8cb37ce280e814bd0\n app-id: wx5b23ba7a5589ecbb # 测试号（自己的）\n secret: 2a7b3b20c537e52e74afd395eb85f61f\n # app-id: wxa69ab825b163be19 # 测试号（Kongdy 提供的）\n # secret: bd4f9fab889591b62aeac0d7b8d8b4a0\n # 存储配置，解决 AccessToken 的跨节点的共享\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wx # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n miniapp: # 小程序配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-miniapp-spring-boot-starter/README.md 文档\n # appid: wx62056c0d5e8db250 # 测试号（牛希尧提供的）\n # secret: 333ae72f41552af1e998fe1f54e1584a\n appid: wx63c280fe3248a3e7 # wenhualian的接口测试号\n secret: 6f270509224a7ae1296bbf1c8cb97aed\n # appid: wxc4598c446f8a9cb3 # 测试号（Kongdy 提供的）\n # secret: 4a1a04e07f6a4a0751b39c3064a92c8b\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wa # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n\n--- #################### 平台相关配置 ####################\n\n# 平台配置项，设置当前项目所有自定义的配置\niailab:\n env: # 多环境的配置项\n tag: ${HOSTNAME}\n captcha:\n enable: false # 本地环境，暂时关闭图片验证码，方便登录等接口的测试\n security:\n mock-enable: true\n xss:\n enable: false\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\n pay:\n pay-notify-url: http://niubi.natapp1.cc/api/pay/order/notify\n pay-return-url: http://niubi.natapp1.cc/api/pay/order/return\n refund-notify-url: http://niubi.natapp1.cc/api/pay/refund/notify\n access-log: # 访问日志的配置项\n enable: false\n demo: false # 关闭演示模式\n\njustauth:\n enabled: true\n type:\n DINGTALK: # 钉钉\n client-id: dingvrnreaje3yqvzhxg\n client-secret: i8E6iZyDvZj51JIb0tYsYfVQYOks9Cq1lgryEjFRqC79P3iJcrxEwT6Qk2QvLrLI\n ignore-check-redirect-uri: true\n WECHAT_ENTERPRISE: # 企业微信\n client-id: wwd411c69a39ad2e54\n client-secret: 1wTb7hYxnpT2TUbIeHGXGo7T0odav1ic10mLdyyATOw\n agent-id: 1000004\n ignore-check-redirect-uri: true\n # noinspection SpringBootApplicationYaml\n WECHAT_MINI_APP: # 微信小程序\n client-id: ${wx.miniapp.appid}\n client-secret: ${wx.miniapp.secret}\n ignore-check-redirect-uri: true\n ignore-check-state: true # 微信小程序，不会使用到 state，所以不进行校验\n WECHAT_MP: # 微信公众号\n client-id: ${wx.mp.app-id}\n client-secret: ${wx.mp.secret}\n ignore-check-redirect-uri: true\n cache:\n type: REDIS\n prefix: \'social_auth_state:\' # 缓存前缀，目前只对 Redis 缓存生效，默认 JUSTAUTH::STATE::\n timeout: 24h # 超时时长，目前只对 Redis 缓存生效，默认 3 分钟\n', 'da92b9ca7535bdf132e0db630e601d7f', '2010-05-05 00:00:00', '2024-06-20 09:30:50', 'nacos', '0:0:0:0:0:0:0:1', 'U', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (56, 74, 'application-local.yaml', 'DEFAULT_GROUP', 'infra-server', '--- #################### 数据库相关配置 ####################\nspring:\n # 数据源配置项\n autoconfigure:\n exclude:\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\n - de.codecentric.boot.admin.client.config.SpringBootAdminClientAutoConfiguration # 禁用 Spring Boot Admin 的 Client 的自动配置\n datasource:\n druid: # Druid 【监控】相关的全局配置\n web-stat-filter:\n enabled: true\n stat-view-servlet:\n enabled: true\n allow: # 设置白名单，不填则允许所有访问\n url-pattern: /druid/*\n login-username: # 控制台管理用户名和密码\n login-password:\n filter:\n stat:\n enabled: true\n log-slow-sql: true # 慢 SQL 记录\n slow-sql-millis: 100\n merge-sql: true\n wall:\n config:\n multi-statement-allow: true\n dynamic: # 多数据源配置\n druid: # Druid 【连接池】相关的全局配置\n initial-size: 1 # 初始连接数\n min-idle: 1 # 最小连接池数量\n max-active: 20 # 最大连接池数量\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\n test-while-idle: true\n test-on-borrow: false\n test-on-return: false\n primary: master\n datasource:\n master:\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\n # url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=true&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai # MySQL Connector/J 5.X 连接的示例\n # url: jdbc:postgresql://127.0.0.1:5432/ruoyi-vue-pro # PostgreSQL 连接的示例\n # url: jdbc:oracle:thin:@127.0.0.1:1521:xe # Oracle 连接的示例\n # url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ruoyi-vue-pro # SQLServer 连接的示例\n # url: jdbc:dm://10.211.55.4:5236?schema=RUOYI_VUE_PRO # DM 连接的示例\n username: root\n password: 123456\n # username: sa # SQL Server 连接的示例\n # password: JSm:g(*%lU4ZAkz06cd52KqT3)i1?H7W # SQL Server 连接的示例\n # username: SYSDBA # DM 连接的示例\n # password: SYSDBA # DM 连接的示例\n slave: # 模拟从库，可根据自己需要修改\n lazy: true # 开启懒加载，保证启动速度\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true\n username: root\n password: 123456\n\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\n redis:\n host: 127.0.0.1 # 地址\n port: 6379 # 端口\n database: 0 # 数据库索引\n password: 123456 # 密码，建议生产环境开启\n\n--- #################### MQ 消息队列相关配置 ####################\n\n# rocketmq 配置项，对应 RocketMQProperties 配置类\nrocketmq:\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\n\nspring:\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\n rabbitmq:\n host: 127.0.0.1 # RabbitMQ 服务的地址\n port: 5672 # RabbitMQ 服务的端口\n username: guest # RabbitMQ 服务的账号\n password: guest # RabbitMQ 服务的密码\n # Kafka 配置项，对应 KafkaProperties 配置类\n kafka:\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\n\n--- #################### 定时任务相关配置 ####################\n\nxxl:\n job:\n enabled: false # 是否开启调度中心，默认为 true 开启\n admin:\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\n\n--- #################### 服务保障相关配置 ####################\n\n# Lock4j 配置项\nlock4j:\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\n\n--- #################### 监控相关配置 ####################\n\n# Actuator 监控端点的配置项\nmanagement:\n endpoints:\n web:\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\n exposure:\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\n\n# Spring Boot Admin 配置项\nspring:\n boot:\n admin:\n # Spring Boot Admin Client 客户端的相关配置\n client:\n instance:\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\n\n# 日志文件配置\nlogging:\n level:\n # 配置自己写的 MyBatis Mapper 打印日志\n com.iailab.module.system.dal.mysql: debug\n com.iailab.module.system.dal.mysql.sensitiveword.SensitiveWordMapper: INFO # 配置 SensitiveWordMapper 的日志级别为 info\n com.iailab.module.system.dal.mysql.sms.SmsChannelMapper: INFO # 配置 SmsChannelMapper 的日志级别为 info\n\n--- #################### 微信公众号、小程序相关配置 ####################\nwx:\n mp: # 公众号配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-mp-spring-boot-starter/README.md 文档\n # app-id: wx041349c6f39b268b # 测试号（牛希尧提供的）\n # secret: 5abee519483bc9f8cb37ce280e814bd0\n app-id: wx5b23ba7a5589ecbb # 测试号（自己的）\n secret: 2a7b3b20c537e52e74afd395eb85f61f\n # app-id: wxa69ab825b163be19 # 测试号（Kongdy 提供的）\n # secret: bd4f9fab889591b62aeac0d7b8d8b4a0\n # 存储配置，解决 AccessToken 的跨节点的共享\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wx # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n miniapp: # 小程序配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-miniapp-spring-boot-starter/README.md 文档\n # appid: wx62056c0d5e8db250 # 测试号（牛希尧提供的）\n # secret: 333ae72f41552af1e998fe1f54e1584a\n appid: wx63c280fe3248a3e7 # wenhualian的接口测试号\n secret: 6f270509224a7ae1296bbf1c8cb97aed\n # appid: wxc4598c446f8a9cb3 # 测试号（Kongdy 提供的）\n # secret: 4a1a04e07f6a4a0751b39c3064a92c8b\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wa # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n\n--- #################### 平台相关配置 ####################\n\n# 平台配置项，设置当前项目所有自定义的配置\niailab:\n env: # 多环境的配置项\n tag: ${HOSTNAME}\n captcha:\n enable: false # 本地环境，暂时关闭图片验证码，方便登录等接口的测试\n security:\n mock-enable: true\n xss:\n enable: false\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\n pay:\n pay-notify-url: http://niubi.natapp1.cc/api/pay/order/notify\n pay-return-url: http://niubi.natapp1.cc/api/pay/order/return\n refund-notify-url: http://niubi.natapp1.cc/api/pay/refund/notify\n access-log: # 访问日志的配置项\n enable: false\n demo: false # 关闭演示模式\n\njustauth:\n enabled: true\n type:\n DINGTALK: # 钉钉\n client-id: dingvrnreaje3yqvzhxg\n client-secret: i8E6iZyDvZj51JIb0tYsYfVQYOks9Cq1lgryEjFRqC79P3iJcrxEwT6Qk2QvLrLI\n ignore-check-redirect-uri: true\n WECHAT_ENTERPRISE: # 企业微信\n client-id: wwd411c69a39ad2e54\n client-secret: 1wTb7hYxnpT2TUbIeHGXGo7T0odav1ic10mLdyyATOw\n agent-id: 1000004\n ignore-check-redirect-uri: true\n # noinspection SpringBootApplicationYaml\n WECHAT_MINI_APP: # 微信小程序\n client-id: ${wx.miniapp.appid}\n client-secret: ${wx.miniapp.secret}\n ignore-check-redirect-uri: true\n ignore-check-state: true # 微信小程序，不会使用到 state，所以不进行校验\n WECHAT_MP: # 微信公众号\n client-id: ${wx.mp.app-id}\n client-secret: ${wx.mp.secret}\n ignore-check-redirect-uri: true\n cache:\n type: REDIS\n prefix: \'social_auth_state:\' # 缓存前缀，目前只对 Redis 缓存生效，默认 JUSTAUTH::STATE::\n timeout: 24h # 超时时长，目前只对 Redis 缓存生效，默认 3 分钟\n', 'da92b9ca7535bdf132e0db630e601d7f', '2010-05-05 00:00:00', '2024-06-26 02:24:00', 'nacos', '172.16.178.119', 'U', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (56, 75, 'application-local.yaml', 'DEFAULT_GROUP', 'local-config', '--- #################### 数据库相关配置 ####################\nspring:\n # 数据源配置项\n autoconfigure:\n exclude:\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\n - de.codecentric.boot.admin.client.config.SpringBootAdminClientAutoConfiguration # 禁用 Spring Boot Admin 的 Client 的自动配置\n datasource:\n druid: # Druid 【监控】相关的全局配置\n web-stat-filter:\n enabled: true\n stat-view-servlet:\n enabled: true\n allow: # 设置白名单，不填则允许所有访问\n url-pattern: /druid/*\n login-username: # 控制台管理用户名和密码\n login-password:\n filter:\n stat:\n enabled: true\n log-slow-sql: true # 慢 SQL 记录\n slow-sql-millis: 100\n merge-sql: true\n wall:\n config:\n multi-statement-allow: true\n dynamic: # 多数据源配置\n druid: # Druid 【连接池】相关的全局配置\n initial-size: 1 # 初始连接数\n min-idle: 1 # 最小连接池数量\n max-active: 20 # 最大连接池数量\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\n test-while-idle: true\n test-on-borrow: false\n test-on-return: false\n primary: master\n datasource:\n master:\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\n # url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=true&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai # MySQL Connector/J 5.X 连接的示例\n # url: jdbc:postgresql://127.0.0.1:5432/ruoyi-vue-pro # PostgreSQL 连接的示例\n # url: jdbc:oracle:thin:@127.0.0.1:1521:xe # Oracle 连接的示例\n # url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ruoyi-vue-pro # SQLServer 连接的示例\n # url: jdbc:dm://10.211.55.4:5236?schema=RUOYI_VUE_PRO # DM 连接的示例\n username: root\n password: 123456\n # username: sa # SQL Server 连接的示例\n # password: JSm:g(*%lU4ZAkz06cd52KqT3)i1?H7W # SQL Server 连接的示例\n # username: SYSDBA # DM 连接的示例\n # password: SYSDBA # DM 连接的示例\n slave: # 模拟从库，可根据自己需要修改\n lazy: true # 开启懒加载，保证启动速度\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true\n username: root\n password: 123456\n\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\n redis:\n host: 127.0.0.1 # 地址\n port: 6379 # 端口\n database: 0 # 数据库索引\n password: 123456 # 密码，建议生产环境开启\n\n--- #################### MQ 消息队列相关配置 ####################\n\n# rocketmq 配置项，对应 RocketMQProperties 配置类\nrocketmq:\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\n\nspring:\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\n rabbitmq:\n host: 127.0.0.1 # RabbitMQ 服务的地址\n port: 5672 # RabbitMQ 服务的端口\n username: guest # RabbitMQ 服务的账号\n password: guest # RabbitMQ 服务的密码\n # Kafka 配置项，对应 KafkaProperties 配置类\n kafka:\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\n\n--- #################### 定时任务相关配置 ####################\n\nxxl:\n job:\n enabled: false # 是否开启调度中心，默认为 true 开启\n admin:\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\n\n--- #################### 服务保障相关配置 ####################\n\n# Lock4j 配置项\nlock4j:\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\n\n--- #################### 监控相关配置 ####################\n\n# Actuator 监控端点的配置项\nmanagement:\n endpoints:\n web:\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\n exposure:\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\n\n# Spring Boot Admin 配置项\nspring:\n boot:\n admin:\n # Spring Boot Admin Client 客户端的相关配置\n client:\n instance:\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\n\n# 日志文件配置\nlogging:\n level:\n # 配置自己写的 MyBatis Mapper 打印日志\n com.iailab.module.system.dal.mysql: debug\n com.iailab.module.system.dal.mysql.sensitiveword.SensitiveWordMapper: INFO # 配置 SensitiveWordMapper 的日志级别为 info\n com.iailab.module.system.dal.mysql.sms.SmsChannelMapper: INFO # 配置 SmsChannelMapper 的日志级别为 info\n\n--- #################### 微信公众号、小程序相关配置 ####################\nwx:\n mp: # 公众号配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-mp-spring-boot-starter/README.md 文档\n # app-id: wx041349c6f39b268b # 测试号（牛希尧提供的）\n # secret: 5abee519483bc9f8cb37ce280e814bd0\n app-id: wx5b23ba7a5589ecbb # 测试号（自己的）\n secret: 2a7b3b20c537e52e74afd395eb85f61f\n # app-id: wxa69ab825b163be19 # 测试号（Kongdy 提供的）\n # secret: bd4f9fab889591b62aeac0d7b8d8b4a0\n # 存储配置，解决 AccessToken 的跨节点的共享\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wx # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n miniapp: # 小程序配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-miniapp-spring-boot-starter/README.md 文档\n # appid: wx62056c0d5e8db250 # 测试号（牛希尧提供的）\n # secret: 333ae72f41552af1e998fe1f54e1584a\n appid: wx63c280fe3248a3e7 # wenhualian的接口测试号\n secret: 6f270509224a7ae1296bbf1c8cb97aed\n # appid: wxc4598c446f8a9cb3 # 测试号（Kongdy 提供的）\n # secret: 4a1a04e07f6a4a0751b39c3064a92c8b\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wa # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n\n--- #################### 平台相关配置 ####################\n\n# 平台配置项，设置当前项目所有自定义的配置\niailab:\n env: # 多环境的配置项\n tag: ${HOSTNAME}\n captcha:\n enable: false # 本地环境，暂时关闭图片验证码，方便登录等接口的测试\n security:\n mock-enable: true\n xss:\n enable: false\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\n pay:\n pay-notify-url: http://niubi.natapp1.cc/api/pay/order/notify\n pay-return-url: http://niubi.natapp1.cc/api/pay/order/return\n refund-notify-url: http://niubi.natapp1.cc/api/pay/refund/notify\n access-log: # 访问日志的配置项\n enable: false\n demo: false # 关闭演示模式\n\njustauth:\n enabled: true\n type:\n DINGTALK: # 钉钉\n client-id: dingvrnreaje3yqvzhxg\n client-secret: i8E6iZyDvZj51JIb0tYsYfVQYOks9Cq1lgryEjFRqC79P3iJcrxEwT6Qk2QvLrLI\n ignore-check-redirect-uri: true\n WECHAT_ENTERPRISE: # 企业微信\n client-id: wwd411c69a39ad2e54\n client-secret: 1wTb7hYxnpT2TUbIeHGXGo7T0odav1ic10mLdyyATOw\n agent-id: 1000004\n ignore-check-redirect-uri: true\n # noinspection SpringBootApplicationYaml\n WECHAT_MINI_APP: # 微信小程序\n client-id: ${wx.miniapp.appid}\n client-secret: ${wx.miniapp.secret}\n ignore-check-redirect-uri: true\n ignore-check-state: true # 微信小程序，不会使用到 state，所以不进行校验\n WECHAT_MP: # 微信公众号\n client-id: ${wx.mp.app-id}\n client-secret: ${wx.mp.secret}\n ignore-check-redirect-uri: true\n cache:\n type: REDIS\n prefix: \'social_auth_state:\' # 缓存前缀，目前只对 Redis 缓存生效，默认 JUSTAUTH::STATE::\n timeout: 24h # 超时时长，目前只对 Redis 缓存生效，默认 3 分钟\n', 'da92b9ca7535bdf132e0db630e601d7f', '2010-05-05 00:00:00', '2024-06-27 03:08:08', 'nacos', '0:0:0:0:0:0:0:1', 'U', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (56, 76, 'application-local.yaml', 'DEFAULT_GROUP', 'local-config', '--- #################### 数据库相关配置 ####################\nspring:\n main:\n allow-circular-references: true # 允许循环依赖，因为项目是三层架构，无法避免这个情况。\n allow-bean-definition-overriding: true # 允许 Bean 覆盖，例如说 Feign 等会存在重复定义的服务\n\n # Servlet 配置\n servlet:\n # 文件上传相关配置项\n multipart:\n max-file-size: 16MB # 单个文件大小\n max-request-size: 32MB # 设置总上传的文件大小\n mvc:\n pathmatch:\n matching-strategy: ANT_PATH_MATCHER # 解决 SpringFox 与 SpringBoot 2.6.x 不兼容的问题，参见 SpringFoxHandlerProviderBeanPostProcessor 类\n\n # Jackson 配置项\n jackson:\n serialization:\n write-dates-as-timestamps: true # 设置 LocalDateTime 的格式，使用时间戳\n write-date-timestamps-as-nanoseconds: false # 设置不使用 nanoseconds 的格式。例如说 1611460870.401，而是直接 1611460870401\n write-durations-as-timestamps: true # 设置 Duration 的格式，使用时间戳\n fail-on-empty-beans: false # 允许序列化无属性的 Bean\n\n # Cache 配置项\n cache:\n type: REDIS\n redis:\n time-to-live: 1h # 设置过期时间为 1 小时\n # 数据源配置项\n autoconfigure:\n exclude:\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\n - de.codecentric.boot.admin.client.config.SpringBootAdminClientAutoConfiguration # 禁用 Spring Boot Admin 的 Client 的自动配置\n datasource:\n druid: # Druid 【监控】相关的全局配置\n web-stat-filter:\n enabled: true\n stat-view-servlet:\n enabled: true\n allow: # 设置白名单，不填则允许所有访问\n url-pattern: /druid/*\n login-username: # 控制台管理用户名和密码\n login-password:\n filter:\n stat:\n enabled: true\n log-slow-sql: true # 慢 SQL 记录\n slow-sql-millis: 100\n merge-sql: true\n wall:\n config:\n multi-statement-allow: true\n dynamic: # 多数据源配置\n druid: # Druid 【连接池】相关的全局配置\n initial-size: 1 # 初始连接数\n min-idle: 1 # 最小连接池数量\n max-active: 20 # 最大连接池数量\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\n test-while-idle: true\n test-on-borrow: false\n test-on-return: false\n primary: master\n datasource:\n master:\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\n # url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=true&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai # MySQL Connector/J 5.X 连接的示例\n # url: jdbc:postgresql://127.0.0.1:5432/ruoyi-vue-pro # PostgreSQL 连接的示例\n # url: jdbc:oracle:thin:@127.0.0.1:1521:xe # Oracle 连接的示例\n # url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ruoyi-vue-pro # SQLServer 连接的示例\n # url: jdbc:dm://10.211.55.4:5236?schema=RUOYI_VUE_PRO # DM 连接的示例\n username: root\n password: 123456\n # username: sa # SQL Server 连接的示例\n # password: JSm:g(*%lU4ZAkz06cd52KqT3)i1?H7W # SQL Server 连接的示例\n # username: SYSDBA # DM 连接的示例\n # password: SYSDBA # DM 连接的示例\n slave: # 模拟从库，可根据自己需要修改\n lazy: true # 开启懒加载，保证启动速度\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true\n username: root\n password: 123456\n\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\n redis:\n host: 127.0.0.1 # 地址\n port: 6379 # 端口\n database: 0 # 数据库索引\n password: 123456 # 密码，建议生产环境开启\n\n--- #################### MQ 消息队列相关配置 ####################\n\n# rocketmq 配置项，对应 RocketMQProperties 配置类\nrocketmq:\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\n\nspring:\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\n rabbitmq:\n host: 127.0.0.1 # RabbitMQ 服务的地址\n port: 5672 # RabbitMQ 服务的端口\n username: guest # RabbitMQ 服务的账号\n password: guest # RabbitMQ 服务的密码\n # Kafka 配置项，对应 KafkaProperties 配置类\n kafka:\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\n\n--- #################### 定时任务相关配置 ####################\n\nxxl:\n job:\n enabled: false # 是否开启调度中心，默认为 true 开启\n admin:\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\n\n--- #################### 服务保障相关配置 ####################\n\n# Lock4j 配置项\nlock4j:\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\n\n--- #################### 监控相关配置 ####################\n\n# Actuator 监控端点的配置项\nmanagement:\n endpoints:\n web:\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\n exposure:\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\n\n# Spring Boot Admin 配置项\nspring:\n boot:\n admin:\n # Spring Boot Admin Client 客户端的相关配置\n client:\n instance:\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\n\n# 日志文件配置\nlogging:\n level:\n # 配置自己写的 MyBatis Mapper 打印日志\n com.iailab.module.system.dal.mysql: debug\n com.iailab.module.system.dal.mysql.sensitiveword.SensitiveWordMapper: INFO # 配置 SensitiveWordMapper 的日志级别为 info\n com.iailab.module.system.dal.mysql.sms.SmsChannelMapper: INFO # 配置 SmsChannelMapper 的日志级别为 info\n\n--- #################### 微信公众号、小程序相关配置 ####################\nwx:\n mp: # 公众号配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-mp-spring-boot-starter/README.md 文档\n # app-id: wx041349c6f39b268b # 测试号（牛希尧提供的）\n # secret: 5abee519483bc9f8cb37ce280e814bd0\n app-id: wx5b23ba7a5589ecbb # 测试号（自己的）\n secret: 2a7b3b20c537e52e74afd395eb85f61f\n # app-id: wxa69ab825b163be19 # 测试号（Kongdy 提供的）\n # secret: bd4f9fab889591b62aeac0d7b8d8b4a0\n # 存储配置，解决 AccessToken 的跨节点的共享\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wx # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n miniapp: # 小程序配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-miniapp-spring-boot-starter/README.md 文档\n # appid: wx62056c0d5e8db250 # 测试号（牛希尧提供的）\n # secret: 333ae72f41552af1e998fe1f54e1584a\n appid: wx63c280fe3248a3e7 # wenhualian的接口测试号\n secret: 6f270509224a7ae1296bbf1c8cb97aed\n # appid: wxc4598c446f8a9cb3 # 测试号（Kongdy 提供的）\n # secret: 4a1a04e07f6a4a0751b39c3064a92c8b\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wa # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n\n--- #################### 平台相关配置 ####################\n\n# 平台配置项，设置当前项目所有自定义的配置\niailab:\n env: # 多环境的配置项\n tag: ${HOSTNAME}\n captcha:\n enable: false # 本地环境，暂时关闭图片验证码，方便登录等接口的测试\n security:\n mock-enable: true\n xss:\n enable: false\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\n pay:\n pay-notify-url: http://niubi.natapp1.cc/api/pay/order/notify\n pay-return-url: http://niubi.natapp1.cc/api/pay/order/return\n refund-notify-url: http://niubi.natapp1.cc/api/pay/refund/notify\n access-log: # 访问日志的配置项\n enable: false\n demo: false # 关闭演示模式\n\njustauth:\n enabled: true\n type:\n DINGTALK: # 钉钉\n client-id: dingvrnreaje3yqvzhxg\n client-secret: i8E6iZyDvZj51JIb0tYsYfVQYOks9Cq1lgryEjFRqC79P3iJcrxEwT6Qk2QvLrLI\n ignore-check-redirect-uri: true\n WECHAT_ENTERPRISE: # 企业微信\n client-id: wwd411c69a39ad2e54\n client-secret: 1wTb7hYxnpT2TUbIeHGXGo7T0odav1ic10mLdyyATOw\n agent-id: 1000004\n ignore-check-redirect-uri: true\n # noinspection SpringBootApplicationYaml\n WECHAT_MINI_APP: # 微信小程序\n client-id: ${wx.miniapp.appid}\n client-secret: ${wx.miniapp.secret}\n ignore-check-redirect-uri: true\n ignore-check-state: true # 微信小程序，不会使用到 state，所以不进行校验\n WECHAT_MP: # 微信公众号\n client-id: ${wx.mp.app-id}\n client-secret: ${wx.mp.secret}\n ignore-check-redirect-uri: true\n cache:\n type: REDIS\n prefix: \'social_auth_state:\' # 缓存前缀，目前只对 Redis 缓存生效，默认 JUSTAUTH::STATE::\n timeout: 24h # 超时时长，目前只对 Redis 缓存生效，默认 3 分钟\n', '790401161763919f659e3f35e65319fa', '2010-05-05 00:00:00', '2024-06-27 03:09:15', 'nacos', '0:0:0:0:0:0:0:1', 'U', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (56, 77, 'application-local.yaml', 'DEFAULT_GROUP', 'local-config', 'spring:\n main:\n allow-circular-references: true # 允许循环依赖，因为项目是三层架构，无法避免这个情况。\n allow-bean-definition-overriding: true # 允许 Bean 覆盖，例如说 Feign 等会存在重复定义的服务\n\n # Servlet 配置\n servlet:\n # 文件上传相关配置项\n multipart:\n max-file-size: 16MB # 单个文件大小\n max-request-size: 32MB # 设置总上传的文件大小\n mvc:\n pathmatch:\n matching-strategy: ANT_PATH_MATCHER # 解决 SpringFox 与 SpringBoot 2.6.x 不兼容的问题，参见 SpringFoxHandlerProviderBeanPostProcessor 类\n\n # Jackson 配置项\n jackson:\n serialization:\n write-dates-as-timestamps: true # 设置 LocalDateTime 的格式，使用时间戳\n write-date-timestamps-as-nanoseconds: false # 设置不使用 nanoseconds 的格式。例如说 1611460870.401，而是直接 1611460870401\n write-durations-as-timestamps: true # 设置 Duration 的格式，使用时间戳\n fail-on-empty-beans: false # 允许序列化无属性的 Bean\n\n # Cache 配置项\n cache:\n type: REDIS\n redis:\n time-to-live: 1h # 设置过期时间为 1 小时\n\n--- #################### 接口文档配置 ####################\n\nspringdoc:\n api-docs:\n enabled: true # 1. 是否开启 Swagger 接文档的元数据\n path: /v3/api-docs\n swagger-ui:\n enabled: true # 2.1 是否开启 Swagger 文档的官方 UI 界面\n path: /swagger-ui.html\n default-flat-param-object: true # 参见 https://doc.xiaominfo.com/docs/faq/v4/knife4j-parameterobject-flat-param 文档\n\nknife4j:\n enable: true # 2.2 是否开启 Swagger 文档的 Knife4j UI 界面\n setting:\n language: zh_cn\n\n# MyBatis Plus 的配置项\nmybatis-plus:\n configuration:\n map-underscore-to-camel-case: true # 虽然默认为 true ，但是还是显示去指定下。\n global-config:\n db-config:\n id-type: AUTO # “智能”模式，基于 IdTypeEnvironmentPostProcessor + 数据源的类型，自动适配成 AUTO、INPUT 模式。\n # id-type: AUTO # 自增 ID，适合 MySQL 等直接自增的数据库\n # id-type: INPUT # 用户输入 ID，适合 Oracle、PostgreSQL、Kingbase、DB2、H2 数据库\n # id-type: ASSIGN_ID # 分配 ID，默认使用雪花算法。注意，Oracle、PostgreSQL、Kingbase、DB2、H2 数据库时，需要去除实体类上的 @KeySequence 注解\n logic-delete-value: 1 # 逻辑已删除值(默认为 1)\n logic-not-delete-value: 0 # 逻辑未删除值(默认为 0)\n banner: false # 关闭控制台的 Banner 打印\n type-aliases-package: ${iailab.info.base-package}.dal.dataobject\n encryptor:\n password: XDV71a+xqStEA3WH # 加解密的秘钥，可使用 https://www.imaegoo.com/2020/aes-key-generator/ 网站生成\n\nmybatis-plus-join:\n banner: false # 关闭控制台的 Banner 打印\n\n# Spring Data Redis 配置\nspring:\n data:\n redis:\n repositories:\n enabled: false # 项目未使用到 Spring Data Redis 的 Repository，所以直接禁用，保证启动速度\n\n# VO 转换（数据翻译）相关\neasy-trans:\n is-enable-global: true # 启用全局翻译（拦截所有 SpringMVC ResponseBody 进行自动翻译 )。如果对于性能要求很高可关闭此配置，或通过 @IgnoreTrans 忽略某个接口\n is-enable-cloud: false # 禁用 TransType.RPC 微服务模式\n\n--- #################### RPC 远程调用相关配置 ####################\n\n--- #################### 消息队列相关 ####################\n\n# rocketmq 配置项，对应 RocketMQProperties 配置类\nrocketmq:\n # Producer 配置项\n producer:\n group: ${spring.application.name}_PRODUCER # 生产者分组\n\nspring:\n # Kafka 配置项，对应 KafkaProperties 配置类\n kafka:\n # Kafka Producer 配置项\n producer:\n acks: 1 # 0-不应答。1-leader 应答。all-所有 leader 和 follower 应答。\n retries: 3 # 发送失败时，重试发送的次数\n value-serializer: org.springframework.kafka.support.serializer.JsonSerializer # 消息的 value 的序列化\n # Kafka Consumer 配置项\n consumer:\n auto-offset-reset: earliest # 设置消费者分组最初的消费进度为 earliest 。可参考博客 https://blog.csdn.net/lishuangzhe7047/article/details/74530417 理解\n value-deserializer: org.springframework.kafka.support.serializer.JsonDeserializer\n properties:\n spring.json.trusted.packages: \'*\'\n # Kafka Consumer Listener 监听器配置\n listener:\n missing-topics-fatal: false # 消费监听接口监听的主题不存在时，默认会报错。所以通过设置为 false ，解决报错\n\n--- #################### 定时任务相关配置 ####################\n\nxxl:\n job:\n executor:\n appname: ${spring.application.name} # 执行器 AppName\n logpath: ${user.home}/logs/xxl-job/${spring.application.name} # 执行器运行日志文件存储磁盘路径\n accessToken: default_token # 执行器通讯TOKEN\n\n--- #################### 验证码相关配置 ####################\n\naj:\n captcha:\n jigsaw: classpath:images/jigsaw # 滑动验证，底图路径，不配置将使用默认图片；以 classpath: 开头，取 resource 目录下路径\n pic-click: classpath:images/pic-click # 滑动验证，底图路径，不配置将使用默认图片；以 classpath: 开头，取 resource 目录下路径\n cache-type: redis # 缓存 local/redis...\n cache-number: 1000 # local 缓存的阈值,达到这个值，清除缓存\n timing-clear: 180 # local定时清除过期缓存(单位秒),设置为0代表不执行\n type: blockPuzzle # 验证码类型 default两种都实例化。 blockPuzzle 滑块拼图 clickWord 文字点选\n water-mark: iailab # 右下角水印文字(我的水印)，可使用 https://tool.chinaz.com/tools/unicode.aspx 中文转 Unicode，Linux 可能需要转 unicode\n interference-options: 0 # 滑动干扰项(0/1/2)\n req-frequency-limit-enable: false # 接口请求次数一分钟限制是否开启 true|false\n req-get-lock-limit: 5 # 验证失败5次，get接口锁定\n req-get-lock-seconds: 10 # 验证失败后，锁定时间间隔\n req-get-minute-limit: 30 # get 接口一分钟内请求数限制\n req-check-minute-limit: 60 # check 接口一分钟内请求数限制\n req-verify-minute-limit: 60 # verify 接口一分钟内请求数限制\n\n--- #################### 平台相关配置 ####################\n\niailab:\n info:\n version: 1.0.0\n base-package: com.iailab.module.system\n web:\n admin-ui:\n url: http://dashboard.iailab.iocoder.cn # Admin 管理后台 UI 的地址\n swagger:\n title: 管理后台\n description: 提供管理员管理的所有功能\n version: ${iailab.info.version}\n base-package: ${iailab.info.base-package}\n captcha:\n enable: true # 验证码的开关，默认为 true；\n tenant: # 多租户相关配置项\n enable: true\n ignore-urls:\n - /admin-api/system/tenant/get-id-by-name # 基于名字获取租户，不许带租户编号\n - /admin-api/system/tenant/get-by-website # 基于域名获取租户，不许带租户编号\n - /admin-api/system/captcha/get-image # 获取图片验证码，和租户无关\n - /admin-api/system/captcha/get # 获取图片验证码，和租户无关\n - /admin-api/system/captcha/check # 校验图片验证码，和租户无关\n - /admin-api/system/sms/callback/* # 短信回调接口，无法带上租户编号\n - /rpc-api/system/tenant/valid # 防止递归。避免调用 /rpc-api/system/tenant/valid 接口时，又去触发 /rpc-api/system/tenant/valid 去校验\n - /rpc-api/system/tenant/id-list # 获得租户列表的时候，无需传递租户编号\n - /rpc-api/system/oauth2/token/check # 访问令牌校验时，无需传递租户编号；主要解决上传文件的场景，前端不会传递 tenant-id！\n ignore-tables:\n - system_tenant\n - system_tenant_package\n - system_dict_data\n - system_dict_type\n - system_error_code\n - system_menu\n - system_sms_channel\n - system_sms_template\n - system_sms_log\n - system_sensitive_word\n - system_oauth2_client\n - system_mail_account\n - system_mail_template\n - system_mail_log\n - system_notify_template\n sms-code: # 短信验证码相关的配置项\n expire-times: 10m\n send-frequency: 1m\n send-maximum-quantity-per-day: 10\n begin-code: 9999 # 这里配置 9999 的原因是，测试方便。\n end-code: 9999 # 这里配置 9999 的原因是，测试方便。\n\ndebug: false\n--- #################### 数据库相关配置 ####################\nspring:\n # 数据源配置项\n autoconfigure:\n exclude:\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\n - de.codecentric.boot.admin.client.config.SpringBootAdminClientAutoConfiguration # 禁用 Spring Boot Admin 的 Client 的自动配置\n datasource:\n druid: # Druid 【监控】相关的全局配置\n web-stat-filter:\n enabled: true\n stat-view-servlet:\n enabled: true\n allow: # 设置白名单，不填则允许所有访问\n url-pattern: /druid/*\n login-username: # 控制台管理用户名和密码\n login-password:\n filter:\n stat:\n enabled: true\n log-slow-sql: true # 慢 SQL 记录\n slow-sql-millis: 100\n merge-sql: true\n wall:\n config:\n multi-statement-allow: true\n dynamic: # 多数据源配置\n druid: # Druid 【连接池】相关的全局配置\n initial-size: 1 # 初始连接数\n min-idle: 1 # 最小连接池数量\n max-active: 20 # 最大连接池数量\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\n test-while-idle: true\n test-on-borrow: false\n test-on-return: false\n primary: master\n datasource:\n master:\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\n # url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=true&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai # MySQL Connector/J 5.X 连接的示例\n # url: jdbc:postgresql://127.0.0.1:5432/ruoyi-vue-pro # PostgreSQL 连接的示例\n # url: jdbc:oracle:thin:@127.0.0.1:1521:xe # Oracle 连接的示例\n # url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ruoyi-vue-pro # SQLServer 连接的示例\n # url: jdbc:dm://10.211.55.4:5236?schema=RUOYI_VUE_PRO # DM 连接的示例\n username: root\n password: 123456\n # username: sa # SQL Server 连接的示例\n # password: JSm:g(*%lU4ZAkz06cd52KqT3)i1?H7W # SQL Server 连接的示例\n # username: SYSDBA # DM 连接的示例\n # password: SYSDBA # DM 连接的示例\n slave: # 模拟从库，可根据自己需要修改\n lazy: true # 开启懒加载，保证启动速度\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true\n username: root\n password: 123456\n\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\n redis:\n host: 127.0.0.1 # 地址\n port: 6379 # 端口\n database: 0 # 数据库索引\n password: 123456 # 密码，建议生产环境开启\n\n--- #################### MQ 消息队列相关配置 ####################\n\n# rocketmq 配置项，对应 RocketMQProperties 配置类\nrocketmq:\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\n\nspring:\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\n rabbitmq:\n host: 127.0.0.1 # RabbitMQ 服务的地址\n port: 5672 # RabbitMQ 服务的端口\n username: guest # RabbitMQ 服务的账号\n password: guest # RabbitMQ 服务的密码\n # Kafka 配置项，对应 KafkaProperties 配置类\n kafka:\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\n\n--- #################### 定时任务相关配置 ####################\n\nxxl:\n job:\n enabled: false # 是否开启调度中心，默认为 true 开启\n admin:\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\n\n--- #################### 服务保障相关配置 ####################\n\n# Lock4j 配置项\nlock4j:\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\n\n--- #################### 监控相关配置 ####################\n\n# Actuator 监控端点的配置项\nmanagement:\n endpoints:\n web:\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\n exposure:\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\n\n# Spring Boot Admin 配置项\nspring:\n boot:\n admin:\n # Spring Boot Admin Client 客户端的相关配置\n client:\n instance:\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\n\n# 日志文件配置\nlogging:\n level:\n # 配置自己写的 MyBatis Mapper 打印日志\n com.iailab.module.system.dal.mysql: debug\n com.iailab.module.system.dal.mysql.sensitiveword.SensitiveWordMapper: INFO # 配置 SensitiveWordMapper 的日志级别为 info\n com.iailab.module.system.dal.mysql.sms.SmsChannelMapper: INFO # 配置 SmsChannelMapper 的日志级别为 info\n\n--- #################### 微信公众号、小程序相关配置 ####################\nwx:\n mp: # 公众号配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-mp-spring-boot-starter/README.md 文档\n # app-id: wx041349c6f39b268b # 测试号（牛希尧提供的）\n # secret: 5abee519483bc9f8cb37ce280e814bd0\n app-id: wx5b23ba7a5589ecbb # 测试号（自己的）\n secret: 2a7b3b20c537e52e74afd395eb85f61f\n # app-id: wxa69ab825b163be19 # 测试号（Kongdy 提供的）\n # secret: bd4f9fab889591b62aeac0d7b8d8b4a0\n # 存储配置，解决 AccessToken 的跨节点的共享\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wx # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n miniapp: # 小程序配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-miniapp-spring-boot-starter/README.md 文档\n # appid: wx62056c0d5e8db250 # 测试号（牛希尧提供的）\n # secret: 333ae72f41552af1e998fe1f54e1584a\n appid: wx63c280fe3248a3e7 # wenhualian的接口测试号\n secret: 6f270509224a7ae1296bbf1c8cb97aed\n # appid: wxc4598c446f8a9cb3 # 测试号（Kongdy 提供的）\n # secret: 4a1a04e07f6a4a0751b39c3064a92c8b\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wa # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n\n--- #################### 平台相关配置 ####################\n\n# 平台配置项，设置当前项目所有自定义的配置\niailab:\n env: # 多环境的配置项\n tag: ${HOSTNAME}\n captcha:\n enable: false # 本地环境，暂时关闭图片验证码，方便登录等接口的测试\n security:\n mock-enable: true\n xss:\n enable: false\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\n pay:\n pay-notify-url: http://niubi.natapp1.cc/api/pay/order/notify\n pay-return-url: http://niubi.natapp1.cc/api/pay/order/return\n refund-notify-url: http://niubi.natapp1.cc/api/pay/refund/notify\n access-log: # 访问日志的配置项\n enable: false\n demo: false # 关闭演示模式\n\njustauth:\n enabled: true\n type:\n DINGTALK: # 钉钉\n client-id: dingvrnreaje3yqvzhxg\n client-secret: i8E6iZyDvZj51JIb0tYsYfVQYOks9Cq1lgryEjFRqC79P3iJcrxEwT6Qk2QvLrLI\n ignore-check-redirect-uri: true\n WECHAT_ENTERPRISE: # 企业微信\n client-id: wwd411c69a39ad2e54\n client-secret: 1wTb7hYxnpT2TUbIeHGXGo7T0odav1ic10mLdyyATOw\n agent-id: 1000004\n ignore-check-redirect-uri: true\n # noinspection SpringBootApplicationYaml\n WECHAT_MINI_APP: # 微信小程序\n client-id: ${wx.miniapp.appid}\n client-secret: ${wx.miniapp.secret}\n ignore-check-redirect-uri: true\n ignore-check-state: true # 微信小程序，不会使用到 state，所以不进行校验\n WECHAT_MP: # 微信公众号\n client-id: ${wx.mp.app-id}\n client-secret: ${wx.mp.secret}\n ignore-check-redirect-uri: true\n cache:\n type: REDIS\n prefix: \'social_auth_state:\' # 缓存前缀，目前只对 Redis 缓存生效，默认 JUSTAUTH::STATE::\n timeout: 24h # 超时时长，目前只对 Redis 缓存生效，默认 3 分钟\n', '5d2f755d7b08e7b74ce3f3c0a83e20ca', '2010-05-05 00:00:00', '2024-06-27 03:12:08', 'nacos', '0:0:0:0:0:0:0:1', 'U', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (56, 78, 'application-local.yaml', 'DEFAULT_GROUP', 'local-config', '--- #################### 数据库相关配置 ####################\nspring:\n # 数据源配置项\n autoconfigure:\n exclude:\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\n - de.codecentric.boot.admin.client.config.SpringBootAdminClientAutoConfiguration # 禁用 Spring Boot Admin 的 Client 的自动配置\n datasource:\n druid: # Druid 【监控】相关的全局配置\n web-stat-filter:\n enabled: true\n stat-view-servlet:\n enabled: true\n allow: # 设置白名单，不填则允许所有访问\n url-pattern: /druid/*\n login-username: # 控制台管理用户名和密码\n login-password:\n filter:\n stat:\n enabled: true\n log-slow-sql: true # 慢 SQL 记录\n slow-sql-millis: 100\n merge-sql: true\n wall:\n config:\n multi-statement-allow: true\n dynamic: # 多数据源配置\n druid: # Druid 【连接池】相关的全局配置\n initial-size: 1 # 初始连接数\n min-idle: 1 # 最小连接池数量\n max-active: 20 # 最大连接池数量\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\n test-while-idle: true\n test-on-borrow: false\n test-on-return: false\n primary: master\n datasource:\n master:\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\n # url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=true&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai # MySQL Connector/J 5.X 连接的示例\n # url: jdbc:postgresql://127.0.0.1:5432/ruoyi-vue-pro # PostgreSQL 连接的示例\n # url: jdbc:oracle:thin:@127.0.0.1:1521:xe # Oracle 连接的示例\n # url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ruoyi-vue-pro # SQLServer 连接的示例\n # url: jdbc:dm://10.211.55.4:5236?schema=RUOYI_VUE_PRO # DM 连接的示例\n username: root\n password: 123456\n # username: sa # SQL Server 连接的示例\n # password: JSm:g(*%lU4ZAkz06cd52KqT3)i1?H7W # SQL Server 连接的示例\n # username: SYSDBA # DM 连接的示例\n # password: SYSDBA # DM 连接的示例\n slave: # 模拟从库，可根据自己需要修改\n lazy: true # 开启懒加载，保证启动速度\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true\n username: root\n password: 123456\n\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\n redis:\n host: 127.0.0.1 # 地址\n port: 6379 # 端口\n database: 0 # 数据库索引\n password: 123456 # 密码，建议生产环境开启\n\n--- #################### MQ 消息队列相关配置 ####################\n\n# rocketmq 配置项，对应 RocketMQProperties 配置类\nrocketmq:\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\n\nspring:\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\n rabbitmq:\n host: 127.0.0.1 # RabbitMQ 服务的地址\n port: 5672 # RabbitMQ 服务的端口\n username: guest # RabbitMQ 服务的账号\n password: guest # RabbitMQ 服务的密码\n # Kafka 配置项，对应 KafkaProperties 配置类\n kafka:\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\n\n--- #################### 定时任务相关配置 ####################\n\nxxl:\n job:\n enabled: false # 是否开启调度中心，默认为 true 开启\n admin:\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\n\n--- #################### 服务保障相关配置 ####################\n\n# Lock4j 配置项\nlock4j:\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\n\n--- #################### 监控相关配置 ####################\n\n# Actuator 监控端点的配置项\nmanagement:\n endpoints:\n web:\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\n exposure:\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\n\n# Spring Boot Admin 配置项\nspring:\n boot:\n admin:\n # Spring Boot Admin Client 客户端的相关配置\n client:\n instance:\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\n\n# 日志文件配置\nlogging:\n level:\n # 配置自己写的 MyBatis Mapper 打印日志\n com.iailab.module.system.dal.mysql: debug\n com.iailab.module.system.dal.mysql.sensitiveword.SensitiveWordMapper: INFO # 配置 SensitiveWordMapper 的日志级别为 info\n com.iailab.module.system.dal.mysql.sms.SmsChannelMapper: INFO # 配置 SmsChannelMapper 的日志级别为 info\n\n--- #################### 微信公众号、小程序相关配置 ####################\nwx:\n mp: # 公众号配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-mp-spring-boot-starter/README.md 文档\n # app-id: wx041349c6f39b268b # 测试号（牛希尧提供的）\n # secret: 5abee519483bc9f8cb37ce280e814bd0\n app-id: wx5b23ba7a5589ecbb # 测试号（自己的）\n secret: 2a7b3b20c537e52e74afd395eb85f61f\n # app-id: wxa69ab825b163be19 # 测试号（Kongdy 提供的）\n # secret: bd4f9fab889591b62aeac0d7b8d8b4a0\n # 存储配置，解决 AccessToken 的跨节点的共享\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wx # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n miniapp: # 小程序配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-miniapp-spring-boot-starter/README.md 文档\n # appid: wx62056c0d5e8db250 # 测试号（牛希尧提供的）\n # secret: 333ae72f41552af1e998fe1f54e1584a\n appid: wx63c280fe3248a3e7 # wenhualian的接口测试号\n secret: 6f270509224a7ae1296bbf1c8cb97aed\n # appid: wxc4598c446f8a9cb3 # 测试号（Kongdy 提供的）\n # secret: 4a1a04e07f6a4a0751b39c3064a92c8b\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wa # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n\n--- #################### 平台相关配置 ####################\n\n# 平台配置项，设置当前项目所有自定义的配置\niailab:\n env: # 多环境的配置项\n tag: ${HOSTNAME}\n captcha:\n enable: false # 本地环境，暂时关闭图片验证码，方便登录等接口的测试\n security:\n mock-enable: true\n xss:\n enable: false\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\n pay:\n pay-notify-url: http://niubi.natapp1.cc/api/pay/order/notify\n pay-return-url: http://niubi.natapp1.cc/api/pay/order/return\n refund-notify-url: http://niubi.natapp1.cc/api/pay/refund/notify\n access-log: # 访问日志的配置项\n enable: false\n demo: false # 关闭演示模式\n\njustauth:\n enabled: true\n type:\n DINGTALK: # 钉钉\n client-id: dingvrnreaje3yqvzhxg\n client-secret: i8E6iZyDvZj51JIb0tYsYfVQYOks9Cq1lgryEjFRqC79P3iJcrxEwT6Qk2QvLrLI\n ignore-check-redirect-uri: true\n WECHAT_ENTERPRISE: # 企业微信\n client-id: wwd411c69a39ad2e54\n client-secret: 1wTb7hYxnpT2TUbIeHGXGo7T0odav1ic10mLdyyATOw\n agent-id: 1000004\n ignore-check-redirect-uri: true\n # noinspection SpringBootApplicationYaml\n WECHAT_MINI_APP: # 微信小程序\n client-id: ${wx.miniapp.appid}\n client-secret: ${wx.miniapp.secret}\n ignore-check-redirect-uri: true\n ignore-check-state: true # 微信小程序，不会使用到 state，所以不进行校验\n WECHAT_MP: # 微信公众号\n client-id: ${wx.mp.app-id}\n client-secret: ${wx.mp.secret}\n ignore-check-redirect-uri: true\n cache:\n type: REDIS\n prefix: \'social_auth_state:\' # 缓存前缀，目前只对 Redis 缓存生效，默认 JUSTAUTH::STATE::\n timeout: 24h # 超时时长，目前只对 Redis 缓存生效，默认 3 分钟\n', 'da92b9ca7535bdf132e0db630e601d7f', '2010-05-05 00:00:00', '2024-06-27 03:50:19', 'nacos', '0:0:0:0:0:0:0:1', 'U', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (0, 79, 'application-dev', 'DEFAULT_GROUP', '', '--- #################### 数据库相关配置 ####################\r\nspring:\r\n # 数据源配置项\r\n autoconfigure:\r\n exclude:\r\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\r\n datasource:\r\n druid: # Druid 【监控】相关的全局配置\r\n web-stat-filter:\r\n enabled: true\r\n stat-view-servlet:\r\n enabled: true\r\n allow: # 设置白名单，不填则允许所有访问\r\n url-pattern: /druid/*\r\n login-username: # 控制台管理用户名和密码\r\n login-password:\r\n filter:\r\n stat:\r\n enabled: true\r\n log-slow-sql: true # 慢 SQL 记录\r\n slow-sql-millis: 100\r\n merge-sql: true\r\n wall:\r\n config:\r\n multi-statement-allow: true\r\n dynamic: # 多数据源配置\r\n druid: # Druid 【连接池】相关的全局配置\r\n initial-size: 5 # 初始连接数\r\n min-idle: 10 # 最小连接池数量\r\n max-active: 20 # 最大连接池数量\r\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\r\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\r\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\r\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\r\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\r\n test-while-idle: true\r\n test-on-borrow: false\r\n test-on-return: false\r\n primary: master\r\n datasource:\r\n master:\r\n url: jdbc:mysql://127.0.0.1:3306/iailab-platform?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\r\n username: root\r\n password: 123456\r\n slave: # 模拟从库，可根据自己需要修改 # 模拟从库，可根据自己需要修改\r\n lazy: true # 开启懒加载，保证启动速度\r\n url: jdbc:mysql://127.0.0.1:3306/iailab-platform?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\r\n username: root\r\n password: 123456\r\n\r\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\r\n redis:\r\n host: 127.0.0.1 # 地址\r\n port: 6379 # 端口\r\n database: 1 # 数据库索引\r\n password: 123456 # 密码，建议生产环境开启\r\n\r\n--- #################### MQ 消息队列相关配置 ####################\r\n\r\n# rocketmq 配置项，对应 RocketMQProperties 配置类\r\nrocketmq:\r\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\r\n\r\nspring:\r\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\r\n rabbitmq:\r\n host: 127.0.0.1 # RabbitMQ 服务的地址\r\n port: 5672 # RabbitMQ 服务的端口\r\n username: guest # RabbitMQ 服务的账号\r\n password: guest # RabbitMQ 服务的密码\r\n # Kafka 配置项，对应 KafkaProperties 配置类\r\n kafka:\r\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\r\n\r\n--- #################### 定时任务相关配置 ####################\r\nxxl:\r\n job:\r\n admin:\r\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\r\n\r\n--- #################### 服务保障相关配置 ####################\r\n\r\n# Lock4j 配置项\r\nlock4j:\r\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\r\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\r\n\r\n--- #################### 监控相关配置 ####################\r\n\r\n# Actuator 监控端点的配置项\r\nmanagement:\r\n endpoints:\r\n web:\r\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\r\n exposure:\r\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\r\n\r\n# Spring Boot Admin 配置项\r\nspring:\r\n boot:\r\n admin:\r\n # Spring Boot Admin Client 客户端的相关配置\r\n client:\r\n instance:\r\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\r\n # Spring Boot Admin Server 服务端的相关配置\r\n context-path: /admin # 配置 Spring\r\n\r\n--- #################### 平台相关配置 ####################\r\n\r\n# 平台配置项，设置当前项目所有自定义的配置\r\niailab:\r\n xss:\r\n enable: false\r\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\r\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\r\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\r\n demo: true # 开启演示模式\r\n', '9f26684015d3eff63033fbf295929f8a', '2010-05-05 00:00:00', '2024-06-27 06:07:18', NULL, '0:0:0:0:0:0:0:1', 'I', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (66, 80, 'application-dev', 'DEFAULT_GROUP', '', '--- #################### 数据库相关配置 ####################\r\nspring:\r\n # 数据源配置项\r\n autoconfigure:\r\n exclude:\r\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\r\n datasource:\r\n druid: # Druid 【监控】相关的全局配置\r\n web-stat-filter:\r\n enabled: true\r\n stat-view-servlet:\r\n enabled: true\r\n allow: # 设置白名单，不填则允许所有访问\r\n url-pattern: /druid/*\r\n login-username: # 控制台管理用户名和密码\r\n login-password:\r\n filter:\r\n stat:\r\n enabled: true\r\n log-slow-sql: true # 慢 SQL 记录\r\n slow-sql-millis: 100\r\n merge-sql: true\r\n wall:\r\n config:\r\n multi-statement-allow: true\r\n dynamic: # 多数据源配置\r\n druid: # Druid 【连接池】相关的全局配置\r\n initial-size: 5 # 初始连接数\r\n min-idle: 10 # 最小连接池数量\r\n max-active: 20 # 最大连接池数量\r\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\r\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\r\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\r\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\r\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\r\n test-while-idle: true\r\n test-on-borrow: false\r\n test-on-return: false\r\n primary: master\r\n datasource:\r\n master:\r\n url: jdbc:mysql://127.0.0.1:3306/iailab-platform?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\r\n username: root\r\n password: 123456\r\n slave: # 模拟从库，可根据自己需要修改 # 模拟从库，可根据自己需要修改\r\n lazy: true # 开启懒加载，保证启动速度\r\n url: jdbc:mysql://127.0.0.1:3306/iailab-platform?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\r\n username: root\r\n password: 123456\r\n\r\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\r\n redis:\r\n host: 127.0.0.1 # 地址\r\n port: 6379 # 端口\r\n database: 1 # 数据库索引\r\n password: 123456 # 密码，建议生产环境开启\r\n\r\n--- #################### MQ 消息队列相关配置 ####################\r\n\r\n# rocketmq 配置项，对应 RocketMQProperties 配置类\r\nrocketmq:\r\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\r\n\r\nspring:\r\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\r\n rabbitmq:\r\n host: 127.0.0.1 # RabbitMQ 服务的地址\r\n port: 5672 # RabbitMQ 服务的端口\r\n username: guest # RabbitMQ 服务的账号\r\n password: guest # RabbitMQ 服务的密码\r\n # Kafka 配置项，对应 KafkaProperties 配置类\r\n kafka:\r\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\r\n\r\n--- #################### 定时任务相关配置 ####################\r\nxxl:\r\n job:\r\n admin:\r\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\r\n\r\n--- #################### 服务保障相关配置 ####################\r\n\r\n# Lock4j 配置项\r\nlock4j:\r\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\r\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\r\n\r\n--- #################### 监控相关配置 ####################\r\n\r\n# Actuator 监控端点的配置项\r\nmanagement:\r\n endpoints:\r\n web:\r\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\r\n exposure:\r\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\r\n\r\n# Spring Boot Admin 配置项\r\nspring:\r\n boot:\r\n admin:\r\n # Spring Boot Admin Client 客户端的相关配置\r\n client:\r\n instance:\r\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\r\n # Spring Boot Admin Server 服务端的相关配置\r\n context-path: /admin # 配置 Spring\r\n\r\n--- #################### 平台相关配置 ####################\r\n\r\n# 平台配置项，设置当前项目所有自定义的配置\r\niailab:\r\n xss:\r\n enable: false\r\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\r\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\r\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\r\n demo: true # 开启演示模式\r\n', '9f26684015d3eff63033fbf295929f8a', '2010-05-05 00:00:00', '2024-06-27 06:07:38', NULL, '0:0:0:0:0:0:0:1', 'D', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (0, 81, 'application-dev.yaml', 'DEFAULT_GROUP', '', '--- #################### 数据库相关配置 ####################\r\nspring:\r\n # 数据源配置项\r\n autoconfigure:\r\n exclude:\r\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\r\n datasource:\r\n druid: # Druid 【监控】相关的全局配置\r\n web-stat-filter:\r\n enabled: true\r\n stat-view-servlet:\r\n enabled: true\r\n allow: # 设置白名单，不填则允许所有访问\r\n url-pattern: /druid/*\r\n login-username: # 控制台管理用户名和密码\r\n login-password:\r\n filter:\r\n stat:\r\n enabled: true\r\n log-slow-sql: true # 慢 SQL 记录\r\n slow-sql-millis: 100\r\n merge-sql: true\r\n wall:\r\n config:\r\n multi-statement-allow: true\r\n dynamic: # 多数据源配置\r\n druid: # Druid 【连接池】相关的全局配置\r\n initial-size: 5 # 初始连接数\r\n min-idle: 10 # 最小连接池数量\r\n max-active: 20 # 最大连接池数量\r\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\r\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\r\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\r\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\r\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\r\n test-while-idle: true\r\n test-on-borrow: false\r\n test-on-return: false\r\n primary: master\r\n datasource:\r\n master:\r\n url: jdbc:mysql://127.0.0.1:3306/iailab-platform?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\r\n username: root\r\n password: 123456\r\n slave: # 模拟从库，可根据自己需要修改 # 模拟从库，可根据自己需要修改\r\n lazy: true # 开启懒加载，保证启动速度\r\n url: jdbc:mysql://127.0.0.1:3306/iailab-platform?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\r\n username: root\r\n password: 123456\r\n\r\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\r\n redis:\r\n host: 127.0.0.1 # 地址\r\n port: 6379 # 端口\r\n database: 1 # 数据库索引\r\n password: 123456 # 密码，建议生产环境开启\r\n\r\n--- #################### MQ 消息队列相关配置 ####################\r\n\r\n# rocketmq 配置项，对应 RocketMQProperties 配置类\r\nrocketmq:\r\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\r\n\r\nspring:\r\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\r\n rabbitmq:\r\n host: 127.0.0.1 # RabbitMQ 服务的地址\r\n port: 5672 # RabbitMQ 服务的端口\r\n username: guest # RabbitMQ 服务的账号\r\n password: guest # RabbitMQ 服务的密码\r\n # Kafka 配置项，对应 KafkaProperties 配置类\r\n kafka:\r\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\r\n\r\n--- #################### 定时任务相关配置 ####################\r\nxxl:\r\n job:\r\n admin:\r\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\r\n\r\n--- #################### 服务保障相关配置 ####################\r\n\r\n# Lock4j 配置项\r\nlock4j:\r\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\r\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\r\n\r\n--- #################### 监控相关配置 ####################\r\n\r\n# Actuator 监控端点的配置项\r\nmanagement:\r\n endpoints:\r\n web:\r\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\r\n exposure:\r\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\r\n\r\n# Spring Boot Admin 配置项\r\nspring:\r\n boot:\r\n admin:\r\n # Spring Boot Admin Client 客户端的相关配置\r\n client:\r\n instance:\r\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\r\n # Spring Boot Admin Server 服务端的相关配置\r\n context-path: /admin # 配置 Spring\r\n\r\n--- #################### 平台相关配置 ####################\r\n\r\n# 平台配置项，设置当前项目所有自定义的配置\r\niailab:\r\n xss:\r\n enable: false\r\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\r\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\r\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\r\n demo: true # 开启演示模式\r\n', '9f26684015d3eff63033fbf295929f8a', '2010-05-05 00:00:00', '2024-06-27 06:07:56', NULL, '0:0:0:0:0:0:0:1', 'I', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (58, 82, 'bootstrap-local.yaml', 'DEFAULT_GROUP', '', '--- #################### 注册中心相关配置 ####################\r\n\r\nspring:\r\n cloud:\r\n nacos:\r\n server-addr: @nacos.server@\r\n discovery:\r\n namespace: @nacos.namespace@ # 命名空间。这里使用 dev 开发环境\r\n metadata:\r\n version: 1.0.0 # 服务实例的版本号，可用于灰度发布\r\n\r\n--- #################### 配置中心相关配置 ####################\r\n\r\nspring:\r\n cloud:\r\n nacos:\r\n # Nacos Config 配置项，对应 NacosConfigProperties 配置属性类\r\n config:\r\n server-addr: @nacos.server@ # Nacos 服务器地址\r\n namespace: @nacos.namespace@ # 命名空间 dev 的ID，不能直接使用 dev 名称。创建命名空间的时候需要指定ID为 dev，这里使用 dev 开发环境\r\n group: DEFAULT_GROUP # 使用的 Nacos 配置分组，默认为 DEFAULT_GROUP\r\n name: ${spring.application.name} # 使用的 Nacos 配置集的 dataId，默认为 spring.application.name\r\n file-extension: yaml # 使用的 Nacos 配置集的 dataId 的文件拓展名，同时也是 Nacos 配置集的配置格式，默认为 properties\r\n', '2ab4eecc9e3ac290d518d54dd7a12656', '2010-05-05 00:00:00', '2024-06-27 06:52:54', 'nacos', '0:0:0:0:0:0:0:1', 'U', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (56, 83, 'application-local.yaml', 'DEFAULT_GROUP', 'local-config', '--- #################### 数据库相关配置 ####################\nspring:\n # 数据源配置项\n autoconfigure:\n exclude:\n - com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 排除 Druid 的自动配置，使用 dynamic-datasource-spring-boot-starter 配置多数据源\n - de.codecentric.boot.admin.client.config.SpringBootAdminClientAutoConfiguration # 禁用 Spring Boot Admin 的 Client 的自动配置\n datasource:\n druid: # Druid 【监控】相关的全局配置\n web-stat-filter:\n enabled: true\n stat-view-servlet:\n enabled: true\n allow: # 设置白名单，不填则允许所有访问\n url-pattern: /druid/*\n login-username: # 控制台管理用户名和密码\n login-password:\n filter:\n stat:\n enabled: true\n log-slow-sql: true # 慢 SQL 记录\n slow-sql-millis: 100\n merge-sql: true\n wall:\n config:\n multi-statement-allow: true\n dynamic: # 多数据源配置\n druid: # Druid 【连接池】相关的全局配置\n initial-size: 1 # 初始连接数\n min-idle: 1 # 最小连接池数量\n max-active: 20 # 最大连接池数量\n max-wait: 600000 # 配置获取连接等待超时的时间，单位：毫秒\n time-between-eviction-runs-millis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位：毫秒\n min-evictable-idle-time-millis: 300000 # 配置一个连接在池中最小生存的时间，单位：毫秒\n max-evictable-idle-time-millis: 900000 # 配置一个连接在池中最大生存的时间，单位：毫秒\n validation-query: SELECT 1 FROM DUAL # 配置检测连接是否有效\n test-while-idle: true\n test-on-borrow: false\n test-on-return: false\n primary: master\n datasource:\n master:\n url: jdbc:mysql://127.0.0.1:3306/iailab-platform?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true # MySQL Connector/J 8.X 连接的示例\n # url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=true&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai # MySQL Connector/J 5.X 连接的示例\n # url: jdbc:postgresql://127.0.0.1:5432/ruoyi-vue-pro # PostgreSQL 连接的示例\n # url: jdbc:oracle:thin:@127.0.0.1:1521:xe # Oracle 连接的示例\n # url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ruoyi-vue-pro # SQLServer 连接的示例\n # url: jdbc:dm://10.211.55.4:5236?schema=RUOYI_VUE_PRO # DM 连接的示例\n username: root\n password: 123456\n # username: sa # SQL Server 连接的示例\n # password: JSm:g(*%lU4ZAkz06cd52KqT3)i1?H7W # SQL Server 连接的示例\n # username: SYSDBA # DM 连接的示例\n # password: SYSDBA # DM 连接的示例\n slave: # 模拟从库，可根据自己需要修改\n lazy: true # 开启懒加载，保证启动速度\n url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true\n username: root\n password: 123456\n\n # Redis 配置。Redisson 默认的配置足够使用，一般不需要进行调优\n redis:\n host: 127.0.0.1 # 地址\n port: 6379 # 端口\n database: 0 # 数据库索引\n password: 123456 # 密码，建议生产环境开启\n\n--- #################### MQ 消息队列相关配置 ####################\n\n# rocketmq 配置项，对应 RocketMQProperties 配置类\nrocketmq:\n name-server: 127.0.0.1:9876 # RocketMQ Namesrv\n\nspring:\n # RabbitMQ 配置项，对应 RabbitProperties 配置类\n rabbitmq:\n host: 127.0.0.1 # RabbitMQ 服务的地址\n port: 5672 # RabbitMQ 服务的端口\n username: guest # RabbitMQ 服务的账号\n password: guest # RabbitMQ 服务的密码\n # Kafka 配置项，对应 KafkaProperties 配置类\n kafka:\n bootstrap-servers: 127.0.0.1:9092 # 指定 Kafka Broker 地址，可以设置多个，以逗号分隔\n\n--- #################### 定时任务相关配置 ####################\n\nxxl:\n job:\n enabled: false # 是否开启调度中心，默认为 true 开启\n admin:\n addresses: http://127.0.0.1:9090/xxl-job-admin # 调度中心部署跟地址\n\n--- #################### 服务保障相关配置 ####################\n\n# Lock4j 配置项\nlock4j:\n acquire-timeout: 3000 # 获取分布式锁超时时间，默认为 3000 毫秒\n expire: 30000 # 分布式锁的超时时间，默认为 30 毫秒\n\n--- #################### 监控相关配置 ####################\n\n# Actuator 监控端点的配置项\nmanagement:\n endpoints:\n web:\n base-path: /actuator # Actuator 提供的 API 接口的根目录。默认为 /actuator\n exposure:\n include: \'*\' # 需要开放的端点。默认值只打开 health 和 info 两个端点。通过设置 * ，可以开放所有端点。\n\n# Spring Boot Admin 配置项\nspring:\n boot:\n admin:\n # Spring Boot Admin Client 客户端的相关配置\n client:\n instance:\n service-host-type: IP # 注册实例时，优先使用 IP [IP, HOST_NAME, CANONICAL_HOST_NAME]\n\n# 日志文件配置\nlogging:\n level:\n # 配置自己写的 MyBatis Mapper 打印日志\n com.iailab.module.system.dal.mysql: debug\n com.iailab.module.system.dal.mysql.sensitiveword.SensitiveWordMapper: INFO # 配置 SensitiveWordMapper 的日志级别为 info\n com.iailab.module.system.dal.mysql.sms.SmsChannelMapper: INFO # 配置 SmsChannelMapper 的日志级别为 info\n\n--- #################### 微信公众号、小程序相关配置 ####################\nwx:\n mp: # 公众号配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-mp-spring-boot-starter/README.md 文档\n # app-id: wx041349c6f39b268b # 测试号（牛希尧提供的）\n # secret: 5abee519483bc9f8cb37ce280e814bd0\n app-id: wx5b23ba7a5589ecbb # 测试号（自己的）\n secret: 2a7b3b20c537e52e74afd395eb85f61f\n # app-id: wxa69ab825b163be19 # 测试号（Kongdy 提供的）\n # secret: bd4f9fab889591b62aeac0d7b8d8b4a0\n # 存储配置，解决 AccessToken 的跨节点的共享\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wx # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n miniapp: # 小程序配置（必填），参见 https://github.com/Wechat-Group/WxJava/blob/develop/spring-boot-starters/wx-java-miniapp-spring-boot-starter/README.md 文档\n # appid: wx62056c0d5e8db250 # 测试号（牛希尧提供的）\n # secret: 333ae72f41552af1e998fe1f54e1584a\n appid: wx63c280fe3248a3e7 # wenhualian的接口测试号\n secret: 6f270509224a7ae1296bbf1c8cb97aed\n # appid: wxc4598c446f8a9cb3 # 测试号（Kongdy 提供的）\n # secret: 4a1a04e07f6a4a0751b39c3064a92c8b\n config-storage:\n type: RedisTemplate # 采用 RedisTemplate 操作 Redis，会自动从 Spring 中获取\n key-prefix: wa # Redis Key 的前缀\n http-client-type: HttpClient # 采用 HttpClient 请求微信公众号平台\n\n--- #################### 平台相关配置 ####################\n\n# 平台配置项，设置当前项目所有自定义的配置\niailab:\n env: # 多环境的配置项\n tag: ${HOSTNAME}\n captcha:\n enable: false # 本地环境，暂时关闭图片验证码，方便登录等接口的测试\n security:\n mock-enable: true\n xss:\n enable: false\n exclude-urls: # 如下两个 url，仅仅是为了演示，去掉配置也没关系\n - ${spring.boot.admin.context-path}/** # 不处理 Spring Boot Admin 的请求\n - ${management.endpoints.web.base-path}/** # 不处理 Actuator 的请求\n pay:\n pay-notify-url: http://niubi.natapp1.cc/api/pay/order/notify\n pay-return-url: http://niubi.natapp1.cc/api/pay/order/return\n refund-notify-url: http://niubi.natapp1.cc/api/pay/refund/notify\n access-log: # 访问日志的配置项\n enable: false\n demo: false # 关闭演示模式\n\njustauth:\n enabled: true\n type:\n DINGTALK: # 钉钉\n client-id: dingvrnreaje3yqvzhxg\n client-secret: i8E6iZyDvZj51JIb0tYsYfVQYOks9Cq1lgryEjFRqC79P3iJcrxEwT6Qk2QvLrLI\n ignore-check-redirect-uri: true\n WECHAT_ENTERPRISE: # 企业微信\n client-id: wwd411c69a39ad2e54\n client-secret: 1wTb7hYxnpT2TUbIeHGXGo7T0odav1ic10mLdyyATOw\n agent-id: 1000004\n ignore-check-redirect-uri: true\n # noinspection SpringBootApplicationYaml\n WECHAT_MINI_APP: # 微信小程序\n client-id: ${wx.miniapp.appid}\n client-secret: ${wx.miniapp.secret}\n ignore-check-redirect-uri: true\n ignore-check-state: true # 微信小程序，不会使用到 state，所以不进行校验\n WECHAT_MP: # 微信公众号\n client-id: ${wx.mp.app-id}\n client-secret: ${wx.mp.secret}\n ignore-check-redirect-uri: true\n cache:\n type: REDIS\n prefix: \'social_auth_state:\' # 缓存前缀，目前只对 Redis 缓存生效，默认 JUSTAUTH::STATE::\n timeout: 24h # 超时时长，目前只对 Redis 缓存生效，默认 3 分钟\n', '49b428cb7493d4e320110c2ea5434b1a', '2010-05-05 00:00:00', '2024-07-03 02:54:22', 'nacos', '0:0:0:0:0:0:0:1', 'U', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (0, 84, 'jeecg-gateway-dev.yaml', 'DEFAULT_GROUP', '', 'jeecg:\r\n route:\r\n config:\r\n #type:database nacos yml\r\n data-type: database\r\n data-id: jeecg-gateway-router\r\nspring:\r\n redis:\r\n database: 0\r\n host: jeecg-boot-redis\r\n port: 6379\r\n password:\r\nknife4j:\r\n production: false', 'cfbcfd01797660f0bb7397eabd254cf9', '2010-05-05 00:00:00', '2024-07-04 05:47:49', NULL, '0:0:0:0:0:0:0:1', 'I', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (70, 85, 'jeecg-gateway-dev.yaml', 'DEFAULT_GROUP', '', 'jeecg:\r\n route:\r\n config:\r\n #type:database nacos yml\r\n data-type: database\r\n data-id: jeecg-gateway-router\r\nspring:\r\n redis:\r\n database: 0\r\n host: jeecg-boot-redis\r\n port: 6379\r\n password:\r\nknife4j:\r\n production: false', 'cfbcfd01797660f0bb7397eabd254cf9', '2010-05-05 00:00:00', '2024-07-04 05:48:57', 'nacos', '0:0:0:0:0:0:0:1', 'U', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (58, 86, 'bootstrap-local.yaml', 'DEFAULT_GROUP', '', '--- #################### 注册中心相关配置 ####################\n\nspring:\n cloud:\n nacos:\n server-addr: @nacos.server@\n discovery:\n namespace: @nacos.namespace@ # 命名空间。这里使用 dev 开发环境\n metadata:\n version: 1.0.0 # 服务实例的版本号，可用于灰度发布\n\n--- #################### 配置中心相关配置 ####################\n\nspring:\n cloud:\n nacos:\n # Nacos Config 配置项，对应 NacosConfigProperties 配置属性类\n config:\n server-addr: @nacos.server@ # Nacos 服务器地址\n namespace: @nacos.namespace@ # 命名空间 dev 的ID，不能直接使用 dev 名称。创建命名空间的时候需要指定ID为 dev，这里使用 dev 开发环境\n group: DEFAULT_GROUP # 使用的 Nacos 配置分组，默认为 DEFAULT_GROUP\n name: ${spring.application.name} # 使用的 Nacos 配置集的 dataId，默认为 spring.application.name\n file-extension: yaml # 使用的 Nacos 配置集的 dataId 的文件拓展名，同时也是 Nacos 配置集的配置格式，默认为 properties\n shared-configs:\n - dataId: application-${spring.profiles.active}.${spring.cloud.nacos.config.file-extension}\n refresh: true #经修正 不加这个无法热更新共享配置', '693ea0a117a806d51264c2db6d28a54c', '2010-05-05 00:00:00', '2024-07-05 03:14:48', 'nacos', '0:0:0:0:0:0:0:1', 'U', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (57, 87, 'bootstrap.yaml', 'DEFAULT_GROUP', '', 'spring:\r\n application:\r\n name: system-server\r\n\r\n profiles:\r\n active: local\r\n\r\nserver:\r\n port: 48081\r\n\r\n# 日志文件配置。注意，如果 logging.file.name 不放在 bootstrap.yaml 配置文件，而是放在 application.yaml 中，会导致出现 LOG_FILE_IS_UNDEFINED 文件\r\nlogging:\r\n file:\r\n name: ${user.home}/logs/${spring.application.name}.log # 日志文件名，全路径\r\n', 'b3e314a9256c0f228682135358701901', '2010-05-05 00:00:00', '2024-07-05 03:19:12', 'nacos', '0:0:0:0:0:0:0:1', 'D', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (58, 88, 'bootstrap-local.yaml', 'DEFAULT_GROUP', '', '--- #################### 注册中心相关配置 ####################\n\nspring:\n cloud:\n nacos:\n server-addr: @nacos.server@\n username: @nacos.username@\n password: @nacos.password@\n discovery:\n namespace: @nacos.namespace@ # 命名空间。这里使用 dev 开发环境\n metadata:\n version: 1.0.0 # 服务实例的版本号，可用于灰度发布\n\n--- #################### 配置中心相关配置 ####################\n\nspring:\n cloud:\n nacos:\n # Nacos Config 配置项，对应 NacosConfigProperties 配置属性类\n config:\n server-addr: @nacos.server@ # Nacos 服务器地址\n namespace: @nacos.namespace@ # 命名空间 dev 的ID，不能直接使用 dev 名称。创建命名空间的时候需要指定ID为 dev，这里使用 dev 开发环境\n group: DEFAULT_GROUP # 使用的 Nacos 配置分组，默认为 DEFAULT_GROUP\n name: ${spring.application.name} # 使用的 Nacos 配置集的 dataId，默认为 spring.application.name\n file-extension: yaml # 使用的 Nacos 配置集的 dataId 的文件拓展名，同时也是 Nacos 配置集的配置格式，默认为 properties\n shared-configs:\n - dataId: application-${spring.profiles.active}.${spring.cloud.nacos.config.file-extension}\n refresh: true #经修正 不加这个无法热更新共享配置', 'd67cc6e17f66d2e8776a98e670bd5e1c', '2010-05-05 00:00:00', '2024-07-05 03:23:36', 'nacos', '0:0:0:0:0:0:0:1', 'U', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); INSERT INTO `his_config_info` VALUES (58, 89, 'bootstrap-local.yaml', 'DEFAULT_GROUP', '', '--- #################### 注册中心相关配置 ####################\n\nspring:\n cloud:\n nacos:\n server-addr: @nacos.server@\n username: @nacos.username@\n password: @nacos.password@\n discovery:\n namespace: @nacos.namespace@ # 命名空间。这里使用 dev 开发环境\n metadata:\n version: 1.0.0 # 服务实例的版本号，可用于灰度发布\n\n--- #################### 配置中心相关配置 ####################\n\nspring:\n cloud:\n nacos:\n # Nacos Config 配置项，对应 NacosConfigProperties 配置属性类\n config:\n server-addr: @nacos.server@ # Nacos 服务器地址\n username: @nacos.username@\n password: @nacos.password@\n namespace: @nacos.namespace@ # 命名空间 dev 的ID，不能直接使用 dev 名称。创建命名空间的时候需要指定ID为 dev，这里使用 dev 开发环境\n group: DEFAULT_GROUP # 使用的 Nacos 配置分组，默认为 DEFAULT_GROUP\n name: ${spring.application.name} # 使用的 Nacos 配置集的 dataId，默认为 spring.application.name\n file-extension: yaml # 使用的 Nacos 配置集的 dataId 的文件拓展名，同时也是 Nacos 配置集的配置格式，默认为 properties\n shared-configs:\n - dataId: application-${spring.profiles.active}.${spring.cloud.nacos.config.file-extension}\n refresh: true #经修正 不加这个无法热更新共享配置', 'b9bf6b619956a9dc754aa72e4d4cbe69', '2010-05-05 00:00:00', '2024-07-05 03:26:18', 'nacos', '0:0:0:0:0:0:0:1', 'D', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', ''); -- ---------------------------- -- Table structure for permissions -- ---------------------------- DROP TABLE IF EXISTS `permissions`; CREATE TABLE `permissions` ( `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `resource` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, UNIQUE INDEX `uk_role_permission`(`role` ASC, `resource` ASC, `action` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of permissions -- ---------------------------- -- ---------------------------- -- Table structure for roles -- ---------------------------- DROP TABLE IF EXISTS `roles`; CREATE TABLE `roles` ( `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, UNIQUE INDEX `uk_username_role`(`username` ASC, `role` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of roles -- ---------------------------- INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN'); -- ---------------------------- -- Table structure for tenant_capacity -- ---------------------------- DROP TABLE IF EXISTS `tenant_capacity`; CREATE TABLE `tenant_capacity` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID', `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID', `quota` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值', `usage` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量', `max_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值', `max_aggr_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数', `max_aggr_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值', `max_history_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量', `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间', `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_tenant_id`(`tenant_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '租户容量信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of tenant_capacity -- ---------------------------- -- ---------------------------- -- Table structure for tenant_info -- ---------------------------- DROP TABLE IF EXISTS `tenant_info`; CREATE TABLE `tenant_info` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', `kp` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'kp', `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id', `tenant_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_name', `tenant_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tenant_desc', `create_source` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'create_source', `gmt_create` bigint NOT NULL COMMENT '创建时间', `gmt_modified` bigint NOT NULL COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_tenant_info_kptenantid`(`kp` ASC, `tenant_id` ASC) USING BTREE, INDEX `idx_tenant_id`(`tenant_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'tenant_info' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of tenant_info -- ---------------------------- INSERT INTO `tenant_info` VALUES (3, '1', 'a7112341-c9e2-4177-bc5b-0d2e8cf0b3bb', 'dev', 'iailab dev', 'nacos', 1718867320294, 1718867320294); -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `enabled` tinyint(1) NOT NULL, PRIMARY KEY (`username`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', 1); SET FOREIGN_KEY_CHECKS = 1;