Pihole -g reads only one list

Help Community Help
1

Hello, every one.
I have the following situation.
I added to the file adlist.list a bug bunch of lists for pihole to block.
But when I do pihole -g it only reads from Steven Black list.
Here is what I have in the adlist.list and the result of pihole -g:
https://pastebin.com/ymrJQqmg

What am I doing wrong?
I run pihole on a Raspberry pi 4, 1 GB - with the OS installed on a 220 GB ssd.
Is there any chance to make it possible to read from all the lists?

On the other hand, blocking or adding regex from the web gui gets me the error message: something went wrong. Nevertheless, from cli I can add domains to the blacklist using pihole -b (I hope I am not wrong with the command).
Must admit that I chose not to install lighttpd due to its conflict with apache on my system. Could that be a problem?
Thanks in advance..

2

That file has not been used since version 4.0. In Pi-hole version 5.0 and later (5.0 was released in May 2020), adlists are stored in the gravity database at /etc/pihole/gravity.db.

Copy the contents of what you pasted into the adlists.list file, then manually enter them into the web GUI. You can paste the lot of them at once from the clipboard. Then update gravity.

Web Admin GUI > Group Management > Adlists

For adding adlists, the web UI is the simplest method. You can install lighttpd and move it to a port other than 80 to remove the Apache conflict.

A permanent way to change the lighttpd port is:

https://discourse.pi-hole.net/t/lighttpd-daemon-wont-start/44985/13

Edit: You can also insert adlists directly into the database using SQL commands. One at a time:

sudo sqlite3 /etc/pihole/gravity.db "INSERT INTO adlist (address, enabled, comment) VALUES ('https://domain.com/blocklist.txt', 1, 'comment')"

or with this Pi-hole command from the terminal:

pihole -a adlist add/del/enable/disable address comment

5

Good morning.
Thanks for your interest. Just tried this:

"sudo sqlite3 /etc/pihole/gravity.db "INSERT INTO adlist (address, enabled, comment) VALUES ('https://mirror1.malwaredomains.com/files/justdomains.txt, 1, 'comment')"
Error: near "comment": syntax error"

Sorry to tell you - I don't really master the sqlite language so I don't know if the comment "test" I put is the correct one or should I have put somenthing different.
ALso, with pihole -a adlist enable https://mirror1.malwaredomains.com/files/justdomains.txt test happens the same as described in the subject: when I update gravity it only updates form one list:

"
  [i] Target: https://raw.githubusercontent.com/StevenBlack/hosts/master/hosts
  [✓] Status: Retrieval successful
  [i] Analyzed 93809 domains
  [i] List stayed unchanged
"

And the rest are ignored. So I don't know what am I doing wrong (I assume it's me, due to the lack of knowledge, of course - pihole appears to work perfectly - or almost...hehe).
Thanks again for your interest.

6

You are missing a single quote (') between txt and , to correctly terminate your blocklist string.

7

You appear to have mismatched '

9

Thanks to you all.
FInally, after reading twice every message of yours, correcting the synthanx the sqlite command did the magic. Now, when I run pihole -g it reads form all the lists I added, one by one using the command.
Thanks again for your fantastic help.

10

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