Potential bug: "Total queries over last 24 hours" empty

General
1

I just noticed that the "Queries in the last 24 hours" bar chart is empty. I generated a debug log for you to take a look at.

Here's my debug log:
https://tricorder.pi-hole.net/heqBF4C4/

2

Your debug log shows that your router is distributing its own IP address as local DNS server:

*** [ DIAGNOSING ]: Discovering active DHCP servers (takes 10 seconds)
   Scanning all your interfaces for DHCP servers
   
   * Received 548 bytes from eth0:192.168.178.1
     Offered IP address: 192.168.178.23
     DHCP options:
      Message type: DHCPOFFER (2)
      router: 192.168.178.1
      dns-server: 192.168.178.1

How did you configure your router to take advantage of Pi-hole?

3

I used this Pi-hole as upstream DNS server for your Fritz!Box.

Also, this used to work until very recently when my raspberrypi had to be restarted.

4

Did you perhaps allow usage of fallback DNS servers in your FritzBox configuration, allowing your FB to use public DNS servers instead of Pi-hole?

5

My Pi-hole is actively used and I can see the numbers in "Total queries" going up. It's just the bar chart that doesn't display anything.

6

What is the API endpoint that's responsible for getting that data? Maybe I can check my query log.

7

I created an issue on the github as well:

8

There are a variety of calls that will show contents of the query database:

echo ">stats >quit" | nc localhost 4711

echo ">top-clients >quit" | nc localhost 4711

echo ">top-domains >quit" | nc localhost 4711

echo ">top-ads >quit" | nc localhost 4711

echo ">querytypes >quit" | nc localhost 4711

echo ">dbstats >quit" | nc localhost 4711

echo ">overTime >quit" | nc localhost 4711
9

I answered your question in Github earlier. There are more than one API endpoint:

  • Total queries 24h graph: admin/api.php?overTimeData10mins;
  • Clients over 24h graph: api.php?overTimeDataClients&getClientNames;
  • Query Types graph (this is working in your github screenshot): api.php?getQueryTypes;
  • Upstream servers graph (also working): api.php?getForwardDestinations.

That screenshot posted in Github shows the first graphic is empty and the second one is absent.

Do you see any error messages in your browser Console (devtools)?

10

Sorry for cross-posting across support channels. If you'd like to suggest one platform where we can continue, I'll go ahead.

I do not see any errors in the browser console. Furthermore, I tried the same thing in Chromium where it also doesn't display the data. A few things happened in the last few days: One was that my raspberry pi shut down unexpectedly and I had to restart, the other one is a few ISP issues (15 minutes without internet access) that shouldn't have had any effect on this.

11

Here are the results for those queries:

12

That may indicate a time issue.
Verify that time and timezone are correct for both the machine hosting your Pi-hole as well as the one running the browser accessing Pi-hole's dashboard.

13

pi@raspberrypi:~ $ date
Wed 17 Apr 00:45:39 CEST 2024

user@My-MacBook-Pro % date
Mi 17 Apr 2024 00:46:40 CEST

Seems okay

14

The results above for >overTime are showing timestamps from 3 or 4 days ago:

1712962500 => GMT: Friday, 12 April 2024 22:55:00
1713048900 => GMT: Saturday, 13 April 2024 22:55:00

15

Any idea what might cause that? Is a certain process not running?

16

Do you see any data on the Long-term Data > Graphics page?
Try the graphic selecting "Today", "Yesterday" and "Last 7 days".

18

I see data for all the ranges:

Screenshot at Apr 17 01-23-15
Screenshot at Apr 17 01-23-15992×504 25.4 KB

Screenshot at Apr 17 01-22-33
Screenshot at Apr 17 01-22-331002×510 26.6 KB

Screenshot at Apr 17 01-22-08
Screenshot at Apr 17 01-22-08995×506 22.8 KB

19

I'm gonna continue this issue only in here. Here's something I posted on the github issue:

Okay, so I noticed that admin/api.php?overTimeData10mins (apparently only executed once when loading) returns

{"domains_over_time":[],"ads_over_time":[]}

Not sure if that is correct.

api.php?overTimeDataClients&getClientNames returns

{"clients":[{"name":"fritz.box","ip":"192.168.178.1"},{"name":"localhost","ip":"127.0.0.1"},{"name":"raspberrypi.fritz.box","ip":"192.168.178.23"},{"name":"localhost","ip":"::1"},{"name":"raspberrypi.fritz.box","ip":"<my public v6 IP>"}],"over_time":[]}
20

Is there anything else you need?

21

Anything further I can provide to help you debug this?