From e57d11d55a95ceafc793f714710d488bb1afc585 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期五, 06 五月 2022 18:07:00 +0800
Subject: [PATCH] add 增加 ruoyi-sms 短信模块 整合 阿里云、腾讯云 短信功能

---
 ruoyi-admin/src/main/resources/application-dev.yml |  244 +++++++++++++++++++++---------------------------
 1 files changed, 109 insertions(+), 135 deletions(-)

diff --git a/ruoyi-admin/src/main/resources/application-dev.yml b/ruoyi-admin/src/main/resources/application-dev.yml
index 867a1fd..d14047f 100644
--- a/ruoyi-admin/src/main/resources/application-dev.yml
+++ b/ruoyi-admin/src/main/resources/application-dev.yml
@@ -1,39 +1,34 @@
---- # 鐩戞帶閰嶇疆
-spring:
-  boot:
-    admin:
-      # Spring Boot Admin Client 瀹㈡埛绔殑鐩稿叧閰嶇疆
-      client:
-        # 澧炲姞瀹㈡埛绔紑鍏�
-        enabled: true
-        # 璁剧疆 Spring Boot Admin Server 鍦板潃
-        url: http://localhost:9090/admin
-        instance:
-          prefer-ip: true # 娉ㄥ唽瀹炰緥鏃讹紝浼樺厛浣跨敤 IP
-        username: ruoyi
-        password: 123456
+--- # 鐩戞帶涓績閰嶇疆
+spring.boot.admin.client:
+  # 澧炲姞瀹㈡埛绔紑鍏�
+  enabled: true
+  url: http://localhost:9090/admin
+  instance:
+    service-host-type: IP
+  username: ruoyi
+  password: 123456
 
 --- # xxl-job 閰嶇疆
-xxl:
-  job:
-    # 璋冨害涓績鍦板潃锛氬璋冨害涓績闆嗙兢閮ㄧ讲瀛樺湪澶氫釜鍦板潃鍒欑敤閫楀彿鍒嗛殧銆�
-    admin-addresses: http://localhost:9100/xxl-job-admin
-    # 鎵ц鍣ㄩ�氳TOKEN锛氶潪绌烘椂鍚敤
-    access-token: xxl-job
-    # 鎵ц鍣ㄩ厤缃�
-    executor:
-      # 鎵ц鍣ˋppName锛氭墽琛屽櫒蹇冭烦娉ㄥ唽鍒嗙粍渚濇嵁锛涗负绌哄垯鍏抽棴鑷姩娉ㄥ唽
-      appname: xxl-job-executor
-      # 鎵ц鍣ㄧ鍙e彿 鎵ц鍣ㄤ粠9101寮�濮嬪線鍚庡啓
-      port: 9101
-      # 鎵ц鍣ㄦ敞鍐岋細榛樿IP:PORT
-      address:
-      # 鎵ц鍣↖P锛氶粯璁よ嚜鍔ㄨ幏鍙朓P
-      ip:
-      # 鎵ц鍣ㄨ繍琛屾棩蹇楁枃浠跺瓨鍌ㄧ鐩樿矾寰�
-      logpath: ./logs/xxl-job
-      # 鎵ц鍣ㄦ棩蹇楁枃浠朵繚瀛樺ぉ鏁帮細澶т簬3鐢熸晥
-      logretentiondays: 30
+xxl.job:
+  # 鎵ц鍣ㄥ紑鍏�
+  enabled: true
+  # 璋冨害涓績鍦板潃锛氬璋冨害涓績闆嗙兢閮ㄧ讲瀛樺湪澶氫釜鍦板潃鍒欑敤閫楀彿鍒嗛殧銆�
+  admin-addresses: http://localhost:9100/xxl-job-admin
+  # 鎵ц鍣ㄩ�氳TOKEN锛氶潪绌烘椂鍚敤
+  access-token: xxl-job
+  executor:
+    # 鎵ц鍣ˋppName锛氭墽琛屽櫒蹇冭烦娉ㄥ唽鍒嗙粍渚濇嵁锛涗负绌哄垯鍏抽棴鑷姩娉ㄥ唽
+    appname: xxl-job-executor
+    # 鎵ц鍣ㄧ鍙e彿 鎵ц鍣ㄤ粠9101寮�濮嬪線鍚庡啓
+    port: 9101
+    # 鎵ц鍣ㄦ敞鍐岋細榛樿IP:PORT
+    address:
+    # 鎵ц鍣↖P锛氶粯璁よ嚜鍔ㄨ幏鍙朓P
+    ip:
+    # 鎵ц鍣ㄨ繍琛屾棩蹇楁枃浠跺瓨鍌ㄧ鐩樿矾寰�
+    logpath: ./logs/xxl-job
+    # 鎵ц鍣ㄦ棩蹇楁枃浠朵繚瀛樺ぉ鏁帮細澶т簬3鐢熸晥
+    logretentiondays: 30
 
 --- # 鏁版嵁婧愰厤缃�
 spring:
@@ -45,11 +40,15 @@
       p6spy: true
       # 璁剧疆榛樿鐨勬暟鎹簮鎴栬�呮暟鎹簮缁�,榛樿鍊煎嵆涓� master
       primary: master
+      # 涓ユ牸妯″紡 鍖归厤涓嶅埌鏁版嵁婧愬垯鎶ラ敊
+      strict: true
       datasource:
         # 涓诲簱鏁版嵁婧�
         master:
           driverClassName: com.mysql.cj.jdbc.Driver
-          url: jdbc:mysql://localhost:3306/ry-vue?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true
+          # jdbc 鎵�鏈夊弬鏁伴厤缃弬鑰� https://lionli.blog.csdn.net/article/details/122018562
+          # rewriteBatchedStatements=true 鎵瑰鐞嗕紭鍖� 澶у箙鎻愬崌鎵归噺鎻掑叆鏇存柊鍒犻櫎鎬ц兘(瀵规暟鎹簱鏈夋�ц兘鎹熻�� 浣跨敤鎵归噺鎿嶄綔搴旇�冭檻鎬ц兘闂)
+          url: jdbc:mysql://localhost:3306/ry-vue?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true
           username: root
           password: root
         # 浠庡簱鏁版嵁婧�
@@ -59,6 +58,23 @@
           url:
           username:
           password:
+#        oracle:
+#          driverClassName: oracle.jdbc.OracleDriver
+#          url: jdbc:oracle:thin:@//localhost:1521/XE
+#          username: ROOT
+#          password: root
+#          druid:
+#            validationQuery: SELECT 1 FROM DUAL
+#        postgres:
+#          driverClassName: org.postgresql.Driver
+#          url: jdbc:postgresql://localhost:5432/postgres?useUnicode=true&characterEncoding=utf8&useSSL=true&autoReconnect=true&reWriteBatchedInserts=true
+#          username: root
+#          password: root
+#        sqlserver:
+#          driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
+#          url: jdbc:sqlserver://localhost:1433;DatabaseName=tempdb;SelectMethod=cursor;rewriteBatchedStatements=true
+#          username: SA
+#          password: root
       druid:
         # 鍒濆杩炴帴鏁�
         initialSize: 5
@@ -75,7 +91,7 @@
         # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�澶х敓瀛樼殑鏃堕棿锛屽崟浣嶆槸姣
         maxEvictableIdleTimeMillis: 900000
         # 閰嶇疆妫�娴嬭繛鎺ユ槸鍚︽湁鏁�
-        validationQuery: SELECT 1 FROM DUAL
+        validationQuery: SELECT 1
         testWhileIdle: true
         testOnBorrow: false
         testOnReturn: false
@@ -83,29 +99,27 @@
         filters: stat
 
 --- # druid 閰嶇疆
-spring:
-  datasource:
-    druid:
-      webStatFilter:
-        enabled: true
-      statViewServlet:
-        enabled: true
-        # 璁剧疆鐧藉悕鍗曪紝涓嶅~鍒欏厑璁告墍鏈夎闂�
-        allow:
-        url-pattern: /druid/*
-        # 鎺у埗鍙扮鐞嗙敤鎴峰悕鍜屽瘑鐮�
-        login-username: ruoyi
-        login-password: 123456
-      filter:
-        stat:
-          enabled: true
-          # 鎱QL璁板綍
-          log-slow-sql: true
-          slow-sql-millis: 1000
-          merge-sql: true
-        wall:
-          config:
-            multi-statement-allow: true
+spring.datasource.druid:
+  webStatFilter:
+    enabled: true
+  statViewServlet:
+    enabled: true
+    # 璁剧疆鐧藉悕鍗曪紝涓嶅~鍒欏厑璁告墍鏈夎闂�
+    allow:
+    url-pattern: /druid/*
+    # 鎺у埗鍙扮鐞嗙敤鎴峰悕鍜屽瘑鐮�
+    login-username: ruoyi
+    login-password: 123456
+  filter:
+    stat:
+      enabled: true
+      # 鎱QL璁板綍
+      log-slow-sql: true
+      slow-sql-millis: 1000
+      merge-sql: true
+    wall:
+      config:
+        multi-statement-allow: true
 
 --- # redis 鍗曟満閰嶇疆(鍗曟満涓庨泦缇ゅ彧鑳藉紑鍚竴涓彟涓�涓渶瑕佹敞閲婃帀)
 spring:
@@ -125,94 +139,54 @@
 
 redisson:
   # 绾跨▼姹犳暟閲�
-  threads: 16
+  threads: 4
   # Netty绾跨▼姹犳暟閲�
-  nettyThreads: 32
-  # 浼犺緭妯″紡
-  transportMode: "NIO"
+  nettyThreads: 8
   # 鍗曡妭鐐归厤缃�
   singleServerConfig:
     # 瀹㈡埛绔悕绉�
     clientName: ${ruoyi.name}
     # 鏈�灏忕┖闂茶繛鎺ユ暟
-    connectionMinimumIdleSize: 32
+    connectionMinimumIdleSize: 8
     # 杩炴帴姹犲ぇ灏�
-    connectionPoolSize: 64
+    connectionPoolSize: 32
     # 杩炴帴绌洪棽瓒呮椂锛屽崟浣嶏細姣
     idleConnectionTimeout: 10000
     # 鍛戒护绛夊緟瓒呮椂锛屽崟浣嶏細姣
     timeout: 3000
-    # 濡傛灉灏濊瘯鍦ㄦ闄愬埗涔嬪唴鍙戦�佹垚鍔燂紝鍒欏紑濮嬪惎鐢� timeout 璁℃椂銆�
-    retryAttempts: 3
-    # 鍛戒护閲嶈瘯鍙戦�佹椂闂撮棿闅旓紝鍗曚綅锛氭绉�
-    retryInterval: 1500
-    # 鍙戝竷鍜岃闃呰繛鎺ョ殑鏈�灏忕┖闂茶繛鎺ユ暟
-    subscriptionConnectionMinimumIdleSize: 1
     # 鍙戝竷鍜岃闃呰繛鎺ユ睜澶у皬
     subscriptionConnectionPoolSize: 50
-    # 鍗曚釜杩炴帴鏈�澶ц闃呮暟閲�
-    subscriptionsPerConnection: 5
-    # DNS鐩戞祴鏃堕棿闂撮殧锛屽崟浣嶏細姣
-    dnsMonitoringInterval: 5000
 
-#--- # redis 闆嗙兢閰嶇疆(鍗曟満涓庨泦缇ゅ彧鑳藉紑鍚竴涓彟涓�涓渶瑕佹敞閲婃帀)
-#spring:
-#  redis:
-#    cluster:
-#      nodes:
-#        - 192.168.0.100:6379
-#        - 192.168.0.101:6379
-#        - 192.168.0.102:6379
-#    # 瀵嗙爜
-#    password:
-#    # 杩炴帴瓒呮椂鏃堕棿
-#    timeout: 10s
-#    # 鏄惁寮�鍚痵sl
-#    ssl: false
-#
-#redisson:
-#  # 绾跨▼姹犳暟閲�
-#  threads: 16
-#  # Netty绾跨▼姹犳暟閲�
-#  nettyThreads: 32
-#  # 浼犺緭妯″紡
-#  transportMode: "NIO"
-#  # 闆嗙兢閰嶇疆
-#  clusterServersConfig:
-#    # 瀹㈡埛绔悕绉�
-#    clientName: ${ruoyi.name}
-#    # master鏈�灏忕┖闂茶繛鎺ユ暟
-#    masterConnectionMinimumIdleSize: 32
-#    # master杩炴帴姹犲ぇ灏�
-#    masterConnectionPoolSize: 64
-#    # slave鏈�灏忕┖闂茶繛鎺ユ暟
-#    slaveConnectionMinimumIdleSize: 32
-#    # slave杩炴帴姹犲ぇ灏�
-#    slaveConnectionPoolSize: 64
-#    # 杩炴帴绌洪棽瓒呮椂锛屽崟浣嶏細姣
-#    idleConnectionTimeout: 10000
-#    # ping杩炴帴闂撮殧
-#    pingConnectionInterval: 1000
-#    # 鍛戒护绛夊緟瓒呮椂锛屽崟浣嶏細姣
-#    timeout: 3000
-#    # 濡傛灉灏濊瘯鍦ㄦ闄愬埗涔嬪唴鍙戦�佹垚鍔燂紝鍒欏紑濮嬪惎鐢� timeout 璁℃椂銆�
-#    retryAttempts: 3
-#    # 鍛戒护閲嶈瘯鍙戦�佹椂闂撮棿闅旓紝鍗曚綅锛氭绉�
-#    retryInterval: 1500
-#    # 浠庡彲鐢ㄦ湇鍔″櫒鐨勫唴閮ㄥ垪琛ㄤ腑鎺掗櫎 Redis Slave 閲嶆柊杩炴帴灏濊瘯鐨勯棿闅斻��
-#    failedSlaveReconnectionInterval: 3000
-#    # 鍙戝竷鍜岃闃呰繛鎺ユ睜鏈�灏忕┖闂茶繛鎺ユ暟
-#    subscriptionConnectionMinimumIdleSize: 1
-#    # 鍙戝竷鍜岃闃呰繛鎺ユ睜澶у皬
-#    subscriptionConnectionPoolSize: 50
-#    # 鍗曚釜杩炴帴鏈�澶ц闃呮暟閲�
-#    subscriptionsPerConnection: 5
-#    # 鎵弿闂撮殧
-#    scanInterval: 1000
-#    # DNS鐩戞祴鏃堕棿闂撮殧锛屽崟浣嶏細姣
-#    dnsMonitoringInterval: 5000
-#    # 璇诲彇妯″紡
-#    readMode: "SLAVE"
-#    # 璁㈤槄妯″紡
-#    subscriptionMode: "MASTER"
+--- # mail 閭欢鍙戦��
+mail:
+  enabled: false
+  host: smtp.163.com
+  port: 465
+  # 鏄惁闇�瑕佺敤鎴峰悕瀵嗙爜楠岃瘉
+  auth: true
+  # 鍙戦�佹柟锛岄伒寰猂FC-822鏍囧噯
+  from: xxx@163.com
+  # 鐢ㄦ埛鍚嶏紙娉ㄦ剰锛氬鏋滀娇鐢╢oxmail閭锛屾澶剈ser涓簈q鍙凤級
+  user: xxx@163.com
+  # 瀵嗙爜锛堟敞鎰忥紝鏌愪簺閭闇�瑕佷负SMTP鏈嶅姟鍗曠嫭璁剧疆瀵嗙爜锛岃鎯呮煡鐪嬬浉鍏冲府鍔╋級
+  pass: xxxxxxxxxx
+  # 浣跨敤 STARTTLS瀹夊叏杩炴帴锛孲TARTTLS鏄绾枃鏈�氫俊鍗忚鐨勬墿灞曘��
+  starttlsEnable: true
+  # 浣跨敤SSL瀹夊叏杩炴帴
+  sslEnable: true
+  # SMTP瓒呮椂鏃堕暱锛屽崟浣嶆绉掞紝缂虹渷鍊间笉瓒呮椂
+  timeout: 0
+  # Socket杩炴帴瓒呮椂鍊硷紝鍗曚綅姣锛岀己鐪佸�间笉瓒呮椂
+  connectionTimeout: 0
 
+--- # sms 鐭俊
+sms:
+  enabled: false
+  # 闃块噷浜� dysmsapi.aliyuncs.com
+  # 鑵捐浜� sms.tencentcloudapi.com
+  endpoint: "dysmsapi.aliyuncs.com"
+  accessKeyId: xxxxxxx
+  accessKeySecret: xxxxxx
+  signName: 娴嬭瘯
+  # 鑵捐涓撶敤
+  sdkAppId:

--
Gitblit v1.9.3