Failed to connect to external MQTT server (Since upgrading to 0.113.3 and 0.114)

Hi,

Since upgrading from 0.112.x to 0.113.3, (edit: also tried now with 0.114) HA fails to connect to my MQTT server.
This is the error:

2020-08-03 22:13:03 ERROR (Thread-8) [homeassistant.components.mqtt] Unable to connect to the MQTT broker: Connection Refused: not authorised.
2020-08-03 22:13:03 WARNING (Thread-8) [homeassistant.components.mqtt] Disconnected from MQTT server mqtt.flespi.io:1883 (5)

I also tested with another MQTT server, who failed with this error:

2020-08-03 22:10:27 WARNING (Thread-8) [homeassistant.components.mqtt] Disconnected from MQTT server mqtt.dioty.co:1883 (1)

This is my configuration - all standard:

mqtt:
  broker: mqtt.flespi.io
  port: 1883
  client_id: flespiHaId
  username: !secret flespi_authentication 

and I also tried with the following to no avail:

  tls_insecure: true

There are breaking changes related to MQTT on latest release (see here), but it doesn’t seem to be related to my issue…

Any idea what is wrong here? Thanks

You restored a snapshot. The database is corrupted again. Simply delete it once more.

Yes, thanks, just figured it out. I was sure a restore action allows using the DB as it was.

Anyway, it was off-topic. MQTT still needs to work when moving to latest version. Any idea?

Not a clue. I have 3 instances of HA, all upgraded to 0.113.x, and the all connect fine to my mqtt server. It is not an external one, but my mqtt server runs on a separate Pi.

Sure, thanks. Will continue to wait patiently…

Hi,
Still with this issue. I thought that maybe with 0.114 it will work. It didn’t.
I also tested the following:
removed the MQTT settings from the configuration.yaml file and added the MQTT through the Integrations panel. the process ends successfully, but still no MQTT communication and in the log I can fiind many entries like:

2020-08-13 20:32:09 ERROR (Thread-26) [homeassistant.components.mqtt] Unable to connect to the MQTT broker: Connection Refused: not authorised.
2020-08-13 20:32:09 WARNING (Thread-26) [homeassistant.components.mqtt] Disconnected from MQTT server mqtt.flespi.io:1883 (5)

When I go back to 0.112.3 - all works as expected, either through the configuration file or by the integrations panel.

Any help will be highly appreciated as it prevents me from upgrading.

As last resort I assume I will have to reinstall everything from scratch but is something I really try to avoid…

Thanks!

So I took the step of loading a fresh new hass.io version (0.114.3). Once loaded, I only logged in using the welcome wizard and then headed to add MQTT using the integrations option on the configuration menu. It ended successfully and then I headed to the core logs just to find out the same error as before -

2020-09-02 12:19:27 ERROR (Thread-8) [homeassistant.components.mqtt] Unable to connect to the MQTT broker: Connection Refused: not authorised.
2020-09-02 12:19:27 WARNING (Thread-8) [homeassistant.components.mqtt] Disconnected from MQTT server mqtt.flespi.io:1883 (5)

How can it be I’m the only one facing this issue?

I’ll appreciate any advice!