No data available in clients list

Help
1

Hello everyone,

I am running my pi-hole on Raspberry Pi 3B. On top of the pi-hole I an running also unbound. However, when checking the clients list in the web interface I can see in the Network overvew tab the "No data available in the table" message.

Expected Behaviour:

I was expeting to see the list of the clients connected (especially that in the dashboard I can see the number of the clients displayed).

Actual Behaviour:

No clients visible in the list.

I checked the pihole-FTL.log content, and I saw many messages like:

SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)

I created the new pihole-FTL.db by

sudo service pihole-FTL stop

mv /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL-old.db

sudo service pihole-FTL start

But it did not help.

Do you have any suggestions or ideas?

Debug Token:

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

2

What's the output of:

pihole-FTL sqlite3 /etc/pihole/pihole-FTL.db ".tables"

pihole-FTL sqlite3 /etc/pihole/pihole-FTL.db "PRAGMA integrity_check"
3

Hey!

the first one:

pihole-FTL sqlite3 /etc/pihole/pihole-FTL.db ".tables"
counters  ftl       network   queries

the second one:

pihole-FTL sqlite3 /etc/pihole/pihole-FTL.db "PRAGMA integrity_check"
ok
4

Hmmm... Your database seems broken.

The integrity check was fine probably because the data in the current tables is OK, but there are a lot of missing tables.

The first command output should be:

root@pihole:/# pihole-FTL sqlite3 /etc/pihole/pihole-FTL.db ".tables"
addinfo_by_id      counters           ftl                network_addresses
aliasclient        domain_by_id       message            queries          
client_by_id       forward_by_id      network            query_storage
5

Thanks for replying!

What's the best to do now? Reinstall pihole?

6

Hey all!

So, I solved it.

I reinstalled pihole with

pihole -r

However, it didn't help. The database was still corrupted as previously.
So, I did:

~ $ sudo service pihole-FTL stop
~ $ sudo mv /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL-old1.db

After i checked again the status of the database:

~ $ pihole-FTL sqlite3 /etc/pihole/pihole-FTL.db ".tables"

Error: unable to open database "/etc/pihole/pihole-FTL.db": unable to open database file

Ok, it made sense to me.
Then I restarted the pihole-FTL:

~ $ sudo service pihole-FTL start

And I tried again how's the database:

~ $ pihole-FTL sqlite3 /etc/pihole/pihole-FTL.db ".tables"
Error: database is locked

Dunno why the start did not work, any ideas?

Then I restarted the pihole-FTL:

~ $ sudo systemctl restart pihole-FTL

And magically the databases are here!

~ $ pihole-FTL sqlite3 /etc/pihole/pihole-FTL.db ".tables"
addinfo_by_id      counters           ftl                network_addresses
aliasclient        domain_by_id       message            queries
client_by_id       forward_by_id      network            query_storage

Also in the web interface I can finally see the list of the clients.

Any idea why the:

~ $ sudo service pihole-FTL start

Did not work in the first place?

Cheers!

F

7

I guess the start worked.
Likely, the database was locked because pihole-FTL was still busy creating all the tables in it. :wink: