Pi-Hole Says it is blocking >80% of ads, but isn't

Expected Behavior:

Pi-Hole blocks ads from the uploaded ad domain list and properly read out how many ads it is blocking
-Raspberry Pi OS (x32) [Most Recent Version]
-Raspberry Pi 3B+

Actual Behavior:

Pi-Hole Dashboard says it is blocking >80% of ads, but when browsing the internet isn't blocking any.

##Extra Info:
My Router's DNS is not set the the Raspberry Pi's IP address, instead my PC is because I only want the ad-blocker working on my PC.

Debug Token:

https://tricorder.pi-hole.net/bOaUfTej/

That's not what it says. It reports the number of domains blocked. Not all blocked domains would have led to an ad.

From the client that you believe should be connected to the Pi-Hole for DNS, from the command prompt or terminal on that client (and not via ssh or Putty to the Pi), what is the output of

nslookup pi.hole

nslookup flurry.com

nslookup flurry.com 192.168.0.222

Unrelated to your problem, but noted in your debug log, you have a number of URLs in your adlist that don't lead to adlists. This is one example of the many:

https://rereddit.com

nslookup pi.hole
Server: pi.hole
Address: 192.168.0.222

Name: pi.hole
Addresses: fe80::d1c2:8578:33f5:f313
192.168.0.222

nslookup flurry.com
Server: pi.hole
Address: 192.168.0.222

Name: flurry.com
Addresses: ::
0.0.0.0
nslookup flurry.com 192.168.0.222
Server: pi.hole
Address: 192.168.0.222

Name: flurry.com
Addresses: ::
0.0.0.0

Thank you for telling me. I got most of the links from a "superlist" where it should have been a simple copy and paste all of the links, after I get my issue resolved I will probably remove most of the links and only have the ones that are confirmed to block ads and trackers.

I also noticed a lot of recent warnings at the end of your web server log:

2022-09-13 17:56:25: mod_fastcgi.c.487) FastCGI-stderr:PHP Warning:  SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /var/www/html/admin/scripts/pi-hole/php/groups.php on line 952

Looks like your database is not writable (maybe a permission problem).

I don't know what is causing this, but I had this problem when I was setting up the adlists and another post told me to update my gravity which I did and it solved it then. Do you know of a particular reason it could have came back?

I saw this warning message before, on docker installations using volumes.

A possible solution (I didn't test it) is mentioned in a comment here:

If you receive an error while trying to write to a sqlite database (update, delete, drop):

Warning: PDO::query() [function.query]: SQLSTATE[HY000]: General error: 1 unable to open database

The folder that houses the database file must be writeable.

All these outputs are normal, and indicate Pi-hole is working properly.

Check your browser for private or secure DNS settings. These can bypass Pi-hole DNS.

There was a browser DNS setup on Firefox, but after disabling it/telling it to use my PC's settings, I still had ads. I know most of my domains aren't explicitly for blocking ads, but the ones that are are the ones used by the major ad blockers so I know that they should be working.

On a related note, while the Dashboard refers to them as Queries, the Chronometer does in fact refer to them as Ads. The Chronometer wording may need tweaking.

Agreed.
https://github.com/pi-hole/pi-hole/pull/4910

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