search

home-assistant / addons

:heavy_plus_sign: Docker add-ons for Home Assistant
https://home-assistant.io/hassio/
Apache License 2.0
1.51k stars 1.46k forks source link

Mosquitto broker update to 6.3.1 resulted in multiple apps unable to connect #3205

Closed snigehere closed 1 year ago

snigehere commented 1 year ago

Describe the issue you are experiencing

Error from multiple addons using mqtt

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

Backed out to 6.3.0 and all working again

I didn't see any docs that said I needed to make changes

What type of installation are you running?

Home Assistant OS

Which operating system are you running on?

Home Assistant Operating System

Which add-on are you reporting an issue with?

Mosquitto broker

What is the version of the add-on?

6.3.1

Steps to reproduce the issue

  1. Install 6.3.1 and restarted HA
  2. All integrations that run mqtt unable to connect to the broker
  3. Restarted broker - didn't solve it
  4. restarted HA - didnt solve it
  5. restored 6.3.0 and all ok ...

System Health information

System information

Version | core-2023.8.4 -- | -- Installation Type | Home Assistant OS Development | false Supervisor | true Docker | true User | root Virtual Environment | false Python Version | 3.11.4 Operating System Family | Linux Operating System Version | 6.1.45 CPU Architecture | x86_64 Timezone | Europe/London Configuration Directory | /config

Core Metrics

Processor Usage
0.5 %
Memory Usage
20.2 %

Supervisor Metrics

Processor Usage
0 %
Memory Usage
4.5 %
System information Version core-2023.8.4 Installation Type Home Assistant OS Development false Supervisor true Docker true User root Virtual Environment false Python Version 3.11.4 Operating System Family Linux Operating System Version 6.1.45 CPU Architecture x86_64 Timezone Europe/London Configuration Directory /config Home Assistant Community Store GitHub API ok GitHub Content ok GitHub Web ok GitHub API Calls Remaining 4857 Installed Version 1.32.1 Stage running Available Repositories 1348 Downloaded Repositories 22 Home Assistant Cloud Logged In true Subscription Expiration 12 September 2023 at 01:00 Relayer Connected true Relayer Region eu-central-1 Remote Enabled true Remote Connected true Alexa Enabled true Google Enabled false Remote Server eu-central-1-6.ui.nabu.casa Certificate Status ready Reach Certificate Server ok Reach Authentication Server ok Reach Home Assistant Cloud ok Home Assistant Supervisor Host Operating System Home Assistant OS 10.5 Update Channel stable Supervisor Version supervisor-2023.08.3 Agent Version 1.5.1 Docker Version 23.0.6 Disk Total 30.8 GB Disk Used 11.8 GB Healthy true Supported true Board ova Supervisor API ok Version API ok Installed Add-ons Advanced SSH & Web Terminal (15.0.7), Samba share (10.0.2), Studio Code Server (5.10.1), Mosquitto broker (6.3.0), SQLite Web (3.9.2), Zigbee2MQTT (1.33.0-1), Ring-MQTT with Video Streaming (5.6.2), Terminal & SSH (9.7.1), OneDrive Backup (2.02), Hildebrand Glow To MQTT (1.3.0), Ginlong Solis Wi-Fi To MQTT (1.1.0) Dashboards Dashboards 20 Resources 11 Views 24 Mode storage Recorder Oldest Run Start Time 31 August 2023 at 23:34 Current Run Start Time 6 September 2023 at 17:56 Estimated Database Size (MiB) 502.46 MiB Database Engine sqlite Database Version 3.41.2 Solcast PV Forecast Solcast server connection ok API requests remaining 10 Rooftop site count 2 Sonoff Version 3.5.2 (2ad1cd7) Cloud devices online 0 / 2 Local devices online 2 / 3 Debug page – [more info](http://homeassistant.local:8123/api/sonoff/e0f4e16c-2979-4dac-af7a-b6d605436141) Core Metrics Processor Usage 0.5 % Memory Usage 20.2 % Supervisor Metrics Processor Usage 0 % Memory Usage 4.5 % ### Anything in the Supervisor logs that might be useful for us? ```txt 2023-09-06 17:57:00.005 ERROR (Thread-4 (_thread_main)) [homeassistant.components.mqtt.client] Unable to connect to the MQTT broker: Connection Refused: not authorised. 2023-09-06 17:57:00.126 WARNING (Thread-4 (_thread_main)) [homeassistant.components.mqtt.client] Disconnected from MQTT server core-mosquitto:1883 (5) 2023-09-06 17:57:01.129 ERROR (Thread-4 (_thread_main)) [homeassistant.components.mqtt.client] Unable to connect to the MQTT broker: Connection Refused: not authorised. 2023-09-06 17:57:01.131 WARNING (Thread-4 (_thread_main)) [homeassistant.components.mqtt.client] Disconnected from MQTT server core-mosquitto:1883 (5) 2023-09-06 17:57:03.084 INFO (MainThread) [custom_components.solis.sensor] Scheduling discovery 2023-09-06 17:57:03.084 DEBUG (MainThread) [custom_components.solis.service] Scheduling discovery in 1 seconds. 2023-09-06 17:57:03.134 ERROR (Thread-4 (_thread_main)) [homeassistant.components.mqtt.client] Unable to connect to the MQTT broker: Connection Refused: not authorised. ``` ### Anything in the add-on logs that might be useful for us? _No response_ ### Additional information _No response_
rodrigocvv commented 1 year ago

I am having the same issue here.

franklinvv commented 1 year ago

I have the same issue. I can't connect either, not even with a stand-alone MQTT client. When I rolled back to a backup for 6.3.0 things started working again.

darkxst commented 1 year ago

Clearly fallout from PR #3183, does it work if you explicitly set password_pre_hashed: false in the configs?

snigehere commented 1 year ago

I did toggled it on and off and checked in the yaml it showed false but that didn't fix it

snigehere commented 1 year ago

Update I have recently updated home assistant to a new release

System information

Version | core-2023.9.1 -- | -- Installation Type | Home Assistant OS Development | false Supervisor | true Docker | true User | root Virtual Environment | false Python Version | 3.11.5 Operating System Family | Linux Operating System Version | 6.1.45 CPU Architecture | x86_64 Timezone | Europe/London Configuration Directory | /config

Home Assistant Supervisor

Host Operating System | Home Assistant OS 10.5 -- | -- Update Channel | stable Supervisor Version | supervisor-2023.08.3 Agent Version | 1.5.1 Docker Version | 23.0.6 Disk Total | 30.8 GB Disk Used | 12.3 GB Healthy | true Supported | true Board | ova Supervisor API | ok Version API | ok

So I thought I would again try the update of the addin to 6.3.1 to see if it still failed and, if so, try and collect more logs

I installed and all was ok... restarted HA and all was ok ... so it looks like it is ok this second time around ... I don't know if its connected to HA version or some issue during the first install but its now good for me.

I will not mark as closed for the moment as some others also reported the issue .. if they are also ok on a second go I will mark closed.

mspiridakis commented 1 year ago

Same here!

snigehere commented 1 year ago

closing