I'm having an issue with the pihole not flushing the log daily. Running the command pihole -f doesn't give any error (says done), but also does not flush the log. Same for running the command from the web admin (The Pi-Hole log file has been flushed). My log file is currently 123mb and growing!
I've also run the pihole -r (repair) command and see no errors.
I went and took a look at the owner & permissions for /etc/pihole to see if there was anything funky, and realized a while back I ran chown -R to that directory to my user account (stupid I know, just getting familiar with linux and thought it would make it easier for me to edit adlists.list).
I ran sudo chown -R root /etc/pihole and everything is working properly.
Sorry for wasting your time, and thanks for the help!
No worries, you didn't waste our time. Think of the user who will have eventually something similar and can safe hours of troubleshooting due to our small conversation
That image shows that it is working correctly - there is a 24hr rolling window of queries. If it goes beyond that 24hrs (without telling FTL to do so), then it would be working incorrectly. You can switch to the previous behavior of flushing everything at midnight by adding this line to /etc/pihole/pihole-FTL.conf:
Check your time zone on your Pi-hole. It may think midnight is when you have 02:00. The displayed time in the graphs always show the time with respect to the time zone on the viewing (not the graph generating) machine for the sake of convenience. By this, the graph you see is always in your local time zone.