{"id":38413,"date":"2025-05-20T09:21:06","date_gmt":"2025-05-20T01:21:06","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/38413.html"},"modified":"2025-05-20T09:21:06","modified_gmt":"2025-05-20T01:21:06","slug":"ubuntu%e5%ae%89%e8%a3%85mosquitto%ef%bc%8c%e5%81%9a%e4%b8%80%e4%b8%aa%e8%87%aa%e5%b7%b1%e7%9a%84%e7%89%a9%e8%81%94%e7%bd%91%e6%9c%8d%e5%8a%a1%e5%99%a8","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/38413.html","title":{"rendered":"Ubuntu\u5b89\u88c5Mosquitto\uff0c\u505a\u4e00\u4e2a\u81ea\u5df1\u7684\u7269\u8054\u7f51\u670d\u52a1\u5668"},"content":{"rendered":"

Ubuntu\u5b89\u88c5Mosquitto\u670d\u52a1\u5668\u5e76\u5bfc\u51fa\u8fd0\u884c\u65e5\u5fd7，web\u67e5\u770b\u8fd0\u884c\u65e5\u5fd7\u5e76\u5bfc\u51fa\u4e3aExcel（\u672a\u5199），\u672c\u6587\u9700\u8981\u540c\u4e00\u5c40\u57df\u7f51\u73af\u5883，\u516c\u7f51\u8bbf\u95ee\u9700\u8981\u4f7f\u7528\u516c\u7f51IP\u6216\u7a7f\u900f<\/p>\n

\u6ce8\u610f：Linux\u4e0b\u521b\u5efa\u65b0\u6587\u4ef6\u8bf7\u5728\u4f7f\u7528\u524d\u786e\u8ba4\u6743\u9650<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u6240\u6709\u64cd\u4f5c\u8bf7\u6ce8\u610f\u8def\u5f84\u3001\u7528\u6237\u540d\u3001\u5bc6\u7801\u7b49<\/p>\n

\u76ee\u5f55<\/p>\n

\u4e00，\u51c6\u5907\u5de5\u4f5c<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a01 \u4e00\u53f0\u8fd0\u884cUbuntu\u7684\u4e3b\u673a，\u4e3b\u673a\u5b8c\u6210\u57fa\u7840\u914d\u7f6e，ssh\u7b49（\u672c\u6587\u4f7f\u7528\u6811\u8393\u6d3e5）<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a02 \u4e00\u53f0\u5176\u4ed6\u652f\u6301mqtt\u6536\u53d1\u7684\u8bbe\u5907\u7528\u6765\u6d4b\u8bd5<\/p>\n

\u4e8c，\u5b89\u88c5<\/p>\n

1 \u786e\u4fdd\u64cd\u4f5c\u7cfb\u7edf\u662f\u6700\u65b0\u7684<\/p>\n

2 \u5b89\u88c5Mosquitto<\/p>\n

3 \u6d4b\u8bd5（\u53ef\u8df3\u8fc7）<\/p>\n

4 \u914d\u7f6e\u9632\u706b\u5899（\u9ed8\u8ba41883\u7aef\u53e3）<\/p>\n

5\u00a0\u8bbe\u7f6eMosquitto\u5f00\u673a\u542f\u52a8<\/p>\n

6\u00a0\u8bbe\u7f6eMosquitto\u914d\u7f6e\u6587\u4ef6（\u91cd\u70b9）<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 6.1\u6253\u5f00\u914d\u7f6e\u6587\u4ef6<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 6.2\u4fee\u6539\u6587\u4ef6\u5982\u4e0b<\/p>\n

7 \u521b\u5efa\u5bc6\u7801\u6587\u4ef6<\/p>\n

8 \u91cd\u542f\u670d\u52a1\u4f7f\u914d\u7f6e\u6587\u4ef6\u751f\u6548<\/p>\n

\u4e09\u3001\u4f7f\u7528<\/p>\n

1 \u786e\u8ba4\u6b63\u5e38\u76d1\u542c\u7aef\u53e3<\/p>\n

2 \u786e\u8ba4\u8fde\u63a5\u72b6\u6001（windows powershell)<\/p>\n

3 \u8fde\u63a5\u81f3Linux\u670d\u52a1\u5668（\u672c\u6587\u4f7f\u7528Windows MQTTX）<\/p>\n

4 \u63a5\u6536\u6d4b\u8bd5<\/p>\n

5 \u53d1\u9001\u6d4b\u8bd5<\/p>\n

6 \u63a5\u6536\u6570\u636e\u5e76\u5bfc\u51fa\u6587\u4ef6<\/p>\n

6.1 \u5bfc\u51fa\u4e3aJSON<\/p>\n

6.2 \u5bfc\u51fa\u4e3atxt<\/p>\n

\u56db\u3001\u8fd0\u884c\u6f14\u793a<\/p>\n

\u4e94\u3001\u56fa\u5b9aLinux\u8bbe\u5907ip<\/p>\n

\u516d\u3001ESP32\u8fde\u63a5\u7b49\u6ce8\u610f\u4e8b\u9879<\/p>\n

\u4e03\u3001Python\u89e3\u6790json\u5e76\u4ece\u7f51\u9875\u5bfc\u51fa\u65e5\u5fd7<\/p>\n

1 \u5b89\u88c5\u6240\u9700python\u5e93<\/p>\n

2 \u9009\u62e9\u4e00\u4e2a\u76ee\u5f55\u521b\u5efa\u5e76\u5199\u5165\u524d\u540e\u7aef\u4ee3\u7801<\/p>\n

app.py<\/p>\n

index.html<\/p>\n

3 \u8fd0\u884c\u5e76\u8bbf\u95ee<\/p>\n

\n

\u4e00，\u51c6\u5907\u5de5\u4f5c<\/h2>\n

\u00a0 \u00a0 \u00a0 \u00a01 \u4e00\u53f0\u8fd0\u884cUbuntu\u7684\u4e3b\u673a，\u4e3b\u673a\u5b8c\u6210\u57fa\u7840\u914d\u7f6e，ssh\u7b49（\u672c\u6587\u4f7f\u7528\u6811\u8393\u6d3e5）<\/h4>\n

\u00a0 \u00a0 \u00a0 \u00a02 \u4e00\u53f0\u5176\u4ed6\u652f\u6301mqtt\u6536\u53d1\u7684\u8bbe\u5907\u7528\u6765\u6d4b\u8bd5<\/h4>\n

\u4e8c，\u5b89\u88c5<\/h2>\n

1 \u786e\u4fdd\u64cd\u4f5c\u7cfb\u7edf\u662f\u6700\u65b0\u7684<\/h4>\n

sudo apt update<\/p>\n

sudo apt upgrade -y <\/p>\n

2 \u5b89\u88c5Mosquitto<\/h4>\n

sudo apt install mosquitto mosquitto-clients -y <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5b89\u88c5\u5b8c\u6210\u540e\u67e5\u770b\u8fd0\u884c\u72b6\u6001\u4f1a\u663e\u793aruning<\/p>\n

sudo systemctl status mosquitto <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"\"<\/p>\n

3 \u6d4b\u8bd5（\u53ef\u8df3\u8fc7）<\/h4>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5206\u522b\u8fd0\u884c\u4ee5\u4e0b\u6307\u4ee4\u6d4b\u8bd5Mosquitto\u670d\u52a1\u5668<\/p>\n

mosquitto_pub -h localhost -t "test\/topic" -m "Hello, MQTT"
\nmosquitto_sub -h localhost -t "test\/topic" <\/p>\n

4 \u914d\u7f6e\u9632\u706b\u5899（\u9ed8\u8ba41883\u7aef\u53e3）<\/h4>\n

sudo ufw allow 1883 <\/p>\n

5\u00a0\u8bbe\u7f6eMosquitto\u5f00\u673a\u542f\u52a8<\/h4>\n

sudo systemctl enable mosquitto <\/p>\n

6\u00a0\u8bbe\u7f6eMosquitto\u914d\u7f6e\u6587\u4ef6（\u91cd\u70b9）<\/h4>\n

\u00a0 \u00a0 \u00a0 \u00a0 6.1\u6253\u5f00\u914d\u7f6e\u6587\u4ef6<\/h6>\n

sudo nano \/etc\/mosquitto\/mosquitto.conf <\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 6.2\u4fee\u6539\u6587\u4ef6\u5982\u4e0b<\/h6>\n

allow_anonymous false \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u8bbe\u7f6e\u4e3a\u7981\u6b62\u533f\u540d\u8fde\u63a5（\u90e8\u5206\u5e93\u533f\u540d\u8fde\u63a5\u5bb9\u6613\u5d29\u6e83）<\/p>\n

password_file \/etc\/mosquitto\/pwfile \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u9009\u62e9\u5bc6\u7801\u6587\u4ef6（\u7b49\u4f1a\u521b\u5efa）<\/p>\n

bind_address 0.0.0.0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4e0d\u9650\u5236\u8bbe\u5907<\/p>\n

# Place your local configuration in \/etc\/mosquitto\/conf.d\/
\n#
\n# A full description of the configuration file is at
\n# \/usr\/share\/doc\/mosquitto\/examples\/mosquitto.conf.example<\/p>\n

#pid_file \/run\/mosquitto\/mosquitto.pid<\/p>\n

persistence true
\npersistence_location \/var\/lib\/mosquitto\/<\/p>\n

log_dest file \/var\/log\/mosquitto\/mosquitto.log<\/p>\n

include_dir \/etc\/mosquitto\/conf.d<\/p>\n

allow_anonymous false<\/p>\n

password_file \/etc\/mosquitto\/pwfile<\/p>\n

bind_address 0.0.0.0 <\/p>\n

7 \u521b\u5efa\u5bc6\u7801\u6587\u4ef6<\/h4>\n

\u7cfb\u7edf\u4f1a\u63d0\u793a\u8f93\u5165\u5bc6\u7801，your_username\u5c31\u662f\u7528\u6237\u540d<\/p>\n

\u521b\u5efa\u5bc6\u7801\u6587\u4ef6
\nsudo mosquitto_passwd -c \/etc\/mosquitto\/pwfile your_username
\n\u8bbe\u7f6e\u6587\u4ef6\u6743\u9650
\nsudo chown mosquitto:mosquitto \/etc\/mosquitto\/pwfile
\nsudo chmod 600 \/etc\/mosquitto\/pwfile<\/p>\n

8 \u91cd\u542f\u670d\u52a1\u4f7f\u914d\u7f6e\u6587\u4ef6\u751f\u6548<\/h4>\n

sudo systemctl restart mosquitto <\/p>\n

\u4e09\u3001\u4f7f\u7528<\/h2>\n

1 \u786e\u8ba4\u6b63\u5e38\u76d1\u542c\u7aef\u53e3<\/h4>\n

\u5b89\u88c5 net-tools \u5305
\nsudo apt install net-tools -y
\n\u8fd0\u884c netstat \u547d\u4ee4
\nsudo netstat -tuln | grep 1883<\/p>\n

\"\"<\/p>\n

2 \u786e\u8ba4\u8fde\u63a5\u72b6\u6001（windows powershell)<\/h4>\n

Test-NetConnection -ComputerName 192.168.66.161 -Port 1883<\/p>\n

\"\"<\/h6>\n

3 \u8fde\u63a5\u81f3Linux\u670d\u52a1\u5668（\u672c\u6587\u4f7f\u7528Windows MQTTX）<\/h4>\n

\u670d\u52a1\u5668\u5730\u5740\u586b\u5199Linux\u8bbe\u5907\u7684IP，\u7528\u6237\u540d\u548c\u5bc6\u7801\u4e3a\u5148\u524d\u8bbe\u7f6e，\u5f39\u51fa\u5df2\u8fde\u63a5\u5219\u6b63\u5e38<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

4 \u63a5\u6536\u6d4b\u8bd5<\/h4>\n

mosquitto_sub \u8ba2\u9605\u00a0-p \u7aef\u53e3 -t "\u8ba2\u9605\u8bdd\u9898" -u "\u7528\u6237\u540d" -P "\u5bc6\u7801"<\/p>\n

mosquitto_sub -p 1883 -t "test\/topic" -u "your_username" -P "password" <\/p>\n

\u8bdd\u9898\u4e0e\u547d\u4ee4\u884c\u4e00\u81f4，\u547d\u4ee4\u884c\u4e2d\u53ef\u4ee5\u770b\u5230\u8ba2\u9605\u7684\u6d88\u606f<\/p>\n

\"\"<\/p>\n

5 \u53d1\u9001\u6d4b\u8bd5<\/h4>\n

mosquitto_pub \u53d1\u9001\u00a0-m "\u5185\u5bb9"<\/p>\n

mosquitto_pub -p 1883 -t "test\/winrec" -m "HELLO" -u "your
\n_username" -P "password" <\/p>\n

\"\"<\/p>\n

6 \u63a5\u6536\u6570\u636e\u5e76\u5bfc\u51fa\u6587\u4ef6<\/h4>\n

6.1 \u5bfc\u51fa\u4e3aJSON<\/h6>\n

\u8def\u5f84\u7b49\u8bf7\u81ea\u884c\u66f4\u6362\u5e76\u8bbe\u7f6e\u597d\u6743\u9650<\/p>\n

mosquitto_sub -p 1883 -t "collect\/updata" -u "pi5" -P "password" | while read -r msg; do echo "{\\\\"timestamp\\\\": \\\\"$(date +'%Y-%m-%dT%H:%M:%S')\\\\", \\\\"message\\\\": \\\\"$msg\\\\"}" >> "\/home\/pi5\/mqtt\/data\/$(date +'%y_%m_%d').json"; done
\n\u6587\u4ef6\u5939\u521b\u5efa\u53c2\u8003
\nsudo mkdir -p \/home\/mqtt\/data
\nsudo chmod -R 777 \/home\/mqtt\/data <\/p>\n

6.2 \u5bfc\u51fa\u4e3atxt<\/h6>\n

mosquitto_sub -p 1883 -t "test\/topic" -u "your_username" -P "password" >> "\/home\/mqtt\/data\/$(date +'%y_%m_%d').txt" <\/p>\n

\u56db\u3001\u8fd0\u884c\u6f14\u793a<\/h2>\n

\u8fd0\u884c\u5bfc\u51fa\u4e3aJSON\u547d\u4ee4\u5e76\u53d1\u9001\u4e00\u6bb5\u6570\u636e<\/p>\n

sudo nano \/home\/mqtt\/data\/25_02_22.json \u67e5\u770b\u8fd0\u884c\u7ed3\u679c<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\u4e94\u3001\u56fa\u5b9aLinux\u8bbe\u5907ip<\/h2>\n

\u4f9d\u6b21\u8fd0\u884c\u5c06Xiaomi 13\u7f51\u7edc\u4e0b\u7684\u8bbe\u5907IP\u56fa\u5b9a\u4e3a192.168.66.66
\nsudo nmcli con mod "Xiaomi 13" ipv4.addresses 192.168.66.66\/24
\nsudo nmcli con mod "Xiaomi 13" ipv4.gateway 192.168.66.1
\nsudo nmcli con mod "Xiaomi 13" ipv4.dns "8.8.8.8"
\nsudo nmcli con mod "Xiaomi 13" ipv4.method manual
\n\u8bbe\u7f6e\u5b8c\u6210\u540e\u91cd\u8fdeWiFi
\nsudo nmcli con up "Xiaomi 13" <\/p>\n

\u516d\u3001ESP32\u8fde\u63a5\u7b49\u6ce8\u610f\u4e8b\u9879<\/h2>\n

\u4f7f\u7528PubSubClient\u5e93\u65f6\u9700\u8981\u8bbe\u7f6e\u53c2\u6570，\u5426\u5219esp32\u4f1a\u5d29\u6e83，\u4ee5\u4e0b\u53c2\u6570\u6d4b\u8bd5\u53ef\u884c，\u4f8b\u7a0b\u5982\u4e0b<\/p>\n

\/\/PubSubClient ESP32-Linux
\n\/\/PubSubClient.h \u4e2d\u4fee\u6539MQTT_MAX_PACKET_SIZE 512 MQTT_KEEPALIVE 180
\n#include <WiFi.h>
\n#include <PubSubClient.h>
\n#include "mqttserver.h"<\/p>\n

\/\/ \u5e73\u53f0\u914d\u7f6e
\nconst char* mqttServer = "192.168.66.66";
\nconst int mqttPort = 1883;
\nconst char* mqttClientId = "ESP32_1";
\nconst char* mqttUsername = "your_username";
\nconst char* mqttPassword = "password";<\/p>\n

\/\/ Topic\u914d\u7f6e
\nString topic_control = "test\/dowload"; \/\/ \u5c5e\u6027\u8bbe\u7f6eTopic
\nString topic_property_post = "test\/update"; \/\/ \u5c5e\u6027\u4e0a\u62a5Topic<\/p>\n

WiFiClient espClient; \/\/ \u521b\u5efa\u4e00\u4e2aWiFi\u5ba2\u6237\u7aef\u5b9e\u4f8b，\u7528\u4e8e\u4e0eWiFi\u7f51\u7edc\u8fde\u63a5
\nPubSubClient client(espClient); \/\/ \u521b\u5efa\u4e00\u4e2aPubSubClient\u5b9e\u4f8b，\u5c06WiFi\u5ba2\u6237\u7aef\u4f20\u9012\u7ed9\u5b83\u4ee5\u8fdb\u884cMQTT\u901a\u4fe1<\/p>\n

\/\/ \u7269\u8054\u7f51\u53c2\u6570
\nfloat depth_water;
\nfloat humi, temp;<\/p>\n

void mqtt_init(void) {
\n \/\/ \u8bbe\u7f6eMQTT\u670d\u52a1\u5668\u5730\u5740\u548c\u7aef\u53e3（\u544a\u8bc9\u5ba2\u6237\u7aef\u5728\u54ea\u91cc\u627e\u5230MQTT\u4ee3\u7406）
\n client.setServer(mqttServer, mqttPort);
\n \/\/ \u8bbe\u7f6eMQTT\u6d88\u606f\u56de\u8c03\u51fd\u6570（\u7528\u4e8e\u5904\u7406\u63a5\u6536\u5230\u7684MQTT\u6d88\u606f\u3002\u5f53\u5ba2\u6237\u7aef\u63a5\u6536\u5230\u6d88\u606f\u65f6，\u8fd9\u4e2a\u51fd\u6570\u4f1a\u88ab\u81ea\u52a8\u8c03\u7528）
\n client.setCallback(callback);
\n}<\/p>\n

\/\/MQTT\u72b6\u6001\u5224\u65ad，\u65ad\u8fde\u5219\u91cd\u8fde，\u8fde\u63a5\u6b63\u5e38\u5219\u4e0a\u62a5\u6570\u636e
\nvoid mqtt_server(void) {
\n \/\/ \u68c0\u67e5MQTT\u8fde\u63a5\u72b6\u6001
\n if (!client.connected()) {
\n connectMQTT(); \/\/ \u5982\u679c\u672a\u8fde\u63a5，\u5219\u5c1d\u8bd5\u8fde\u63a5MQTT\u670d\u52a1\u5668
\n }
\n client.loop(); \/\/ \u5904\u7406MQTT\u6d88\u606f（MQTT\u5ba2\u6237\u7aef\u7684\u6838\u5fc3\u5faa\u73af，\u5904\u7406\u6240\u6709\u5f85\u5904\u7406\u7684\u6d88\u606f\u548c\u56de\u8c03\u3002\u5982\u679c\u6ca1\u6709\u8c03\u7528\u8fd9\u4e2a\u51fd\u6570，\u5ba2\u6237\u7aef\u5c06\u65e0\u6cd5\u63a5\u6536\u6d88\u606f\u3002）
\n reportDeviceStatus(); \/\/ \u62a5\u544a\u8bbe\u5907\u72b6\u6001
\n}<\/p>\n

\/\/ \u5904\u7406\u6536\u5230\u7684\u63a7\u5236\u547d\u4ee4
\nvoid callback(char* topic, byte* payload, unsigned int length) {
\n \/\/ \u5c06payload\u8f6c\u6362\u4e3a\u5b57\u7b26\u4e32
\n String message;
\n for (int i = 0; i < length; i++) {
\n message += (char)payload[i];
\n }<\/p>\n

Serial.print("Message received: ");
\n Serial.println(message);
\n}<\/p>\n

\/\/ MQTT\u670d\u52a1\u5668\u8fde\u63a5
\nvoid connectMQTT(void) {
\n \/\/ \u53ea\u8981\u672a\u8fde\u63a5\u5230MQTT\u670d\u52a1\u5668，\u5c31\u6301\u7eed\u5c1d\u8bd5\u8fde\u63a5
\n while (!client.connected()) {
\n Serial.println("Reconnecting to MQTT…"); \/\/ \u8f93\u51fa\u91cd\u65b0\u8fde\u63a5\u7684\u4fe1\u606f
\n \/\/ \u5c1d\u8bd5\u8fde\u63a5\u5230MQTT\u670d\u52a1\u5668（\u4f7f\u7528\u63d0\u4f9b\u7684\u5ba2\u6237\u7aefID\u3001\u7528\u6237\u540d\u548c\u5bc6\u7801）
\n if (client.connect(mqttClientId, mqttUsername, mqttPassword)) {
\n Serial.println("Reconnected to MQTT server"); \/\/ \u8f93\u51fa\u8fde\u63a5\u6210\u529f\u7684\u4fe1\u606f
\n client.subscribe(topic_control.c_str()); \/\/ \u91cd\u65b0\u8ba2\u9605\u63a7\u5236\u547d\u4ee4\u4e3b\u9898
\n } else {
\n \/\/ \u5982\u679c\u8fde\u63a5\u5931\u8d25，\u8f93\u51fa\u9519\u8bef\u72b6\u6001
\n Serial.print("MQTT reconnection failed, state: ");
\n Serial.println(client.state());
\n delay(2000); \/\/ \u7b49\u5f852\u79d2\u518d\u5c1d\u8bd5\u91cd\u65b0\u8fde\u63a5
\n }
\n }
\n}<\/p>\n

\/\/ \u4e0a\u4f20\u6570\u636e
\nvoid reportDeviceStatus(void) {
\n \/\/ \u6784\u9020JSON\u683c\u5f0f\u7684\u8d1f\u8f7d
\n String payload = "{\\\\"depth_water\\\\":" + String(depth_water) + ",\\\\"humi\\\\":" + String(humi) +",\\\\"temp\\\\":" + String(temp) +"}";<\/p>\n

\/\/ \u901a\u8fc7MQTT\u53d1\u5e03\u8d1f\u8f7d
\n if (client.publish(topic_property_post.c_str(), payload.c_str())) {
\n Serial.println("Device status reported successfully"); \/\/ \u8f93\u51fa\u6210\u529f\u4fe1\u606f
\n } else {
\n Serial.println("Failed to report device status"); \/\/ \u8f93\u51fa\u5931\u8d25\u4fe1\u606f
\n }
\n}<\/p>\n

\u4e03\u3001Python\u89e3\u6790json\u5e76\u4ece\u7f51\u9875\u5bfc\u51fa\u65e5\u5fd7<\/h2>\n

1 \u5b89\u88c5\u6240\u9700python\u5e93<\/h4>\n

sudo apt install python3-pip python3-flask<\/p>\n

sudo apt install python3-pandas python3-openpyxl<\/p>\n

2 \u9009\u62e9\u4e00\u4e2a\u76ee\u5f55\u521b\u5efa\u5e76\u5199\u5165\u524d\u540e\u7aef\u4ee3\u7801<\/h4>\n

cd \/home\/pi5<\/p>\n

touch app.py touch index.html<\/p>\n

app.py<\/h6>\n

from flask import Flask, request, jsonify, send_from_directory
\nimport os
\nimport json
\nimport re
\nimport pandas as pd
\nfrom datetime import datetime<\/p>\n

app = Flask(__name__)<\/p>\n

# \u8bbe\u7f6e\u5b58\u50a8 JSON \u6587\u4ef6\u7684\u76ee\u5f55
\nDATA_DIR = '\/home\/pi5\/mqtt\/data\/'<\/p>\n

# \u83b7\u53d6\u6240\u6709\u65e5\u671f\u7684\u6587\u4ef6\u540d
\ndef get_json_files():
\n files = [f for f in os.listdir(DATA_DIR) if f.endswith('.json')]
\n return sorted(files)<\/p>\n

# \u89e3\u6790\u6307\u5b9a\u65e5\u671f\u7684 JSON \u6587\u4ef6
\ndef parse_json_file(file_name):
\n try:
\n data_list = []
\n with open(os.path.join(DATA_DIR, file_name), 'r') as f:
\n for line in f:
\n line = line.strip()
\n if not line:
\n continue
\n try:
\n # \u5c1d\u8bd5\u76f4\u63a5\u89e3\u6790\u884c\u6570\u636e
\n data = json.loads(line)
\n except json.JSONDecodeError:
\n # \u4f7f\u7528\u6b63\u5219\u8868\u8fbe\u5f0f\u4fee\u590d message \u5b57\u6bb5\u7684\u683c\u5f0f\u95ee\u9898
\n corrected_line = re.sub(
\n r'"message":\\\\s*"(\\\\{.*?\\\\})"',
\n r'"message": \\\\1',
\n line,
\n flags=re.DOTALL
\n )
\n try:
\n data = json.loads(corrected_line)
\n except json.JSONDecodeError as e:
\n print(f"Error decoding corrected line in {file_name}: {e}")
\n continue
\n # \u68c0\u67e5 message \u5b57\u6bb5\u662f\u5426\u4e3a\u5b57\u7b26\u4e32，\u5c1d\u8bd5\u8fdb\u4e00\u6b65\u89e3\u6790
\n if 'message' in data and isinstance(data['message'], str):
\n try:
\n data['message'] = json.loads(data['message'])
\n except json.JSONDecodeError:
\n print(f"Failed to parse message field in {file_name}")
\n data_list.append(data)
\n return data_list
\n except Exception as e:
\n print(f"Error reading {file_name}: {e}")
\n return None<\/p>\n

# \u67e5\u8be2\u6307\u5b9a\u65e5\u671f\u8303\u56f4\u7684\u6570\u636e
\n@app.route('\/query', methods=['GET'])
\ndef query_data():
\n start_date = request.args.get('start_date') # \u83b7\u53d6\u67e5\u8be2\u7684\u5f00\u59cb\u65e5\u671f
\n end_date = request.args.get('end_date') # \u83b7\u53d6\u67e5\u8be2\u7684\u7ed3\u675f\u65e5\u671f<\/p>\n

# \u89e3\u6790\u65e5\u671f\u683c\u5f0f (yyyy-mm-dd)
\n try:
\n start_date = datetime.strptime(start_date, '%Y-%m-%d')
\n end_date = datetime.strptime(end_date, '%Y-%m-%d')
\n except ValueError:
\n return jsonify({'error': 'Invalid date format. Please use yyyy-mm-dd.'}), 400<\/p>\n

result = []<\/p>\n

# \u904d\u5386\u6240\u6709\u6587\u4ef6，\u6839\u636e\u65f6\u95f4\u8303\u56f4\u8fc7\u6ee4\u6587\u4ef6
\n for file_name in get_json_files():
\n # \u63d0\u53d6\u6587\u4ef6\u65e5\u671f（\u5047\u8bbe\u6587\u4ef6\u540d\u662f\u7c7b\u4f3c "25_02_22.json"）
\n file_date_str = file_name.split('.')[0]
\n try:
\n file_date = datetime.strptime(file_date_str, '%y_%m_%d')
\n except ValueError:
\n print(f"Skipping invalid filename: {file_name}")
\n continue<\/p>\n

# \u5982\u679c\u6587\u4ef6\u65e5\u671f\u5728\u6307\u5b9a\u7684\u65f6\u95f4\u8303\u56f4\u5185，\u89e3\u6790\u5e76\u8fd4\u56de\u6570\u636e
\n if start_date <= file_date <= end_date:
\n parsed_data = parse_json_file(file_name)
\n if parsed_data:
\n for entry in parsed_data:
\n # \u63d0\u53d6 timestamp \u5b57\u6bb5\u5e76\u4ec5\u4fdd\u7559\u65f6\u95f4\u90e8\u5206
\n timestamp = entry.get("timestamp", "")
\n time_part = timestamp.split('T')[1] if 'T' in timestamp else ""<\/p>\n

# \u63d0\u53d6 message \u5b57\u6bb5，\u5e76\u683c\u5f0f\u5316\u4e3a "key: value | key: value"
\n message = entry.get("message", {})
\n message_str = " | ".join([f"{key}: {value}" for key, value in message.items()])<\/p>\n

# \u5c06\u65f6\u95f4\u548c\u683c\u5f0f\u5316\u540e\u7684 message \u62fc\u63a5
\n result.append({
\n 'date': file_date.strftime('%Y-%m-%d'),
\n 'data': f"{time_part} {message_str}" # \u62fc\u63a5\u65f6\u95f4\u548c\u6d88\u606f\u5185\u5bb9
\n })<\/p>\n

return jsonify(result)<\/p>\n

# \u5bfc\u51fa\u6570\u636e\u4e3a Excel
\n@app.route('\/export_excel', methods=['GET'])
\ndef export_excel():
\n start_date = request.args.get('start_date') # \u83b7\u53d6\u67e5\u8be2\u7684\u5f00\u59cb\u65e5\u671f
\n end_date = request.args.get('end_date') # \u83b7\u53d6\u67e5\u8be2\u7684\u7ed3\u675f\u65e5\u671f<\/p>\n

# \u89e3\u6790\u65e5\u671f\u683c\u5f0f (yyyy-mm-dd)
\n try:
\n start_date = datetime.strptime(start_date, '%Y-%m-%d')
\n end_date = datetime.strptime(end_date, '%Y-%m-%d')
\n except ValueError:
\n return jsonify({'error': 'Invalid date format. Please use yyyy-mm-dd.'}), 400<\/p>\n

result = []<\/p>\n

# \u904d\u5386\u6240\u6709\u6587\u4ef6，\u6839\u636e\u65f6\u95f4\u8303\u56f4\u8fc7\u6ee4\u6587\u4ef6
\n for file_name in get_json_files():
\n # \u63d0\u53d6\u6587\u4ef6\u65e5\u671f（\u5047\u8bbe\u6587\u4ef6\u540d\u662f\u7c7b\u4f3c "25_02_22.json"）
\n file_date_str = file_name.split('.')[0]
\n try:
\n file_date = datetime.strptime(file_date_str, '%y_%m_%d')
\n except ValueError:
\n print(f"Skipping invalid filename: {file_name}")
\n continue<\/p>\n

# \u5982\u679c\u6587\u4ef6\u65e5\u671f\u5728\u6307\u5b9a\u7684\u65f6\u95f4\u8303\u56f4\u5185，\u89e3\u6790\u5e76\u8fd4\u56de\u6570\u636e
\n if start_date <= file_date <= end_date:
\n parsed_data = parse_json_file(file_name)
\n if parsed_data:
\n for entry in parsed_data:
\n result.append({
\n 'date': file_date.strftime('%Y-%m-%d'),
\n 'data': entry
\n })<\/p>\n

# \u5c06\u67e5\u8be2\u7ed3\u679c\u8f6c\u6362\u4e3a pandas DataFrame
\n df_list = []
\n for item in result:
\n date_str = item['date']
\n data = item['data']
\n # \u68c0\u67e5 'message' \u662f\u5426\u4e3a\u5b57\u7b26\u4e32，\u5982\u679c\u662f，\u5219\u89e3\u6790\u5b83\u4e3a\u5b57\u5178
\n if isinstance(data.get("message", ""), str):
\n try:
\n data['message'] = json.loads(data['message']) # \u89e3\u6790\u4e3a\u5b57\u5178
\n except json.JSONDecodeError:
\n print(f"Failed to parse message field in {item['date']}")<\/p>\n

# \u63d0\u53d6 'timestamp' \u5e76\u53ea\u4fdd\u7559 'T' \u540e\u7684\u90e8\u5206，\u6539\u4e3a 'time'
\n timestamp = data.get("timestamp", "")
\n time_part = timestamp.split('T')[1] if 'T' in timestamp else ""<\/p>\n

# \u63d0\u53d6\u5b57\u6bb5，\u5e76\u786e\u4fdd\u83b7\u53d6\u6709\u6548\u7684\u6570\u636e
\n df_list.append({
\n 'date': date_str,
\n 'time': time_part, # \u53ea\u4fdd\u7559 'T' \u540e\u7684\u90e8\u5206
\n 'humi1': data.get("message", {}).get("humi1", ""),
\n 'temp2': data.get("message", {}).get("temp2", ""),
\n #'temp': data.get("message", {}).get("temp", ""),
\n })<\/p>\n

# \u5c06\u6570\u636e\u4fdd\u5b58\u5230 Excel \u6587\u4ef6
\n df = pd.DataFrame(df_list)
\n file_path = "data.xlsx" # \u4f7f\u7528\u76f8\u5bf9\u8def\u5f84
\n df.to_excel(file_path, index=False, engine='openpyxl')<\/p>\n

# \u4f7f\u7528 send_from_directory \u53d1\u9001\u6587\u4ef6，\u786e\u4fdd\u6587\u4ef6\u4f4d\u4e8e\u5f53\u524d\u5de5\u4f5c\u76ee\u5f55
\n return send_from_directory(os.getcwd(), file_path, as_attachment=True)<\/p>\n

# \u8fd4\u56de\u9759\u6001\u6587\u4ef6（index.html）
\n@app.route('\/')
\ndef serve_index():
\n return send_from_directory(os.getcwd(), 'index.html')<\/p>\n

if __name__ == '__main__':
\n app.run(debug=True, host='0.0.0.0')<\/p>\n

index.html<\/h6>\n

<!DOCTYPE html>
\n<html lang="en">
\n<head>
\n <meta charset="UTF-8">
\n <meta name="viewport" content="width=device-width, initial-scale=1.0">
\n <title>MQTT Data Query<\/title>
\n <style>
\n body {
\n font-family: Arial, sans-serif;
\n margin: 20px;
\n }
\n .container {
\n max-width: 600px;
\n margin: auto;
\n }
\n input, button {
\n padding: 8px;
\n margin: 5px;
\n }
\n .result {
\n margin-top: 20px;
\n }
\n table {
\n width: 100%;
\n border-collapse: collapse;
\n }
\n table, th, td {
\n border: 1px solid #ddd;
\n }
\n th, td {
\n padding: 8px;
\n text-align: left;
\n }
\n <\/style>
\n<\/head>
\n<body><\/p>\n

<div class="container">
\n <h1>Data Query<\/h1><\/p>\n

<label for="start_date">Start Date:<\/label>
\n <input type="date" id="start_date" required><\/p>\n

<label for="end_date">End Date:<\/label>
\n <input type="date" id="end_date" required>
\n <br>
\n <button onclick="fetchData()">Query Data<\/button>
\n <button onclick="exportExcel()">Export to Excel<\/button><\/p>\n

<div class="result">
\n <h3>Results<\/h3>
\n <div id="data-table"><\/div>
\n <\/div>
\n <\/div><\/p>\n

<script>
\n async function fetchData() {
\n const start_date = document.getElementById('start_date').value;
\n const end_date = document.getElementById('end_date').value;<\/p>\n

if (!start_date || !end_date) {
\n alert("Please select both start and end dates.");
\n return;
\n }<\/p>\n

const response = await fetch(`\/query?start_date=${start_date}&end_date=${end_date}`);
\n const data = await response.json();<\/p>\n

let tableHTML = '<table><tr><th>Date<\/th><th>Data<\/th><\/tr>';<\/p>\n

data.forEach(item => {
\n tableHTML += `<tr><td>${item.date}<\/td><td>${JSON.stringify(item.data)}<\/td><\/tr>`;
\n });<\/p>\n

tableHTML += '<\/table>';
\n document.getElementById('data-table').innerHTML = tableHTML;
\n }<\/p>\n

function exportExcel() {
\n const start_date = document.getElementById('start_date').value;
\n const end_date = document.getElementById('end_date').value;<\/p>\n

if (!start_date || !end_date) {
\n alert("Please select both start and end dates.");
\n return;
\n }<\/p>\n

window.location.href = `\/export_excel?start_date=${start_date}&end_date=${end_date}`;
\n }
\n <\/script><\/p>\n

<\/body>
\n<\/html><\/p>\n

3 \u8fd0\u884c\u5e76\u8bbf\u95ee<\/h4>\n

\u8fd0\u884c<\/p>\n

python app.py<\/p>\n

\u8bbf\u95ee<\/p>\n

\u8bbe\u5907IP:5000<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb535\u6b21\uff0c\u70b9\u8d5e5\u6b21\uff0c\u6536\u85cf10\u6b21\u3002Ubuntu\u5b89\u88c5Mosquitto\u670d\u52a1\u5668\u5e76\u5bfc\u51fa\u8fd0\u884c\u65e5\u5fd7\uff0cweb\u67e5\u770b\u8fd0\u884c\u65e5\u5fd7\u5e76\u5bfc\u51fa\u4e3aExcel\uff08\u672a\u5199\uff09\uff0c\u672c\u6587\u9700\u8981\u540c\u4e00\u5c40\u57df\u7f51\u73af\u5883\uff0c\u516c\u7f51\u8bbf\u95ee\u9700\u8981\u4f7f\u7528\u516c\u7f51IP\u6216\u7a7f\u900f\u6ce8\u610f\uff1aLinux\u4e0b\u521b\u5efa\u65b0\u6587\u4ef6\u8bf7\u5728\u4f7f\u7528\u524d\u786e\u8ba4\u6743\u9650\u3002_ubuntu mosquitto<\/p>\n","protected":false},"author":2,"featured_media":38404,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[43,44],"topic":[],"class_list":["post-38413","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-43","tag-44"],"yoast_head":"\nUbuntu\u5b89\u88c5Mosquitto\uff0c\u505a\u4e00\u4e2a\u81ea\u5df1\u7684\u7269\u8054\u7f51\u670d\u52a1\u5668 - \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\/38413.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ubuntu\u5b89\u88c5Mosquitto\uff0c\u505a\u4e00\u4e2a\u81ea\u5df1\u7684\u7269\u8054\u7f51\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb535\u6b21\uff0c\u70b9\u8d5e5\u6b21\uff0c\u6536\u85cf10\u6b21\u3002Ubuntu\u5b89\u88c5Mosquitto\u670d\u52a1\u5668\u5e76\u5bfc\u51fa\u8fd0\u884c\u65e5\u5fd7\uff0cweb\u67e5\u770b\u8fd0\u884c\u65e5\u5fd7\u5e76\u5bfc\u51fa\u4e3aExcel\uff08\u672a\u5199\uff09\uff0c\u672c\u6587\u9700\u8981\u540c\u4e00\u5c40\u57df\u7f51\u73af\u5883\uff0c\u516c\u7f51\u8bbf\u95ee\u9700\u8981\u4f7f\u7528\u516c\u7f51IP\u6216\u7a7f\u900f\u6ce8\u610f\uff1aLinux\u4e0b\u521b\u5efa\u65b0\u6587\u4ef6\u8bf7\u5728\u4f7f\u7528\u524d\u786e\u8ba4\u6743\u9650\u3002_ubuntu mosquitto\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/38413.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-20T01:21:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250520012104-682bd90002f0f.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=\"9 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/38413.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/38413.html\",\"name\":\"Ubuntu\u5b89\u88c5Mosquitto\uff0c\u505a\u4e00\u4e2a\u81ea\u5df1\u7684\u7269\u8054\u7f51\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-05-20T01:21:06+00:00\",\"dateModified\":\"2025-05-20T01:21:06+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/38413.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/38413.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/38413.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ubuntu\u5b89\u88c5Mosquitto\uff0c\u505a\u4e00\u4e2a\u81ea\u5df1\u7684\u7269\u8054\u7f51\u670d\u52a1\u5668\"}]},{\"@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":"Ubuntu\u5b89\u88c5Mosquitto\uff0c\u505a\u4e00\u4e2a\u81ea\u5df1\u7684\u7269\u8054\u7f51\u670d\u52a1\u5668 - \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\/38413.html","og_locale":"zh_CN","og_type":"article","og_title":"Ubuntu\u5b89\u88c5Mosquitto\uff0c\u505a\u4e00\u4e2a\u81ea\u5df1\u7684\u7269\u8054\u7f51\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb535\u6b21\uff0c\u70b9\u8d5e5\u6b21\uff0c\u6536\u85cf10\u6b21\u3002Ubuntu\u5b89\u88c5Mosquitto\u670d\u52a1\u5668\u5e76\u5bfc\u51fa\u8fd0\u884c\u65e5\u5fd7\uff0cweb\u67e5\u770b\u8fd0\u884c\u65e5\u5fd7\u5e76\u5bfc\u51fa\u4e3aExcel\uff08\u672a\u5199\uff09\uff0c\u672c\u6587\u9700\u8981\u540c\u4e00\u5c40\u57df\u7f51\u73af\u5883\uff0c\u516c\u7f51\u8bbf\u95ee\u9700\u8981\u4f7f\u7528\u516c\u7f51IP\u6216\u7a7f\u900f\u6ce8\u610f\uff1aLinux\u4e0b\u521b\u5efa\u65b0\u6587\u4ef6\u8bf7\u5728\u4f7f\u7528\u524d\u786e\u8ba4\u6743\u9650\u3002_ubuntu mosquitto","og_url":"https:\/\/www.wsisp.com\/helps\/38413.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-05-20T01:21:06+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250520012104-682bd90002f0f.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"9 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/38413.html","url":"https:\/\/www.wsisp.com\/helps\/38413.html","name":"Ubuntu\u5b89\u88c5Mosquitto\uff0c\u505a\u4e00\u4e2a\u81ea\u5df1\u7684\u7269\u8054\u7f51\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-05-20T01:21:06+00:00","dateModified":"2025-05-20T01:21:06+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/38413.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/38413.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/38413.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"Ubuntu\u5b89\u88c5Mosquitto\uff0c\u505a\u4e00\u4e2a\u81ea\u5df1\u7684\u7269\u8054\u7f51\u670d\u52a1\u5668"}]},{"@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\/38413","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=38413"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/38413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/38404"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=38413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=38413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=38413"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=38413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}