Boas,
Preciso de uma pequena akia pois estou a passar a BD do Hassbian para mysql (externa), a estrutura foi criada com sucesso, apaguei a BD de origem do HA mas não está a escrever no mysql, também já verifiquei as permissões do user
recorder:
db_url: mysql://USERBD:PASSWBD@SERVIDOR/NOME_BD
purge_interval: 3
purge_keep_days: 3
log:
2019-05-16 12:04:45 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb._exceptions.OperationalError) (2006, 'MySQL server has gone away')
[SQL: SELECT events.event_id AS events_event_id, events.event_type AS events_event_type, events.event_data AS events_event_data, events.origin AS events_origin, events.time_fired AS events_time_fired, events.created AS events_created, events.context_id AS events_context_id, events.context_user_id AS events_context_user_id
FROM events
LIMIT %s]
[parameters: (1,)]
(Background on this error at: http://sqlalche.me/e/e3q8)