On the Clients Tab in the web interface I expect to see a list of all clients. This had worked previously.
Raspberry Pi 4 running DietPi with a basic PiHole installation.
Actual Behaviour:
Only configured clients are showing (manually configured). I suspect it has something to with database errors in the FTL log.
Errors persist after doing the following based on this previous topic that seemed similar.
Not sure what else to try at this point.
sudo service pihole-FTL stop
mv /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL-old.db
sudo service pihole-FTL start
all clients will show on the tools - network tab. The clients tab is for defining clients so that they can be assigned to groups - an individual group is allocated specific adlists.
This is normal. The client assignment screen does not autopopulate with all the network clients. You have to manually select clients from the pulldown menu and assign the client to a group (or groups).
Thanks! I thought i remembered them being listed on that tab also but seems like an instance of the mandala effect
Before closing this out - are these errors in the FTL log something to be concerned with?
[2023-07-20 14:55:01.097 15895/F15846] SQLite3 message: database is locked in "SELECT hwaddr FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? GROUP BY ip HAVING max(lastSeen));" (5)
[2023-07-20 14:55:01.097 15895/F15846] getMACfromIP("10.0.0.24") - SQL error prepare: database is locked
[2023-07-20 14:55:02.098 15895/F15846] SQLite3 message: database is locked in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (5)
[2023-07-20 14:55:02.098 15895/F15846] getNameFromIP("10.0.0.24") - SQL error prepare: database is locked
