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 
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.
I am getting the same popup every time I reload the page on my Mac. Even without adding the auth part to my config.
Edit: I am using the lovelace UI
Unable to click any sensors in the web UI after the update, nothing pops up. Also missing stuff from the config sections. It does work in the mobile browser however…not PC. Also getting the save password popup every time (have not added the new auth config).
nothing works, log is full with syntax errors. wtf
2018-08-18 12:54:27 ERROR (MainThread) [homeassistant.components.notify] Unknown notification service specified
Aug 18 12:54:27 raspberrypi hass[3005]: (standard_in) 1: syntax error
Aug 18 12:54:28 raspberrypi hass[3005]: 2018-08-18 12:54:28 ERROR (MainThread) [homeassistant.setup] Unable to setup dependencies of switch.mqtt. Setup failed for dependencies: mqtt
Aug 18 12:54:28 raspberrypi hass[3005]: 2018-08-18 12:54:28 ERROR (MainThread) [homeassistant.setup] Unable to prepare setup for platform switch.mqtt: Could not setup all dependencies.
Aug 18 12:54:28 raspberrypi hass[3005]: (standard_in) 1: syntax error
Aug 18 12:54:30 raspberrypi hass[3005]: 2018-08-18 12:54:30 ERROR (MainThread) [homeassistant.core] Error doing job: Task exception was never retrieved
Did you update your configuration? There was a breaking change for the embedded MQTT broker
yes, all updated
x.0 releases…never works 
1 Like
I have not added anything to configuration.yaml, but I have still the same problem as you.
This problem has been fixed. Will be in next update.
Please can someone help me?
I have updated using Hassio however the version still shows as 0.75.2 and i get the following error:
The following components and platforms could not be set up:
hassio
Please check your config.
Is it just me or is Rename Node gone from the Zwave control panel?
EDIT: Also the question marks in the zwave control panel are broken too. They don’t display any help text.
EDIT2: Reverting back to 0.75.3 didn’t work either. I know this was just working too. And I’m still getting the save login popup like i didn’t properly revert back to 0.75.3 but the info screen says 0.75.3. Anyone have any ideas?