Error, something went wrong! While executing INSERT OT IGNORE: attempt to write a readonly database Added 0 out of 1 domains

unurgunite commented 3 years ago

Versions

Pi-hole version is v5.3.1 (Latest: v5.3.1)
AdminLTE version is v5.5.1 (Latest: v5.5.1)
FTL version is v5.8.1 (Latest: v5.8.1)

Platform

Docker setup from https://github.com/IAmStoxe/wirehole

Expected behaviour I went to http://my_ip/admin/groups-domains.php?type=black and tried to add a domain to blacklist. Since then this domain is not accessible from my network

Actual behaviour I went to http://my_ip/admin/groups-domains.php?type=black and tried to add a domain to the blacklist, but instead get an error inside the red block:

Error, something went wrong!
While executing INSERT OT IGNORE: attempt to write a readonly database
Added 0 out of 1 domains

P.S: I have the same issue with whitelist. On top of that, pihole -w example.com and pihole -b example.com works without any errors

asyba commented 3 years ago

same issue with new fresh install on Rpi4

lightswitch05 commented 2 years ago

I believe this is a duplicate of #860

freebrowser1 commented 1 year ago

Run as root:

usermod -aG www-data pihole
usermod -aG pihole www-data
chown pihole:www-data /etc/pihole/*
chown pihole:www-data /etc/pihole/.

and restart Apache (or reboot) solved the problem for me. It is allowing the pihole and Apache user each into each others groups. And setting ownership of the /etc/pihole folder and files to pihole user and groupship Apache user.

pi-hole / docker-pi-hole

Error, something went wrong! While executing INSERT OT IGNORE: attempt to write a readonly database Added 0 out of 1 domains #915