Zigbee2mqtt plugin configuration

[zygios]

Hello,
After working on upgrade on Domoticz and Zigbee2Mqtt can run pluggin, error message:
Zigbee2MQTT: Initialized version 3.2.0-beta
2023-09-04 21:24:13.313 Zigbee2MQTT: Alias for handling linkquality(endpoint: n/a) feature of device 0xe0798fdsde57dbb3 already exists in plugin configuration but Domoticz logical device with ID 0xe0798fdsde57dbb3(unit: 7) is not found. If you have removed device and want plugin to recreate it, please remove alias from configuration as well.

Which configuration file I need to edit? Zigbee2MQTT-> plugin Configuration empty:


Domoticz version:
Version: 2023.2
Build Hash: 19efd039c

[globoloco]

I had the same problem after I had to reconnect all zigbee devices. Probably enumeration of the "unit" value is done in chronological order of the (randomly) received values. And of course this order will differ on rejoin the devices.
Furthermore the plugin interface of zigbee2mqtt obviously does not work well. I also see just empty pages.
However: I found the obscure "configuration", which holds these aliases: it is the sqlite database: domoticz/domoticz\.db (note: I had to use "\." in place of "." since this forum does not allow to submit strings like example-dot-db as it treats it as an URL)
This file is used also to backup/restore all domoticz settings and history values.

To recover:

1. backup the domoticz database (settings -> backup -> check downloads)
2. I recommend to copy this original db version: cp domoticz\.db domoticz\.orig\.db
3. check the content:

   Code: Select all

   sqlite3 domoticz\.db 'SELECT * FROM Hardware WHERE `Extra` is "Zigbee2MQTT"'

   When the output matches expectation (one entry having these aliases), continue. Otherwise use another WHERE clause.
4. clear plugin config:

   Code: Select all

   sqlite3 domoticz\.db 'UPDATE Hardware SET Configuration = "" WHERE `Extra` is "Zigbee2MQTT"'

5. restore by modified database (settings -> restore)

In case you have multiple HW entries matching `Extra` is "Zigbee2MQTT", you may want to use WHERE `Name` is "yourSpecialName"