# Client List not loading

**URL:** <https://discourse.pi-hole.net/t/client-list-not-loading/48496>\
**Category:** Community Help\
**Tags:** apache\
**Created:** [July 26, 2021, 8:12pm UTC](https://discourse.pi-hole.net/t/client-list-not-loading/48496 "2021-07-26T20:12:32Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kona](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/kona/32/26286_2.png) [@Kona](https://discourse.pi-hole.net/u/Kona)\
**Post date:** [July 26, 2021, 8:12pm UTC](https://discourse.pi-hole.net/t/client-list-not-loading/48496/1 "2021-07-26T20:12:32Z")

</div>

**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:

```auto
   [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?](https://discourse.pi-hole.net/t/how-do-i-update-pi-hole/249))  
> [i] Remotes: origin [https://github.com/pi-hole/pi-hole.git](https://github.com/pi-hole/pi-hole.git) (fetch)  
> origin [https://github.com/pi-hole/pi-hole.git](https://github.com/pi-hole/pi-hole.git) (push)  
> [i] Branch: master  
> [i] Commit: v5.3.1-0-g4736e03
> 
> \*\*\* [DIAGNOSING]: Web version  
> [i] Web: v5.5 ([How do I update Pi-hole?](https://discourse.pi-hole.net/t/how-do-i-update-pi-hole/249))  
> [i] Remotes: origin [https://github.com/pi-hole/AdminLTE.git](https://github.com/pi-hole/AdminLTE.git) (fetch)  
> origin [https://github.com/pi-hole/AdminLTE.git](https://github.com/pi-hole/AdminLTE.git) (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).

---

<div class="post-metadata">

**Author:** ![yubiuser](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/yubiuser/32/12100_2.png) [@yubiuser](https://discourse.pi-hole.net/u/yubiuser)\
**Post date:** [July 27, 2021, 1:12pm UTC](https://discourse.pi-hole.net/t/client-list-not-loading/48496/2 "2021-07-27T13:12:19Z")

</div>

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:

```auto
pihole -d

```

or do it through the Web interface:

_ **Tools \> Generate Debug Log** _

---

<div class="post-metadata">

**Author:** ![Kona](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/kona/32/26286_2.png) [@Kona](https://discourse.pi-hole.net/u/Kona)\
**Post date:** [July 27, 2021, 7:33pm UTC](https://discourse.pi-hole.net/t/client-list-not-loading/48496/3 "2021-07-27T19:33:21Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![yubiuser](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/yubiuser/32/12100_2.png) [@yubiuser](https://discourse.pi-hole.net/u/yubiuser)\
**Post date:** [July 28, 2021, 5:32am UTC](https://discourse.pi-hole.net/t/client-list-not-loading/48496/4 "2021-07-28T05:32:15Z")

</div>

Are you running Pi-hole in docker?

* * *

```auto
[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?

```auto
sudo usermod -a -G pihole www-data
sudo apachctl restart

```

---

<div class="post-metadata">

**Author:** ![Kona](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/kona/32/26286_2.png) [@Kona](https://discourse.pi-hole.net/u/Kona)\
**Post date:** [July 28, 2021, 6:55am UTC](https://discourse.pi-hole.net/t/client-list-not-loading/48496/5 "2021-07-28T06:55:11Z")

</div>

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:

```auto
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.

---

<div class="post-metadata">

**Author:** ![yubiuser](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/yubiuser/32/12100_2.png) [@yubiuser](https://discourse.pi-hole.net/u/yubiuser)\
**Post date:** [July 28, 2021, 5:57pm UTC](https://discourse.pi-hole.net/t/client-list-not-loading/48496/6 "2021-07-28T17:57:45Z")

</div>

> [@Kona](#):
>
> No, the user www-data was not in the pihole group. Changed it but the problem persists.

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.

---

<div class="post-metadata">

**Author:** ![Kona](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/kona/32/26286_2.png) [@Kona](https://discourse.pi-hole.net/u/Kona)\
**Post date:** [July 29, 2021, 8:31am UTC](https://discourse.pi-hole.net/t/client-list-not-loading/48496/7 "2021-07-29T08:31:05Z")

</div>

Ok. Thank you for trying 🙂

---

<div class="post-metadata">

**Author:** ![system](https://discourse.pi-hole.net/uploads/default/original/3X/7/c/7c8792f649eeb921c5d2b4c41564ffa873d9a2b8.png) [@system](https://discourse.pi-hole.net/u/system)\
**Post date:** [August 19, 2021, 8:31am UTC](https://discourse.pi-hole.net/t/client-list-not-loading/48496/8 "2021-08-19T08:31:20Z")

</div>

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