InfluxDB not populating

Configuration
1

Hi,

I want to store all my sensor data in Influx but doesn’t appear to be populating with any data. HA can see Influx, as it created fields for the sensor names - but doesn’t appear to populate any measurements.
I’m running the latest version of HA 0.38.3. Is the InfluxDB integration functioning ?

Thanks

2

It is working fine for me with 0.38.3 with influxdb and grafana.

I seem to remember, from when I was getting started, that adjusting the grafana display was a bit of a problem. Clicking the time at the top right hand corner and choosing ‘last 3 hours’ eventually got some data displayed.

3

Installed InfluxDB and Grafana yesterday for testing purposes and configured HA to use it. It took some time, but it was populated by HA. Unfortunally, the “climate” domain was not pushed, so I removed everything again.

But - it should work.

4

Thanks for your help. Is there a command I can run in the Influx CLI that should show me data. The example under the Influx HA blog page says to try “SELECT * FROM binary_sensor”. This doesn’t return anything and tried this for all combinations of sensors I haave and still nothing.

Thanks

5

Try something like this

pi@raspberrypi:/home/homeassistant/.homeassistant
$ influx
Visit https://enterprise.influxdata.com to register for updates, InfluxDB server management, and monitoring.
Connected to http://localhost:8086 version 1.1.0
InfluxDB shell version: 1.1.0
> use home_assistant
Using database home_assistant
> select "value" from "binary_sensor.lounge_motion_sensor"
name: binary_sensor.lounge_motion_sensor
time                    value
----                    -----
1480689103831160064     0
1480689545270433024     0
6

Still no joy i’m afraid, this is what I have tried:

homeassistant@rpi:/home/pi$ influx
Connected to http://localhost:8086 version 1.2.0
InfluxDB shell version: 1.2.0
> use home_assistant
Using database home_assistant
> show series
key
---
%,domain=sensor,entity_id=hallway_thermostat_humidity
%,domain=sensor,entity_id=humidity
W,domain=sensor,entity_id=fibaro_system_fgd212_dimmer_2_power_2_4
W,domain=sensor,entity_id=fibaro_system_fgd212_dimmer_2_power_2_8
device_tracker.owntracksap_iphone,domain=device_tracker,entity_id=owntracksap_iphone
device_tracker.owntrackspp_iphone,domain=device_tracker,entity_id=owntrackspp_iphone
kWh,domain=sensor,entity_id=fibaro_system_fgd212_dimmer_2_energy_2_0
°C,domain=sensor,entity_id=hallway_thermostat_target
°C,domain=sensor,entity_id=hallway_thermostat_temperature
ºC,domain=sensor,entity_id=temperature

> show measurements
name: measurements
name
----
%
W
device_tracker.owntracksap_iphone
device_tracker.owntrackspp_iphone
kWh
°C
ºC

> select "value" from "sensor.humidity"
> select * from "sensor.humidity"
> select * from "sensor.temperature"
> select * from sensor.temperature
>

All of the select statements return nothing

Thanks

7

it should be

select * from “%” where entity_id = ‘sensor.humidity’

8

Thanks for your help. I did manage to get it working in the end by slightly tweaking your statement… This worked :

 select * from "%" where entity_id = 'humidity'

:slight_smile:

1 Like