Unable to connect to the MQTT broker: Connection Refused: not authorised

Bonjour,

J’ai voulu faire joujou avec un Bridge Sonoff RF 433 R2,V2 (non non, c’est pas un droïde)
c’est la dernière mouture avec les antennes imprimées sur le PCB.

quand j’ai flashé Tasmota dessus, j’ai rentré mes paramètres MQTT mais au moment de sauvegarder, il me sort que mon mot de passe de 4 caractères était trop court.

Comme un grand, je vais dans paramètres / modules complémentaires
et je met un login et un mot de passe plus élaboré. mqtt_user et un mot de passe à 10 caractères maj/min/num/non-alphanumérique… jusque là, pas trop de problèmes.
je teste avec mqtt-explorer depuis un PC: ok
mon sonoff ne met plus d’erreurs mqtt. :+1: :+1: :+1:

mais j’ai plus de zigbee. enfin, j’ai ma console zigbee2mqtt qui marche, je vois mes devices et mon schéma, mais tout est grisé dans les dashboards. :face_with_spiral_eyes:
dans les logs j’ai :

Détails du journal (ERREUR)

Logger: homeassistant.components.mqtt.client
Source: components/mqtt/client.py:488
Integration: MQTT ([documentation](https://www.home-assistant.io/integrations/mqtt), [issues](https://github.com/home-assistant/home-assistant/issues?q=is%3Aissue+is%3Aopen+label%3A%22integration%3A+mqtt%22))
First occurred: 18:25:21 (15 occurrences)
Last logged: 18:41:30

Unable to connect to the MQTT broker: Connection Refused: not authorised.

et

Détails du journal (ATTENTION)

Logger: homeassistant.components.mqtt.client
Source: components/mqtt/client.py:598
Integration: MQTT ([documentation](https://www.home-assistant.io/integrations/mqtt), [issues](https://github.com/home-assistant/home-assistant/issues?q=is%3Aissue+is%3Aopen+label%3A%22integration%3A+mqtt%22))
First occurred: 18:25:21 (15 occurrences)
Last logged: 18:41:30

Disconnected from MQTT server core-mosquitto:1883 (5)

et là, ca va moins bien.
j’avais bien une « personne » mqtt-user au niveau des utilisateurs mais je l’ai retiré comme elle n’avait pas le même nom.

HELP

Salut,

Tu ne dis pas si tu as bien mis le nouveau mot de passe MQTT dans Zigbee2MQTT.
Dans Paramêtres>MQTT de l’interface de Zigbee2MQTT.

Alors, voila ce que j’ai changé:



et là aussi mais je sais pas si c’est bon ou pas…

et dans /config/zigbee2mqtt/configuration.yaml

external_converters: []
devices:
  - devices.yaml
groups:
  - groups.yaml
homeassistant: true
permit_join: false
mqtt:
  base_topic: zigbee2mqtt
  server: mqtt://192.168.92.25:1883
  user: mqtt_user
  password: xxxxxxxxxx
serial:
  port: /dev/ttyUSB0
advanced:
  log_level: info
1 « J'aime »

voila les logs de mosquitto:

1654967613: Saving in-memory database to /data//mosquitto.db.
1654967694: New connection from 172.30.32.2:54880 on port 1883.
1654967694: Client <unknown> closed its connection.
1654967709: New connection from 172.30.32.1:52145 on port 1883.
1654967709: Client <unknown> disconnected, not authorised.
1654967790: New connection from 172.30.32.1:47329 on port 1883.
1654967790: Client <unknown> disconnected, not authorised.
1654967792: New connection from 172.30.32.1:56861 on port 1883.
1654967792: Client <unknown> disconnected, not authorised.
1654967794: New connection from 172.30.32.1:59979 on port 1883.
1654967794: Client <unknown> disconnected, not authorised.
1654967798: New connection from 172.30.32.1:59267 on port 1883.
1654967798: Client <unknown> disconnected, not authorised.
1654967807: New connection from 172.30.32.1:46231 on port 1883.
1654967807: Client <unknown> disconnected, not authorised.
1654967814: New connection from 172.30.32.2:54882 on port 1883.
1654967814: Client <unknown> closed its connection.
1654967823: New connection from 172.30.32.1:39783 on port 1883.
1654967823: Client <unknown> disconnected, not authorised.
1654967855: New connection from 172.30.32.1:38457 on port 1883.
1654967855: Client <unknown> disconnected, not authorised.
1654967898: Client tasmota_48D34B closed its connection.
1654967902: New connection from 192.168.92.216:61528 on port 1883.
1654967902: New client connected from 192.168.92.216:61528 as tasmota_48D34B (p2, c1, k30, u'mqtt_user').
1654967919: New connection from 172.30.32.1:43439 on port 1883.
1654967919: Client <unknown> disconnected, not authorised.
1654967934: New connection from 172.30.32.2:54884 on port 1883.
1654967934: Client <unknown> closed its connection.
1654968019: Client tasmota_48D34B closed its connection.
1654968024: New connection from 192.168.92.216:60449 on port 1883.
1654968024: Client <unknown> disconnected, not authorised.
1654968035: New connection from 192.168.92.216:58173 on port 1883.
1654968035: Client <unknown> disconnected, not authorised.
1654968039: New connection from 172.30.32.1:39937 on port 1883.
1654968039: Client <unknown> disconnected, not authorised.
1654968054: New connection from 172.30.32.2:54886 on port 1883.
1654968054: Client <unknown> closed its connection.
1654968056: New connection from 192.168.92.216:52445 on port 1883.
1654968056: Client <unknown> disconnected, not authorised.
1654968066: New connection from 192.168.92.216:53646 on port 1883.
1654968066: New client connected from 192.168.92.216:53646 as tasmota_48D34B (p2, c1, k30, u'mqtt_user').
1654968159: New connection from 172.30.32.1:42183 on port 1883.
1654968159: Client <unknown> disconnected, not authorised.
1654968174: New connection from 172.30.32.2:54888 on port 1883.
1654968174: Client <unknown> closed its connection.

et zigbee2mqtt

Zigbee2MQTT:info  2022-06-11 19:55:48: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":108,"power":0,"state":"ON","voltage":236.94}'
zlinky config: historique, single_phase, false, BASE
Zigbee2MQTT:info  2022-06-11 19:56:17: MQTT publish: topic 'zigbee2mqtt/Salle de bains', payload '{"battery":34,"humidity":52.35,"linkquality":144,"temperature":24.82,"voltage":2600}'
Zigbee2MQTT:info  2022-06-11 19:56:17: MQTT publish: topic 'zigbee2mqtt/Salle de bains', payload '{"battery":34,"humidity":53.27,"linkquality":147,"temperature":24.82,"voltage":2600}'
Zigbee2MQTT:info  2022-06-11 19:56:18: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":102,"power":0,"state":"ON","voltage":236.83}'
Zigbee2MQTT:info  2022-06-11 19:56:28: MQTT publish: topic 'zigbee2mqtt/ZLinky', payload '{"active_register_tier_delivered":"TH..","apparent_power":770,"available_power":30,"current_summ_delivered":13266,"current_tarif":"BASE","linkquality":99,"meter_serial_number":"062061183053","rms_current":3,"rms_current_max":90,"update":{"state":"idle"},"update_available":false,"warn_d_p_s":30}'
Zigbee2MQTT:info  2022-06-11 19:56:33: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":99,"power":0,"state":"ON","voltage":236.87}'
Zigbee2MQTT:info  2022-06-11 19:56:37: MQTT publish: topic 'zigbee2mqtt/Detecteur Incendie', payload '{"alarm":null,"battery":100,"battery_low":false,"current_firmware":"4.0.2","enrolled":true,"fault":false,"ias_cie_address":"0x00124b0024c918ac","linkquality":135,"max_duration":20,"reliability":"no_fault_detected","restore_reports":true,"smoke":false,"supervision_reports":true,"temperature":24.75,"test":false,"update":{"state":"idle"},"update_available":false,"voltage":3000,"zone_id":23}'
Zigbee2MQTT:info  2022-06-11 19:56:48: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":102,"power":0,"state":"ON","voltage":237.79}'
Zigbee2MQTT:info  2022-06-11 19:56:52: MQTT publish: topic 'zigbee2mqtt/Capteur Hygrometrie et Temperature', payload '{"battery":99,"humidity":54.5,"linkquality":102,"temperature":null}'
Zigbee2MQTT:info  2022-06-11 19:57:03: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":99,"power":0,"state":"ON","voltage":237.43}'
Zigbee2MQTT:info  2022-06-11 19:57:07: MQTT publish: topic 'zigbee2mqtt/ZLinky', payload '{"active_register_tier_delivered":"TH..","apparent_power":790,"available_power":30,"current_summ_delivered":13266,"current_tarif":"BASE","linkquality":96,"meter_serial_number":"062061183053","rms_current":3,"rms_current_max":90,"update":{"state":"idle"},"update_available":false,"warn_d_p_s":30}'
Zigbee2MQTT:info  2022-06-11 19:57:08: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":102,"power":0,"state":"ON","voltage":237.47}'
zlinky config: historique, single_phase, false, BASE
Zigbee2MQTT:info  2022-06-11 19:57:28: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":114,"power":0,"state":"ON","voltage":236.9}'
Zigbee2MQTT:info  2022-06-11 19:57:29: MQTT publish: topic 'zigbee2mqtt/ZLinky', payload '{"active_register_tier_delivered":"TH..","apparent_power":790,"available_power":30,"current_summ_delivered":13266,"current_tarif":"BASE","linkquality":99,"meter_serial_number":"062061183053","rms_current":6,"rms_current_max":90,"update":{"state":"idle"},"update_available":false,"warn_d_p_s":30}'
Zigbee2MQTT:info  2022-06-11 19:57:33: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":117,"power":0,"state":"ON","voltage":236.8}'
Zigbee2MQTT:info  2022-06-11 19:57:52: MQTT publish: topic 'zigbee2mqtt/ZLinky', payload '{"active_register_tier_delivered":"TH..","apparent_power":790,"available_power":30,"current_summ_delivered":13266,"current_tarif":"BASE","linkquality":105,"meter_serial_number":"062061183053","rms_current":6,"rms_current_max":90,"update":{"state":"idle"},"update_available":false,"warn_d_p_s":30}'
Zigbee2MQTT:info  2022-06-11 19:57:53: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":81,"power":0,"state":"ON","voltage":236.55}'
zlinky config: historique, single_phase, false, BASE
Zigbee2MQTT:info  2022-06-11 19:58:28: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":117,"power":0,"state":"ON","voltage":237.83}'
Zigbee2MQTT:info  2022-06-11 19:58:31: MQTT publish: topic 'zigbee2mqtt/ZLinky', payload '{"active_register_tier_delivered":"TH..","apparent_power":770,"available_power":30,"current_summ_delivered":13266,"current_tarif":"BASE","linkquality":84,"meter_serial_number":"062061183053","rms_current":6,"rms_current_max":90,"update":{"state":"idle"},"update_available":false,"warn_d_p_s":30}'
Zigbee2MQTT:info  2022-06-11 19:58:48: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":123,"power":0,"state":"ON","voltage":236.65}'
Zigbee2MQTT:info  2022-06-11 19:58:49: MQTT publish: topic 'zigbee2mqtt/ZLinky', payload '{"active_register_tier_delivered":"TH..","apparent_power":770,"available_power":30,"current_summ_delivered":13266,"current_tarif":"BASE","linkquality":90,"meter_serial_number":"062061183053","rms_current":3,"rms_current_max":90,"update":{"state":"idle"},"update_available":false,"warn_d_p_s":30}'
Zigbee2MQTT:info  2022-06-11 19:59:13: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":114,"power":0,"state":"ON","voltage":237.15}'
Zigbee2MQTT:info  2022-06-11 19:59:16: MQTT publish: topic 'zigbee2mqtt/ZLinky', payload '{"active_register_tier_delivered":"TH..","apparent_power":770,"available_power":30,"current_summ_delivered":13266,"current_tarif":"BASE","linkquality":102,"meter_serial_number":"062061183053","rms_current":3,"rms_current_max":90,"update":{"state":"idle"},"update_available":false,"warn_d_p_s":30}'
zlinky config: historique, single_phase, false, BASE
Zigbee2MQTT:info  2022-06-11 19:59:18: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":117,"power":0,"state":"ON","voltage":237.54}'
Zigbee2MQTT:info  2022-06-11 19:59:52: MQTT publish: topic 'zigbee2mqtt/Bouilloire', payload '{"linkquality":39,"state":"OFF"}'
Zigbee2MQTT:info  2022-06-11 19:59:53: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":114,"power":0,"state":"ON","voltage":237.72}'
Zigbee2MQTT:info  2022-06-11 19:59:56: MQTT publish: topic 'zigbee2mqtt/ZLinky', payload '{"active_register_tier_delivered":"TH..","apparent_power":780,"available_power":30,"current_summ_delivered":13266,"current_tarif":"BASE","linkquality":105,"meter_serial_number":"062061183053","rms_current":3,"rms_current_max":90,"update":{"state":"idle"},"update_available":false,"warn_d_p_s":30}'
Zigbee2MQTT:info  2022-06-11 19:59:58: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":126,"power":0,"state":"ON","voltage":237.58}'
Zigbee2MQTT:info  2022-06-11 20:00:03: MQTT publish: topic 'zigbee2mqtt/Capteur Toilettes', payload '{"battery":null,"humidity":46.17,"linkquality":135,"temperature":25.79,"voltage":null}'
Zigbee2MQTT:info  2022-06-11 20:00:03: MQTT publish: topic 'zigbee2mqtt/Capteur Toilettes', payload '{"battery":null,"humidity":46.41,"linkquality":135,"temperature":25.79,"voltage":null}'
Zigbee2MQTT:info  2022-06-11 20:00:13: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":123,"power":0,"state":"ON","voltage":237.72}'
zlinky config: historique, single_phase, false, BASE
Zigbee2MQTT:info  2022-06-11 20:00:18: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":126,"power":0,"state":"ON","voltage":237.79}'
Zigbee2MQTT:info  2022-06-11 20:00:39: MQTT publish: topic 'zigbee2mqtt/ZLinky', payload '{"active_register_tier_delivered":"TH..","apparent_power":780,"available_power":30,"current_summ_delivered":13266,"current_tarif":"BASE","linkquality":105,"meter_serial_number":"062061183053","rms_current":3,"rms_current_max":90,"update":{"state":"idle"},"update_available":false,"warn_d_p_s":30}'
zlinky config: historique, single_phase, false, BASE
Zigbee2MQTT:info  2022-06-11 20:01:33: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":111,"power":0,"state":"ON","voltage":237.29}'
Zigbee2MQTT:info  2022-06-11 20:01:37: MQTT publish: topic 'zigbee2mqtt/Detecteur Incendie', payload '{"alarm":null,"battery":100,"battery_low":false,"current_firmware":"4.0.2","enrolled":true,"fault":false,"ias_cie_address":"0x00124b0024c918ac","linkquality":66,"max_duration":20,"reliability":"no_fault_detected","restore_reports":true,"smoke":false,"supervision_reports":true,"temperature":24.75,"test":false,"update":{"state":"idle"},"update_available":false,"voltage":3000,"zone_id":23}'
Zigbee2MQTT:info  2022-06-11 20:01:47: MQTT publish: topic 'zigbee2mqtt/ZLinky', payload '{"active_register_tier_delivered":"TH..","apparent_power":790,"available_power":30,"current_summ_delivered":13266,"current_tarif":"BASE","linkquality":96,"meter_serial_number":"062061183053","rms_current":3,"rms_current_max":90,"update":{"state":"idle"},"update_available":false,"warn_d_p_s":30}'
Zigbee2MQTT:info  2022-06-11 20:01:58: MQTT publish: topic 'zigbee2mqtt/Prise 0cec6', payload '{"current":0,"energy":0.23,"linkquality":99,"power":0,"state":"ON","voltage":237.54}'
Zigbee2MQTT:info  2022-06-11 20:02:00: MQTT publish: topic 'zigbee2mqtt/Presence Placard', payload '{"battery":100,"battery_low":false,"linkquality":135,"occupancy":true,"tamper":false,"voltage":3000}'

Alors c’est HA qui n’est pas connecté au MQTT.
Les autres logs on l’air bons.

Si tu va dans HA Paramètres>Appareils & Sevices > Intégration,
Sur la tuile MQTT tu fais configurer, puis re-configurer mqtt tu devrais pouvoir y remettre ton mot de passe.

1 « J'aime »

je reteste demain, là j’ai redescendu la sauvegarde d’hier soir pour passer la nuit tranquille !!!

C’est bon !!! Sur ma machine restaurée à la date de vendredi , j’ai modifié les mot de passe dans:

  1. paramètres / modules / MQTT / configuration
  2. paramètres / modules / Zigbee2mqtt / configuration
  3. paramètres / intégration / MQTT - configurer / Re-Configure MQTT

ensuite, pour vérifier, j’ai redescendu ma sauvegarde de samedi et fait les 3 mêmes opérations.

j’en ai profité pour virer les entrées user/password qui trainaient dans /config/zigbee2mqtt/configuration.yaml
et retirer le user mqtt-user dans paramètres / personnes / utilisateurs

un reboot pour être certain que tout fonctionne et Hop tout baigne.

au passage, il manque la fonction shutdown dans HA avec la nouvelle interface…
c’est bien pratique quand on veut être certain que la machine est bien débranchable quand on n’a pas de console.

Merci Bentou et bonne année 2024, grâce à tes 1), 2), 3, j’ai pu faire fonctionner mon système.
:partying_face: :partying_face:

C’est à @AlexHass qu’il faut dire merci !!!

Bonne année également !!!