Dashboard problems 5.0 and Apache

[bengt-a]

I am running Pihole behind Apache. It worked fine with version 4.4. After upgrading to 5.1.2, the dashboard is showing --- for all three boxes (Total queries, queries blocked and percent blocked). Other tabs are showing data. It's just the Dashboard (including the Status area) which is messed up.

I checked and I already have php7.3 enabled.

What to do?

[jfb]

Please post a screen capture of what you see. You can paste directly into a reply here.

[bengt-a]

There are queries in the query log, so it is definitely running.

[jfb]

Have you cleared the browser cache and reloaded the page?

[bengt-a]

The Load started showing after doing CTRL-Reload in Chrome:

I tried with another browser (Edge). No difference (except uglier).

I restarted Apache. No change.
I also tried the usermod -aG pihole www-data command suggested earlier. (Although I didn't want to restart the pi...)

[bengt-a]

Perhaps this message in the Apache error log can give some clue to the fault?

[Tue Aug 25 00:06:21.307542 2020] [php7:error] [pid 26473] [client 192.168.1.36:65496] PHP Fatal error: Uncaught Error: Class 'SQLite3' not found in /var/www/html/admin/scripts/pi-hole/php/database.php:42\nStack trace:\n#0 /var/www/html/admin/scripts/pi-hole/php/database.php(65): SQLite3_connect_try('/etc/pihole/gra...', 'SQLITE3_OPEN_RE...', true)\n#1 /var/www/html/admin/scripts/pi-hole/php/gravity.php(13): SQLite3_connect('/etc/pihole/gra...')\n#2 /var/www/html/admin/index.php(73): gravity_last_update()\n#3 {main}\n thrown in /var/www/html/admin/scripts/pi-hole/php/database.php on line 42, referer: http://192.168.1.19/admin/settings.php

[Coro]

@bengt-a

PHP Fatal error: Uncaught Error: Class 'SQLite3' not found

Please install the appropriate sqlite3 module for the PHP your apache server is using. This is outside the scope of the Pi-hole project as replacing the server is a custom extension.

Please use the search of the forum, there are many (MANY) topics around PHP and apache. I just picked this random one, maybe it already helps you:

Dashboard is empty after v5.0 update

Just installed php-sqlite3 right now. And... it works! Thank you so much. That also solved 500 - internal server errors for the Groups page and Network page. I thought the php-sqlite3 was available from the beginning, as stated here: https://www.php.net/manual/en/sqlite3.installation.php The SQLite3 extension is enabled by default as of PHP 5.3.0. It's possible to disable it by using --without-sqlite3 at compile time.

[bengt-a]

@Coro

Please install the appropriate sqlite3 module for the PHP your apache server is using. This is outside the scope of the Pi-hole project as replacing the server is a custom extension.

It's a bit weird though that it was working fine on 4.4, but not for 5.1.2.

I did the following (a summary of the page How to install SQLite for PHP on a Apache/Nginx server | Astra Security):

php -v
sudo apt-get install php7.3-sqlite
sudo service apache2 restart

Then reloaded the page, and - lo and behold - it started working again!
Thank you @Coro!

Some extra information which hopefully might help someone in the same situation as I was. You need to get the following results, or you need to install sqlite3 on your Apache server.

pi@plex ~ $ php -m | grep 'json\|sqlite'
json
pdo_sqlite
sqlite3

[deHakkelaar]

@bengt-a

It's a bit weird though that it was working fine on 4.4, but not for 5.1.2.

Thats called progress
From the 5 release onwards, allot of data is stored in databases now:

https://pi-hole.net/2020/05/10/pi-hole-v5-0-is-here/#page-content

[bengt-a]

@deHakkelaar

Thats called progress

Nice! I like progress.
And I'm super happy that its working again. I'll read the v5.0 release notes now

[deHakkelaar]

If want to know more:

https://docs.pi-hole.net/database/