I just started noticing issues with 5.10, though I update a couple of weeks ago. I have not made any config file changes in the last 3 or 4 months, just some blacklist, whitelist, and adlist changes before the update. I just tried to add a new domain from the web interface and I received the following error:
While executing: attempt to write a readonly database
Added 0 out of 1 domains
When investigating, I found the following new error in /var/log/pihole-FTL.log which keeps occurring over and over:
[2022-05-11 19:11:49.519 1757M] ERR: Port mismatch for 127.1.1.1: we derived 5353, dnsmasq told us 43
The error log has a strange output after startup:
2022-05-11 18:25:08: (server.c.1464) server started (lighttpd/1.4.53)
2022-05-11 18:25:08: (server.c.1493) WARNING: unknown config-key: alias.url (
ignored)
2022-05-11 18:31:07: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /var/www/html/admin/scripts/pi-hole/php/groups.php on line 708
2022-05-11 18:37:18: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /var/www/html/admin/scripts/pi-hole/php/groups.php on line 708
2022-05-11 18:37:36: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /var/www/html/admin/scripts/pi-hole/php/groups.php on line 708
2022-05-11 18:39:10: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /var/www/html/admin/scripts/pi-hole/php/groups.php on line 708
2022-05-11 18:46:28: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /var/www/html/admin/scripts/pi-hole/php/groups.php on line 723
2022-05-11 18:50:21: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /var/www/html/admin/scripts/pi-hole/php/groups.php on line 723
I am not using port 43 for anything: 'netstat -an | grep 43' shows no address tied to port 43, and a 'grep 43 /etc/pihole/*.conf' shows nothing.
None of my filesystems are full, and I have disabled log2ram to help with diagnoses. I have wireguard installed but not configured. I have checked all of my file ownerships and permissions in /etc/pihole and they seem to be correct. I use stubby for my DNS backend, but I am not having issues with DNS lookups... as everything is working except for the errors above.
I am running a standard pihole configuration installed on my Rpi-3B on a 64GB SDXC card on Raspbian Buster. As previously noted, I have changed some configration files on install and issues, but I had no problems before 5.10. I will check the updated version at my other house again next week, but that one uses NGINX and an external HDD for storage, so it is non-standard.
Does anyone know the fix for these issues on a standard installation running directlly on a dedicated Rpi-3B?
Thanks... -James