Client activity is empty, Query Log error

Help Community Help
1

Expected Behaviour:

I updated my py3 from pihole 4 to 5. The blocking works finde but the dashboard shows nothing. I read in this forum, that it could be a missing php-sqlite package. I installed it an the dashboard shows me total query, percentage blocked, total querys. I expect that the dashboard shows me client activity over 24 hours and so on, but there are only circeling arrows.
Furthermore selecting query log shows me the message box "An unknown error occured during loading data".

Actual Behaviour:

  1. See above, circeling arrows in the dashboard in all charts, expect total querys.
  2. Error-Message when selecting query log.
  3. http://pi.hole/admin/api.php?topItems gives me an empty list.
  4. echo ">top-ads" | nc 127.0.0.1 4711 shows me the top blocked ads

Debug Token:

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

2

Please try again after you cleared your browser's cache.

3

I already cleared the browsers cache and tryed differnet devices and browsers. (Win10 Firefox and Edge, both with newest version. Android 8 with Firefox).
All off them shows the same behaviour as described.

Furthermore i disabled adblockers on browsers side.

------ Originalnachricht ------

4

Ok. Are there any errors in

sudo cat /var/log/lighttpd/error.log

5

I use Apasche, the only "error.log" that can be found on my system are:
pi@raspi3:~ $ sudo locate error.log
/var/log/apache2/error.log
/var/log/apache2/error.log.1

6

You are running Apache2 as your web server. This is an unsupported configuration. If you search the Community Help topic here you will find some user solutions for this webserver.

[80] is in use by apache2 (https://discourse.pi-hole.net/t/hardware-software-requirements/273#ports)
*:12381 apache2 (IPv6)
7

What are the errors you see in this logs?

8

The latest errors, greped with "error" out of the log: (I have to remove the leading http:// to avoid the error message that i can't post more than 5 links).

[Tue Jul 21 15:20:11.271780 2020] [:error] [pid 817] [client 192.168.178.21:52408] PHP Fatal error:  Uncaught Error: Call to undefined function utf8_encode() in /var/www/html/admin/api_FTL.php:388\nStack trace:\n#0 /var/www/html/admin/api.php(165): require()\n#1 {main}\n  thrown in /var/www/html/admin/api_FTL.php on line 388, referer: raspi3.fritz.box/admin/index.php
[Tue Jul 21 15:20:11.326822 2020] [:error] [pid 10971] [client 192.168.178.21:52407] PHP Fatal error:  Uncaught Error: Call to undefined function utf8_encode() in /var/www/html/admin/api_FTL.php:107\nStack trace:\n#0 /var/www/html/admin/api.php(165): require()\n#1 {main}\n  thrown in /var/www/html/admin/api_FTL.php on line 107, referer: raspi3.fritz.box/admin/index.php
[Tue Jul 21 15:20:11.376834 2020] [:error] [pid 2002] [client 192.168.178.21:52405] PHP Fatal error:  Uncaught Error: Call to undefined function utf8_encode() in /var/www/html/admin/api_FTL.php:168\nStack trace:\n#0 /var/www/html/admin/api.php(165): require()\n#1 {main}\n  thrown in /var/www/html/admin/api_FTL.php on line 168, referer: raspi3.fritz.box/admin/index.php
[Tue Jul 21 15:20:11.380772 2020] [:error] [pid 690] [client 192.168.178.21:52409] PHP Fatal error:  Uncaught Error: Call to undefined function utf8_encode() in /var/www/html/admin/api_FTL.php:233\nStack trace:\n#0 /var/www/html/admin/api.php(165): require()\n#1 {main}\n  thrown in /var/www/html/admin/api_FTL.php on line 233, referer: raspi3.fritz.box/admin/index.php
[Tue Jul 21 15:21:11.422424 2020] [:error] [pid 11044] [client 192.168.178.21:52377] PHP Fatal error:  Uncaught Error: Call to undefined function utf8_encode() in /var/www/html/admin/api_FTL.php:388\nStack trace:\n#0 /var/www/html/admin/api.php(165): require()\n#1 {main}\n  thrown in /var/www/html/admin/api_FTL.php on line 388, referer: raspi3.fritz.box/admin/index.php
[Tue Jul 21 15:22:11.472071 2020] [:error] [pid 817] [client 192.168.178.21:52440] PHP Fatal error:  Uncaught Error: Call to undefined function utf8_encode() in /var/www/html/admin/api_FTL.php:388\nStack trace:\n#0 /var/www/html/admin/api.php(165): require()\n#1 {main}\n  thrown in /var/www/html/admin/api_FTL.php on line 388, referer: raspi3.fritz.box/admin/index.php
[Tue Jul 21 15:23:11.528515 2020] [:error] [pid 690] [client 192.168.178.21:52476] PHP Fatal error:  Uncaught Error: Call to undefined function utf8_encode() in /var/www/html/admin/api_FTL.php:388\nStack trace:\n#0 /var/www/html/admin/api.php(165): require()\n#1 {main}\n  thrown in /var/www/html/admin/api_FTL.php on line 388, referer: raspi3.fritz.box/admin/index.php
[Tue Jul 21 15:24:11.558608 2020] [:error] [pid 809] [client 192.168.178.21:52507] PHP Fatal error:  Uncaught Error: Call to undefined function utf8_encode() in /var/www/html/admin/api_FTL.php:388\nStack trace:\n#0 /var/www/html/admin/api.php(165): require()\n#1 {main}\n  thrown in /var/www/html/admin/api_FTL.php on line 388, referer: raspi3.fritz.box/admin/index.php
[Tue Jul 21 15:25:11.617670 2020] [:error] [pid 817] [client 192.168.178.21:52543] PHP Fatal error:  Uncaught Error: Call to undefined function utf8_encode() in /var/www/html/admin/api_FTL.php:388\nStack trace:\n#0 /var/www/html/admin/api.php(165): require()\n#1 {main}\n  thrown in /var/www/html/admin/api_FTL.php on line 388, referer: raspi3.fritz.box/admin/index.php
9

I edited your log output for better readability. You can use </> from the menu to insert code, which will be automatically nicely formated.

All errors are utf8_encode() related. See here for a possible solution:
https://blog.sleeplessbeastie.eu/2018/03/19/how-to-fix-undefined-function-utf8_decode-error-in-php-application/

Also it might be usefull to install all of pihole's web dependencies (of course except of lighttpd if you want to keep apache)

10

sudo apt-get install php-xml was the solution.
Thank you for your help!

11

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