I’ve had this working ok for a while now, but now suddenly it doesn’t:
This is the log details on the error I get in HA:
> Error during connection setup to mysql://homeassistant:[email protected]/hass?charset=utf8: (MySQLdb._exceptions.OperationalError) (1115, "Unknown character set: 'utf8mb4'") [SQL: CREATE TABLE statistics_meta ( id INTEGER NOT NULL AUTO_INCREMENT, statistic_id VARCHAR(255), source VARCHAR(32), unit_of_measurement VARCHAR(255), has_mean BOOL, has_sum BOOL, PRIMARY KEY (id) )DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci ] (Background on this error at: https://sqlalche.me/e/14/e3q8) (retrying in 3 seconds)
This is the config in HA:
db_url: mysql://homeassistant:[email protected]/hass?charset=utf8
The mySQL server, version 5.1.36, is located on an old QNAP NAS.
All the equipement was powered down reciently, for the first time in 2 years. Could be related to this, but I cannot figure out why.
Any thoughts where to look? Thanks.