Databases unable to read anything blocking isnt working either

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

Expected Behaviour:

[blocking of ADs and able to see data in the web interface]

Actual Behaviour:

[Not seeing any data and get errors when accessing blocklists and trying to query logs. I see no logging at all when trying to tail from web interface]

Debug Token:

[vfsqnu4jd9]

Centos 8 is missing a package, php-json, so you’ll need to install that for the web interface to work. 8 is not supported in the released code. There is a fix in development to be released next.

Perfect! Thank you!

Would this be the same reason that the networking tab is failing as well?

If you’ve installed that package and the page is still not functioning then paste a screenshot of the page and a new debug token.

magj250ocp

I did install php-json which gave me the graphs and info there just this piece is the only thing not functioning.

New debug token?

n3dfui7x79

Here is a newer one.

   [2020-01-14 11:39:22.336 24181] SQLite3 message: cannot open file at line 38452 of [0eca3dd3d3] (14)
   [2020-01-14 11:39:22.336 24181] SQLite3 message: os_unix.c:38452: (2) open(/etc/pihole/pihole-FTL.db) -  (14)

What does

ls -lh /etc | grep pihole
ls -lh /etc/pihole/*.db

say?

drwxr-xr-x 2 pihole pihole 4.0K Jan 14 15:22 pihole

-rw-r–r-- 1 root root 2.3M Jan 14 11:34 /etc/pihole/macvendor.db
-rw------- 1 pihole pihole 300K Jan 14 15:22 /etc/pihole/pihole-FTL.db

Okay, how about

sqlite3 /etc/pihole/pihole-FTL.db "SELECT COUNT(*) FROM network;"

?

Also, please run

sudo chmod ga+r /etc/pihole/pihole-FTL.db

and check again the dashboard.

That did it! Thank you! fully functional now. Appreciate it!

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.