I am using casaos and inside the pi-hole docker.
Use the installer they have.
This is the docker configuration
Actual Behaviour:
When I log in to clients, the list stays on loading...
I am using casaos and inside the pi-hole docker.
Use the installer they have.
This is the docker configuration
When I log in to clients, the list stays on loading...
Usually an empty database is 80Kb in size. Your database file is smaller than that:
*** [ DIAGNOSING ]: Pi-hole FTL Query Database
-rw-rw-r-- 1 pihole pihole 44K Oct 3 10:54 /etc/pihole/pihole-FTL.db
This probably means the database was not correctly created and there are missing tables/fields, causing errors like that:
[2023-10-03 10:55:00.101 702/T718] SQLite3 message: no such column: name in "UPDATE network_addresses SET name = NULL WHERE nameUpdated < 1664794500;" (1)
[2023-10-03 10:55:00.101 702/T718] ERROR: SQL query "UPDATE network_addresses SET name = NULL WHERE nameUpdated < 1664794500;" failed: SQL logic error (SQLITE_ERROR)
To fix this, run these commands to move the existing database to a new file name.
Pi-hole will create a fresh database.
sudo service pihole-FTL stop
sudo mv /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL-old.db
sudo service pihole-FTL start
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.