Error connecting to database

Please follow the below template, it will help us to help you!

If you are Experiencing issues with a Pi-hole install that has non-standard elements (e.g you are using nginx instead of lighttpd, or there is some other aspect of your install that is customised) - please use the Community Help category.

Expected Behaviour:

Running Pi-Hole on Raspbian and expect to be able to see the dashboard/update lists, etc.

Actual Behaviour:

I can't see my ad lists, or any groups or statistics from the web interface. From inspecting with dev tools in Chrome I can see that it's giving me an error that it's unable to open the gravity database.

I do see the gravity.db file, the debug doesn't appear to show anything obviously wrong (IPv6 doesn't work but that's expected as I disabled it on the Pi). (I also ran a repair and that didn't change anything)

Debug Token:

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

Can you please post some screen shots of what you are seeing on the pages affected?

Absolutely -
Dashboard:


Groups:

Dev tools showing the request getting the database error:
image
CLI showing the gravity.db file does exist and is owned by the pihole user:

Anything more specific that would be helpful?

My gravity database permissions (latest master) are:

-rw-rw-r-- 1 pihole pihole 30M Jun 9 00:08 gravity.db

1 Like

That did it, thank you very much!