Please follow the below template, it will help us to help you!
Expected Behaviour:
Adding an entry to the whitelist page (on the web interface) will complete without any issues.
Actual Behaviour:
Receives a message that the database is read-only:
However, SSH works fine:
Debug Token:
https://tricorder.pi-hole.net/5g26p75htk
It appears that the blacklist page exhibits the same behavior (SSH is still works fine).
jfb
September 1, 2019, 9:49pm
4
What is the output of ls -lh /etc/pihole
from the Pi command line?
total 447M
-rw-r--r-- 1 root pihole 1.7K Sep 1 14:42 adlists.list
-rw-rw-r-- 1 root pihole 96 Sep 1 10:54 blacklist.txt
-rw-r--r-- 1 pihole pihole 0 Sep 1 16:05 dhcp.leases
-rw-r--r-- 1 root root 596 Sep 1 15:05 dns-servers.conf
-rw-r--r-- 1 root root 12 Sep 1 14:22 ftlbranch
-rw-r--r-- 1 root root 2 Sep 1 15:30 GitHubVersions
-rw-rw-r-- 1 pihole pihole 311M Sep 1 16:50 gravity.db
-rw-r--r-- 1 root root 2.6M Sep 1 14:21 gravity.list
-rw-r--r-- 1 root root 1.1K Sep 1 15:05 install.log
-rw-r--r-- 1 root root 624K Sep 1 15:05 list.0.sysctl.org.domains
-rw-r--r-- 1 root root 52M Sep 1 15:06 list.10.blocklist.site.domains
-rw-r--r-- 1 root root 113K Sep 1 15:06 list.11.blocklist.site.domains
-rw-r--r-- 1 root root 50K Sep 1 15:06 list.12.blocklist.site.domains
-rw-r--r-- 1 root root 1.7M Sep 1 15:06 list.13.blocklist.site.domains
-rw-r--r-- 1 root root 3.9K Sep 1 15:06 list.14.blocklist.site.domains
-rw-r--r-- 1 root root 22K Sep 1 15:06 list.15.blocklist.site.domains
-rw-r--r-- 1 root root 28K Sep 1 15:06 list.16.blocklist.site.domains
-rw-r--r-- 1 root root 207K Sep 1 15:06 list.17.blocklist.site.domains
-rw-r--r-- 1 root root 1.7M Sep 1 15:06 list.18.hosts-file.net.domains
-rw-r--r-- 1 root root 45M Sep 1 15:07 list.19.hosts.ubuntu101.co.za.domai ns
-rw-r--r-- 1 root root 3.1M Sep 1 15:05 list.1.blocklist.site.domains
-rw-r--r-- 1 root root 582K Sep 1 15:07 list.20.mirror1.malwaredomains.com. domains
-rw-r--r-- 1 root root 9.0K Sep 1 15:36 list.21.raw.githubusercontent.com.d omains
-rw-r--r-- 1 root root 366K Sep 1 15:36 list.22.raw.githubusercontent.com.d omains
-rw-r--r-- 1 root root 19K Sep 1 15:36 list.23.raw.githubusercontent.com.d omains
-rw-r--r-- 1 root root 142K Sep 1 15:36 list.24.raw.githubusercontent.com.d omains
-rw-r--r-- 1 root root 1.3M Sep 1 15:36 list.25.raw.githubusercontent.com.d omains
-rw-r--r-- 1 root root 43K Sep 1 15:07 list.27.s3.amazonaws.com.domains
-rw-r--r-- 1 root root 613 Sep 1 15:07 list.28.s3.amazonaws.com.domains
-rw-r--r-- 1 root root 773 Sep 1 15:36 list.29.v.firebog.net.domains
-rw-r--r-- 1 root root 484K Sep 1 15:05 list.2.blocklist.site.domains
-rw-r--r-- 1 root root 39K Sep 1 15:07 list.30.www.stopforumspam.com.domai ns
-rw-r--r-- 1 root root 53 Sep 1 15:36 list.31.zeustracker.abuse.ch.domain s
-rw-r--r-- 1 root root 488K Sep 1 15:05 list.3.blocklist.site.domains
-rw-r--r-- 1 root root 13K Sep 1 15:05 list.4.blocklist.site.domains
-rw-r--r-- 1 root root 4.2M Sep 1 15:05 list.5.blocklist.site.domains
-rw-r--r-- 1 root root 488K Sep 1 15:05 list.6.blocklist.site.domains
-rw-r--r-- 1 root root 15M Sep 1 15:06 list.7.blocklist.site.domains
-rw-r--r-- 1 root root 4.0M Sep 1 15:06 list.8.blocklist.site.domains
-rw-r--r-- 1 root root 38K Sep 1 15:06 list.9.blocklist.site.domains
-rw-r--r-- 1 root root 29 Sep 1 16:50 localbranches
-rw-r--r-- 1 root root 136 Sep 1 16:03 local.list
-rw-r--r-- 1 root root 48 Sep 1 16:50 localversions
-rw-r--r-- 1 root root 234 Sep 1 15:05 logrotate
-rw-r--r-- 1 pihole pihole 2.3M Sep 1 15:05 macvendor.db
drwxr-xr-x 2 root root 4.0K Sep 1 16:03 migration_backup
-rw-rw-r-- 1 pihole root 31 Sep 1 15:07 pihole-FTL.conf
-rw-rw-r-- 1 pihole pihole 220K Sep 1 16:50 pihole-FTL.db
-rw-r--r-- 1 root root 0 Sep 1 10:54 regex.list
-rw-r--r-- 1 root root 689 Sep 1 15:05 setupVars.conf
-rw-r--r-- 1 root root 689 Sep 1 15:05 setupVars.conf.update.bak
-rw-rw-r-- 1 root pihole 3.6K Sep 1 15:44 whitelist.txt
I also found that this happens temporarily after an attempt to add something to either the black or whitelist via the web interface (GUI):
It also temporarily affects the ability to add via SSH as well:
jfb
September 1, 2019, 10:50pm
8
The 5 million plus domains you have on blocklist may be contributing to this problem. As a first troubleshooting step, I would save your current blocklists and replace them with the original blocklists, rebuild gravity and see if the problem persists.
https://discourse.pi-hole.net/t/how-can-i-restore-pi-holes-default-ad-lists/4683/3?u=ramset
You think its going beyond what the sdcard is capable of (R/W performance)? I only ask as I just moved from an Ubuntu Server VM (on my Unraid Server) to the RPi4 2gb, and it wasn't running into any problems on the previous setup. - I'm using a U1-rated 64gb card that I had laying around, but am going to eventually get a U3-rated model (something like this ).
jfb
September 1, 2019, 11:31pm
10
Maybe not, but if you revert the the default lists temporarily you eliminate a possible cause for the problem.
I haven't tried adding via SSH yet, but I was able to at least delete all of the current lists using the web gui. However, when I go to add the original ones back, I'm seeing nothing being added.
Ran a repair via SSH (pihole -r), and I was able to add the lists via the web gui.
Still having the same problem w/ the whitelist via the webgui:
I think I fixed the problem. - I just switched from the dev branch back to main, and was able to add to the lists w/o any error messages.
I was previously put on that branch by the devs back in July for another issue.
system
Closed
September 23, 2019, 4:01pm
16
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.