From 89495b99f06cd9d897105759924d7b73ae907b44 Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期六, 03 十月 2026 11:46:07 +0800
Subject: [PATCH] fix(部署): pack-deploy 补齐外置配置/启动脚本/docs/web 并修正模板端口(8090)

---
 HANDOFF.md |   25 +++++++++++++++++++++++++
 1 files changed, 25 insertions(+), 0 deletions(-)

diff --git a/HANDOFF.md b/HANDOFF.md
index f09daf0..a6b9243 100644
--- a/HANDOFF.md
+++ b/HANDOFF.md
@@ -4,6 +4,30 @@
 > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄��
 > **鍗忎綔绾﹀畾锛�2026-08-31锛�**锛氳銆屾彁浜ゃ��= 鏈湴 commit + 鎺ㄩ�佸埌杩滅 git锛坥rigin main锛孏itblit锛夛紝涓嶅啀鍙仛鏈湴 commit銆�
 
+## 鏈�鏂帮紙2026-10-03锛�
+
+### 琛ュ厖锛�10-03 涓嬪崍锛夛細鏈嶅姟鍣ㄩ儴缃叉姤 鈥淎ccess denied ... (using password: NO)鈥� 鈥斺�� 鏍瑰洜涓庝慨澶�
+- **鐜拌薄**锛氭妸 `deploy/traffic-audit-release-20261002/` 閮ㄧ讲鍒� `61.183.254.94` 鍚庯紝鍚庣鍚姩鎶� `java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)`銆�
+- **鏍瑰洜**锛歫ar 鍐呯疆閰嶇疆閲屽簱鍙ｄ护鏄崰浣嶇 `${TRAFFIC_DB_PASSWORD:}`锛堥粯璁ょ┖涓诧級锛岃�� 10-02 閭ｄ釜鍖�**鍙惈 jar + web + dist**锛屾病鏈夊缃� `application.yml`銆佹病鏈� `docs/`銆乣db/`銆佸惎鍔ㄨ剼鏈�傞儴缃叉満娌℃湁浠讳綍澶栭儴閰嶇疆瑕嗙洊锛孲pring 灏辨嬁绌哄瘑鐮佽繛鏈満 MySQL 鈫� `using password: NO`锛堟敞鎰忥細杩欐槸鈥滄湯浼犲瘑鐮佲�濓紝涓嶆槸瀵嗙爜閿欙級銆�
+- **鏈嶅姟鍣ㄤ晶涓�姝ヤ慨澶嶏紙鏃犻渶閲嶆墦鍖咃級**锛氬湪 jar 鍚岀骇鏀� `application.yml`锛屾妸 `spring.datasource.url/username/password` 鏀规垚鐜板満鐪熷疄鍊煎悗閲嶅惎鍗冲彲锛涗篃鍙敤鐜鍙橀噺 `TRAFFIC_DB_PASSWORD` 浠ｆ浛銆傚惎鍔ㄨ剼鏈凡鍔犻妫�鎻愰啋锛堢己 `application.yml` / password 浠嶆槸鍗犱綅鏂囧瓧閮戒細 WARN锛夈�備慨澶嶅悗鑻ユ姤鈥滄湭鎵惧埌鏁版嵁鐩綍 docs鈥濆垯璇存槑鍖呭唴缂� `backend/docs`锛屼粠鏂板寘鎴栨簮鏈哄櫒鎷枫��
+- **鎵撳寘宸ュ叿宸蹭慨锛堝師 鈥滄墦鍖呭伐鍏峰緟淇�� 涓ら」鍧囧凡钀藉疄锛�**锛歚pack-deploy.ps1` 閲嶅啓涓轰簲姝ワ細鈶� 鐢ㄦ柊澧炴ā鏉� `deploy-templates/jar-application.yml`锛�**鍏ㄥ崰浣嶇**锛変复鏃舵浛鎹㈡簮鐮侀厤缃悗 `mvn clean package`锛屾棤璁烘垚璐ラ兘杩樺師鐪熷疄閰嶇疆锛涒憽 瑙ｅ帇 jar 鍘诲瘑鑷锛涒憿 鍓嶇鏋勫缓锛涒懀 缁勮**瀹屾暣鍖�**锛歚backend/{jar, application.yml, start-backend.cmd/.sh, docs/, web/}` + `frontend/dist` + `db/*.sql` + README锛坄backend/web` 浠� dist 鑷姩鍚屾锛岄�愭枃浠朵竴鑷达級锛涒懁 鏁村寘鏄庢枃瀵嗛挜鎵弿銆傛柊澧� `-SkipBackend` 鍙鐢ㄧ幇鏈� jar 蹇�熼噸缁勫寘銆�
+- **妯℃澘鍚屾淇**锛歚deploy-templates/backend/application.yml` 鐨� `server.port` 鐢� 8080 鏀瑰洖 8090锛堝師鍊间細瀵艰嚧鍚庣璧峰湪 8080锛夈�佽ˉ `static-locations: file:./web/` 涓� password 闄烽槺娉ㄩ噴锛沗README-閮ㄧ讲璇存槑.txt` 甯歌闂鏂板璇ユ姤閿欏缃紱`docs/鎵撳寘閮ㄧ讲璇存槑.md` 鎺掗敊琛ㄦ柊澧炶琛岋紱`application.yml.example` 鐜鍙橀噺鍚嶇粺涓�涓� `TRAFFIC_DB_USER/TRAFFIC_DB_PASSWORD/TRAFFIC_JWT_SECRET`锛堝師鏉ヨ鐢� `MYSQL_PASSWORD`/`JWT_SECRET`锛屼笌 `start-dev.ps1` 涓嶄竴鑷达級銆�
+- **鏂板寘锛堟湰鍦帮紝涓嶅叆搴擄級**锛歚deploy/traffic-audit-deploy-20261003/`锛�388 鏂囦欢 / 93.07 MB锛寊ip 76.37 MB锛夛紝宸查獙璇侊細jar 鍐呯疆閰嶇疆鍏ㄥ崰浣嶇锛堝幓瀵嗚嚜妫�閫氳繃锛夈�乣backend/web` 涓� `frontend/dist` 閫愭枃浠朵竴鑷达紙鍚� 44 涓級銆乣backend/docs/鐢熸垚姹囨�诲ぇ琛╜ 姣嶇増瀛樺湪銆乣鍔熻兘娴嬭瘯鎶ュ憡/宸ヤ綔鏃ョ粨/闂姹囨��/_cache` 宸叉帓闄ゃ��
+- **韪╁潙锛堥噸瑕侊級**锛氭湰鏈� PowerShell 5.1 鎶婃棤 BOM 鐨� `.ps1` 褰� ANSI 璇伙紝涓枃娉ㄩ噴浼氬彉鎴愪贡鐮佸苟瀵艰嚧鑴氭湰瑙ｆ瀽澶辫触銆俙pack-deploy.ps1` 蹇呴』淇濆瓨涓� **UTF-8 with BOM**锛堜粨搴撳叾浠� `*.ps1` 涔熼兘鏄� BOM锛夛紱鎺掓煡涓浘瀹為檯韪╁埌銆�
+
+- **杩愯鐘舵�侊紙鍐欎氦鎺ユ椂锛�**锛氬悗绔� 8090銆佸墠绔� 8080 鍧囨湭鐩戝惉锛涙柊瀵硅瘽濡傜户缁紑鍙戞垨娴嬭瘯锛屽厛鎵ц `powershell -NoProfile -ExecutionPolicy Bypass -File start-dev.ps1`銆傛暟鎹簱浠嶄负 `127.0.0.1:3305/traffic_audit`锛孧ySQL 鏈嶅姟鏈仠銆�
+- **鍙戝竷鏋勫缓锛堝凡瀹屾垚锛�**锛氬簲鈥滃彂甯冪紪璇戔�濊姹傦紝宸插畬鎴愬悗绔� `mvn clean package -DskipTests` 鍜屽墠绔� `npm run build`銆俲ar 鍐呭凡鍋氬幓瀵嗚嚜妫�锛屽彧淇濈暀鐜鍙橀噺鍗犱綅绗︼紱鏋勫缓鍚庢湰鏈虹湡瀹� `src/main/resources/application.yml` 宸插師鏍锋仮澶嶃��
+- **鍙戝竷浜х墿锛堟湰鍦帮紝鏈叆搴擄級**锛�
+  - 鍚庣 jar锛歚traffic-audit-server/target/traffic-audit-server-1.0.0-SNAPSHOT.jar`锛堢害 54.6 MB锛�
+  - 鍓嶇锛歚traffic-audit-web/dist`锛�44 涓枃浠躲�佺害 3.55 MB锛�
+  - 鍙戝竷鐩綍锛歚deploy/traffic-audit-release-20261002/`锛堝惈 `backend/`銆乣frontend/dist/`锛�
+  - 鍙戝竷鍘嬬缉鍖咃細`deploy/traffic-audit-release-20261002.zip`锛堢害 51.11 MB锛�
+- **鍙戝竷鍖呯粨鏋勮鏄�**锛歚frontend/dist` 鏄爣鍑嗗墠绔彂甯冪洰褰曪紱`backend/web` 鏄悓涓�浠� dist 鐨勫壇鏈紝鐢ㄤ簬鍚庣 8090 鍗曠鍙ｆā寮忥紙褰撳墠闈欐�佽祫婧愯矾寰勪负 `file:./web/,classpath:/static/`锛夈�備袱澶勫凡閫愭枃浠舵瘮瀵癸紝鏂囦欢鍒楄〃涓� SHA-256 瀹屽叏涓�鑷淬��
+- **瀹夊叏鐘舵��**锛氭湰鏈虹湡瀹為厤缃凡淇濆瓨鍦ㄨ蹇界暐鐨� `traffic-audit-server/config/application.yml`锛涘彂甯� jar 涓嶅惈鐪熷疄鏁版嵁搴撳彛浠ゃ�丣WT secret 鎴� DeepSeek key銆傚彂甯冨寘涓嶅寘鍚儴缃叉満鐨勭湡瀹炲閮ㄩ厤缃紝閮ㄧ讲鏃堕渶瑕佺户缁娇鐢ㄧ幇鍦� `application.yml` 鎴栨寜妯℃澘濉啓銆�
+- **鎵撳寘宸ュ叿寰呬慨锛堥噸瑕侊級**锛歚pack-deploy.ps1` 鐩墠鐩存帴娑堣垂 `src/main/resources/application.yml`锛岃嫢璇ユ枃浠惰鏈満鐪熷疄閰嶇疆瑕嗙洊锛屼細鍦ㄥ幓瀵嗚嚜妫�闃舵涓锛涗笖瀹冨彧鎶� dist 鏀惧埌 `frontend/dist`锛屾病鏈夊悓姝ュ埌 `backend/web`锛岄粯璁ゅ寘鏃犳硶鐩存帴鐢ㄤ簬 8090 鍗曠鍙ｆā寮忋�傛湰娆′娇鐢ㄢ�滀复鏃跺崰浣嶇閰嶇疆 鈫� 鏋勫缓鑷 鈫� 鎭㈠鐪熷疄閰嶇疆鈥濈殑鏂瑰紡瀹屾垚銆備笅娆″彂甯冨墠寤鸿鏀逛负浠� `application.yml.example` 鐢熸垚涓存椂璧勬簮锛屽苟鍦ㄧ粍瑁呴樁娈靛悓鏃跺鍒� `backend/web`銆�
+- **Git/宸ヤ綔鍖猴紙鏈鏇存柊鍓嶏級**锛歚HEAD = origin/main = 37f5209`锛涘綋鍓嶆棤宸茶窡韪枃浠舵敼鍔ㄣ�傛湭璺熻釜椤规湁 `_tmp_holiday_verify/`锛堝巻鍙查獙璇佷骇鐗╋級鍜� `docs.zip`锛堢害 31.6 MB锛岀敤鎴锋湰鍦颁骇鐗╋級锛涗簩鑰呭潎淇濈暀锛屾柊瀵硅瘽涓嶈璇垹鎴栬鎻愪氦銆�
+- **涓嬩竴姝�**锛氬闇�閮ㄧ讲锛岀洿鎺ヤ娇鐢ㄤ笂闈㈠彂甯冪洰褰曟垨 zip锛涘闇�缁х画淇鍙戝竷宸ュ叿锛屽厛瀹炵幇鈥滃崰浣嶇妯℃澘鑷姩鍒囨崲 + `backend/web` 鑷姩缁勮 + jar 鍘诲瘑鑷鈥濆悗鍐嶉噸鏂颁骇鍑哄彂甯冨寘銆�
+
 ## 鏈�鏂帮紙2026-10-02锛�
 
 - **鏂版ā鍧楋紙鐢ㄦ埛宸查獙鏀讹紝鏈鎻愪氦/鎺ㄩ�侊級**锛氭柊澧炩�滀笓椤圭粺璁�-閲嶈鑺傚亣鏃モ�濇ā鍧楋紝鍚妭鍋囨棩閰嶇疆銆佽惀涓氭�у娴併�侀潪钀ヤ笟鎬ц溅娴併�佸杩愮郴鏁� 4 寮犺〃锛涚郴缁熼厤缃彍鍗曚粎 admin 鍙淮鎶わ紝涓撻」缁熻-鑺傚亣鏃ユ敮鎸佸鍏ャ�佸鍑恒�佹ā鏉夸笅杞藉拰 Word 蹇姤涓嬭浇銆�
@@ -19,6 +43,7 @@
 - **蹇姤鐧惧垎姣旂簿搴︼紙2026-10-02 杩藉姞锛�**锛歐ord 蹇姤涓悓姣�/鐜瘮鐧惧垎姣旂粺涓�淇濈暀1浣嶅皬鏁帮紙濡�6.79%鏄剧ず6.8%銆�11.46%鏄剧ず11.5%锛夛紱浜烘銆佽溅娴佺瓑涓氬姟鏁板�间粛淇濈暀2浣嶅皬鏁般��
 - **楠岃瘉缁撴灉**锛氬悗绔紪璇戙�佸墠绔瀯寤恒�佹潈闄�/CRUD/璐熷悜瀵煎叆銆佸巻鍙插彉鏇翠袱闃舵瀵煎叆銆丒xcel 瀵煎嚭銆乄ord 蹇姤銆佸墠绔� admin/闈� admin 鐑熸祴鍧囬�氳繃锛涜彍鍗曢『搴忋�佸杩愮郴鏁� 2.4 灞曠ず锛堢郴缁熼厤缃〉 + 鑺傚亣鏃ョ粺璁￠〉锛夈�乣decimal(30,15)` 鍒楀瀷銆佸巻鍙插彉鏇翠袱闃舵瀵煎叆鍥炲綊鍧囧凡瀹炴祴锛涘姛鑳芥祴璇曟姤鍛婁笌宸ヤ綔鏃ョ粨鎸� 2026-09-27 鎻愪氦瑙勮寖浠呮湰鍦扮暀瀛橈紙涓嶅叆搴擄級锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_閲嶈鑺傚亣鏃ヤ笓椤圭粺璁2026-10-02.md`銆乣docs/宸ヤ綔鏃ョ粨/宸ヤ綔鏃ョ粨_2026-10-02.md`銆�
 - **杩愯鐘舵��**锛氬悗绔� 8090銆佸墠绔� 8080 宸插惎鍔紱鏁版嵁搴� `127.0.0.1:3305/traffic_audit`銆傛祴璇曚骇鐢熺殑 2026 涓存椂鏁版嵁鍜屽鍏ユ壒娆″凡娓呯悊銆�
+- **鍏虫満鏀跺熬锛�2026-10-02锛�**锛氬凡鍋滄帀鏈寮�鍙戠敤鍚庣 8090銆佸墠绔� 8080 鍙婂悇鑷繘绋嬫爲锛岀鍙ｅ潎宸查噴鏀撅紱MySQL 鏈嶅姟淇濈暀銆傚綋鍓嶅彲瀹夊叏鍏虫満銆�
 - **Git**锛氱敤鎴峰凡浜� 2026-10-02 鏄庣‘楠屾敹閫氳繃锛涙湰娆℃寜瑕佹眰鍚堝苟杩滅 `origin/main` 鍚庢彁浜ゅ苟鎺ㄩ�侊紝涓嶈鐩栬繙绔悓浜嬫彁浜ゃ��
 - **閮ㄧ讲妯℃澘鍚屾**锛氳妭鍋囨棩 4 寮犺〃宸插悓姝ュ埌 `deploy-templates/db/init.sql`锛沗sql_holiday.sql` 鍙婁袱涓棫搴撹縼绉昏剼鏈殢閮ㄧ讲鍖呭彂甯冿紝閬垮厤鏂板寘缂鸿〃銆�
 

--
Gitblit v1.9.1