hi ho,
I want to create the MariaDB_size sensor but it seems Iām not able to 
MariaDB runs on Synology. Hassio works on virtual machine also on Synology. Iām working on Supervised mode and the logging works fine.
Database name is home assistant.
I also granted all rights on global and database level.
Now I tried to create the size sensor but without success (Username+password are set correctly):
### MARIA DB SIZE ##############################################################
- platform: sql
db_url: mysql://username:[email protected]:3307/homeassistant?charset=utf8
queries:
- name: 'DataBase_size'
query: 'SELECT table_schema "homeassistant", Round(Sum(data_length + index_length) / 1024 / 1024 / 1024, 2) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema;'
column: 'value'
unit_of_measurement: GB
Does anybody know how I can check what is wrong?
Thanks in advance.
Erik