Whitelist -> attempt to write a readonly database

ovrld · June 6, 2020, 6:49pm

Moin Leute

Seit dem Update auf PiHole 5 hab ich nur Terz mit dem System - neuestes Thema: Whitelist Button funktioniert nicht und ich kann keine Einträge manuell hinzufügen:

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

Hab einige Sachen hier mal probiert, aber nichts davon hat geklappt - einiges hat sich in den Themen auch widersprochen ala "mach xy" zu "mach xy auf keinen Fall!".

Deshalb die Frage - gibt es hierzu schon eine gängige Lösung? Scheint ja mal wieder einige zu treffen. Genau wie die Probleme mit der fehlenden Gravity DB nach dem Update

Greetz
Ovrld

jfb · June 6, 2020, 6:54pm

Please post the token generated by

pihole -d

or do it through the Web interface:

Tools > Generate Debug Log

ovrld · June 6, 2020, 6:59pm

https://tricorder.pi-hole.net/5w35bqqzll

jfb · June 6, 2020, 7:04pm

What is the output of the following command from the Pi terminal:

ls -lha /etc/pihole

ovrld · June 6, 2020, 7:16pm

-rw-r--r--  1 root   root     4.5K Jan 17 10:27 adlists.list
-rw-r--r--  1 root   root       30 May 31 04:00 black.list
-rw-r--r--  1 root   root       30 Mar 30 16:48 blacklist.txt
-rw-r--r--  1 pihole pihole      0 May 13 23:32 dhcp.leases
-rw-r--r--  1 root   root      596 Mar  7 13:48 dns-servers.conf
-rw-r--r--  1 root   root       14 Jun  6 17:30 GitHubVersions
-rw-rw-r--  1 pihole pihole   500M May 13 23:23 gravity.db
-rw-r--r--  1 root   root      77M May 31 04:00 gravity.list
-rw-r--r--  1 root   root        0 May 13 09:34 install.log
-rw-------  1 root   root     1.7M May 31 03:58 list.0.raw.githubusercontent.com.domains
-rw-------  1 root   root      16K May 31 03:58 list.10.v.firebog.net.domains
-rw-------  1 root   root     135K May 13 09:38 list.11.v.firebog.net.domains
-rw-------  1 root   root     2.0M May 31 03:58 list.12.www.dshield.org.domains
-rw-------  1 root   root      62K May 31 03:58 list.13.www.dshield.org.domains
-rw-------  1 root   root      58K May 31 03:58 list.14.www.dshield.org.domains
-rw-------  1 root   root     1.2M May 31 03:58 list.15.www.joewein.net.domains
-rw-------  1 root   root      30K May 31 03:58 list.16.raw.githubusercontent.com.domains
-rw-------  1 root   root     776K May 13 09:38 list.17.hostsfile.org.domains
-rw-------  1 root   root     408K May 24 03:58 list.18.someonewhocares.org.domains
-rw-------  1 root   root     129K May 31 03:58 list.19.raw.githubusercontent.com.domains
-rw-------  1 root   root     581K May 24 03:58 list.1.mirror1.malwaredomains.com.domains
-rw-------  1 root   root     230K May 31 03:58 list.20.raw.githubusercontent.com.domains
-rw-------  1 root   root     379K May 13 09:38 list.21.winhelp2002.mvps.org.domains
-rw-------  1 root   root     113K May 31 03:58 list.22.hosts.nfz.moe.domains
-rw-------  1 root   root     848K May 31 03:58 list.23.raw.githubusercontent.com.domains
-rw-------  1 root   root      15K May 31 03:58 list.24.ssl.bblck.me.domains
-rw-------  1 root   root     431K May 24 03:58 list.25.adaway.org.domains
-rw-------  1 root   root     546K May 31 03:58 list.26.v.firebog.net.domains
-rw-------  1 root   root     1.4M May 31 03:58 list.27.raw.githubusercontent.com.domains
-rw-------  1 root   root      48K May 31 03:58 list.28.v.firebog.net.domains
-rw-------  1 root   root      88K May 31 03:58 list.29.pgl.yoyo.org.domains
-rw-------  1 root   root     624K May 13 09:35 list.2.sysctl.org.domains
-rw-------  1 root   root      310 May 31 03:58 list.30.raw.githubusercontent.com.domains
-rw-------  1 root   root     527K May 31 03:58 list.32.raw.githubusercontent.com.domains
-rw-------  1 root   root      48K May 31 03:58 list.33.raw.githubusercontent.com.domains
-rw-------  1 root   root      52K May 31 03:58 list.34.v.firebog.net.domains
-rw-------  1 root   root      58K May 31 03:58 list.35.v.firebog.net.domains
-rw-------  1 root   root     349K May 31 03:58 list.36.gitlab.com.domains
-rw-------  1 root   root      41K May 31 03:58 list.37.raw.githubusercontent.com.domains
-rw-------  1 root   root      13K May 31 03:58 list.38.raw.githubusercontent.com.domains
-rw-------  1 root   root      613 May 13 09:35 list.3.s3.amazonaws.com.domains
-rw-------  1 root   root     4.1M May 31 03:58 list.40.www.github.developerdan.com.domains
-rw-------  1 root   root     1.1M May 31 03:58 list.41.hostfiles.frogeye.fr.domains
-rw-------  1 root   root     1.4M May 31 03:58 list.42.hostfiles.frogeye.fr.domains
-rw-------  1 root   root     2.1K May 31 03:58 list.43.raw.githubusercontent.com.domains
-rw-------  1 root   root     8.4K May 31 03:58 list.44.raw.githubusercontent.com.domains
-rw-------  1 root   root     1.4K May 31 03:58 list.45.raw.githubusercontent.com.domains
-rw-------  1 root   root      44K May 31 03:58 list.46.s3.amazonaws.com.domains
-rw-------  1 root   root      43K May 13 09:35 list.4.s3.amazonaws.com.domains
-rw-------  1 root   root      50K May 13 09:41 list.50.mirror.cedia.org.ec.domains
-rw-------  1 root   root      35K May 13 09:41 list.51.www.malwaredomainlist.com.domains
-rw-------  1 root   root      43K May 13 09:41 list.52.bitbucket.org.domains
-rw-------  1 root   root     1.2M May 31 03:59 list.53.v.firebog.net.domains
-rw-------  1 root   root     1.1M May 24 03:59 list.54.v.firebog.net.domains
-rw-------  1 root   root     280K May 31 03:59 list.55.phishing.army.domains
-rw-------  1 root   root      11K May 31 03:59 list.56.gitlab.com.domains
-rw-------  1 root   root     331K May 13 09:41 list.57.v.firebog.net.domains
-rw-------  1 root   root      67K May 31 03:59 list.58.raw.githubusercontent.com.domains
-rw-------  1 root   root     1.9M May 31 03:59 list.60.gitlab.com.domains
-rw-------  1 root   root      11K May 31 03:59 list.61.raw.githubusercontent.com.domains
-rw-------  1 root   root     5.9M May 31 03:59 list.62.raw.githubusercontent.com.domains
-rw-------  1 root   root      89K May 13 09:41 list.63.zerodot1.gitlab.io.domains
-rw-------  1 root   root      49M May 31 03:59 list.64.raw.githubusercontent.com.domains
-rw-------  1 root   root     1.2M May 13 09:41 list.65.v.firebog.net.domains
-rw-------  1 root   root     1.2M May 13 09:41 list.66.v.firebog.net.domains
-rw-------  1 root   root      49M May 31 03:59 list.67.github.com.domains
-rw-------  1 root   root     202K May 31 03:59 list.68.raw.githubusercontent.com.domains
-rw-------  1 root   root     4.0M May 31 03:59 list.69.blocklist.site.domains
-rw-------  1 root   root      52M May 31 03:59 list.70.blocklist.site.domains
-rw-------  1 root   root      50K May 31 03:59 list.71.blocklist.site.domains
-rw-------  1 root   root      15K May 13 09:38 list.7.reddestdream.github.io.domains
-rw-------  1 root   root     279K May 31 03:58 list.8.raw.githubusercontent.com.domains
-rw-------  1 root   root     2.1K May 31 03:58 list.9.raw.githubusercontent.com.domains
-rw-r--r--  1 root   root      77M May 31 04:00 list.preEventHorizon
-rw-r--r--  1 root   root       20 Jun  6 20:40 localbranches
-rw-r--r--  1 root   root       42 May 31 04:00 local.list
-rw-r--r--  1 root   root       36 Jun  6 20:40 localversions
-rw-r--r--  1 root   root      234 Mar  7 13:48 logrotate
-rw-r--r--  1 pihole pihole   2.3M May 13 09:34 macvendor.db
-rw-rw-r--  1 pihole root       15 Mar  7 13:48 pihole-FTL.conf
-rw-r--r--  1 pihole pihole   367M Jun  6 20:45 pihole-FTL.db
-rw-rw-r--  1 pihole www-data   21 Mar 30 16:47 regex.list
-rw-r--r--  1 root   root      391 Jun  6 20:25 setupVars.conf
-rw-r--r--  1 root   root      391 Mar  7 13:48 setupVars.conf.update.bak
-rw-r--r--  1 root   root      768 May 11 13:35 whitelist.txt

jfb · June 6, 2020, 7:22pm

Run pihole -r and select repair, then generate a fresh debug log.

ovrld · June 6, 2020, 7:36pm

https://tricorder.pi-hole.net/bixpkosemm

jfb · June 6, 2020, 7:39pm

Are you able to whitelist now?

ovrld · June 6, 2020, 7:46pm

It's working again - thanks for the help!
Have a nice weekend!

Greetz