search

deividgdt / ytadsblocker

YTadsblocker is a script to block all the Youtube's advertisement in Pi-Hole
GNU General Public License v3.0
97 stars 14 forks source link

problem when querylogging is off #14

Open petergeelhoed opened 3 years ago

petergeelhoed commented 3 years ago

This will not work when the querylogging is off.

I propose that you use something like:

echo " select domain from queries where domain like '%.googlevideo.com'and status in (2, 3,14,12,13) group by domain" | /usr/bin/sqlite3 /etc/pihole/pihole-FTL.db | grep 'r[0-9]{1,2}[^-].*.googlevideo.com'

deividgdt commented 3 years ago

Hi @petergeelhoed ,

You're right, I hadn't think about this. I'll take look to your comment, and I'll do some tests.

Kind regards,