VictorRobellini / pfSense-Dashboard

A functional and useful dashboard for pfSense that utilizes influxdb, grafana and telegraf
669 stars 184 forks source link

"No data" on Dashboard (pfBlocker Details / Uptime) #76

Open unix1984 opened 9 months ago

unix1984 commented 9 months ago

Hi All,

Screenshot_github

Screenshot_2023-12-10_20-17-59

> select * from system limit 5
name: system
time                host            load1         load15      load5         n_cpus n_unique_users n_users uptime uptime_format
----                ----            -----         ------      -----         ------ -------------- ------- ------ -------------
1702135490000000000 home 0.40380859375 0.322265625 0.46240234375 4      1              3       591138 6 days, 20:12
1702135500000000000 home 0.4951171875  0.330078125 0.4794921875  4      1              3       591148 6 days, 20:12
1702135510000000000 home 0.41845703125 0.326171875 0.462890625   4      1              3       591158 6 days, 20:12
1702135520000000000 home 0.353515625   0.322265625 0.447265625   4      1              3       591168 6 days, 20:12
1702135530000000000 home 0.298828125   0.318359375 0.43212890625 4      1              3       591178 6 days, 20:12

however, there is data in influx shell.

Thanks / Regards

SpreeZ00 commented 9 months ago

Could you show the query and standard options for the uptime widget? Maybe there's an issue.

unix1984 commented 9 months ago

Hi,

The first problem with "No data" was solved this morning. We don't really know what the problem was, but the data appeared this morning.

Here is the data in uptime widget: uptime

or in raw format: SELECT "uptime" FROM "system" WHERE ("host" =~ /^$Host$/) AND $timeFilter

SpreeZ00 commented 9 months ago

What unit did you choose in Grafana? Maybe set it to duration (d hh:mm:ss) or whatever duration you like.

grafik

unix1984 commented 9 months ago

Hi @SpreeZ00

Thanks it worked! :-)

Problem Solved!

Regards