Same numbers when selecting 'Today'
Little difference can be explained because of logrotation at 06:25. So 00:00 to 06:25 is not visible on Dashboard.
Am I correct?
Numbers that can't be correct at Long Term data. E.g ~1200 blocked on dashboard vs 4 on LT at ~18:00.
p1dr58bhz1
Pi-hole v4.0 Debian amd64 VM fresh install (~one week)
Please post some screen captures showing what you are seeing and why you believe it is not normal.
Here are two screenshots (Dashboard and Long Term)
/etc/pihole/pihole-FTL.db has as timestamp the current date/time.
You are querying over two different time periods. The dashboard shows the most recent 24 hours. In your case, that would be 16:41 yesterday to 16:41 today.
But, in your long term query, you only looked at data from 00:00 today to 16:41 today.
Here is an example from my web Admin page - about 10:00 local at the time.
Dashboard shows the most recent 24 hours:

A query of the long term data using a custom field of 10:00 yesterday to 10:00 today shows very similar data (not exact because the times weren't exact):
Recommendation - try querying your long term query log again, select the custom range you want (24 hours ago until current time), hit the green "Apply" tab and see if the results appear correct.
Did that. Total queries is about the same so that is correct.
But blocked queries 0 is not.
In Long Term data => Query Log => Recent queries there is a domain with status 'Unknown (5)'.
This domain is on my blacklist and on Query Log this same domain has status Pi-holed (blacklist)
Is the status in Long Term data correct?
Thanks for reporting that issue, it seems that there's a bug in the long term data query log. When the normal query log code was updated to support a new Blocked (blacklist) query status, the database code query log was not updated (the query status ID is 5, hence the "Unknown (5)" query status).
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.
