Struggling with InfluxDb

Configuration
1

Hallo,
i am pretty new to the HomeAssistent World, but , comming from OpenHab, i am quite happy with the simplicity from Home Assistant.

I have integrated some MQTT Sensors which i can observe in my Dasboard. Now i want to store these Sensors in InfluxDBand create some fancy grafana dashboards. It seems so, that InfluxDB and Grafana are installed properly.

When i run
with this text in the configuration i dont get any errors in the home assistant log

influxdb:
    host: 192.168.0.190
    port: 8086
    database: home
    username: hoas
    password: sagichnicht
    max_retries: 300
    ssl: false´

But when I add an entity to record with

    include:
    entities:
       - sensor.qnap_nas_power`

I get this Entry in the home-assistant.log

2023-02-06 16:26:05.108 ERROR (MainThread) [homeassistant.components.hassio] The system cannot restart because the configuration is not valid: Invalid config for [influxdb]: expected a dictionary for dictionary value @ data['influxdb']['include']. Got None extra keys not allowed @ data['influxdb']['entities']. Got ['sensor.qnap_nas_power']. (See /config/configuration.yaml, line 120). 2023-02-06 16:26:05.110 ERROR (MainThread) [aiohttp.server] Error handling request Traceback (most recent call last): File "/usr/local/lib/python3.10/site-packages/aiohttp/web_protocol.py", line 435, in _handle_request resp = await request_handler(request) File "/usr/local/lib/python3.10/site-packages/aiohttp/web_app.py", line 504, in _handle resp = await handler(request) File "/usr/local/lib/python3.10/site-packages/aiohttp/web_middlewares.py", line 117, in impl return await handler(request) File "/usr/src/homeassistant/homeassistant/components/http/security_filter.py", line 60, in security_filter_middleware return await handler(request) File "/usr/src/homeassistant/homeassistant/components/http/forwarded.py", line 100, in forwarded_middleware return await handler(request) File "/usr/src/homeassistant/homeassistant/components/http/request_context.py", line 28, in request_context_middleware return await handler(request) File "/usr/src/homeassistant/homeassistant/components/http/ban.py", line 80, in ban_middleware return await handler(request) File "/usr/src/homeassistant/homeassistant/components/http/auth.py", line 236, in auth_middleware return await handler(request) File "/usr/src/homeassistant/homeassistant/components/http/view.py", line 145, in handle result = await result File "/usr/src/homeassistant/homeassistant/components/api/__init__.py", line 325, in post await hass.services.async_call( File "/usr/src/homeassistant/homeassistant/core.py", line 1787, in async_call task.result() File "/usr/src/homeassistant/homeassistant/core.py", line 1824, in _execute_service await cast(Callable[[ServiceCall], Awaitable[None]], handler.job.target)( File "/usr/src/homeassistant/homeassistant/components/hassio/__init__.py", line 529, in async_handle_core_service raise HomeAssistantError( homeassistant.exceptions.HomeAssistantError: The system cannot restart because the configuration is not valid: Invalid config for [influxdb]: expected a dictionary for dictionary value @ data['influxdb']['include']. Got None extra keys not allowed @ data['influxdb']['entities']. Got ['sensor.qnap_nas_power']. (See /config/configuration.yaml, line 120).

Can anyone tell me what my mistake is?

2

Could you please post your yaml as formatted code (</> icon)?

Yaml is very strict with indention and that gets lost if you do not use the code feature here.

3

So the relevant Code in the configuration.yaml looks like this:

influxdb:
    host: 192.168.0.190
    port: 8086
    database: home
    username: hoas
    password: sagichnicht
    max_retries: 300
    ssl: false
    include:
    entities:
       - sensor.qnap_nas_power
4

okayyy… just changed the spacing to

influxdb:
    host: 192.168.0.190
    port: 8086
    database: home
    username: hoas
    password: hoas
    max_retries: 300
    ssl: false
    include:
      entities:
       - sensor.qnap_nas_power

and now i have all entities in the DB?! I thought i have to define the ones which i want to store in the InflxDatabase via include entities?

5

Ok for some reasons, which i dont understand, influx recorded all entities for only a few minutes, now it is again recording nothing.

6

Without the includes/excludes it’s was recording everything.

Now you have an include it will only record that sensor, but only when it changes state.