0.76: Auth almost done, FleetGo, PJLink, RMV public transport

This release has a migration, initial startup can take ~20 minutes (depends on size DB)

This release includes a database migration to allow us to store context in the database. This will make it possible in the future to introduce attribution. For example, we’ll be able to say which user opened the garage door or which automation triggered the party mode at 3am.

![](upload://x8m9BOMFX3T2HD04yECRAJuOejv.png)

The auth system is entering release candidate status 🎉. If nothing major is found, it will be enabled by default starting the next release (0.77) with backwards compatability modus turned on. If you want to get ahead of the pack, you can already easily enable it now:

homeassistant:
  # add this part
  auth_providers:
   - type: homeassistant
   # uncomment this to enable backwards compatible API password support
   # - type: legacy_api_password

For iOS users, your frontend should be a lot faster. We had an issue that forced us to serve the frontend in compatability mode, which is slower. We haven’t been able to solve the issue, but found a workaround. Race on 🏎.

New Platforms

New Features

  • Add and restore context in recorder (@balloob - #15859) (new-feature)

If you need help…

…don’t hesitate to use our very active forums or join us for a little chat. The release notes have comments enabled but it’s preferred if you use the former communication channels. Thanks.

Reporting Issues

Experiencing issues introduced by this release? Please report them in our issue tracker. Make sure to fill in all fields of the issue template.

Breaking Changes

  • Keenetic NDMS: user needs to have access to the TelNet interface (@foxel - #15511) (device_tracker docs) (breaking change)
  • openweathermap: wind speed is now correctly in km/h (fixes #15710) (@fabaff - #15740) (weather.openweathermap docs) (breaking change)
  • Remove Telstra notifiy component: This API has been decomissioned on the 31st of May 2018 by Telstra (@dgomes - #15757) (notify docs) (breaking change)
  • deCONZ - support for power plugs. Power plugs that are of type “On/Off plug-in unit” and “Smart plug” (Osram and Innr among others) will now be switches instead of lights. Entities will be found as switch.entity_id instead of light.entity_id. (@Kane610 - #15752) (deconz docs) (light.deconz docs) (switch.deconz docs) (breaking change) (new-platform)
  • HTTP: Make sure use_x_forward_for and trusted_proxies must be configured together (@awarecan - #15804) (http docs) (breaking change)
  • Velbus: Breaking changes include auto-discovery support so that you don’t need to specify modules manually anymore in the configuration file, but just load the velbus component which will automatically load the switch and binary_sensor platforms. In addition, the fan and light platforms are removed since these should be modeled with template platform based on velbus switches. (@thomasdelaet - #13742) (velbus docs) (binary_sensor.velbus docs) (switch.velbus docs) (breaking change)
  • Facebox: Events are no longer fired when a face is taught, as these are unnecessary and the info they convey is already in the logs. (@robmarkcole - #15439) (image_processing.facebox docs) (breaking change)
  • AMCrest switch: Fix for multiple camera switches naming of entity. May change switch entity_id. Please check your automation and update the identity-id if you have previously assigned a name to your camera as it appends the name of the camera to the switch id. (@rafale77 - #14028) (switch.amcrest docs) (breaking change)
  • MQTT embedded broker will no longer rely on HTTP API password to automatically configure itself. You need to set own password. (@awarecan - #15929) (mqtt docs) (breaking change) (beta fix)
  • Remove remote.API from core.Config. Might break custom components if they rely on hass.config.api (@awarecan - #15951) (http docs) (breaking change) (beta fix)

Beta Fixes

All changes


This is a companion discussion topic for the original entry at https://www.home-assistant.io/blog/2018/08/17/release-76/
3 Likes

Just a heads up to zwave users that this release has a PyOZW update so it will take time for that to build in addition to the database migration. Have patience during first boot especially if you are on a pi.

1 Like

I updated to 0.76 and now my configuration says invalid for all the entities, help please !!

image

I added the authorization in my config file and now i’m getting the below message every time I refesh the website and the ios app. Is this normal?

image

config:

# add this part for authorization
auth_providers:
 - type: homeassistant
 # uncomment this to enable backwards compatible API password support
 # - type: legacy_api_password

As instructed in the error log maintaining the following in config fixed my problem.

mqtt:
username: USER
password: PASSWORD

1 Like

Read the release note

MQTT embedded broker will no longer rely on HTTP API password to automatically configure itself. You need to set own password. (@awarecan - #15929)

2 Likes

Only password need, username is not.

to keep everything in backward compatibility, you can use http.api_password as mqtt.password, e.g.

http:
  api_password: !secret http_password
mqtt:
  password: !secret http_password
1 Like

could #15929 be a wrong link?
think you had a paste-error.
this would be the correct one https://github.com/home-assistant/home-assistant/pull/15929

thx!

This release doesn’t seem to be playing nice with my MySQL DB will not load history or recorder.

60 <-> 59, shift one column on keyboard :smile:

1 Like

How do webhooks work now with this new authentification system? Will it break ifttt applets?

Can you confirm this? I am on mysql as well and in case I won’t upgrade until solved

Edit: actually on MariaDB10.0.3 but it should be the same

You need to enable legaci_api_password auth_provider for now. We are working on decouple REST API with HTTP api_password, please check https://github.com/home-assistant/home-assistant/issues/15376 for more details.

I’m on 10.1.30-MariaDB-1~jessie (Docker) and had no issues with the migration.

The logger / recorder are not working after upgrading to this version :frowning:

I’m running a MariaDB on another server on my local network.
db_url: mysql://USERNAME:PASSWORD@IP-ADDRESS/hass_db?charset=utf8l

aug. 18 00:52:20 hass hass[24522]: 2018-08-18 00:52:20 INFO (MainThread) [homeassistant.bootstrap] Home Assistant core initialized
aug. 18 00:52:21 hass hass[24522]: 2018-08-18 00:52:21 INFO (MainThread) [homeassistant.loader] Loaded history from homeassistant.components.history
aug. 18 00:52:21 hass hass[24522]: 2018-08-18 00:52:21 INFO (MainThread) [homeassistant.loader] Loaded recorder from homeassistant.components.recorder
aug. 18 00:52:21 hass hass[24522]: 2018-08-18 00:52:21 INFO (MainThread) [homeassistant.loader] Loaded http from homeassistant.components.http
aug. 18 00:52:21 hass hass[24522]: 2018-08-18 00:52:21 INFO (MainThread) [homeassistant.loader] Loaded frontend from homeassistant.components.frontend
aug. 18 00:52:21 hass hass[24522]: 2018-08-18 00:52:21 INFO (MainThread) [homeassistant.loader] Loaded api from homeassistant.components.api
aug. 18 00:52:21 hass hass[24522]: 2018-08-18 00:52:21 INFO (MainThread) [homeassistant.loader] Loaded websocket_api from homeassistant.components.websocket_api
aug. 18 00:52:21 hass hass[24522]: 2018-08-18 00:52:21 INFO (MainThread) [homeassistant.loader] Loaded system_log from homeassistant.components.system_log
aug. 18 00:52:22 hass hass[24522]: 2018-08-18 00:52:22 INFO (MainThread) [homeassistant.loader] Loaded auth from homeassistant.components.auth
aug. 18 00:52:22 hass hass[24522]: 2018-08-18 00:52:22 INFO (MainThread) [homeassistant.loader] Loaded onboarding from homeassistant.components.onboarding
aug. 18 00:52:22 hass hass[24522]: 2018-08-18 00:52:22 INFO (MainThread) [homeassistant.loader] Loaded mqtt from homeassistant.components.mqtt
aug. 18 00:52:22 hass hass[24522]: 2018-08-18 00:52:22 INFO (MainThread) [homeassistant.loader] Loaded logger from homeassistant.components.logger
aug. 18 00:52:22 hass hass[24522]: 2018-08-18 00:52:22 INFO (MainThread) [homeassistant.setup] Setting up logger
aug. 18 00:52:25 hass hass[24522]: 2018-08-18 00:52:25 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8)
aug. 18 00:52:25 hass hass[24522]: 2018-08-18 00:52:25 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
aug. 18 00:52:25 hass hass[24522]: 2018-08-18 00:52:25 WARNING (MainThread) [homeassistant.components.http] Experimental auth api enabled and legacy_api_password support enabled. Please use access_token instead api_password, although you can still use legacy api_password
aug. 18 00:52:31 hass hass[24522]: 2018-08-18 00:52:31 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8)
aug. 18 00:52:31 hass hass[24522]: 2018-08-18 00:52:31 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
aug. 18 00:52:34 hass hass[24522]: 2018-08-18 00:52:34 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.
aug. 18 00:52:34 hass hass[24522]: 2018-08-18 00:52:34 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8)
aug. 18 00:52:34 hass hass[24522]: 2018-08-18 00:52:34 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
aug. 18 00:52:37 hass hass[24522]: 2018-08-18 00:52:37 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8)
aug. 18 00:52:37 hass hass[24522]: 2018-08-18 00:52:37 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
aug. 18 00:52:41 hass hass[24522]: 2018-08-18 00:52:41 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8)
aug. 18 00:52:41 hass hass[24522]: 2018-08-18 00:52:41 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
aug. 18 00:52:44 hass hass[24522]: 2018-08-18 00:52:44 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8)
aug. 18 00:52:44 hass hass[24522]: 2018-08-18 00:52:44 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
aug. 18 00:52:47 hass hass[24522]: 2018-08-18 00:52:47 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8)
aug. 18 00:52:47 hass hass[24522]: 2018-08-18 00:52:47 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
aug. 18 00:52:50 hass hass[24522]: 2018-08-18 00:52:50 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8)
aug. 18 00:52:50 hass hass[24522]: 2018-08-18 00:52:50 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
aug. 18 00:52:53 hass hass[24522]: 2018-08-18 00:52:53 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8)
aug. 18 00:52:53 hass hass[24522]: 2018-08-18 00:52:53 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
aug. 18 00:52:57 hass hass[24522]: 2018-08-18 00:52:57 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8)
aug. 18 00:52:57 hass hass[24522]: 2018-08-18 00:52:57 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1060, "Duplicate column name 'context_id'") [SQL: 'ALTER TABLE events ADD COLUMN context_id CHARACTER(36)'] (Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
aug. 18 00:52:57 hass hass[24522]: 2018-08-18 00:52:57 ERROR (MainThread) [homeassistant.setup] Setup failed for recorder: Component failed to initialize.
aug. 18 00:52:57 hass hass[24522]: 2018-08-18 00:52:57 ERROR (MainThread) [homeassistant.setup] Unable to setup dependencies of history. Setup failed for dependencies: recorder
aug. 18 00:52:57 hass hass[24522]: 2018-08-18 00:52:57 ERROR (MainThread) [homeassistant.setup] Setup failed for history: Could not setup all dependencies.
aug. 18 00:52:59 hass hass[24522]: 2018-08-18 00:52:59 ERROR (MainThread) [homeassistant.setup] Unable to setup dependencies of history_graph. Setup failed for dependencies: history
aug. 18 00:52:59 hass hass[24522]: 2018-08-18 00:52:59 ERROR (MainThread) [homeassistant.setup] Setup failed for history_graph: Could not setup all dependencies.
aug. 18 00:52:59 hass hass[24522]: 2018-08-18 00:52:59 ERROR (MainThread) [homeassistant.setup] Unable to setup dependencies of logbook. Setup failed for dependencies: recorder
aug. 18 00:52:59 hass hass[24522]: 2018-08-18 00:52:59 ERROR (MainThread) [homeassistant.setup] Setup failed for logbook: Could not setup all dependencies.

Your db migration failed for some reason, and the migration process is not protected by transaction, so you either modify the database schema by yourself (see: 0.76 Migration Fails against MSSQL), or delete the database and home-assistant will recreate one for you.

1 Like

Upgraded to 0.76 fine using docker homeassistant image and running latest mariadb image. Took about 5-10 minutes to do the database migration.

can you please explain how did you migrate data?
i am using maridadb on venv.
Please guide
thanks in adv.

just update HA and wait until it is done and your front end loads.

frontend will load but i am getting errors with recorder as i am using mysql/mariadb as my database
Please someone guide
thanks in adv.