Speedtest-Tracker icon indicating copy to clipboard operation
Speedtest-Tracker copied to clipboard

[Feature Request] Guide for using InfluxdbV2 with Speedtest-Tracker Avalible Now at Grafana Dashboard 16428

Open masterwishx opened this issue 2 years ago • 13 comments

Finaly uploaded my dashboard to Grafana with instructions Speedtest Tracker - InfluxDBv2 https://grafana.com/grafana/dashboards/16428

This dashboard shows data collected by Speedtest Tracker (https://github.com/henrywhitaker3/Speedtest-Tracker) and exported in an InfluxDBv1 database witch is connected to InfluxDBv2 bucket.

How to use it :

(InfluxDBv1 client connect to InfluxDBv2)

  1. create bucket in InfluxDBv2 2.1 create or use exist API token (ALL ACCESS) for create dbv1 and auth. 2.2 create API token (read/write) for this bucket to use with Grafana.

  2. Enter in Console of InfluxDBv2.

  3. Make DB:

influx v1 dbrp create -t yourtokenALLACCESS --bucket-id yourbucketid --db speedtest-tracker --rp v1-rp --default -o yourorg

  1. Make User:

influx v1 auth create -t yourtokenALLACCESS --username speedtest --password speedtestpass --write-bucket yourbucketid -o yourorg

  1. Config Client of InfluxDBv1(Speedtest-tracker) by entered data : db username, db pass , etc ...

  2. Check in InfluxDBv2 in Data Explorer that data is exist in bucket

  3. Then you can select all data needed and switch to Script Editor copy the script (already done)

  4. Configure Grafana to use with data from InfluxDBv2 ( select datasource = InfluxDB , Query Language = Flux ,Organization = yourorg , Bucket = speedtest , Token = yourtoken for bucket )

  5. import this script in Grafana Dashboard .

  6. Enjoy

Based on https://grafana.com/grafana/dashboards/16339

myspeedtest

masterwishx avatar Jun 11 '22 17:06 masterwishx

I've tried but i still got no data in db. I checked your picture and i followed you guide with exactly the same config except for my hostname (ip).

Bronom avatar Aug 28 '22 06:08 Bronom

can you post more info on your setup from influxdb ang grafana ?

masterwishx avatar Aug 28 '22 15:08 masterwishx

I have influxdb on docker currently running with telegraf on windows and 2 exportarr on docker. I also have speedtest-tracker in docker who run everyday on 5AM. I would like to add your dashboard on my grafana, but my Speedtest tracker seems to not storing any data in influxdb 2. So i followed you guide by creating a new bucket called speedtest or with the same name for both bucket (speedtest-tracker)

Creating a new token with or without full access (for debuging).

Open the bash console for influxdb entering both commands with the info.

influx v1 dbrp create -t MYNEWTOKEN --bucket-id (speedtest-tracker bucket id) --db speedtest-tracker --rp v1-rp --default -o MYORGNAME

influx v1 auth create -t MYNEWTOKEN --username speedtest --password speedtestpass --write-bucket (speedtest-tracker bucket id) -o MYORGNAME

I also tried with my current user i currently use.

I entering my connection information in Speedtest-tracker influx cb enable : Checked http://(The ip of my server) port 8086 speedtest-tracker (i also tried with same db name for both and differents name) speedtest (or with my current user i use) speedtestpass (or with my current user password i use) and save

But now when i go in influxdb explorer i can't get any data its just empty

My grafana seems to connect successfully to influxdb but don't display data because my bucket looks empty.

EDIT: I tried with my current server and a VM and both don't work.

Bronom avatar Aug 28 '22 15:08 Bronom

Befor grafana you should check if all data you created for speedtest is shown in influxdb data exploer.

For 'influx v1 dbrp create -t yourtoken' you need use Main token for ALL ACCCESS that allow to great db and auth , (i think token for buket dont allow to create db and auth) and the token you ctreat is for use in grafana for read write buket.

if you made all right you can check from console that db and auth is created , and if still no value from speedtest-tracker. try to disable and save then enable and save checkbox in speedtest. image

masterwishx avatar Aug 28 '22 18:08 masterwishx

I just did everything again and is still doesn't work. The db is still empty. I tried to disable enable the checkbox and no success

Bronom avatar Aug 28 '22 19:08 Bronom

I finally make it work. Im not sure how i did it but the last thing i tried was to remove the http:// before the host. I already tried it before but now it work.!

Bronom avatar Aug 28 '22 20:08 Bronom

I hope @masterwishx can help me out: I created everything and I get data in my bucket. But the Grafana Dashboard is showing nothing.

My Settings: Influx: Bucket = speedtest influx v1 db name = speedtest-tracker username = speedtest

Grafana: Name: speedtest-tracker QueryLang: Flux URL= Pointing to my Influx LXC (which works ) eg. http://influx:8086 Auth is Basic with credentials skipping tls Basic Auth Details: Username and Password I created eg. influx v1 auth create etc. Default Bucket: speedtest (not sure if I have to use my bucket name or the speedtest-tracker db?)

What I'm doing wrong here?

badummtss avatar Sep 23 '23 11:09 badummtss

solved I used your newer dashboard https://grafana.com/grafana/dashboards/16428 and everything is working fine

badummtss avatar Sep 23 '23 11:09 badummtss