After latest update "no domains on blocklist"

DanSchaper · February 26, 2020, 4:10am

Okay, ls -la /etc/pihole and then sqlite3 /etc/pihole/gravity.db ".tables"

PA3DSS · February 26, 2020, 4:11am

PA3DSS · February 26, 2020, 4:14am

sorry, did just copy-paste

DL6ER · February 27, 2020, 8:56am

Gravity is complaining that you have either no blocking lists or they are all disabled.

Please run

sqlite3 /etc/pihole/gravity.db "SELECT * FROM adlist;"

If the response is empty, please provide the output of

ls /etc/pihole/migration_backup

I assume your initial gravity run (after checking out the beta) was incomplete as there should be no adlists.list in your /etc/pihole any longer (however, in your screenshot, there clearly is one).

PA3DSS · February 27, 2020, 9:47am

After the first release of 5.0 beta i installed a fresh buster on the pi with pihole 4.3.2, after that the 5.0 beta, so i was sure there was no other old software involved.

DL6ER · February 27, 2020, 9:54am

Yes, the adlists are all disabled. You seem to have done this via the web GUI, there is no real other way in which this could have happened.

Go to http://pi.hole/admin/groups-adlists.php
Enable all adlists you want to use
Run pihole -g

PA3DSS · February 27, 2020, 10:01am

done

, unfortunatly the same result

jpgpi250 · February 27, 2020, 10:03am

Enable blocklists on the settings page

PA3DSS · February 27, 2020, 10:05am

OMG, my big mistake....

i feel verry sorry @DL6ER !!

PA3DSS · February 27, 2020, 10:07am

It's all there @jpgpi250

DL6ER · February 27, 2020, 10:13am

The two pages are equivalent. The latter will disappear at some point, seems there is still some PR under review as I already coded this.

Does it work now?

PA3DSS · February 27, 2020, 10:17am

Well, not for 100% as far as i can see because dbl.oisd.nl has on it's own more the a million domains and they are not there, they were there before i this topic started.

PA3DSS · February 27, 2020, 10:22am

Anyway the block works properly from those big list.

jfb · February 27, 2020, 11:51am

What is the output of pihole -g

PA3DSS · February 27, 2020, 12:05pm

The site dbl.oisd.nl seems to be down at the moment, but it was there before i this topic started.

jfb · February 27, 2020, 12:14pm

Gravity update is working properly, it appears. If a list is unavailable on the web, it cannot be loaded into Pi-hole.

PA3DSS · February 27, 2020, 12:17pm

Yes, i understand that, but i can't check if it's in the database or not, it was there before so it should not be deleted, here are the files including file sizes, the card has plenty of space

jfb · February 27, 2020, 12:23pm

Since Pi-hole attempted to load the list and failed, the URL of the list is in the database. The contents of the list are not, since you had disabled the list previously.

PA3DSS · February 27, 2020, 12:29pm

Ah, ok, why it was disabled i can't tell you, almost daily i run "pihole -up" in beta 5.0, so it was deleted from the database as wel ? If so, the number of blocked domains are ok i think.

DL6ER · February 29, 2020, 9:42am

Yes, everything seems to be fine here. Thanks for checking.