Adlist editing, mistakenly added 000's of sites, not lists

[maraven2001]

Hi, I have a R-Pi 4 running Pi-Hole, all was well until I mistakenly added nearly 5,000 sites to the adlist, instead of adding lists, now gravity won´t work and it takes forever to delete each site.

How can I edit the adlist contents quickly without having to delete each one individually ?? I tried teleporter but all I get are .json files I have no idea how to use or edit.

How can I quickly edit the list without having to go through all 5,000 sites one by one, having to wait for the update.

Thanks

Manuel

[jfb]

This command from the Pi terminal will delete all your adlists at once. Then you can add back the lists you want.

sudo sqlite3 /etc/pihole/gravity.db "DELETE FROM adlist;"

Restoring default Pi-hole adlist(s)

Pi-hole ships with optional adlist(s) (publicly maintained block lists), which you can enable if you choose. If you find that you need to restore the default list(s), they are as follows - current as of the V5.2 release and a pending change to remove a discontinued list. https://raw.githubusercontent.com/StevenBlack/hosts/master/hosts To restore these lists to your Pi-hole, you have several options: Pi-hole V4: From the web Admin GUI > Settings > Blocklists you can paste any of the URL's …

Rebuild gravity at the end.

[maraven2001]

Thanks will give it a try

[maraven2001]

Something is not working, I get this error:

[✗] Unable to create new database /etc/pihole/gravity_temp.db
/opt/pihole/gravity.sh: line 344: /etc/.pihole/advanced/Templates/gravity.db.sql: No such file or directory

Gravity is not updating for some reason, I did what you recommended, all good, everything erased, added all my adlists again, some did not work, but still managed to add all the rest and now gravity won't update.

[Coro]

@maraven2001

/etc/.pihole/advanced/Templates/gravity.db.sql: No such file or directory

Run ls -lh /etc/.pihole/advanced/Templates and post the output. If it says no directory, try with ls -lh /etc/.pihole/advanced or ls -lh /etc/.pihole/ until you find something works

Somehow an integral part of your Pi-hole installation disappeared.

[maraven2001]

Hi, thanks I will post it, all I have done recently was upgrade to the latest version. BTW Coro you are in whonix as well right ??

[quote="Coro, post:5, topic:37863"]
ls -lh /etc/.pihole/advanced/Templates
[/quote] says no such file directory

[quote="Coro, post:5, topic:37863"]
ls -lh /etc/.pihole/advanced
[/quote]

This is what I get for advanced, templates not there, what do you suggest doing next ??

Thanks

Manuel

[Coro]

@maraven2001

you are in whonix as well right ??

No, I have no idea what "whonix" is

@maraven2001

what do you suggest doing next ??

cd /etc/.pihole
git status --verbose

[jfb]

Please generate a debug log, upload it when prompted and post the token here.

[maraven2001]

:/etc/.pihole $ git status --verbose
HEAD detached at v3.2.1
nothing to commit, working tree clean

This is the result.

[maraven2001]

Will do it now. Thanks

[Coro]

@maraven2001

HEAD detached at v3.2.1
nothing to commit, working tree clean

This is VERY old and outdated. This is at least several years old.

This explains why it did not work, the code is not even aware of the database. I don't understand how anything could have worked at all for you.

Does

pihole checkout master

fix it?

[maraven2001]

@Coro

pihole checkout master

The Pi install is 6 months old tops, I ran the command but nothing happens,
pihole checkout master
/opt/pihole/piholeCheckout.sh: line 51: get_binary_name: command not found
pi@raspberrypi:~ $
is the result

[jfb]

Debug token?

[maraven2001]

https://tricorder.pi-hole.net/5swa2qi26n

[jfb]

You have a mismatch among the Pi-hole parts (three parts). In particular, your core version is quite old and on a different branch then the rest of the install. With one part of Pi-hole being on a different version, the three parts won't work together properly.

*** [ DIAGNOSING ]: Core version
[i] Core: v3.2.1 (https://discourse.pi-hole.net/t/how-do-i-update-pi-hole/249)
[i] Remotes: origin	https://github.com/pi-hole/pi-hole.git (fetch)
             origin	https://github.com/pi-hole/pi-hole.git (push)
[i] Branch: HEAD (https://discourse.pi-hole.net/t/the-pihole-command-with-examples/738#checkout)
[i] Commit: v3.2.1-0-ge602008

*** [ DIAGNOSING ]: Web version
[i] Web: v5.1.1 (https://discourse.pi-hole.net/t/how-do-i-update-pi-hole/249)
[i] Remotes: origin	https://github.com/pi-hole/AdminLTE.git (fetch)
             origin	https://github.com/pi-hole/AdminLTE.git (push)
[i] Branch: master
[i] Commit: v5.1.1-0-ga03d1bd

*** [ DIAGNOSING ]: FTL version
[✓] FTL: v5.2

These commands should clear your local files and get you on the latest master branch:

cd /
sudo rm -rf /etc/.pihole
sudo git clone https://github.com/pi-hole/pi-hole /etc/.pihole

[maraven2001]

Running gravity once more, will let you know how it all goes, thanks !!!

[jfb]

Please generate a fresh debug log and post the token.

[maraven2001]

https://tricorder.pi-hole.net/8dwkvjpqtz

seems to be working now

[maraven2001]

btw thanks for the help, let me know if there's anything else I should do

thanks

Manuel