Hello, I have a raspberry pi4 with retropie, kodi and pihole running. I recently had to reflash my SSd with a backup image - and although pihole is working, the admin panel seems to be corrupted. Please find the error messages and all things I have tried in folowwing sections - and once again, thanks a lot for support!
Expected Behaviour:
PiHole admin panel shows stats etc.
Actual Behaviour:
No stats shown on admin panel
Settings page shows the above error and none of the settings changes are indeed applied
Restoring using teleporter gives the following error:
Error connecting to database /etc/pihole/gravity.db: Unable to open database: unable to open database file
I simply tried to use pihole -r
to repair/ reconfigure it, but both show a similar error:
Even a full install did not work (still using pihole -r
):
All this time, pihole is properly working, and blocking ads like a champ~
pi@retropie:~ $ pihole status
[✓] DNS service is listening
[✓] UDP (IPv4)
[✓] TCP (IPv4)
[✓] UDP (IPv6)
[✓] TCP (IPv6)
[✓] Pi-hole blocking is enabled
Lastly, setupVars.conf has the following content:
<?xml version="1.0"?>
<bool name="BackgroundJoystickInput" value="false" />
<bool name="CaptionsCompatibility" value="true" />
<bool name="CollectionShowSysBLOCKING_ENABLED=true
PIHOLE_DNS_3=1.1.1.1
PIHOLE_DNS_4=1.0.0.1
DNS_FQDN_REQUIRED=true
DNS_BOGUS_PRIV=true
DNSSEC=false
REV_SERVER=false
WEBPASSWORD=XXXXXX
PIHOLE_INTERFACE=eth0
IPV4_ADDRESS=192.168.1.115/24
IPV6_ADDRESS=
PIHOLE_DNS_1=8.8.8.8
PIHOLE_DNS_2=8.8.4.4
QUERY_LOGGING=true
INSTALL_WEB_SERVER=true
INSTALL_WEB_INTERFACE=true
LIGHTTPD_ENABLED=true
CACHE_SIZE=10000
Debug Token:
q35z868eql