{"id":20219,"date":"2025-04-19T02:58:45","date_gmt":"2025-04-18T18:58:45","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/20219.html"},"modified":"2025-04-19T02:58:45","modified_gmt":"2025-04-18T18:58:45","slug":"2024fic%e5%86%b3%e8%b5%9b%e6%9c%8d%e5%8a%a1%e5%99%a8%e9%83%a8%e5%88%86%e5%a4%8d%e7%8e%b0wp","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/20219.html","title":{"rendered":"2024fic\u51b3\u8d5b\u670d\u52a1\u5668\u90e8\u5206\u590d\u73b0wp"},"content":{"rendered":"<p style=\"margin-left:0px;text-align:justify\">\u7b14\u8005\u5728\u91cd\u6784\u7f51\u7ad9\u7684\u65f6\u5019\u53d1\u73b0\u6709\u5e08\u5085\u662f\u901a\u8fc7\u7ed5\u5bc6\u548c\u6dfb\u52a0\u8def\u7531\u7aef\u53e3\u6620\u5c04\u5b9e\u73b0\u7684&#xff0c;\u6df1\u611f\u8fd9\u79cd\u65b9\u6cd5\u7684\u7b80\u5355\u660e\u4e86\u3001\u6e05\u6670\u6613\u61c2&#xff0c;\u7b14\u8005\u5f3a\u70c8\u63a8\u8350\u3002\u5728\u8fd9\u91cc\u7b14\u8005\u63d0\u4f9b\u4e86\u4e24\u79cd\u91cd\u6784\u7f51\u7ad9\u7684\u65b9\u6cd5&#xff0c;\u4f9b\u5927\u5bb6\u53c2\u8003<\/p>\n<p style=\"margin-left:0px;text-align:justify\">\u6302\u8f7d\u5bc6\u7801&#xff1a;2024Fic~Competition~Finals&#064;\u676d\u5dde&amp;Powered~By~HL!<\/p>\n<h3 style=\"margin-left:0px;text-align:justify\"><\/h3>\n<h3 style=\"margin-left:0px;text-align:justify\">PVE\u865a\u62df\u5316\u5e73\u53f0<\/h3>\n<p style=\"margin-left:0;text-align:justify\">\u5c06\u7cfb\u7edf\u955c\u50cf\u548c\u6570\u636e\u955c\u50cf\u4e00\u6b21\u5bfc\u5165\u8fdb\u884c\u4eff\u771f<\/p>\n<p style=\"margin-left:0;text-align:justify\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"768\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185828-6802a0d4c0d47.png\" width=\"1200\" \/><\/p>\n<p style=\"margin-left:0;text-align:justify\">\u8fd9\u91cc\u5f00\u5d4c\u5957\u865a\u62df\u5316\u5931\u8d25\u7684&#xff0c;\u7b14\u8005\u63d0\u4f9b\u4e00\u4e2a\u53c2\u8003\u89e3&#xff08;\u5f04\u4e86\u6211\u6574\u6574\u4e24\u4e2a\u5c0f\u65f6QAQ&#xff09;<\/p>\n<p style=\"margin-left:0;text-align:justify\">\u5173\u4e8e\u865a\u62df\u5316\u7684Inter VT-x\u7684\u95ee\u9898\u5904\u7406_virtualizationfirmwareenabled-CSDN\u535a\u5ba2<\/p>\n<p style=\"margin-left:0;text-align:justify\">\u8981\u5173VBS&#xff08;\u57fa\u4e8e\u865a\u62df\u5316\u5b89\u5168&#xff09;\u6709\u4e2a\u811a\u672c&#xff0c;\u53ef\u4ee5\u53bb\u7f51\u4e0a\u641c\u4e00\u4e0b&#xff0c;\u7b14\u8005\u8fd9\u91cc\u4e0d\u518d\u8d58\u8ff0<\/p>\n<p style=\"margin-left:0;text-align:justify\">\n<h4 style=\"margin-left:0px;text-align:justify\">1 PVE\u865a\u62df\u5316\u5e73\u53f0\u7248\u672c\u53f7\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;1.1.1\u3011<\/h4>\n<p style=\"margin-left:0;text-align:justify\">\n<p style=\"margin-left:0;text-align:justify\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"916\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185829-6802a0d52bc46.png\" width=\"1200\" \/><\/p>\n<p style=\"margin-left:0;text-align:justify\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"800\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185829-6802a0d5c2b6c.png\" width=\"1200\" \/><\/p>\n<p style=\"margin-left:0;text-align:justify\">\u770b\u5230\u4e86\u7ba1\u7406ip\u4e3a192.168.71.133:8006&#xff0c;\u800c\u4e14\u6709\u4e00\u5f20\u7f51\u5361\u7684\u9759\u6001ip\u5c31\u662f71\u7f51\u6bb5&#xff0c;\u90a3\u6211\u4eec\u5148\u6539\u865a\u62df\u7f51\u5361\u8bbe\u7f6e&#xff0c;\u6539\u621071\u7f51\u6bb5<\/p>\n<p style=\"margin-left:0;text-align:justify\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"557\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185830-6802a0d62d279.png\" width=\"609\" \/><\/p>\n<p style=\"margin-left:0px;text-align:justify\">\u6539\u597d\u4ee5\u540e\u5c31\u53ef\u4ee5\u8fdb\u865a\u62df\u5316\u5e73\u53f0\u4e86&#xff0c;\u5de6\u4e0a\u89d2\u770b\u5230\u7248\u672c\u53f7<\/p>\n<p style=\"margin-left:0;text-align:justify\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185830-6802a0d651552.png\" width=\"1200\" \/><\/p>\n<p style=\"margin-left:0;text-align:justify\">\n<h4 style=\"margin-left:0px;text-align:justify\">2. PVE\u865a\u62df\u5316\u5e73\u53f0\u7684web\u7ba1\u7406\u5730\u5740\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;192.168.1.1:22\u3011<\/h4>\n<p style=\"margin-left:0;text-align:justify\">\u89c1\u4e0a\u9898<\/p>\n<p style=\"margin-left:0;text-align:justify\">\n<h4 style=\"margin-left:0px;text-align:justify\">3. \u5728PVE\u865a\u62df\u5316\u5e73\u53f0\u4e2d&#xff0c;\u5f53\u524d\u5171\u6709\u591a\u5c11\u4e2a\u865a\u62df\u673a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;1\u3011<\/h4>\n<p style=\"margin-left:0;text-align:justify\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"957\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185830-6802a0d6ee581.png\" width=\"1200\" \/><\/p>\n<p style=\"margin-left:0;text-align:justify\">\u7c7b\u578b\u91cc\u6709\u4e09\u79cd&#xff1a;lxc\u2014\u2014\u7528\u4e8e\u7ba1\u7406\u5bb9\u5668&#xff1b;qemu\u2014\u2014\u7528\u4e8e\u7ba1\u7406\u865a\u62df\u673a&#xff1b;sdn\u2014\u2014\u7528\u4e8e\u7ba1\u7406\u7f51\u7edc&#xff1b;storage\u2014\u2014\u7528\u4e8e\u7ba1\u7406\u6570\u636e&#xff1b;\u6570qemu\u5373\u53ef&#xff0c;\u51717\u4e2a<\/p>\n<p style=\"margin-left:0;text-align:justify\">\n<h4 style=\"margin-left:0px;text-align:justify\">4. PVE\u865a\u62df\u5316\u5e73\u53f0\u7684\u201cvmbr1\u201d\u7f51\u5361\u6240\u4f7f\u7528\u7684\u7f51\u6bb5\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;192.168.1.0\/11\u3011<\/h4>\n<p style=\"margin-left:0;text-align:justify\">100<\/p>\n<p style=\"margin-left:0;text-align:justify\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1080\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185831-6802a0d792c8e.png\" width=\"1200\" \/><\/p>\n<p style=\"margin-left:0;text-align:justify\">\n<h4>5.PVE\u865a\u62df\u5316\u5e73\u53f0\u4e2d\u201d120(Luck)\u201d\u865a\u62df\u673a\u7684smbios uuid\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;123abc-123ba-123ad-23ab-12345abczc\u3011<\/h4>\n<p>\u865a\u62df\u673a\u7684smbios uuid\u662f\u865a\u62df\u673a\u6807\u8bc6\u7684\u610f\u601d&#xff0c;\u552f\u4e00<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185832-6802a0d88ede1.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>6.\u5728PVE\u865a\u62df\u5316\u5e73\u53f0\u4e2d&#xff0c;\u7528\u6237\u201cLu2k\u201d\u88ab\u6388\u4e88\u4e86\u591a\u5c11\u4e2a\u865a\u62df\u673a\u7684\u4f7f\u7528\u6743\u9650&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;1\u3011<\/h4>\n<p>\u6328\u4e2a\u70b9\u4e00\u4e0b&#xff0c;\u4e00\u5171\u67094\u4e2a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"957\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185833-6802a0d93d130.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>7.\u5728PVE\u865a\u62df\u5316\u5e73\u53f0\u4e2d&#xff0c;shell\u5386\u53f2\u547d\u4ee4\u4e2d\u6700\u540e\u4e00\u6761\u547d\u4ee4\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;hello world\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1080\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185833-6802a0d9dbe4f.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>8.\u8bf7\u5206\u6790\u5acc\u7591\u4eba\u6700\u8fd1\u4e00\u6b21\u9500\u6bc1\u865a\u62df\u673a\u7684\u65f6\u95f4\u4e3a<\/h4>\n<p>A.2024-03-13 10:34:20<\/p>\n<p>B.2024-03-22 18:06:15<\/p>\n<p>C.2024-03-22 18:15:17<\/p>\n<p>D.2024-03-22 18:20:55<\/p>\n<p>\u770b\u65e5\u5fd7<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185834-6802a0dad7f7b.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>9.PVE\u865a\u62df\u5316\u5e73\u53f0\u7684openEuler\u7cfb\u7edf\u955c\u50cf\u4e0b\u8f7d\u7684\u5f00\u59cb\u65f6\u95f4\u4e3a&#xff1f;<\/h4>\n<p>A.2024-03-12 12:03:12<\/p>\n<p>B.2024-03-12 12:04:19<\/p>\n<p>C.2024-03-12 12:10:09<\/p>\n<p>D.2024-03-12 12:11:02<\/p>\n<p>\u6839\u636e\u9009\u9879\u6307\u5b9a12\u53f712\u70b9\u5de6\u53f3\u53bb\u770b<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185835-6802a0db856d0.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>10.\u6839\u636e\u5acc\u72af\u4f9b\u8ff0&#xff0c;\u53ef\u901a\u8fc7\u5feb\u7167\u542f\u52a8PVE\u865a\u62df\u5316\u5e73\u53f0\u4e2d\u7684\u4e91\u624b\u673a\u3002\u8bf7\u6839\u636e\u8be5\u6761\u7ebf\u7d22\u627e\u5230\u5bf9\u5e94\u865a\u62df\u673a&#xff0c;\u5176\u5feb\u7167\u7684\u65f6\u95f4\u4e3a<\/h4>\n<p>A.2024-03-12 11:02:32<\/p>\n<p>B.2024-03-12 11:24:11<\/p>\n<p>C.2024-03-13 10:34:20<\/p>\n<p>D.2024-03-13 9:43:23<\/p>\n<p>\u770b\u4efb\u52a1\u5386\u53f2\u6bd4\u8f83\u63a5\u8fd1D&#xff0c;\u5176\u5b83\u9009\u9879\u90fd\u4e0d\u592a\u5bf9<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185836-6802a0dc33824.png\" width=\"1200\" \/><\/p>\n<p>\u770b\u5230\u662fVM102\u7684\u955c\u50cf&#xff0c;\u5c31\u53bb\u770b102<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185836-6802a0dcdbb08.png\" width=\"1200\" \/><\/p>\n<p>\u8fd9\u4e2a\u65f6\u95f4\u5c31\u5bf9\u4e86<\/p>\n<\/p>\n<h3>\u8f6f\u8def\u7531\u90e8\u5206<\/h3>\n<p>\u865a\u62df\u673a\u8981\u5206\u914d\u591a\u4e00\u70b9cpu<\/p>\n<h4>1. \u8f6f\u8def\u7531root\u7528\u6237\u7684\u5bc6\u7801\u662f&#xff1f;\u3010\u7b54\u9898\u683c\u5f0f&#xff1a;abc123\u3011<\/h4>\n<p>\u6253\u5f00router\u7684\u63a7\u5236\u53f0\u770b\u4e00\u4e0bip&#xff0c;\u53d1\u73b0\u662f.71.100<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"933\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185837-6802a0dd87592.png\" width=\"1200\" \/><\/p>\n<p>\u5bf9\u5e94\u524d\u9762\u7684\u68c0\u6750Personal.E01\u53ef\u4ee5\u5f97\u77e5\u8be5ip\u7684\u5bc6\u7801<\/p>\n<\/p>\n<h4>2. \u8f6f\u8def\u7531\u7ba1\u7406\u9762\u677f\u6240\u7528http\u534f\u8bae\u76d1\u542c\u7684\u7aef\u53e3\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;7001\u3011<\/h4>\n<p>netstat -lntp <\/p>\n<p>\u770b\u4e00\u4e0buhttpd\u5bf9\u5e94\u7684\u5c31\u662fhttp\u534f\u8bae\u76d1\u542c\u7684&#xff0c;\u6709443\u548c8080&#xff0c;\u90fd\u8bd5\u4e00\u4e0b<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"933\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185838-6802a0de35191.png\" width=\"1200\" \/><\/p>\n<p>\u7ed3\u679c\u662f8080<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1200\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185838-6802a0ded5ede.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>3. \u8f6f\u8def\u7531\u7684\u7cfb\u7edf\u7248\u672c\u53f7\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;1.1.1\u3011<\/h4>\n<p>\u7528\u4e0a\u9762\u7684\u5bc6\u7801\u767b\u5f55<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1200\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185841-6802a0e1a36bf.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>4. \u8f6f\u8def\u7531\u7684WAN\u53e3\u6240\u914d\u7f6e\u7684\u7f51\u5173\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;1.1.1.1\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"546\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185842-6802a0e2f37b7.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>5. \u8f6f\u8def\u7531\u9632\u706b\u5899\u7aef\u53e3\u8f6c\u53d1\u89c4\u5219\u6709\u591a\u5c11\u6761\u8bb0\u5f55\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;1\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1200\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185843-6802a0e388bdf.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>6. OpenClash\u63a7\u5236\u9762\u677f\u767b\u5f55\u5bc6\u94a5\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f: Abc123\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1200\" src=\"2025-04-19fmsw2xybj0g.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>7 OpenClash\u7684\u5c40\u57df\u7f51\u4ee3\u7406\u5bc6\u7801(SOCKS5\/HTTP\u8ba4\u8bc1\u4fe1\u606f)\u4e3a&#xff1f;\u3010\u7b54\u9898\u683c\u5f0f&#xff1a;Abc123\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1200\" src=\"2025-04-19zwcti1bmx0d.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>8. OpenClash\u7684\u8ba2\u9605\u5730\u5740\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;https:\/\/www.forensix.cn\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1200\" src=\"2025-04-19kgtajw5hxb1.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>9. \u4ee3\u7406\u8282\u70b9&#034;\u9999\u6e2f501 \u4e2d\u7ee7 \u52a8\u6001&#034;\u7684\u670d\u52a1\u7aef\u53e3\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1200\" src=\"2025-04-19x3n20isyahi.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>10. OpenWrt\u7684\u5305\u7ba1\u7406\u8f6f\u4ef6\u7684\u7cfb\u7edf\u955c\u50cf\u6e90\u914d\u7f6e\u6587\u4ef6\u7684\u7edd\u5bf9\u8def\u5f84\u662f&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;\/root\/hl\/abc.conf\u3011<\/h4>\n<p>\/etc\/opkg\/distfeeds.conf<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1200\" src=\"2025-04-19gw1dikzjhet.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h3>\u4e91\u624b\u673a\u90e8\u5206<\/h3>\n<h4>1. PVE\u865a\u62df\u5316\u5e73\u53f0\u7684\u865a\u62df\u673a&#034;101(node1)&#034;\u7684droid\u7528\u6237\u767b\u5f55\u5bc6\u7801\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:Abc123\u3011<\/h4>\n<p>\u548c\u8f6f\u8def\u7531\u90e8\u5206\u7684\u7b2c\u4e00\u9898\u4e00\u6837&#xff0c;\u4e5f\u662f\u5728\u8ba1\u7b97\u673a\u955c\u50cf\u5206\u6790\u91cc\u5934\u6709&#xff0c;\u524d\u9762\u7528\u8fc7\u4e86.100\u7684\u5bc6\u7801&#xff0c;\u90a3\u5e94\u8be5\u5c31\u662f.137\u7684<\/p>\n<p>\u767b\u5f55\u6210\u529f<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1055\" src=\"2025-04-193cwdmaxkm13.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>2. PVE\u865a\u62df\u5316\u5e73\u53f0\u7684\u865a\u62df\u673a&#034;101(node1)&#034;\u4e2dDocker\u5bb9\u5668\u7684\u955c\u50cfID\u7684\u524d\u516d\u4f4d\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;abc123\u3011<\/h4>\n<p>docker images<\/p>\n<p>\u4f46\u662f\u8981\u5148sudo su\u5148\u63d0\u4e2a\u6743<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1050\" src=\"2025-04-190qb4zicjtlx.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>3. \u5728PVE\u865a\u62df\u5316\u5e73\u53f0\u7684node1\u865a\u62df\u673a\u4e2d&#xff0c;\u5bb9\u5668\u624b\u673a\u7684\u6570\u91cf\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;1\u3011<\/h4>\n<p>docker ps -a <\/p>\n<p>\u89c1\u4e0a\u56fe<\/p>\n<\/p>\n<h4>4. \u5728PVE\u865a\u62df\u5316\u5e73\u53f0\u7684node1\u865a\u62df\u673a\u4e2d,\u82e5\u8981\u542f\u52a8\u624b\u673a\u5bb9\u5668&#xff0c;\u6709\u51e0\u6761\u524d\u7f6e\u547d\u4ee4&#xff08;docker\u547d\u4ee4\u4e0d\u7eb3\u5165\u8ba1\u7b97&#xff09;? \u3010\u7b54\u6848\u683c\u5f0f&#xff1a;1\u3011<\/h4>\n<p>\u5907\u6ce8\u5199\u4e86\u600e\u4e48\u8d77,\u6240\u4ee5\u662f\u4e24\u6761<img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"946\" src=\"2025-04-19n0v3potwu0v.png\" width=\"1200\" \/><\/p>\n<p>history\u4e5f\u80fd\u770b<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1058\" src=\"2025-04-19etl1l0chckh.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>5.\u00a0\u5728PVE\u865a\u62df\u5316\u5e73\u53f0\u7684&#034;101(node1)&#034;\u865a\u62df\u673a\u4e2d\u542f\u52a8\u201cpriceless_knuth\u201d\u624b\u673a\u5bb9\u5668\u540e&#xff0c;\u8be5\u5b89\u5353\u624b\u673a\u7684\u84dd\u7259MAC\u5730\u5740\u662f\u591a\u5c11&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:\u00a012:34:ab:cd:a1:b2\u3011<\/h4>\n<p>\u5386\u53f2\u547d\u4ee4\u6709\u63d0\u793a&#xff0c;\u8fdb\u4e86\u8fd9\u4e2a\u5bb9\u5668\u7684shell<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"818\" src=\"2025-04-19ccg5ohgcefx.png\" width=\"1200\" \/><\/p>\n<p>\u6253\u5f00docker380&#xff0c;\u8fdb\u5165&#xff0c;ip a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"255\" src=\"2025-04-19mwrtlvzngvp.png\" width=\"1200\" \/><\/p>\n<p>\u8fd9\u91cc\u4e5f\u53ef\u4ee5\u628anode1\u5bfc\u51fa\u6765\u7528\u5f18\u8fde\u5206\u6790\u3002<\/p>\n<p>\u6211\u5c1d\u8bd5\u7528pve\u5236\u4f5c\u5907\u4efd&#xff0c;\u7136\u540e\u7528ssh\u8fde\u63a5\u5bfc\u51fa\u5907\u4efd&#xff0c;\u518d\u7528ftk\u8f6c\u6362\u6210.e01&#xff0c;\u4f46\u662f\u5931\u8d25\u4e86<\/p>\n<p>\u5176\u5b9e\u6839\u672c\u4e0d\u7528\u8fd9\u4e48\u9ebb\u70e6&#xff0c;\u5148\u8df3\u8f6c\u6e90\u6587\u4ef6<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"775\" src=\"2025-04-19tqgyn4m4ayj.png\" width=\"1200\" \/><\/p>\n<p>\u518d\u6dfb\u52a0\u5230\u68c0\u6750\u5c31\u53ef\u4ee5\u4e86<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"775\" src=\"2025-04-19lc3t33jsmtv.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>6. \u8b66\u65b9\u73b0\u573a\u52d8\u9a8c\u8fc7\u7a0b\u4e2d&#xff0c;\u66fe\u4f7f\u7528\u96f7\u7535\u624b\u673a\u53d6\u8bc1\u8f6f\u4ef6\u901a\u8fc7\u5acc\u7591\u4eba\u8f6f\u8def\u7531\u5bf9\u4e91\u624b\u673a\u8fdb\u884c\u4e86\u8fdc\u7a0b\u53d6\u8bc1&#xff0c;\u8bf7\u95ee\u4ee5\u4e0b\u54ea\u4e2a\u7aef\u53e3\u53ef\u4ee5\u660e\u786e\u662f\u53d6\u8bc1\u65f6\u4f7f\u7528\u8fc7\u7684\u7aef\u53e3&#xff1f;\u3010\u591a\u9009\u9898\u3011<\/h4>\n<p>A.11111<\/p>\n<p>B.12222<\/p>\n<p>C.13333<\/p>\n<p>D.23333<\/p>\n<p>E.24444<\/p>\n<p>F.35555<\/p>\n<p>\u4f9d\u636e\u4e0a\u9898\u4f9d\u6b21\u5bfc\u51fa&#xff0c;\u53d1\u73b0\u662fnode2\u91cc\u5934\u6709\u53d6\u8bc1\u8f6f\u4ef6<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"775\" src=\"2025-04-19jgqgydzvwuq.png\" width=\"1200\" \/><\/p>\n<p>\u6839\u636e\u524d\u9762\u7684\u8def\u7531\u89c4\u5219\u53ef\u4ee5\u5f97\u77e5&#xff0c;node2\u6709\u54ea\u4e9b\u7aef\u53e3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"897\" src=\"2025-04-19g3hxq5knccx.png\" width=\"1200\" \/><\/p>\n<h4>7. \u5728PVE\u865a\u62df\u5316\u5e73\u53f0\u7684node2\u4e2d\u540d\u4e3aloving_shtern\u7684\u624b\u673a\u6620\u5c04\u81f3\u8f6f\u8def\u7531\u4e2d&#xff0c;\u6240\u5360\u7528\u7684\u7aef\u53e3\u53f7\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p>\u5728node2\u627e\u5230\u8be5\u624b\u673a\u7684docker&#xff0c;\u8df3\u8f6c\u6e90\u6587\u4ef6<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"775\" src=\"2025-04-19bijuzgbsbn5.png\" width=\"1200\" \/><\/p>\n<p>\u53d1\u73b0\u5176\u6839\u76ee\u5f55\u4e0b\u6709\u5f88\u591a\u914d\u7f6e\u6587\u4ef6&#xff0c;\u7ffb\u4e00\u4e0b&#xff0c;\u53d1\u73b0\u624b\u673a\u662f5555\u7aef\u53e3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"775\" src=\"2025-04-19cugfghkny4f.png\" width=\"1200\" \/><\/p>\n<p>\u5728\u8def\u7531\u89c4\u5219\u91cc\u7528\u7684\u662f\u8def\u7531\u5668\u768425555\u7aef\u53e3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"897\" src=\"2025-04-19sm0lf5oaup5.png\" width=\"1200\" \/><\/p>\n<h4>8. \u5728PVE\u865a\u62df\u5316\u5e73\u53f0\u7684node2\u4e2dloving_shtern\u624b\u673a\u5bb9\u5668\u4e2d\u5b89\u88c5\u7684\u540d\u4e3a\u201c\u6296\u97f3\u201d\u5b89\u88c5\u5305\u7684MD5\u503c\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:abc123\u3011<\/h4>\n<p>\u6839\u636e\u521a\u521a\u7684\u914d\u7f6e\u6587\u4ef6\u6211\u4eec\u80fd\u770b\u5230\/data\u5206\u533a\u6620\u5c04\u5230\u4e86\/root\/data&#xff0c;\u6240\u4ee5\u5b89\u88c5\u5305\u5e94\u8be5\u5728node2\u7684\/root\/data\/app\/\u91cc\u3002\u53d1\u73b0\u6709\u56db\u4e2a\u6587\u4ef6\u5939&#xff0c;\u66b4\u529b\u4e00\u70b9\u5168\u90fd\u5f04\u53bb\u96f7\u7535\u5206\u6790\u5f97\u4e86<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19zjzfoe3jlpm.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>9. \u6839\u636e\u96c6\u7fa4\u4e2d\u624b\u673a\u5185\u5bb9\u5206\u6790&#xff0c;\u4f20\u9500\u4eba\u5458\u5728\u8bc4\u8bba\u533a\u5f15\u6d41\u4f7f\u7528\u7684qq\u53f7\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p>\u770b\u4e86\u522b\u7684\u5e08\u5085\u7684wp&#xff0c;\u53d1\u73b0\u4e86\u5f88\u6709\u610f\u601d\u7684\u4e00\u70b9&#xff0c;\u628anode1\u5f53\u5b89\u5353\u8fdb\u884c\u5206\u6790&#xff0c;\u80fd\u5f97\u5230TIM\u7684\u5206\u6790&#xff0c;\u5f97\u5230ID<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"775\" src=\"2025-04-19kp30kd42n1z.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>10. \u901a\u8fc7\u4e91\u624b\u673a\u804a\u5929\u8bb0\u5f55\u53ef\u4ee5\u5f97\u77e5&#xff0c;\u6d89\u6848\u4f20\u9500\u7f51\u7ad9\u57df\u540d\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;www.forensix.cn\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"775\" src=\"2025-04-19eyzovsdpybc.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h3>\u4f20\u9500\u7f51\u7ad9<\/h3>\n<h4><\/h4>\n<h4 style=\"background-color:transparent\">\u91cd\u6784\u7f51\u7ad9<\/h4>\n<p>\u5176\u5b9e\u8fd9\u91cc\u76f8\u5f53\u4e00\u90e8\u5206\u7684\u9898\u90fd\u53ef\u4ee5\u76f4\u63a5\u901a\u8fc7\u5f18\u8fde\u548c\u67e5\u770b\u914d\u7f6e\u6587\u4ef6\u6765\u770b&#xff0c;\u4f46\u662f\u603b\u5f52\u8fd8\u662f\u8981\u91cd\u6784\u7f51\u7ad9\u7684&#xff0c;\u6240\u4ee5\u65e9\u70b9\u665a\u70b9\u90fd\u8981\u91cd\u6784<\/p>\n<\/p>\n<p style=\"margin-left:0\">\u91cd\u6784\u7f51\u7ad9\u8981\u8d77\u6570\u636e\u5e93\u548c\u670d\u52a1\u5668&#xff0c;\u4e5f\u5c31\u662f\u8981\u8d77111\u548c112&#xff0c;\u5f53\u7136nginx&#xff08;110&#xff09;\u4e5f\u8981\u8d77<\/p>\n<h5 style=\"margin-left:0px\">\u65b9\u6cd5\u4e00&#xff1a;<\/h5>\n<p style=\"margin-left:0\">\u7531\u4e8e111&#xff08;javaserver&#xff09;\u548c112&#xff08;sqlserver&#xff09;\u6211\u4eec\u6ca1\u6709\u8d26\u53f7\u5bc6\u7801\u4e0d\u80fd\u76f4\u63a5\u5728pve\u542f\u52a8&#xff0c;\u5c31\u53ea\u80fd\u7528\u5f18\u8fde\u4eff\u771f\u7ed5\u5bc6&#xff0c;\u518d\u5f00\u542f\u91cc\u5934\u7684\u5bb9\u5668\u548c\u670d\u52a1<\/p>\n<p style=\"margin-left:0\">\u5148\u52a0\u4e00\u5f20100\u7f51\u6bb5\u7684\u7f51\u5361&#xff0c;\u56e0\u4e3a111\u548c112\u90fd\u662f100\u7f51\u6bb5\u7684<\/p>\n<p style=\"margin-left:0\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"777\" src=\"2025-04-19yptvnu3uurz.png\" width=\"899\" \/><\/p>\n<h5 style=\"margin-left:0px\">111&#xff1a;<\/h5>\n<p>ip a <\/p>\n<p style=\"margin-left:0\">\u53d1\u73b0\u6ca1\u6709ip&#xff0c;\u90a3\u5c31\u8981\u6539\u7f51\u5361\u8bbe\u7f6e<\/p>\n<p>vi \/etc\/netplan\/00-installer-config.yaml <\/p>\n<p style=\"margin-left:0\">\n<p style=\"margin-left:0\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"219\" src=\"2025-04-19semgmg1goxw.png\" width=\"1024\" \/><\/p>\n<p>apply netplan <\/p>\n<p style=\"margin-left:0\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1\" src=\"2025-04-19jjtoxb5tir1.png\" width=\"1\" \/>\u8fd9\u6837\u5c31\u6709ip\u4e86\u00a0<\/p>\n<h5 style=\"margin-left:0px\">112:<\/h5>\n<p style=\"margin-left:0\">ip a\u4e5f\u53d1\u73b0\u6ca1\u6709<\/p>\n<p>vi \/etc\/sysconfig\/network-scripts\/ifcfg-enp6s18 <\/p>\n<p style=\"margin-left:0\">\n<p style=\"margin-left:0\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"287\" src=\"2025-04-19pnqq02pyf5f.png\" width=\"1024\" \/><\/p>\n<p>systemctl restart NetworkManager <\/p>\n<p style=\"margin-left:0\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1\" src=\"2025-04-19ku3fk21d5ay.png\" width=\"1\" \/><\/p>\n<p style=\"margin-left:0\">\u53c2\u8003\u5f18\u8fde\u5206\u6790\u51fa\u6765\u7684111\u548c112\u7684\u5386\u53f2\u547d\u4ee4&#xff0c;\u8d77jar\u548cdocker&#xff08;\u628a111\u548c112\u7684\u547d\u4ee4\u590d\u5236\u7c98\u8d34\u4e00\u904d\u5c31\u884c&#xff09;<\/p>\n<p style=\"margin-left:0\">\n<h5 style=\"background-color:transparent;margin-left:0px\">\u00a0110&#xff1a;<\/h5>\n<p style=\"margin-left:0\">\u63d0\u793a\u8fc7\u4e86&#xff0c;\u5728pve\u7684\u5386\u53f2\u547d\u4ee4\u91cc\u6709&#xff0c;\u8fd9\u6837\u6211\u4eec\u5c31\u80fd\u8fdb\u5230nginx\u7684\u547d\u4ee4\u884c<\/p>\n<p>lxc-attach 110 <\/p>\n<p>\u95ee\u9898\u662f\u6211\u4eecping\u4e0d\u901a111\u548c112&#xff0c;\u53d1\u73b0\u662f100\u7f51\u6bb5\u6ca1\u6709\u6865\u63a5\u7aef\u53e3&#xff0c;\u52a0\u4e0aens36<\/p>\n<p>\u4e3a\u4ec0\u4e48\u662fens36\u5462&#xff0c;\u662f\u56e0\u4e3a\u6211\u4eec\u8981\u5148\u7ed9pve\u518d\u6dfb\u52a0\u4e00\u5f20\u7f51\u5361&#xff0c;100\u7f51\u6bb5\u7684\u7f51\u5361\u3002<\/p>\n<p>&#xff08;\u8fd9\u91cc\u56fe\u7247\u662f\u540e\u52a0\u7684&#xff0c;\u53ef\u80fd\u51fa\u73b0\u9898\u4e0d\u5bf9\u7248&#xff09;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1199\" src=\"2025-04-190jgqt0ulpo2.png\" width=\"1073\" \/><\/p>\n<p>\u6709\u4e86\u53cc\u7f51\u5361\u4ee5\u540epve\u5e73\u53f0\u4e0a\u7f51\u7edc\u5c31\u4f1a\u591a\u4e00\u4e2a\u8bbe\u5907&#xff0c;\u540d\u5b57\u5c31\u662fens36\u3002\u6211\u4eec\u8981\u505a\u7684\u5c31\u662f\u7ed9vmbr1\u6865\u63a5\u4e0aens36<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"592\" src=\"2025-04-19km553ppixzw.png\" width=\"784\" \/><\/p>\n<p>\u91cd\u542f&#xff0c;\u8fd9\u6837\u5c31\u80fdping\u901a\u4e86\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"676\" src=\"2025-04-19jgfgj4ku3t4.png\" width=\"1200\" \/><\/p>\n<p>\u6700\u540e\u7684\u6700\u540e&#xff0c;\u6211\u4eec\u770bnginx\u914d\u7f6e\u6587\u4ef6\u770b\u5230\u540e\u53f0\u7ba1\u7406\u7684\u57df\u540d\u548c\u8f6c\u53d1<\/p>\n<p>\u6240\u4ee5\u518d\u672c\u673a\u7684hosts\u6587\u4ef6\u91cc\u6dfb\u52a0\u57df\u540d\u89e3\u6790\u5373\u53ef<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1091\" src=\"2025-04-19grr1zewsoot.png\" width=\"1200\" \/><\/p>\n<p>\u590d\u5236\u9ecf\u8d34\u7f51\u5740&#xff0c;\u8981\u8f93\u5165\u8d26\u53f7\u5bc6\u7801&#xff0c;\u90a3\u5c31\u8981\u770b\u6570\u636e\u5e93&#xff0c;\u6570\u636e\u5e93\u8fde\u63a5\u8be6\u60c5\u8df3\u8f6c\u5341\u4e09\u9898<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"741\" src=\"2025-04-19i3ktpjkgzi3.png\" width=\"1200\" \/><\/p>\n<p>\u6539\u7ba1\u7406\u5458\u5bc6\u7801&#xff0c;\u5df2\u77e5\u5bc6\u7801\u52a0\u5bc6\u65b9\u5f0f\u4e3abcrypt&#xff0c;\u90a3\u6211\u4eec\u628aadmin\u7684\u5bc6\u7801\u6539\u6210123456\u7684bcrypt\u7684\u5bc6\u6587\u5c31\u884c\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19uq35w3y0kzi.png\" width=\"1200\" \/><\/p>\n<p>\u767b\u5f55\u6210\u529f\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19pjuoccz4zqt.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h5>\u65b9\u6cd5\u4e8c&#xff1a;&#xff08;\u66f4\u63a8\u8350&#xff09;<\/h5>\n<p>\u76f4\u63a5\u5728pve\u91cc\u901a\u8fc7\u7ed5\u5bc6\u7684\u65b9\u5f0f&#xff0c;\u8fdb\u5165111\u548c112&#xff0c;\u8d77sql\u548cjava<\/p>\n<p>\u5e76\u4e14\u76f4\u63a5\u7528\u63d0\u4f9b\u7684\u8f6f\u8def\u7531&#xff0c;\u6211\u4eec\u81ea\u5df1\u5199\u6620\u5c04\u89c4\u5219&#xff0c;\u628a\u7f51\u6bb5\u4e4b\u95f4\u7684\u901a\u8baf\u8f6c\u6362\u4e3a\u7aef\u53e3\u4e4b\u95f4\u7684\u6620\u5c04&#xff0c;\u5c31\u4e0d\u7528\u518d\u62c5\u5fc371\u548c100\u7f51\u6bb5\u4e4b\u95f4\u4e0d\u901a\u7684\u95ee\u9898\u4e86<\/p>\n<p>\u6211\u4eec\u4e00\u6b65\u4e00\u6b65\u7684\u6765&#xff1a;<\/p>\n<h5>\u9996\u5148\u662fsql\u548cjava\u7684\u7ed5\u5bc6<\/h5>\n<p>java\u7684\u7cfb\u7edf\u662fUbuntu&#xff0c;\u7b14\u8005\u8fd9\u91cc\u6f14\u793a\u4e00\u4e0b&#xff0c;\u5f00\u673a\u72c2\u6309esc&#xff0c;\u8fdbcontinue<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"676\" src=\"2025-04-19hfzboohymfb.png\" width=\"1200\" \/><\/p>\n<p>\u518d\u9a6c\u4e0a\u6309esc&#xff0c;\u8f93\u5165normal&#xff0c;\u518d\u9a6c\u4e0a\u6309esc<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"676\" src=\"2025-04-19unv45ktizd4.png\" width=\"902\" \/><\/p>\n<p>\u8fdb\u5165\u5f15\u5bfc\u9875\u9762&#xff0c;\u9009\u62e9\u7b2c\u4e8c\u9879\u76ee<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"676\" src=\"2025-04-19e5ywpdubjln.png\" width=\"902\" \/><\/p>\n<p>\u518d\u9009\u62e9\u7b2c\u4e8c\u4e2a\u6a21\u5f0f\u6309e\u8fdb\u884c\u4fee\u6539<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"676\" src=\"2025-04-19e1lx2uq1hcy.png\" width=\"902\" \/><\/p>\n<p>\u6539\u6210\u6211\u8fd9\u6837&#xff0c;\u518d\u6309f10\u8fdb\u884c\u4fdd\u5b58<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"676\" src=\"2025-04-1944goumgwhjf.png\" width=\"902\" \/><\/p>\n<p>passwd root\u4fee\u6539\u5bc6\u7801&#xff1b;touch\u00a0\/.autorelabel\u4fdd\u5b58&#xff1b;touch \/sbin\/init\u91cd\u542f<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"676\" src=\"2025-04-19dmvn4r3vkjp.png\" width=\"1082\" \/><\/p>\n<p>\u8fd9\u6837\u5bc6\u7801\u5c31\u4fee\u6539\u597d\u4e86<\/p>\n<\/p>\n<p>sql\u7684\u7cfb\u7edf\u662fopenEuler&#xff0c;\u5177\u4f53\u7ed5\u5bc6\u65b9\u5f0f\u7b14\u8005\u8d34\u5728\u8fd9\u91cc&#xff0c;\u5728pve\u91cc\u8ddf\u7740\u505a\u5c31\u884c<\/p>\n<p>\u3010HUAWEI-openeuler\u7cfb\u7edf\u5fd8\u8bb0\u5bc6\u7801\u4fee\u6539\u5bc6\u7801&#xff01;\u3011_openeuler\u91cd\u7f6e\u5bc6\u7801-CSDN\u535a\u5ba2<\/p>\n<\/p>\n<h5>\u63a5\u7740\u6211\u4eec\u8981\u91cd\u65b0\u8bbe\u7f6e\u8def\u7531<\/h5>\n<p>\u6211\u4eec\u80fd\u53d1\u73b0&#xff0c;\u8def\u7531&#xff08;71.100&#xff09;\u901a\u8fc780\u7aef\u53e3\u8f6c\u53d1\u7ed9192.168.100.110&#xff08;nginx&#xff09;\u768480\u7aef\u53e3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-193ztei5kryae.png\" width=\"1200\" \/><\/p>\n<p>\u90a3\u5f88\u660e\u663e&#xff0c;\u4e0d\u548cpve\u548c\u8def\u7531\u5728\u540c\u4e00\u7f51\u6bb5\u91cc\u7684javaserver\u548csqlserver\u662f\u4e0d\u901a\u7684&#xff0c;\u6211\u4eec\u5c31\u53ef\u4ee5\u53c2\u8003\u8fd9\u6837\u7684\u65b9\u5f0f&#xff0c;\u628a\u4e24\u4e2a\u670d\u52a1\u5668&#xff08;100.111\u548c100.112&#xff09;\u6620\u5c04\u5230\u8def\u7531&#xff08;71.100&#xff09;\u4e0a<\/p>\n<p>\u50cf\u8fd9\u6837&#xff0c;\u6211\u4eec\u5c31\u80fd\u901a\u8fc7\u8bbf\u95ee\u8def\u7531\u768444433\u7aef\u53e3\u6765\u8bbf\u95eejavaserver\u4e86&#xff0c;\u4e0d\u518d\u9700\u8981\u62c5\u5fc3\u4e0d\u901a\u7684\u95ee\u9898<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"754\" src=\"2025-04-19kwq04eogqgu.png\" width=\"1200\" \/><\/p>\n<p>\u540c\u7406&#xff0c;sqlserver\u4e5f\u662f\u4e00\u6837\u7684<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"753\" src=\"2025-04-19wy4dkhcmqon.png\" width=\"1200\" \/><\/p>\n<\/p>\n<p>\u81f3\u6b64\u6211\u4eec\u53ea\u9700\u8981\u628a\u670d\u52a1\u5668\u7684docker\u548cjar\u8d77\u8d77\u6765&#xff0c;\u518d\u6dfb\u52a0\u57df\u540d\u5e76\u4fee\u6539\u7ba1\u7406\u5458\u5bc6\u7801\u5373\u53ef&#xff0c;\u7f51\u7ad9\u91cd\u6784\u5b8c\u6210<\/p>\n<\/p>\n<h4>\u00a01. \u6d89\u6848\u670d\u52a1\u5668\u96c6\u7fa4\u4e2d&#xff0c;sql\u6570\u636e\u5e93\u670d\u52a1\u5668112&#xff08;sqlserver&#xff09;\u5bf9\u5e94\u7684\u865a\u62df\u78c1\u76d8\u7684SHA256\u503c\u4e3a&#xff1f;<\/h4>\n<p>\u56e0\u4e3a\u6211\u4eec\u5728pve\u91cc\u542f\u52a8\u8fc7112&#xff0c;\u6240\u4ee5SHA256\u4f1a\u53d8\u3002\u6211\u4eec\u8981\u91cd\u65b0\u4eff\u771f\u4e00\u4e2apve&#xff0c;\u4e0d\u5f00\u542f\u5d4c\u5957\u865a\u62df\u5316\u5373\u53ef&#xff0c;\u8fd9\u6837\u7684\u8bdd112\u4e0d\u4f1a\u81ea\u5df1\u542f\u52a8&#xff0c;SHA256\u5c31\u4e0d\u4f1a\u53d8\u3002<\/p>\n<p>cd \/mnt\/pve\/local\/images\/112<br \/>\nsha256sum vm-112-disk-0.qcow2 <\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"715\" src=\"2025-04-19xw3glznwaul.png\" width=\"1200\" \/><\/p>\n<\/p>\n<p>\u8fd9\u91cc\u76f4\u63a5\u5728\u5f18\u8fde\u91cc\u6dfb\u52a0\u4e3a\u65b0\u68c0\u6750\u4f1a\u5931\u8d25&#xff0c;\u7b14\u8005\u5c31\u5728finalshell\u8fde\u4e86\u518d\u4e0b\u8f7dsqlserver&#xff08;112&#xff09;<\/p>\n<h4>2. \u6d89\u6848\u670d\u52a1\u5668\u96c6\u7fa4\u4e2d&#xff0c;\u6570\u636e\u5e93\u670d\u52a1\u5668\u7684root\u7528\u6237\u5bc6\u7801\u52a0\u5bc6\u65b9\u5f0f\u4e3a&#xff1f;<\/h4>\n<p>\u68c0\u7d22shadow\u6587\u4ef6<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1200\" src=\"2025-04-19obpvwztj3hw.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>3. \u6d89\u6848\u670d\u52a1\u5668\u96c6\u7fa4\u4e2d&#xff0c;\u6570\u636e\u5e93\u670d\u52a1\u5668\u7684\u5185\u6838\u7248\u672c&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;1.1.1\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1200\" src=\"2025-04-19r3rvi3tuyhw.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>4. \u6d89\u6848\u670d\u52a1\u5668\u96c6\u7fa4\u4e2d&#xff0c;Java\u670d\u52a1\u5668web\u670d\u52a1\u76d1\u542c\u7684\u7aef\u53e3\u4e3a&#xff1f;\u3010\u591a\u9009\u9898\u3011<\/h4>\n<p>\u65b9\u6cd5\u4e00&#xff1a;javaserver\u5bf9\u5e94\u7684111\u865a\u62df\u673a&#xff0c;\u4f5c\u4e3a\u68c0\u6750\u5206\u6790&#xff0c;\u770b\u5230\u5386\u53f2\u547d\u4ee4\u7528\u4e86jar\u5305&#xff0c;\u89e3\u5305\u6765\u770b<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1123\" src=\"2025-04-19a4dzrnauchv.png\" width=\"1200\" \/><\/p>\n<p>\u4f46\u8fd9\u91cc\u6bd4\u8f83\u5751&#xff0c;\u5751\u5728\u6709\u4e24\u4e2ajar\u5305&#xff0c;\u5404\u7528\u4e86\u4e00\u4e2a\u7aef\u53e3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"332\" src=\"2025-04-19010nt2mh3vs.png\" width=\"1200\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1123\" src=\"2025-04-19b4lnqhpcy1q.png\" width=\"1200\" \/><\/p>\n<p>\u65b9\u6cd5\u4e8c&#xff1a;\u8fdb\u5230javaserver\u91cc\u5934\u770b\u7aef\u53e3\u4f7f\u7528\u60c5\u51b5<\/p>\n<p>netstat -lntp <\/p>\n<p>\u8fd9\u6837\u8fd8\u662f\u770b\u4e0d\u5230\u7aef\u53e3&#xff0c;\u662f\u56e0\u4e3a\u6211\u4eec\u4eff\u771f\u6ca1\u6709\u5f00\u90a3\u4e9b\u670d\u52a1<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1079\" src=\"2025-04-194gf1gubt2on.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>5. \u6d89\u6848\u670d\u52a1\u5668\u96c6\u7fa4\u4e2d&#xff0c;\u6570\u636e\u5e93\u670d\u52a1\u5668\u4e2dDocker\u5bb9\u5668\u7684\u6570\u91cf\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;1\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1200\" src=\"2025-04-19fv5k1fpuvq5.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>6.\u6d89\u6848\u670d\u52a1\u5668\u96c6\u7fa4\u4e2d&#xff0c;\u6570\u636e\u5e93\u670d\u52a1\u5668\u6709\u4e00\u4e2amysql\u5bb9\u5668\u8282\u70b9&#xff0c;\u8be5\u5bb9\u5668\u7684ID\u524d\u516d\u4f4d\u4e3a?\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;abc123\u3011<\/h4>\n<p>\u89c1\u4e0a\u56fe<\/p>\n<\/p>\n<h4>7.\u6d89\u6848\u670d\u52a1\u5668\u96c6\u7fa4\u4e2d&#xff0c;\u6570\u636e\u5e93\u670d\u52a1\u5668mysql\u5bb9\u5668\u8282\u70b9\u7684\u6570\u636e\u5e93\u7248\u672c\u53f7\u4e3a?\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;1.1.1\u3011<\/h4>\n<p>\u00a0<img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1200\" src=\"2025-04-19sgpkh5ybr1q.png\" width=\"1200\" \/><\/p>\n<h4>8.\u4ece\u5916\u90e8\u8bbf\u95ee\u6d89\u6848\u7f51\u7ad9&#034;\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf&#034;\u7ba1\u7406\u540e\u53f0\u6240\u4f7f\u7528\u7684\u57df\u540d\u4e3a&#xff1f;\u3010\u591a\u9009\u3011<\/h4>\n<p>\u7f51\u7ad9\u5e94\u8be5\u7531nginx\u7ba1\u7406&#xff08;110&#xff09;&#xff0c;\u6dfb\u52a0\u4e3a\u65b0\u68c0\u6750<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"775\" src=\"2025-04-19bgckedrvexr.png\" width=\"1200\" \/><\/p>\n<p>\u5f53\u7136\u6211\u4eec\u53bb\u770b\u53cd\u5411\u4ee3\u7406\u7684\u914d\u7f6e\u6587\u4ef6\u4e5f\u884c<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"775\" src=\"2025-04-19ygffbpecqar.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>9. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u6240\u4f7f\u7528\u7684\u7f51\u7ad9\u6846\u67b6\u4e3a&#xff1f;<\/h4>\n<p>\u8fd9\u9053\u9898\u662f\u5728\u524d\u9762\u91cd\u6784\u7f51\u7ad9111\u8d77javaserver\u7684jar\u5305\u53d1\u73b0\u7684&#xff0c;\u6bd5\u7adf\u90a3\u4e48\u5927\u4e2a\u4f5b\u7956\u4fdd\u4f51&#xff08;spring\u88ab\u66ff\u6362\u6389\u4e86&#xff09;<\/p>\n<p>\u5176\u5b9e\u5c31\u5199\u5728MANIFEST.MF\u6587\u4ef6\u91cc<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1079\" src=\"2025-04-19abrm1vytupn.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>10. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u8fd0\u884c\u65f6&#xff0c;\u4f9d\u8d56\u4e86\u51e0\u79cd\u4e0d\u540c\u7684\u6570\u636e\u5e93&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p>\u65e2\u7136\u8fd9\u4e2a\u7ba1\u7406\u540e\u53f0\u548c\u524d\u9762\u90a3\u4e2ajinyi.web.web.jar\u6709\u5173&#xff0c;\u90a3\u5927\u6982\u7387\u53bb\u770b\u8fd9\u4e2ajar\u5305\u91cc\u5934\u662f\u6709\u7684<\/p>\n<p>\u5176\u5b9e\u8fd9\u91cc\u8fd9\u4e2a\u7ba1\u7406\u540e\u53f0\u6307\u7684\u5c31\u662f\u524d\u9762\u7b2c\u56db\u9898\u7684\u7f51\u7ad9&#xff0c;\u7b2c\u56db\u9898\u7684\u56fe\u4e5f\u5199\u4e86\u4f7f\u7528\u4e86mysql\u548credis<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1123\" src=\"2025-04-19a4dzrnauchv.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>11. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u8fd0\u884c\u65f6&#xff0c;\u5728\u751f\u4ea7\u73af\u5883(prod)\u4e0b\u6240\u8fde\u63a5\u7684mysql\u670d\u52a1\u5668\u5bc6\u7801\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p>\u89c1\u4e0a\u56fe&#xff0c;honglian7001<\/p>\n<\/p>\n<h4>12. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2dAliyun OSS\u5bf9\u5e94\u7684\u5bc6\u94a5KEY\u662f\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:Abc123\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"748\" src=\"2025-04-19jg1qfencskj.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>13.&#034;\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf&#034;\u7ba1\u7406\u540e\u53f0\u4e2d&#xff0c;\u7ba1\u7406\u5458&#xff08;admin&#xff09;\u7684\u8d26\u53f7\u5bc6\u7801\u91c7\u7528\u4e86\u4ec0\u4e48\u6837\u7684\u52a0\u5bc6\u65b9\u5f0f&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f&#xff1a;rc4\u3011(\u4e0d\u533a\u5206\u5927\u5c0f\u5199)<\/h4>\n<p>\u4e24\u79cd\u65b9\u6cd5&#xff0c;\u4e00\u79cd\u662f\u7ee7\u7eed\u5728jar\u5305\u91cc\u5934\u770b&#xff0c;\u8fd9\u6837\u76f4\u63a5\u80fd\u770b\u5230\u662f\u4ec0\u4e48\u65b9\u5f0f&#xff0c;\u4f46\u662f\u6bd4\u8f83\u9ebb\u70e6&#xff1b;\u7b2c\u4e8c\u79cd\u662f\u53bb\u6570\u636e\u5e93\u91cc\u5934\u770b&#xff0c;\u770b\u770b\u5bc6\u7801\u662f\u4ec0\u4e48\u7279\u5f81&#xff0c;\u4f46\u662f\u9700\u8981\u4e00\u70b9\u57fa\u7840<\/p>\n<p>\u8fd9\u91cc\u7528navicat\u8fde\u6570\u636e\u5e93\u7684\u65f6\u5019\u8981\u6ce8\u610f&#xff0c;\u524d\u9762\u7684\u7f51\u7ad9jar\u5305\u5199\u4e86\u8d26\u53f7\u5bc6\u7801&#xff0c;\u540c\u65f6\u4e5f\u5199\u4e86\u7aef\u53e3\u662f13306&#xff08;\u89c1\u7b2c10\u9898\u56fe&#xff09;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"741\" src=\"2025-04-19i3ktpjkgzi3.png\" width=\"1200\" \/><\/p>\n<p>\u627e\u5230\u7528\u6237\u4fe1\u606f\u8868&#xff0c;\u6709admin&#xff0c;\u5bc6\u7801\u7684\u52a0\u5bc6\u65b9\u5f0f\u662fbcrypt<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"741\" src=\"2025-04-191eax4rljd54.png\" width=\"1200\" \/><\/p>\n<p>\u8fd9\u91cc\u5c31\u53ef\u4ee5\u628aadmin\u7684\u5bc6\u7801\u6539\u6210123456\u7684bcrypt\u7684\u5bc6\u6587&#xff0c;\u8fd9\u6837\u540e\u53f0\u5c31\u597d\u8fdb\u4e86<\/p>\n<\/p>\n<h4>14.\u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2d,\u7ba1\u7406\u5458(admin)\u8d26\u53f7\u7ed1\u5b9a\u7684\u624b\u673a\u53f7\u7801\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:18818881888\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"741\" src=\"2025-04-19koswusdnmma.png\" width=\"1200\" \/><\/p>\n<h4><\/h4>\n<h4>\u63a5\u4e0b\u6765\u7684\u9898\u5c31\u662f\u7ffb\u7f51\u7ad9\u4e86&#xff0c;\u6bd4\u8f83\u7b80\u5355<\/h4>\n<h4>15.\u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2d,\u4f1a\u5458\u7684\u6570\u91cf\u4e3a?\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-193mhrhur0xyv.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>16. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2d,\u4f1a\u5458\u7ea7\u522b\u4e3a\u201c\u603b\u4ee3\u201d\u7684\u6570\u91cf\u4e3a?\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19osp4ijdyzet.png\" width=\"1200\" \/><\/p>\n<p>\u4f1a\u5458\u7ea7\u522b\u9009\u603b\u4ee3&#xff0c;\u641c\u7d22<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19fuueo0ni5vm.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>17. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2d,\u4ee5\u201c\u63a8\u8350\u4ebaid\u201d\u505a\u4e3a\u4e0a\u7ea7id\u5bf9\u4f1a\u5458\u8fdb\u884c\u5c42\u7ea7\u5206\u6790&#xff0c;\u603b\u5c42\u7ea7\u4e3a\u591a\u5c11\u5c42&#xff1f;(\u6700\u9ad8\u5c42\u7ea7\u89c6\u4e3a1\u5c42)\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p>\u5bfc\u51fa\u7528\u7f51\u949c\u505a&#xff0c;\u524d\u9762\u521a\u521a\u53ea\u9650\u5b9a\u4e86\u603b\u4ee3&#xff0c;\u8981\u6ce8\u610f\u91cd\u7f6e\u6389&#xff0c;\u8981\u4e0d\u7136\u4e00\u5171\u53ea\u6709\u4e24\u767e\u591a\u6761<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19y3aqp22xy5y.png\" width=\"1200\" \/><\/p>\n<p>\u5bfc\u51fa\u4ee5\u540e\u9009 \u7ec4\u7ec7\u67b6\u6784<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-192jpcbkfz5bc.png\" width=\"1200\" \/><\/p>\n<p>\u6211\u8fd9\u91cc\u6700\u5927\u662f54\u662f\u56e0\u4e3a\u5b83\u628a\u603b\u4ee3\u7684\u4e0a\u7ea7\u7b97\u4e86\u4e00\u5c42&#xff08;\u5373\u4f7f\u4ed6\u6ca1\u6709\u660e\u786e\u7684\u9080\u8bf7\u4eba&#xff09;&#xff0c;\u6240\u4ee5\u5149\u4ece\u8868\u4e0a\u6765\u770b\u662f53<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19l1qgkr5gvfs.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>18. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2d&#xff0c;\u4f1a\u5458\u7f16\u53f7\u4e3asgl01\u7684\u4e0b\u6e38\u4eba\u6570(\u4f1e\u4e0b\u4f1a\u5458)\u6570\u91cf\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19x1w4xlb2ljx.png\" width=\"1200\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19yqa1s0bbvrb.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>19. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2d&#xff0c;\u4f1a\u5458\u7f16\u53f7\u4e3asgl01\u7684\u4e0b\u6e38\u4eba\u6570(\u4f1e\u4e0b\u4f1a\u5458)\u5145\u503c\u603b\u91d1\u989d\u5408\u8ba1\u4e3a\u591a\u5c11\u5143\/RMB\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p>\u7f51\u7ad9\u91cc\u6ca1\u770b\u5230&#xff0c;\u5012\u662f\u5728\u6570\u636e\u5e93\u91cc\u627e\u5230\u4e86<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"741\" src=\"2025-04-19gfdhcwftrie.png\" width=\"1200\" \/><\/p>\n<p>\u4f46\u662f\u53d1\u73b0\u8fd9\u4e2a\u8868\u91cc\u5934\u6ca1\u6709\u4f1a\u5458\u7f16\u53f7&#xff0c;\u53ea\u6709\u4f1a\u5458ID&#xff0c;\u90a3\u6211\u4eec\u5c31\u628a\u8fd9\u4e2a\u8868\u548cmember\u4e00\u8d77\u5bfc\u51fa<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"741\" src=\"2025-04-19y4k3bjizhjd.png\" width=\"1200\" \/><\/p>\n<p>\u628a\u6570\u636e\u5e93\u6587\u4ef6\u5bfc\u5165\u7f51\u949c\u4ee5\u540e\u53ef\u4ee5\u4ee5excel\u683c\u5f0f\u5bfc\u51fa<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19rlztmf5otyv.png\" width=\"1200\" \/><\/p>\n<p>\u5bfc\u51fa\u4ee5\u540e\u628a\u4e24\u4e2aexcel\u4e00\u8d77\u5bfc\u5165&#xff0c;\u4ee5\u7ec4\u7ec7\u67b6\u6784\u7684\u5f62\u5f0f\u5206\u6790<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19tkts5fxlnnt.png\" width=\"1200\" \/><\/p>\n<p>\u4f46\u662f\u8981\u662f\u586b\u8fd9\u4e2a\u7b54\u6848\u6211\u5c31\u89c9\u5f97\u6709\u70b9\u597d\u7b11&#xff0c;\u4e00\u4e2a\u4eba&#xff08;\u5c31\u7b97\u662f\u4f1e\u4e0b&#xff09;\u6709\u516b\u4e2a\u4ebf\u7684\u6d41\u6c34&#xff0c;\u592a\u79bb\u8c31\u4e86&#xff0c;\u968f\u4fbf\u627e\u4e00\u4e2a\u4eba\u7684\u5bf9\u7167\u4e00\u4e0b&#xff0c;\u53d1\u73b0\u5dee\u4e86100\u500d&#xff0c;\u90a3\u5c31\u662f\u5c0f\u6570\u70b9\u540e\u4e24\u4f4d\u653e&#xff08;\u89d2\u3001\u5206&#xff09;\u5230\u6574\u6570\u90e8\u5206\u4e86\u3002<\/p>\n<\/p>\n<h4>20. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2d&#xff0c;\u5df2\u652f\u4ed8\u8ba2\u5355\u7684\u6570\u91cf\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p>\u9009\u5df2\u652f\u4ed8\u5e76\u62c9\u5bbd\u65f6\u95f4\u8fdb\u884c\u67e5\u8be2<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19gvu2edwdcyo.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>21. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2d&#xff0c;\u5df2\u652f\u4ed8\u8ba2\u5355\u7684\u652f\u4ed8\u603b\u91d1\u989d\u603b\u8ba1\u4e3a\u591a\u5c11\u5143\/RMB&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p>\u53ef\u4ee5\u5bfc\u51fa\u8868\u683c\u6c42\u548c<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1080\" src=\"2025-04-19lxtibonzogp.png\" width=\"1200\" \/><\/p>\n<p>\u4e5f\u53ef\u4ee5\u65b0\u5efa\u67e5\u8be2&#xff0c;\u53ef\u4ee5\u53d1\u73b0\u8ba2\u5355\u5bf9\u5e94\u7684\u662f&#034;doing_order&#034;\u8fd9\u5f20\u8868&#xff0c;\u5df2\u652f\u4ed8&#034;is_pay&#034;&#061;1<\/p>\n<p>SELECT SUM(pay_money) FROM doing_order WHERE is_pay&#061;1; <\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"741\" src=\"2025-04-19pas5m5bfkrw.png\" width=\"1200\" \/><\/p>\n<p>\u6ce8\u610f\u8fd9\u91cc\u7684\u91d1\u989d\u548c\u524d\u6587\u63d0\u5230\u7684\u4e00\u6837\u8981\u9664\u4ee5100&#xff0c;\u8981\u4e0d\u7136\u90fd\u5341\u51e0\u4ebf\u4e86\u90fd&#xff08;\u5f53\u7136\u6211\u4eec\u4e0d\u80fd\u56e0\u4e3a\u6570\u5b57\u5927\u5c31\u6b66\u65ad\u7684\u5426\u5b9a\u4ed6&#xff0c;\u8fd8\u662f\u8981\u627e\u6570\u5b57\u5bf9\u7167\u4e00\u4e0b&#xff09;<\/p>\n<\/p>\n<h4>22. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2d&#xff0c;\u5728\u63d0\u73b0\u8d26\u53f7\u7ba1\u7406\u9875\u9762\u4e2d\u94f6\u884c\u5361\u7684\u8bb0\u5f55\u6570\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19nrf05hpynxq.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>23. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2d&#xff0c;\u6253\u6b3e\u6210\u529f\u7684\u63d0\u73b0\u8bb0\u5f55\u6570\u91cf\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-191zcncw2atdd.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>24. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2d&#xff0c;\u6253\u6b3e\u6210\u529f\u7684\u63d0\u73b0\u5e94\u6253\u6b3e\u91d1\u989d\u603b\u8ba1\u4e3a\u591a\u5c11\u5143\/RMB&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:123\u3011<\/h4>\n<p>\u540c\u7406&#xff0c;\u6211\u4eec\u53ef\u4ee5\u627e\u6570\u636e\u5e93\u5bf9\u5e94\u7684\u8868\u683c(member_deal,deal_status&#061;4)&#xff0c;\u4e5f\u53ef\u4ee5\u5bfc\u51fa\u7528excel\u6c42\u548c<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"741\" src=\"2025-04-19yodwodupotj.png\" width=\"1200\" \/><\/p>\n<p>\u5176\u5b9e\u6211\u8fd8\u662f\u89c9\u5f97\u7528excel\u7b80\u5355\u4e00\u70b9 0.0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1080\" src=\"2025-04-19f3n0kxgxb5k.png\" width=\"1200\" \/><\/p>\n<\/p>\n<h4>25. \u201c\u9cb8\u6613\u5143MALL\u7ba1\u7406\u7cfb\u7edf\u201d\u7ba1\u7406\u540e\u53f0\u4e2d&#xff0c;\u62fc\u5238\u6d3b\u52a8D\u4ed3\u4f4d\u7684\u6536\u76ca\u7387\u4e3a&#xff1f;\u3010\u7b54\u6848\u683c\u5f0f:100%\u3011<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1040\" src=\"2025-04-19ysqinisn0rr.png\" width=\"1200\" \/><\/p>\n<\/p>\n<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1.3k\u6b21\uff0c\u70b9\u8d5e17\u6b21\uff0c\u6536\u85cf27\u6b21\u3002\u770b\u65e5\u5fd7\u3002_fic\u51b3\u8d5bwp<\/p>\n","protected":false},"author":2,"featured_media":20188,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[58,43,78],"topic":[],"class_list":["post-20219","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-linux","tag-43","tag-78"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>2024fic\u51b3\u8d5b\u670d\u52a1\u5668\u90e8\u5206\u590d\u73b0wp - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/20219.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2024fic\u51b3\u8d5b\u670d\u52a1\u5668\u90e8\u5206\u590d\u73b0wp - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1.3k\u6b21\uff0c\u70b9\u8d5e17\u6b21\uff0c\u6536\u85cf27\u6b21\u3002\u770b\u65e5\u5fd7\u3002_fic\u51b3\u8d5bwp\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/20219.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-18T18:58:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185828-6802a0d4c0d47.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/20219.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/20219.html\",\"name\":\"2024fic\u51b3\u8d5b\u670d\u52a1\u5668\u90e8\u5206\u590d\u73b0wp - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-04-18T18:58:45+00:00\",\"dateModified\":\"2025-04-18T18:58:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/20219.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/20219.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/20219.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"2024fic\u51b3\u8d5b\u670d\u52a1\u5668\u90e8\u5206\u590d\u73b0wp\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"2024fic\u51b3\u8d5b\u670d\u52a1\u5668\u90e8\u5206\u590d\u73b0wp - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/20219.html","og_locale":"zh_CN","og_type":"article","og_title":"2024fic\u51b3\u8d5b\u670d\u52a1\u5668\u90e8\u5206\u590d\u73b0wp - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1.3k\u6b21\uff0c\u70b9\u8d5e17\u6b21\uff0c\u6536\u85cf27\u6b21\u3002\u770b\u65e5\u5fd7\u3002_fic\u51b3\u8d5bwp","og_url":"https:\/\/www.wsisp.com\/helps\/20219.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-04-18T18:58:45+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418185828-6802a0d4c0d47.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"5 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/20219.html","url":"https:\/\/www.wsisp.com\/helps\/20219.html","name":"2024fic\u51b3\u8d5b\u670d\u52a1\u5668\u90e8\u5206\u590d\u73b0wp - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-04-18T18:58:45+00:00","dateModified":"2025-04-18T18:58:45+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/20219.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/20219.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/20219.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"2024fic\u51b3\u8d5b\u670d\u52a1\u5668\u90e8\u5206\u590d\u73b0wp"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/20219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=20219"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/20219\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/20188"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=20219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=20219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=20219"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=20219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}