Not all values are stored in Influxdb

Configuration
1

To check internetspeed I use this in config:

speedtestdotnet:
  scan_interval:
    minutes: 30
  monitored_conditions:
    - ping
    - download
    - upload

To store these value in Influxdb I use this :

influxdb:
  host: 10.0.0.31
  include:
    entities:
      - sensor.power_consumption_low
      - sensor.power_consumption_phase_l1
      - sensor.regenmeter_hoeveelheid
      - sensor.daily_power_offpeak
      - sensor.daily_power_peak
      - sensor.daily_gas
      - sensor.monthly_power_offpeak
      - sensor.monthly_power_peak
      - sensor.monthly_gas
      - sensor.speedtest_download
      - sensor.speedtest_upload
      - sensor.speedtest_ping

all the values are stored except the speedtest values
what can be wrong ?

speedtest
speedtest786×205 20.1 KB

2

I have a similar setup - speedtestdotnet running every hour and storing all sensor states into InfluxDB - and download/upload/ping are successfully stored in the database.

Are you sure you are looking for the values in the right place? Here a screenshot from Chronograf showing how download/upload appear (ping is under “ms”):
speedtest-influxdb

3

This is what I get when I want to show the available measurementsinfluxdb%20screenshot

Will try to install Chronograf. Seems it has a nice gui

4

Just for comparison, this is my output on the command line:

InfluxDB shell version: 1.7.6
Enter an InfluxQL query
> show databases
name: databases
name
----
_internal
homeassistant
luftdaten
> use homeassistant
Using database homeassistant
> show measurements
name: measurements
name
----
%
A
DU
Incidents
Mbit/s
MiB
UV index
...

Any errors in the influxdb log?

5

I cannot find any logging showing errors. Chronograf did not help me neither.

6

Turned out, that I had to restart the Docker container of Home-assistant. Thank you for your help

1 Like