From d9e64c2f482ffb770c90e6055b8bb9458b962d17 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期三, 30 九月 2026 09:16:04 +0800
Subject: [PATCH] config(database): 更新测试环境数据库配置和移除研究基金记录类型

---
 yudao-server/src/main/resources/application-test.yaml |   58 +++++++++++++++++++---------------------------------------
 1 files changed, 19 insertions(+), 39 deletions(-)

diff --git a/yudao-server/src/main/resources/application-test.yaml b/yudao-server/src/main/resources/application-test.yaml
index af05078..971cf7b 100644
--- a/yudao-server/src/main/resources/application-test.yaml
+++ b/yudao-server/src/main/resources/application-test.yaml
@@ -65,40 +65,16 @@
       primary: master
       datasource:
         master:
-          url: jdbc:mysql://172.17.0.1:11101/ruoyi-vue-pro?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true&rewriteBatchedStatements=true # MySQL Connector/J 8.X 杩炴帴鐨勭ず渚�
-          #          url: jdbc:mysql://127.0.0.1:3306/ruoyi-vue-pro?useSSL=true&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true # MySQL Connector/J 5.X 杩炴帴鐨勭ず渚�
-          #          url: jdbc:postgresql://127.0.0.1:5432/ruoyi-vue-pro # PostgreSQL 杩炴帴鐨勭ず渚�
-          #          url: jdbc:oracle:thin:@127.0.0.1:1521:xe # Oracle 杩炴帴鐨勭ず渚�
-          #          url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ruoyi-vue-pro;SelectMethod=cursor;encrypt=false;rewriteBatchedStatements=true;useUnicode=true;characterEncoding=utf-8 # SQLServer 杩炴帴鐨勭ず渚�
-          #          url: jdbc:dm://127.0.0.1:5236?schema=RUOYI_VUE_PRO # DM 杩炴帴鐨勭ず渚�
-          #          url: jdbc:kingbase8://127.0.0.1:54321/test  # 浜哄ぇ閲戜粨 KingbaseES 杩炴帴鐨勭ず渚�
-          #          url: jdbc:postgresql://127.0.0.1:5432/postgres # OpenGauss 杩炴帴鐨勭ず渚�
-          #          url: jdbc:postgresql://127.0.0.1:5866/ruoyi-vue-pro # 鐎氶珮 HighGo 杩炴帴鐨勭ず渚�
+          url: jdbc:mysql://172.17.0.1:10000/mom-jssm?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true&rewriteBatchedStatements=true # MySQL Connector/J 8.X 杩炴帴鐨勭ず渚�
           username: root
           password: xd@123456..
-          #          username: sa # SQL Server 杩炴帴鐨勭ず渚�
-          #          password: Yudao@2024 # SQL Server 杩炴帴鐨勭ず渚�
-          #          username: SYSDBA # DM 杩炴帴鐨勭ず渚�
-          #          password: SYSDBA001 # DM 杩炴帴鐨勭ず渚�
-          #          username: root # OpenGauss 杩炴帴鐨勭ず渚�
-          #          password: Yudao@2024 # OpenGauss 杩炴帴鐨勭ず渚�
-          #          username: root # 鐎氶珮 HighGo 杩炴帴鐨勭ず渚�
-          #          password: 123456 # 鐎氶珮 HighGo 杩炴帴鐨勭ず渚�
-#        tdengine: # IoT 鏁版嵁搴擄紙闇�瑕� IoT 鐗╄仈缃戝啀寮�鍚櫌锛侊級
-#          lazy: true # 寮�鍚噿鍔犺浇锛屼繚璇佸惎鍔ㄩ�熷害
-#          url: jdbc:TAOS-WS://127.0.0.1:6041/ruoyi_vue_pro?varcharAsString=true&enableAutoReconnect=true # 鍙傝锛歨ttps://t.zsxq.com/qaX9c锛屽紑鍚� TDengine WebSocket 鑷姩閲嶈繛
-#          driver-class-name: com.taosdata.jdbc.ws.WebSocketDriver
-#          username: root
-#          password: taosdata
-#          druid:
-#            validation-query: SELECT SERVER_STATUS() # TDengine 鏁版嵁婧愮殑鏈夋晥鎬ф鏌� SQL
 
   # Redis 閰嶇疆銆俁edisson 榛樿鐨勯厤缃冻澶熶娇鐢紝涓�鑸笉闇�瑕佽繘琛岃皟浼�
   data:
     redis:
       host: 172.17.0.1 # 鍦板潃
-      port: 11102 # 绔彛
-      database: 0 # 鏁版嵁搴撶储寮�
+      port: 9999 # 绔彛
+      database: 3 # 鏁版嵁搴撶储寮�
 #      password: dev # 瀵嗙爜锛屽缓璁敓浜х幆澧冨紑鍚�
 
 --- #################### 瀹氭椂浠诲姟鐩稿叧閰嶇疆 ####################
@@ -196,7 +172,7 @@
       milvus:
         initialize-schema: true
         database-name: test
-        collection-name: knowledge_segment_test
+        collection-name: knowledge_segment_jssm
         host: 36.213.90.123
         port: 19530
 
@@ -214,7 +190,7 @@
   storage: # 鏂囦欢涓婁紶閰嶇疆
     path: /data/javaWork/mom/file # 鏂囦欢瀛樺偍鏍圭洰褰�
     url-prefix: /admin-api/system/storage-blob # URL璺緞鍓嶇紑
-    domain: http://36.213.90.123:9500 # 鍩熷悕鍓嶇紑锛堟寜瀹為檯鍩熷悕閰嶇疆锛夛紝鍓嶇閰嶇疆濂藉儚涓嶅お瀵圭幇鍦ㄦ槸鐩磋繛鍚庣锛屾墍鏈夎鍚庣绔彛
+    domain: http://36.213.150.237:9007 # 鍩熷悕鍓嶇紑锛堟寜瀹為檯鍩熷悕閰嶇疆锛夛紝鍓嶇閰嶇疆濂藉儚涓嶅お瀵圭幇鍦ㄦ槸鐩磋繛鍚庣锛屾墍鏈夎鍚庣绔彛
     expired: 120 # token杩囨湡鏃堕棿锛堝垎閽燂級
     use-limit: 10 # token浣跨敤娆℃暟涓婇檺
     jwt-secret: abcdefghijklmnopqrstuvwxyz0123456789ABCDEFG # JWT瀵嗛挜
@@ -223,18 +199,22 @@
     compress-quality: 0.5 # 鍘嬬缉璐ㄩ噺(0.0-1.0)
   qcreport: # 鏅鸿兘璐ㄦ鎶ュ憡
     pdf: # PDF 鍑轰欢锛氭湇鍔$璋� Chromium 鎶婃姤鍛� HTML 鎵撳嵃鎴� PDF
-      # 閮ㄧ讲鍓嶇疆锛圠inux 鏈嶅姟鍣級锛�
-      #   1) 娴忚鍣細鏈」 channel 榛樿 chrome锛岄渶瑕佹湇鍔″櫒涓婅浜� Chrome锛涙病瑁呭氨鏀规垚 '' 骞舵墽琛�
-      #      playwright install chromium 鐢ㄨ嚜甯︾殑 Chromium锛屾垨鎶� executable-path 鎸囧悜鏈嶅姟鍣ㄤ笂鐨勬祻瑙堝櫒
-      #   2) 涓枃瀛椾綋锛氭姤鍛婃鏂囨槸涓枃锛屾湇鍔″櫒缂� CJK 瀛椾綋浼氭墦鎴愭柟妗嗭紝闇�瑁� fonts-wqy-zenhei / Noto Sans CJK
-      #   3) 浠� root 杩愯锛欳hromium 闇�瑕� --no-sandbox锛屽姞鍒� browser-args 閲�
+      # 閮ㄧ讲鍓嶇疆锛堝鍣ㄥ唴锛岃鐢熶骇 Dockerfile 鐨� USER root锛夛細
+      #   1) 娴忚鍣細澶氶樁娈垫瀯寤轰粠 mcr.microsoft.com/playwright:v1.63.0-jammy 閲�
+      #      COPY --from 鍙栧嚭 /ms-playwright 涓嬬殑 chromium锛堣闀滃儚搴曞骇鏄� Ubuntu 22.04/glibc 2.35锛�
+      #      涓庤繍琛岄暅鍍忎竴鑷达級銆侾laywright 涓嶄細鏇夸綘涓嬭浇娴忚鍣紝瑁呭湪瀹夸富鏈轰篃娌$敤锛屽繀椤昏繘闀滃儚锛�
+      #      鏋勫缓鏈熬鎶婂畠杞摼鍒� /usr/local/bin/chromium锛屽苟鐢� --version + ldd 鑷锛�
+      #      瑁呭け璐ュ氨鐩存帴涓柇鏋勫缓锛屼笉鎷栧埌鐢ㄦ埛鐐瑰鍑烘墠鏆撮湶
+      #   2) 涓枃瀛椾綋锛氭姤鍛婃鏂囨槸涓枃锛岀己 CJK 瀛椾綋浼氭墦鎴愭柟妗嗭紝闇�瑁� fonts-wqy-zenhei / Noto Sans CJK
+      #   3) 浠� root 杩愯锛欳hromium 涓嶅姞 --no-sandbox 浼氱洿鎺ユ嫆缁濆惎鍔紱瀹瑰櫒 /dev/shm 榛樿浠� 64M锛�
+      #      杩橀渶 --disable-dev-shm-usage锛屽惁鍒欐覆鏌撳ぇ鎶ュ憡鏃朵細闅忔満宕�
       enabled: true # 鍏虫帀鍚庡鍑烘帴鍙d細鏄庣‘鎶ャ�屾湭鍚敤銆嶏紝鑰屼笉鏄姏 500
-      channel: chrome # 娴忚鍣ㄩ�氶亾锛涚暀绌� = Playwright 鑷甫 Chromium锛堥渶鍏� playwright install chromium锛�
-      executable-path: '' # 娴忚鍣ㄥ彲鎵ц鏂囦欢璺緞锛岄厤浜嗗氨浼樺厛浜� channel
+      channel: '' # 鐣欑┖锛氭敼鐢变笅闈㈢殑 executable-path 鎸囧畾闀滃儚鍐呯殑 chromium
+      executable-path: /usr/local/bin/chromium # 闀滃儚鍐� chromium 鐨勫浐瀹氫綅缃紝鐢� Dockerfile 寤鸿蒋閾句繚璇�
       concurrency: 2 # 鍚屾椂杩涜鐨� PDF 娓叉煋涓婇檺锛孋hromium 寰堝悆鍐呭瓨锛屼笉瑕佹斁寮�
       timeout-ms: 30000 # 鍗曟娓叉煋瓒呮椂锛堟绉掞級锛屽悓鏃朵篃鏄帓闃熺瓑骞跺彂鍚嶉鐨勪笂闄�
       show-page-number: true # 椤佃剼鎵撳嵃銆岀 N 椤� / 鍏� M 椤点��
-      browser-args: [ ] # 棰濆鐨勬祻瑙堝櫒鍚姩鍙傛暟锛屽 Linux 浠� root 杩愯闇�鍔� --no-sandbox
+      browser-args: [ '--no-sandbox', '--disable-dev-shm-usage' ] # 瀹瑰櫒鍐呬互 root 杩愯蹇呴渶锛屼袱椤归兘涓嶈兘鍘绘帀
     ai-import: # AI 瀵煎叆锛氫笂浼犳棦鏈夋姤鍛婃枃浠讹紝璇嗗埆鎴愭ā鏉胯崏绋�
       # 閮ㄧ讲鍓嶇疆锛氬簲鐢ㄦ湇鍔″櫒闇�鑳藉嚭缃戣闂� DashScope锛堥�氫箟鍗冮棶锛夈�傚唴缃戦儴缃茶鎶� enabled 缃� false锛�
       # 鎺ュ彛浼氭槑纭姤銆屾湭鍚敤銆嶈�屼笉鏄竴鐩寸瓑鍒� AI 瓒呮椂銆傛澶栬繕闇�鍦ㄣ�孉I 澶фā鍨嬨�嶉噷閰嶅ソ瀵硅瘽妯″瀷涓庡瘑閽ャ��
@@ -250,8 +230,8 @@
       max-xlsx-rows: 300 # Excel 鍗曡〃鏈�澶氳鍙栫殑琛屾暟
   database-backup: # 鏁版嵁搴撳浠介厤缃�
     host: 172.17.0.1 # 澶囦唤鐩爣 MySQL 涓绘満锛岀暀绌鸿嚜鍔ㄤ粠鏁版嵁婧� JDBC URL 瑙f瀽
-    port: 11101 # 澶囦唤鐩爣 MySQL 绔彛锛岀暀绌鸿嚜鍔ㄤ粠鏁版嵁婧� JDBC URL 瑙f瀽
-    database: ruoyi-vue-pro # 澶囦唤鐩爣鏁版嵁搴擄紝鐣欑┖鑷姩浠庢暟鎹簮 JDBC URL 瑙f瀽
+    port: 10000 # 澶囦唤鐩爣 MySQL 绔彛锛岀暀绌鸿嚜鍔ㄤ粠鏁版嵁婧� JDBC URL 瑙f瀽
+    database: jssm # 澶囦唤鐩爣鏁版嵁搴擄紝鐣欑┖鑷姩浠庢暟鎹簮 JDBC URL 瑙f瀽
     username: root # 澶囦唤璐﹀彿锛岀暀绌轰娇鐢ㄦ暟鎹簮璐﹀彿
     password: 'xd@123456..' # 澶囦唤瀵嗙爜锛岀暀绌轰娇鐢ㄦ暟鎹簮瀵嗙爜
     command: # mysqldump 鍛戒护锛岀暀绌鸿嚜鍔ㄦ娴嬮儴缃茬幆澧冿紙鏈満 mysqldump 鎴� Docker MySQL 瀹瑰櫒锛夛紱鍙墜鍔ㄦ寚瀹氾紝濡傦細docker exec mysql8 mysqldump

--
Gitblit v1.9.3