Invalid config for 'notify' at configuration.yaml, line 212: required key 'platform' not provided

qrioniclabs / homeassistant-mysql_command

A Home Assistant custom component that creates a Notify service to send commands (e.g. INSERT) to a MySQL server.

12 stars 3 forks source link

Invalid config for 'notify' at configuration.yaml, line 212: required key 'platform' not provided #10

Open kimsvane opened 5 months ago

kimsvane commented 5 months ago

Im getting

Invalid config for 'notify' at configuration.yaml, line 212: required key 'platform' not provided

I have this in my config file:

Write to db

notify:

name: mysql_command_sdcc_db platform: mysql_command host: 192.168.1.169 username:un password: pw db: sdcc
service: notify.mysql_command_sdcc_db data_template: message: > INSERT INTO table (datetime, column1, column2) VALUES ('{{ now().timestamp() | timestamp_custom('%Y-%m-%d %H:%M:%S') }}', 'value1', 'value2');

I might be doing it wrong, please assist

clau-bucur commented 5 months ago

It works for me like this:

notify:
  - name: mysql_command
    platform: mysql_command
    host: xxxx`
    username: xxx
    password: xxx
    db: homeassistant

kimsvane commented 5 months ago

It works for me like this:

notify:
  - name: mysql_command
    platform: mysql_command
    host: xxxx`
    username: xxx
    password: xxx
    db: homeassistant

I might need to explain better, sorry for that.

the connection seems to be valid, at leat there is no warnings. But i am trying to setup the notification, but HA states that the visual edit cannot edit the code i pasted in automation.yaml, and the key data_template is not supported. And i cannot run the part it states: Unknown error

this is properly a noob issue, nontheless i hope you can help.