Historical data, lists, graphs don't work

No effect whatsoever. Still no historical data.

Let's run a quick check on your SD card space - please paste output of

df -h -a

pi@pi-hole:~ $ df -h -a
df: /proc/sys/fs/binfmt_misc: No such device
Filesystem      Size  Used Avail Use% Mounted on
/dev/root        29G  1.7G   26G   6% /
devtmpfs        460M     0  460M   0% /dev
sysfs              0     0     0    - /sys
proc               0     0     0    - /proc
tmpfs           464M     0  464M   0% /dev/shm
devpts             0     0     0    - /dev/pts
tmpfs           464M   24M  441M   6% /run
tmpfs           5.0M  4.0K  5.0M   1% /run/lock
tmpfs           464M     0  464M   0% /sys/fs/cgroup
cgroup             0     0     0    - /sys/fs/cgroup/systemd
cgroup             0     0     0    - /sys/fs/cgroup/cpu,cpuacct
cgroup             0     0     0    - /sys/fs/cgroup/net_cls
cgroup             0     0     0    - /sys/fs/cgroup/cpuset
cgroup             0     0     0    - /sys/fs/cgroup/devices
cgroup             0     0     0    - /sys/fs/cgroup/freezer
cgroup             0     0     0    - /sys/fs/cgroup/blkio
mqueue             0     0     0    - /dev/mqueue
sunrpc             0     0     0    - /run/rpc_pipefs
debugfs            0     0     0    - /sys/kernel/debug
configfs           0     0     0    - /sys/kernel/config
/dev/mmcblk0p1   41M   22M   19M  54% /boot
tmpfs            93M     0   93M   0% /run/user/999
tmpfs            93M     0   93M   0% /run/user/1000
pi@pi-hole:~ $

Log into the web interface, then open a new tab and go to http://pi.hole/admin/api_db.php?getGraphData

Share the output.

{"domains_over_time":{"1517376600":235,"1517377200":592,"1517377800":1070,"1517378400":642,"1517379000":302,"1517379600":683,"1517381400":115,"1517382000":778,"1517382600":400,"1517383200":210,"1517383800":393,"1517384400":941,"1517385000":557,"1517385600":353,"1517386200":425,"1517386800":407,"1517387400":336,"1517388000":384,"1517388600":429,"1517389200":115,"1517389800":64,"1517390400":153,"1517391000":100,"1517391600":141,"1517392200":631,"1517392800":635,"1517393400":288,"1517394000":111,"1517394600":949,"1517395200":120,"1517395800":397,"1517396400":1389,"1517397000":711,"1517397600":230,"1517398200":288,"1517398800":297,"1517399400":487,"1517400000":266,"1517400600":423,"1517401200":451,"1517401800":508,"1517402400":179,"1517403000":344,"1517403600":347,"1517404200":215,"1517404800":514,"1517405400":425,"1517406000":237,"1517406600":210,"1517407200":379,"1517407800":157,"1517408400":122,"1517409000":118,"1517409600":112,"1517410200":115,"1517410800":111,"1517411400":112,"1517412000":108,"1517412600":113,"1517413200":109,"1517413800":110,"1517414400":112,"1517415000":115,"1517415600":116,"1517416200":116,"1517416800":111,"1517417400":123,"1517418000":121,"1517418600":104,"1517419200":120,"1517419800":114,"1517420400":109,"1517421000":117,"1517421600":112,"1517422200":107,"1517422800":151,"1517423400":143,"1517424000":111,"1517424600":118,"1517425200":126,"1517425800":116,"1517426400":108,"1517427000":126,"1517427600":107,"1517428200":328,"1517428800":148,"1517429400":140,"1517430000":153,"1517430600":152,"1517431200":133,"1517431800":217,"1517432400":201,"1517433000":171,"1517433600":126,"1517434200":154,"1517434800":191,"1517435400":146,"1517436000":143,"1517436600":130,"1517437200":137,"1517437800":138,"1517438400":134,"1517439000":132,"1517439600":144,"1517440200":186,"1517440800":182,"1517441400":196,"1517442000":172,"1517442600":189,"1517443200":251,"1517443800":293,"1517444400":256,"1517445000":174,"1517445600":197,"1517446200":276,"1517446800":339,"1517447400":349,"1517448000":180,"1517448600":285,"1517449200":455,"1517449800":414,"1517450400":437,"1517451000":409,"1517451600":338,"1517452200":454,"1517452800":425,"1517453400":472,"1517454000":325,

Its dozens and dozens of pages of that, so much so that I reach the character limit when trying to post it all. That was the output of the URL you listed. Thanks for the help, hope this means something to you, ha.

Well, it seems to be returning stuff correctly. Open the dev tools (F12) and got to then network tab. Then refresh the tab and try loading some data from the database. Find the network request in the dev tools and see if it completes. Once it completes, it will take a few seconds before the page shows the data because it has to process it still.

This is the output, not sure how useful it will be without looking at it in real time. I've even had an ssh open a dozen or so times when testing, looking at cpu load and sysload, thinking maybe the wee little pi just can't keep up with a big query, and wondering if I can observe the CPU spike while it "thinks" through the database query. But no such CPU activity is observed. As soon as I make the request in the GUI, the CPU load goes flat, back to baseline.

I should add, to rule it out, that I've tried multiple browsers across several PCs and devices, just to rule out that plug-in etc might be preventing some script from running or something. Same issue, even on a machine with a fresh install of a browser I've never used before, and therefore has no add-on software associated with it.

If you're willing to move to the 4.0 branch (where the devs are actively working), on at least one occasion moving to that branch has cleared up a log issue. Plus, it has some new features and improved performance. Here are the commands if you want to go this route.

echo release/v4.0 | sudo tee /etc/pihole/ftlbranch 
pihole checkout core release/v4.0 
pihole checkout web release/v4.0

Done, thanks. FTL is still at 3.0, said no updates were found on Git, not sure that matters or not.

No effect though, still no historical data. Maybe time for a re-install? Still would like to know what happened though, to prevent it from happening in the future.

The devs would probably like to know as well, but to get you up and running properly I think a fresh install is the best option.

You originally said the graphs didn't work, so instead of checking out the query log, check the graphics page.

Graphics, etc are not working. And now, its showing 2.7 million domains in the block list, with ZERO requests blocked.

Its funny, this will be the fourth time I've completely reinstalled the OS in the last year or so I've been using pihole. After setting up the initial lists I want, I do virtually no maintenance on this system whatsoever. I make no changes after its up and running. I just log in every now and again to check historical data.

Yet each fresh install only seems to last a few months before I need to "nuke it from orbit" like we have to do with Windows machines after a few years of use.

Curious as to why this is.

Perhaps this is a hardware issue. What hardware are you running this on, what brand SD card are you using, and what are the details of your power supply (brand, voltage and current rating)?

There have been a number of threads regarding issues with inadequate power supplies or cables - SD cards do not perform well without adequate power.

Interesting, I hadn't considered power. The SD Card is a Sandisk, and I'd have to go look at the wall wart, but for sure its a $0.99 craptastic job made by 8-year-old Chinese child slave labor. I bought the Pi kit from Fleabay, and it came with the power supply.

Disregard. Its a 2.5 amp Canakit power supply.

LOL. Now I have 2.7mil entries on the black list, 3k queries, and not a single domain blocked........

Guess I need to reload the OS ASAP.

Wish I knew why it broke on its own.

What is the output of the following commands to see how Pi-Hole is handling a known ad-serving domain?

dig flurry.com

dig flurry.com @8.8.8.8

And, can you upload a screen capture of this part of your dashboard?

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.