Unable to delete single item from whitelist in pihole V5.0

[PA3DSS]

In version 4 of pihole you could manual edit /etc/pihole/whitelist.txt and then pihole -g, like this topic:

Pi-hole whitelist oddity - could not remove site that was added and killed Pi

Expected Behaviour: Should be able to delete a particular item from Pi-Hole whitelist via web Actual Behaviour: Unable to delete single item from whitelist Hi guys. This morning I added a line to my pihole whitelist from the web interface using my phone. The pihole froze up and dns stopped working. So I unplugged the pi and plugged it back in and went back to ad free web browsing. Then I noticed the site I added to my whitelist wasn't working! I went back into the pihole interface and tried to…

How to do that in pihole V5.0 ? I can't find it in the help pages.

[jfb]

In addition to doing this through the web GUI, you can use SQL commands to work directly with the gravity database.

https://docs.pi-hole.net/database/gravity/example/

[PA3DSS]

Thank you, groupmanagment --> domains was in my case the solution, i have to study more about SQL commands

[Edward]

I would add that you can also use phpliteadmin and get easy access to gravity.db. It makes it so much easier.

All you have to do is download the phpliteadmin.php and copy it in the /var/www/html/admin folder and configure the

$directory = '/etc/pihole';

You might also have to install php7.3-mbstring

sudo apt install php7.3-mbstring

Check the version of PHP, ofcourse.

[PromoFaux]

One can also still use the pihole command (per docs)

To remove an item from the whitelist:

pihole -w -d domaintodelete.tld

[PA3DSS]

Nice !! but what is the password after the install ? The default password of the main dashboard i have disabled, password of user pi and root doesn't work unfortunatly

[PA3DSS]

I only use SSH to install, configure, but in the browser, here http://192.168.178.240/admin/phpliteadmin.php , but what Edward mentiond ask about password

[Edward]

I believe the default password is admin. However, if you go to phpaliteadmin.php file, there is a line:

$password = 

You can set it to whatever you want and then you should be good.
Apologies should have mentioned it earlier.

Edward.

[PA3DSS]

Thanks, indeed the password is admin, but if i log in there is nothing
I think it doesn't point to the right database, but i don't understand exactly what to change/configure

[Edward]

There is nothing else to configure as far as I know. The directory setting overrides any database settings. Search for $debug=false and set it to true. It will show any issues with drivers or why it's not able to find any database. For me the mbstring library was missing.

[PA3DSS]

Wth the setting $debug=true i got these error message

I feel sorry but i don't understand what's going on.

edit, btw, my setup is a Pi4 with the latest version of strech with the latest updates and a fresh install of pihole V5.0 last week, nothing else is running.

[Edward]

Hi,

As I mentioned in my first message, you will have to install php7.3-mbstring (assuming your php version is 7.3). This has nothing to with pihole.
sudo apt install php7.3-mbstring

That should fix it.

Edward.

[PA3DSS]

Hey Edward, ofcourse i installed php7.3-mbstring yesterday.

[Edward]

Sorry.
Don't know beyond that. After I installed php7.3-mbstring, this was resolved.
Did you restart the webserver for it to find the php7.3-mbstring?

Maybe just reboot the pi to be safe.

Edward.

[Paul]

I've never used phpliteadmin and after installing it (sudo apt-get install -y phpliteadmin) on Ubuntu 20.04, I can't find a phpliteadmin.php file to copy to /var/www/html/admin. I do have an /etc/phpliteadmin.config.php file. But don't see much else (yes a /etc/php/7.4 directory).

[Edward]

I never installed anything. I just downloaded the file, unzipped it and placed the php file in the admin folder. Hope that helps.

[PA3DSS]

YES !! The reboot did the trick, thanks Edward