Client List not loading

Help Community Help
1

The issue I am facing:
Client List in Group Management not loading and "Known Clients" shows a list of:

  • 0
  • success
  • Error while querying FTL's database: not an error
  • Custom, specified below...

In the pihole -d output the following lines caught my eyes:

   [2021-07-26 16:00:01.362 894843/T894849] SQLite3 message: database is locked in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (5)
   [2021-07-26 16:00:01.362 894843/T894849] getNameFromIP("192.168.2.112") - SQL error prepare: database is locked

which is similar to an error I saw here twice. Unfortunately the first topics solution was running pihole checkout core release/v5.0 which seems a bit out of date now. The second solution was removing pihole-FTL.db while FTL is stopped which didn't resolved the issue for me.

After the first tries I uninstalled pihole using the uninstall argument and reinstalled it using the original install script.

Details about my system:
Ubuntu Server 20.04.2
Also runs Nextcloud

Versions

*** [ DIAGNOSING ]: Core version
[i] Core: v5.3.1 (How do I update Pi-hole?)
[i] Remotes: origin GitHub - pi-hole/pi-hole: A black hole for Internet advertisements (fetch)
origin GitHub - pi-hole/pi-hole: A black hole for Internet advertisements (push)
[i] Branch: master
[i] Commit: v5.3.1-0-g4736e03

*** [ DIAGNOSING ]: Web version
[i] Web: v5.5 (How do I update Pi-hole?)
[i] Remotes: origin GitHub - pi-hole/AdminLTE: Pi-hole Dashboard for stats and more (fetch)
origin GitHub - pi-hole/AdminLTE: Pi-hole Dashboard for stats and more (push)
[i] Branch: master
[i] Commit: v5.5-0-g7e602e0

*** [ DIAGNOSING ]: FTL version
[✓] FTL: v5.8.1

What I have changed since installing Pi-hole:
My install doesn't use lighttpd, Pihole shares an apache server with nextcloud.
A few month ago everything was fine with an old install of pihole (don't know the version which was installed, but it was old).

2

Please upload a debug log and post just the token that is generated after the log is uploaded by running the following command from the Pi-hole host terminal:

pihole -d

or do it through the Web interface:

Tools > Generate Debug Log

3

Hi,
here is the requested token:
https://tricorder.pi-hole.net/bxxojhspab

4

Are you running Pi-hole in docker?

[2021-07-26 16:00:01.362 894843/T894849] SQLite3 message: database is locked in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (5)
   [2021-07-26 16:00:01.362 894843/T894849] getNameFromIP("192.168.2.112") - SQL error prepare: database is locked

This line is not present in your new debug log. I can't see any database related errors.

Did you add the www-data group to the pihole group?

sudo usermod -a -G pihole www-data
sudo apachctl restart
5

You're right. Those lines aren't present anymore. Thought they disappeared since I restarted the system but I can't bring them back by loading the Client list or adding a client by choosing "Custom".

Btw. added Clients appear in the gravity database:

sqlite> SELECT * FROM client_by_group;
1|0
2|0
sqlite> SELECT * FROM client;
1|192.168.2.175|1627243164|1627243164|  #<< Added before adding www-data to pihole
2|192.168.2.1|1627454038|1627454038|      #<<...after

No, the user www-data was not in the pihole group. Changed it but the problem persists.

6

I'm out of ideas. I'm not using apache and this was a common issue in the past. Someone else with a running apache server might be able to provide further troubleshooting tips.

7

Ok. Thank you for trying :slight_smile:

8

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