See no stats after update to 5.0

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

Expected Behaviour:

When i on the Mainpage of pihole i see the query diagram and stats of blocked ads

Actual Behaviour:

i see nothing

Extra informations

i use nginx as webserver

Debug Token:

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

1 Like

For me, this helped:

pihole -g -r

no i tried it already but no change the log says it create everythink correct, but under pihole -d the log say the gravity.db does not exists under /etc/pihole/, when i look at this path it exists :confused:<

the new debug token after a clean install of pihole

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

Same problem.

pihole -g -r not help

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

Same problem here...

> May 11 08:56:17 dnsmasq[15245]: bad address at /etc/pihole/gravity.list line 426705

https://tricorder.pi-hole.net/0o3iyhc9h1

With the command

awk 'NR==426705' /etc/pihole/gravity.list

you can check that line.

Thanks, but my hole pihole.log looks like this

That's why I think it's a problem with the gravity.list

I fixed the problem by setting the permissions of /etc/pihole to 777 and than made pihole -up again

nginx is not a supported server for the Pi-hole web admin page. There is an unsupported user guide that may have some information that can help you:

https://docs.pi-hole.net/guides/nginx-configuration/

I'm experiencing the same issue. Also, FTL won't update from 4.3.1 to 5:

E: Unable to locate package php5-xml
E: Unable to locate package php-intl

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

I already setup correctly by this guide

A post was split to a new topic: Incomplete dashboard after updating to V5.0

I have the same problem.
And also errors on the GroupManagement-Groups page, Network page and others because Ajax content cannot be loaded. Does that work for you?

http://192.168.1.2/admin/api_db.php?network&_=1589217731596 -> Error 500
http://192.168.1.2/admin/scripts/pi-hole/php/groups.php -> "Not allowed (login session invalid or expired, please relogin on the Pi-hole dashboard)!"

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

1 Like

Yep I agree

Hi guys, everyone who did not choose to install Lighttpd within Pi-hole installer needs to do:

usermod -aG pihole www-data
apt install php-intl # Respectively the package matching your PHP version, like php7.3-intl

I just got the idea to view the error log from the webserver:

[Mon May 11 20:33:50.704422 2020] [php7:warn] [pid 3039] [client 192.168.1.60:56525] PHP Warning:  Use of undefined constant SQLITE3_OPEN_READONLY - assumed 'SQLITE3_OPEN_READONLY' (this will throw an Error in a future version of PHP) in /var/www/html/admin/scripts/pi-hole/php/database.php on line 61, referer: http://192.168.1.2/admin/network.php
[Mon May 11 20:33:50.704669 2020] [php7:error] [pid 3039] [client 192.168.1.60:56525] 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/pih...', 'SQLITE3_OPEN_RE...', true)\n#1 /var/www/html/admin/api_db.php(56): SQLite3_connect('/etc/pihole/pih...')\n#2 {main}\n  thrown in /var/www/html/admin/scripts/pi-hole/php/database.php on line 42, referer: http://192.168.1.2/admin/network.php

Then I checked if php-sqlite3 is installed, which was not the case. After a webserver restart it worked again.

Edit:
New problem: When I want to edit the groups While executing: **attempt to write a readonly database**

Please open a new topic for this problem, so the existing topic for the original issue can continue.

The issues have the same source, hence I would not separate. In case of OP it is expected since Nginx as webserver means that INSTALL_WEB_SERVER=false is set which again means that the installer/updater does not add www-data to pihole group, preventing database write access, and no PHP modules are installed, leading to missing SQLite and intl modules. Although in case of SQLite it is strange since this was used/required before already :thinking:.

Micah, respectfully, we'll handle our support the way we prefer.

I have tried but no change in view and errors by loading the query log or group management.

I already installed sqlite for php7.x in the past.