MQTT X and thingspeak - lost connection

Question

Vegar Bartnes 2022-3-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1667749-mqtt-x-and-thingspeak-lost-connection

编辑： Stonez Chen 2022-3-16

Hi :-)

I have followed the instructions on mathworks site:

https://se.mathworks.com/help/thingspeak/use-desktop-mqtt-client-to-publish-to-a-channel.html

I have downloaded the MQTT X software.

Then I add a new connection as described. The username, password and ID i get from my thingspeak device in my account.

I then at 3) "Click" the connect button, the program replies "connected". But within 3-6 secounds the connection is lost... so I never get to test out the rest of the subscription and publish.

This should not be a difficult task, but I an stuck :-(

Are there anyone experiensing the same?

mvh vegar bartnes

6 个评论
显示 4更早的评论隐藏 4更早的评论

Vegar Bartnes 2022-3-14

I have resett my device in thingspeak, new ID and password. Still the same read ECONNRESET.

Then I am not able to add new subscription because no connection.

vegar

Vinod 2022-3-14

@Vegar Bartnes: Did you see my screenshot below showing the connection settings? If you are still unable to connect, please share your clientID you are using to connect.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Stonez Chen 2022-3-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1667749-mqtt-x-and-thingspeak-lost-connection#answer_916244

编辑：Stonez Chen 2022-3-13

Hi Christopher,

I'm making a YouTube video in Traditional Chinese to show people how to use ThingSpeak MQTT.

However, I'm also facing the same problem that both my ESP32 & Node-RED lost mqtt3.thingspeak.com connection right after a successful connection. Both ESP32 & Node-RED are under the same Wi-Fi AP.

I'm sure that MQTT device is created and mapped to a Channel.

Server: mqtt://mqtt3.thingspeak.com

Retain: False

QoS: 0

Clean session: 1

I use client.state() to check on my ESP32 and the result is: -3 (MQTT_CONNECTION_LOST - the network connection was broken)

What could be the problem? Server issue or mine issue?

Thanks,

Stonez

PS: My last video is with home hosted MQTT server: MQTT + ESP32 + Mosquitto on Raspberry Pi

8 个评论
显示 6更早的评论隐藏 6更早的评论

Stonez Chen 2022-3-14

编辑：Stonez Chen 2022-3-14

在 MATLAB Online 中打开

Thanks for the quick reply.

I tried both Node-RED and MQTT Lens just now and both of them connected to mqtt3.thingspeak.com and disconnected right away. This cycle just continues and connected and disconnected. Could it be my account, channels, or my device Mac address being banned?

Here are screenshots for your refernce.

Screenshot 1-1:

I managed to get 2 message to the channel 1675230 with MQTT Lens. However, the message "true" didn't write to the csv file

Screenshot 1-2: Downloaded channel data, no message was written

Screenshot 2: MQTT connection successful

Screenshot 3: MQTT lost connection

Screenshot 4: MQTT connection re-established:

Here is the log from the Node-RED:

Mar 21:12:43 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:12:43 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:12:59 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:13:00 - [error] [function:Experiment(short version)] TypeError: Cannot read property '0' of undefined
Mar 21:13:00 - [error] [function:Format data for InfluxDB(Long)] TypeError: Cannot read property '0' of undefined
Mar 21:13:00 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:13:17 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:13:17 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:13:30 - [error] [function:Experiment(short version)] TypeError: Cannot read property '0' of undefined
Mar 21:13:30 - [error] [function:Format data for InfluxDB(Long)] TypeError: Cannot read property '0' of undefined
Mar 21:13:37 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:13:37 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:13:54 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:13:54 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:14:00 - [error] [function:Experiment(short version)] TypeError: Cannot read property '0' of undefined
Mar 21:14:00 - [error] [function:Format data for InfluxDB(Long)] TypeError: Cannot read property '0' of undefined
Mar 21:14:12 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:14:13 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:14:29 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:14:29 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:14:30 - [error] [function:Experiment(short version)] TypeError: Cannot read property '0' of undefined
Mar 21:14:30 - [error] [function:Format data for InfluxDB(Long)] TypeError: Cannot read property '0' of undefined
Mar 21:14:46 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:14:46 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:15:00 - [error] [function:Experiment(short version)] TypeError: Cannot read property '0' of undefined
Mar 21:15:00 - [error] [function:Format data for InfluxDB(Long)] TypeError: Cannot read property '0' of undefined
Mar 21:15:04 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:15:05 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:15:21 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:15:21 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:15:30 - [error] [function:Experiment(short version)] TypeError: Cannot read property '0' of undefined
Mar 21:15:30 - [error] [function:Format data for InfluxDB(Long)] TypeError: Cannot read property '0' of undefined
Mar 21:15:36 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:15:37 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:15:54 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:15:54 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:16:00 - [error] [function:Experiment(short version)] TypeError: Cannot read property '0' of undefined
Mar 21:16:00 - [error] [function:Format data for InfluxDB(Long)] TypeError: Cannot read property '0' of undefined
Mar 21:16:10 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:16:10 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:16:26 - [info] [mqtt-broker:ThingSpeak] Connected to broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883
Mar 21:16:26 - [info] [mqtt-broker:ThingSpeak] Disconnected from broker: NyYnGAocADoBGAUdCgUZIiM@mqtt://mqtt3.thingspeak.com:1883

Vinod 2022-3-15

@Stonez Chen: Your connection will be disconnected if you try to publish or subscribe to an invalid topic or a topic your client is not authorized to access. So, if you only publish/subscribe to topics with valid payloads, your connection should be stable.

Stonez Chen 2022-3-16