MQTT failed to connect, Zigbee2MQTT:error

Hi mine Z2M / MQTT stopped working yesterday. I can see my Zigbee dongle is working as data is coming in from my devices, I have access to the gui Zigbee2mqtt but all devices are gone after some reboots.

Failed to connect to MQTT server due to exception: [Errno 111] Connection refused

Zigbee2MQTT: error 2023-09-06 06:35:17: Not connected to MQTT server!

Zigbee2MQTT:error 2023-09-06 06:35:59: Cannot send message: topic: zigbee2mqtt/Basement stair ceiling light, payload: '{“linkquality”:219,“state”:“OFF”}

[04:43:11] INFO: Service restart after closing
[06:43:12] INFO: Starting mosquitto MQTT broker…
2023-09-06 06:43:12: Warning: Mosquitto should not be run as root/administrator.
mosquitto: persist_read.c:550: persist__restore_sub: Assertion `client_id’ failed.

It happened suddenly, not Shure if it could be an “auto update” on MQTT or

1 Like

Check the username and password used to connect to mosquitto

Hi thanks for helping.

I have reentered user name and password in MQTT and Z2M i also reentered the user but still same problem.

Zigbee2MQTT:info 2023-09-06 08:00:52: Zigbee: disabling joining new devices.
Zigbee2MQTT:info 2023-09-06 08:00:52: Started frontend on port 0.0.0.0:8099
Zigbee2MQTT:info 2023-09-06 08:00:52: Connecting to MQTT server at mqtt://192.168.1.120:1883
Zigbee2MQTT:error 2023-09-06 08:01:02: Not connected to MQTT server!

[08:41:59] INFO: Successfully send service information to the Supervisor.
[06:41:59] INFO: Service restart after closing
[08:41:59] INFO: Successfully send discovery information to Home Assistant.
[08:42:00] INFO: Starting mosquitto MQTT broker…
2023-09-06 08:42:00: Warning: Mosquitto should not be run as root/administrator.
mosquitto: persist_read.c:550: persist__restore_sub: Assertion `client_id’ failed.

I found this in supervisor log.

Option ‘anonymous’ does not exist in the schema for Mosquitto broker (core_mosquitto)

Where can i find the user missing as Anonymous ?

23-09-06 10:02:05 ERROR (MainThread) [supervisor.services.modules.mqtt] There is already a MQTT service in use from core_mosquitto
23-09-06 10:02:08 WARNING (MainThread) [supervisor.misc.tasks] Watchdog found a problem with core_mosquitto application!
23-09-06 10:02:08 INFO (SyncWorker_4) [supervisor.docker.manager] Stopping addon_core_mosquitto application
23-09-06 10:02:08 ERROR (MainThread) [supervisor.services.modules.mqtt] There is already a MQTT service in use from core_mosquitto
23-09-06 10:02:13 INFO (SyncWorker_4) [supervisor.docker.manager] Cleaning addon_core_mosquitto application
23-09-06 10:02:13 WARNING (MainThread) [supervisor.addons.options] Option ‘anonymous’ does not exist in the schema for Mosquitto broker (core_mosquitto)

Guess something happend to my MQTT Broker, not sure what happened.
This is what i get when trying to do a “RE_CONFIGURE MQTT” .

Just to let you know that I have a similar issue, no solutions found yet :
https://community.home-assistant.io/t/zigbee2mqtt-suddenly-cant-connect-to-mqtt-server/611456/3

I restore from a backup to Mqtt broker 6.2.1 .
Update to latest HA os , made a “RE_CONFIGURE MQTT” and that went ok through the gui.
After that i updated the Mqtt broker to latest version.
And everything is working again.

I am also facing the same issue

Same here. MQTT is restarting constantly.

[11:35:01] INFO: Starting mosquitto MQTT broker...
2023-09-20 11:35:01: Warning: Mosquitto should not be run as root/administrator.
mosquitto: persist_read.c:550: persist__restore_sub: Assertion `client_id' failed.
[11:35:01] INFO: Successfully send service information to the Supervisor.
[09:35:01] INFO: Service restart after closing
[11:35:02] INFO: Successfully send discovery information to Home Assistant.
[11:35:02] INFO: Starting mosquitto MQTT broker...
2023-09-20 11:35:02: Warning: Mosquitto should not be run as root/administrator.
mosquitto: persist_read.c:550: persist__restore_sub: Assertion `client_id' failed.
[11:35:03] INFO: Successfully send service information to the Supervisor.
[09:35:03] INFO: Service restart after closing
[11:35:04] INFO: Successfully send discovery information to Home Assistant.
[11:35:04] INFO: Starting mosquitto MQTT broker...

EDIT: Could resolve the problem by deleting the mosquitto.db and restart the add-on afterwards.

Hi, where is the mosquitto.db file located?