InfluxDB: Not all sensors get populated

Configuration
1

Hi there,

yesterday I have setup influxDB and Grafana which works so far. The influxDB gets populated but its missing some sensors. For example a Fibaro Z-Wave Multi-Sensor creates the following sensors in in HA:

  • binary_sensor.fibaro_system_fgms001_motion_sensor_sensor_2_0
  • sensor.fibaro_system_fgms001_motion_sensor_alarm_level_2_1
  • sensor.fibaro_system_fgms001_motion_sensor_alarm_type_2_0
  • sensor.fibaro_system_fgms001_motion_sensor_burglar_2_10
  • sensor.fibaro_system_fgms001_motion_sensor_general_2_0
  • sensor.fibaro_system_fgms001_motion_sensor_seismic_intensity_2_25
  • sensor.fibaro_system_fgms001_motion_sensor_sourcenodeid_2_2
  • sensor.fibaro_system_fgms001_motion_sensor_luminance_2_3
  • sensor.fibaro_system_fgms001_motion_sensor_temperature_2_1

But the last two (marked bold above) are not populated to influx and therefore not accessible in Grafana:

Screenshot_1.png710Ă—319 27.7 KB

This applies for all three Fibrao Multi-Sensores I have and I have also checked that with the Influx client.

My config is very simple and I have no white- or blacklist in place:

influxdb:
    host: localhost
    port: 8086
    database: home_assistant
    default_measurement: state
    tags:
        instance: prod
        source: homeassistant

Sadly luminance and temperature would be the most insteressiting sensores to be analyzed… :pensive:

Would be glad if someone has any ideas where these sensors get lost…

Thanks!

2

The query for me looks like:

“SELECT mean("value") FROM "lux" WHERE "entity_id" = 'fibaro_system_fgms001_motion_sensor_luminance_17_3' AND $timeFilter GROUP BY time($interval) fill(null)”

so it should be “FROM lux” and not “FROM sensor.fibaro_system_fgms001…”.
The temperature sensor creates a “°C” table respectively.

You distinguish the sensors by further choosing “entity_id = your specific sensor”.

Hope that helps.

Sebastian

5 Likes
3

Ahhhhhhhhh, thats how it works! :bulb:

Thanks @sebk-666!

4

Recycling this thread as my question fits in here …
How do you add additional sensor data to the same graph (e.g. temperature living room, temperature basement)? The °C table in influxdb already contains the data I want to be displayed, but I’ve only managed to create graphs containing a single sensor. Example: https://goo.gl/images/5JHwbG (load (in %) of both CPU and memory within the same graph)
TIA

5

@tmeringer Just add the same query multiple times to one graph and just change the entiy ids of the sensors you want to use, see my tempearture graph for example:

1688Ă—1050 160 KB

I’m showing three rooms and the weather temp.

1 Like
6

Thanks. I must have missed the obvious :wink:

Well … seems as if I am running into some known issues right now (Influx 1.2.2-1 and Grafana 2.6.0). See https://github.com/influxdata/influxdb/issues/6220 or https://github.com/grafana/grafana/issues/4475, but that’s outside the scope of this forum.
Edit: updating Grafana did the trick.