J’ai pu retrouver ma connexion en https par contre j’ai plein d’erreurs…Zigbee2mqtt me met « 502 : bad gateway » sur l’interface web quand je vais dessus car mes devis en zigbee sont indisponibles. Dans le journal de Z2MQTT j’ai :
s6-overlay-suexec: fatal: can only run as pid 1
Et dans le journal de HA :
Database connection invalidated: Error executing query: (MySQLdb._exceptions.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id, context_parent_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)] [parameters: ('state_changed', '{}', 'LOCAL', datetime.datetime(2022, 5, 24, 9, 40, 1, 258272, tzinfo=datetime.timezone.utc), datetime.datetime(2022, 5, 24, 9, 40, 1, 258272, tzinfo=datetime.timezone.utc), 'ddc8be81693eecff35e047b9e4430f9d', None, None)] (Background on this error at: https://sqlalche.me/e/14/e3q8). (retrying in 3 seconds)
11:41:33 – (ERREUR) Recorder - message survenu pour la première fois à 11:39:27 et apparu 39 fois.
SQLAlchemyError error processing task EventTask(event=<Event time_changed[L]: now=2022-05-24T11:39:48.001649+02:00>): This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (MySQLdb._exceptions.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id, context_parent_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)] [parameters: ('state_changed', '{}', 'LOCAL', datetime.datetime(2022, 5, 24, 9, 39, 47, 368952, tzinfo=datetime.timezone.utc), datetime.datetime(2022, 5, 24, 9, 39, 47, 368952, tzinfo=datetime.timezone.utc), '7d67705f57062eee07532360e02361d0', None, None)] (Background on this error at: https://sqlalche.me/e/14/e3q8) (Background on this error at: https://sqlalche.me/e/14/7s2a)
11:41:33 – (ERREUR) Recorder - message survenu pour la première fois à 11:39:30 et apparu 38 fois.
Failed to to call /addons/7ad98f9c_zigbee2mqtt_edge/stats - Container addon_7ad98f9c_zigbee2mqtt_edge is not running
11:39:51 – (ERREUR) Home Assistant Supervisor - message survenu pour la première fois à 11:39:46 et apparu 2 fois.
Error executing statistics: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (MySQLdb._exceptions.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id, context_parent_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)] [parameters: ('service_registered', '{"domain":"recorder","service":"purge"}', 'LOCAL', datetime.datetime(2022, 5, 24, 9, 36, 21, 889120, tzinfo=datetime.timezone.utc), datetime.datetime(2022, 5, 24, 9, 36, 21, 889120, tzinfo=datetime.timezone.utc), 'c3568ee1ef45a01b51fa0b183cc0cfbe', None, None)] (Background on this error at: https://sqlalche.me/e/14/e3q8)
11:36:54 – (ATTENTION) Recorder - message survenu pour la première fois à 11:36:54 et apparu 36 fois.
Error executing query: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (MySQLdb._exceptions.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id, context_parent_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)] [parameters: ('service_registered', '{"domain":"recorder","service":"purge"}', 'LOCAL', datetime.datetime(2022, 5, 24, 9, 36, 21, 889120, tzinfo=datetime.timezone.utc), datetime.datetime(2022, 5, 24, 9, 36, 21, 889120, tzinfo=datetime.timezone.utc), 'c3568ee1ef45a01b51fa0b183cc0cfbe', None, None)] (Background on this error at: https://sqlalche.me/e/14/e3q8)
11:36:54 – (ERREUR) Recorder - message survenu pour la première fois à 11:36:54 et apparu 36 fois.
Error setting up platform legacy bluetooth_le_tracker
11:36:46 – (ERREUR) Dispositif de suivi
No Bluetooth LE devices to track!
11:36:46 – (ATTENTION) bluetooth_le_tracker
Platform systemmonitor does not generate unique IDs. ID disk_free already exists - ignoring sensor.disk_free
11:36:46 – (ERREUR) Capteur - message survenu pour la première fois à 11:36:46 et apparu 4 fois.
Cannot read CPU / processor temperature information
11:36:46 – (ATTENTION) systemmonitor
Configuration of the Version platform in YAML is deprecated and will be removed in Home Assistant 2022.4; Your existing configuration has been imported into the UI automatically and can be safely removed from your configuration.yaml file
11:36:46 – (ATTENTION) Version
Could not sync group address '24/4/43' (Salle de bains parentale - State)
11:36:41 – (ATTENTION) /usr/local/lib/python3.9/site-packages/xknx/remote_value/remote_value.py
Error: KNX bus did not respond in time (2.0 secs) to GroupValueRead request for: 24/4/43
11:36:41 – (ATTENTION) /usr/local/lib/python3.9/site-packages/xknx/core/value_reader.py
Failed to connect to MQTT server due to exception: [Errno 111] Connection refused
11:36:37 – (ERREUR) MQTT
The 'tunneling' option near /config/configuration.yaml:23 is deprecated, please remove it from your configuration
11:36:37 – (ATTENTION) KNX
Can't read Supervisor data: Container addon_7ad98f9c_zigbee2mqtt_edge is not running
11:36:36 – (ATTENTION) Home Assistant Supervisor
The 'base_url' option near /config/configuration.yaml:191 is deprecated, please remove it from your configuration
11:36:33 – (ATTENTION) HTTP
Ended unfinished session (id=315 from 2022-05-19 07:46:47)
11:36:33 – (ATTENTION) Recorder
Setup of recorder is taking over 10 seconds.
11:36:31 – (ATTENTION) /usr/local/lib/python3.9/asyncio/events.py
Error during connection setup: (MySQLdb._exceptions.OperationalError) (2002, "Can't connect to MySQL server on 'core-mariadb' (115)") (Background on this error at: https://sqlalche.me/e/14/e3q8) (retrying in 3 seconds)
11:36:30 – (ERREUR) Recorder - message survenu pour la première fois à 11:36:21 et apparu 4 fois.