Network Overview leer

Help Deutschsprachige Hilfe
1

Bitte beachte diese Vorlage, damit wir dir bestmöglich helfen können!

Hi zusammen,

bei meinem neu aufgesetztem PiHole ist die Network Overview leer. Im Dashboard zeigt er mir 23 Aktive Clients an.

Das FTL Log ist auf True gesetzt dennoch ist der Log absolut leer.

Wenn ich mir die pihole-FTL.db mit
sqlite3 /Etc/pihole/pihole-ftl.db "select * from network;"
anschauen möchte passiert nichts in der Konsole.

Der Pihole ist auf einem Ubuntu 22.04 Container im Proxmox installiert.

Ich habe euch mal einen Debug Token erstellt.

Debug Token:
https://tricorder.pi-hole.net/GgKy5yAG/

Danke für die Hilfe.

2

No, it's not empty.
If you are talking about the Web Interface Tools > Tail FTL.log page, this page doesn't show past log entries.
The page starts empty and only shows NEW log entries generated AFTER the page was loaded, but FTL doesn't generate messages too often (unless it is in debug mode), so you probably won't see many messages there.
You can read the full FTL log on the command line with cat /var/log/pihole/FTL.log
To read only the last lines on the log, you can use tail /var/log/pihole/FTL.log

There are 2 typos in your file path (Linux is case sensitive):

  • the file path should be /etc/pihole (all lower case).
  • the file name should be pihole-FTL.db (upper case "FTL").

Try again using the command:

pihole-FTL sqlite3 /etc/pihole/pihole-FTL.db "SELECT * FROM network"

This is strange.
Do you see any messages on the browser? Can you please check the browser's devtools (F12 key) and select the "Console" tab.

Note:
Sorry to answer in English.

3

Du hast Probleme mit der Datenbank

   [2023-07-03 14:49:32.261 2576M] SQLite3 message: no such column: name in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
   [2023-07-03 14:49:32.261 2576M] getNameFromIP("192.168.178.43") - SQL error prepare: SQL logic error
   [2023-07-03 14:49:32.261 2576M] SQLite3 message: no such column: aliasclient_id in "SELECT aliasclient_id FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? AND aliasclient_id IS NOT NULL GROUP BY ip HAVING max(lastSeen));" (1)
   [2023-07-03 14:49:32.261 2576M] getAliasclientIDfromIP("192.168.178.43") - SQL error prepare: SQL logic error
   [2023-07-03 14:49:32.261 2576M] find_mac("192.168.178.43") returned 0 bytes of data
   [2023-07-03 14:49:32.702 2576M] SQLite3 message: no such column: name in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
   [2023-07-03 14:49:32.702 2576M] getNameFromIP("::1") - SQL error prepare: SQL logic error
   [2023-07-03 14:49:32.702 2576M] SQLite3 message: no such column: aliasclient_id in "SELECT aliasclient_id FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? AND aliasclient_id IS NOT NULL GROUP BY ip HAVING max(lastSeen));" (1)
   [2023-07-03 14:49:32.703 2576M] getAliasclientIDfromIP("::1") - SQL error prepare: SQL logic error
   [2023-07-03 14:49:32.703 2576M] find_mac("::1") returned 0 bytes of data
   [2023-07-03 14:49:32.728 2576M] SQLite3 message: no such column: name in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
   [2023-07-03 14:49:32.728 2576M] getNameFromIP("fda2:8cfe:cbe5:e9b1:4bc3:7bff:fe67:c175") - SQL error prepare: SQL logic error
   [2023-07-03 14:49:32.728 2576M] SQLite3 message: no such column: aliasclient_id in "SELECT aliasclient_id FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? AND aliasclient_id IS NOT NULL GROUP BY ip HAVING max(lastSeen));" (1)
   [2023-07-03 14:49:32.728 2576M] getAliasclientIDfromIP("fda2:8cfe:cbe5:e9b1:4bc3:7bff:fe67:c175") - SQL error prepare: SQL logic error
   [2023-07-03 14:49:32.728 2576M] find_mac("fda2:8cfe:cbe5:e9b1:4bc3:7bff:fe67:c175") returned 0 bytes of data
   [2023-07-03 14:49:32.742 2576M] find_mac("127.0.0.1") returned 0 bytes of data
   [2023-07-03 14:49:35.855 2576M] SQLite3 message: no such column: name in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
   [2023-07-03 14:49:35.855 2576M] getNameFromIP("192.168.178.35") - SQL error prepare: SQL logic error
   [2023-07-03 14:49:35.856 2576M] SQLite3 message: no such column: name in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
   [2023-07-03 14:49:35.856 2576M] getNameFromIP("192.168.178.35") - SQL error prepare: SQL logic error
   [2023-07-03 14:49:35.856 2576M] SQLite3 message: no such column: name in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
   [2023-07-03 14:49:35.856 2576M] getNameFromIP("192.168.178.35") - SQL error prepare: SQL logic error

Versuch mal Pi-hole zu stoppen, die Datenbank umzubennen und Pi-hole neu zu starten.

systemctl stop pihole-FTL
mv /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL.db.bak
systemctl start pihole-FTL
5

Hab ich gerade versucht, hat nicht geholfen. Die Network Overview ist weiterhin leer.

6

Blockquote No, it's not empty.
If you are talking about the Web Interface Tools > Tail FTL.log page, this page doesn't show past log entries.
The page starts empty and only shows NEW log entries generated AFTER the page was loaded, but FTL doesn't generate messages too often (unless it is in debug mode), so you probably won't see many messages there.
You can read the full FTL log on the command line with cat /var/log/pihole/FTL.log
To read only the last lines on the log, you can use tail /var/log/pihole/FTL.log

Ah thank you for pointing that out.

root@pi-Hole:~# tail /var/log/pihole/FTL.log
[2023-07-03 19:09:00.096 6438/T6454] Network table: read interface details for interface eth0@if17 (5a:6f:40:55:7b:47) with address 192.168.178.43
[2023-07-03 19:09:00.096 6438/T6454] Network table (ip a): Client with MAC 5a:6f:40:55:7b:47 was recently be seen for network ID 25
[2023-07-03 19:09:00.100 6438/T6454] Network table: Updating existing ip a device MAC = 5a:6f:40:55:7b:47, IP = 192.168.178.43, interface = "eth0@if17"
[2023-07-03 19:09:00.100 6438/T6454] Network table: read interface details for interface eth0@if17 (5a:6f:40:55:7b:47) with address fda2:8cfe:cbe5:e9b1:4bc3:7bff:fe67:c175
[2023-07-03 19:09:00.100 6438/T6454] Network table (ip a): Client with MAC 5a:6f:40:55:7b:47 was recently be seen for network ID 25
[2023-07-03 19:09:00.104 6438/T6454] Network table: Updating existing ip a device MAC = 5a:6f:40:55:7b:47, IP = fda2:8cfe:cbe5:e9b1:4bc3:7bff:fe67:c175, interface = "eth0@if17"
[2023-07-03 19:09:00.104 6438/T6454] Network table: read interface details for interface eth0@if17 (5a:6f:40:55:7b:47) with address fe80::586f:40ff:fe55:7b47
[2023-07-03 19:09:00.104 6438/T6454] Network table (ip a): Client with MAC 5a:6f:40:55:7b:47 was recently be seen for network ID 25
[2023-07-03 19:09:00.108 6438/T6454] Network table: Updating existing ip a device MAC = 5a:6f:40:55:7b:47, IP = fe80::586f:40ff:fe55:7b47, interface = "eth0@if17"
[2023-07-03 19:09:00.113 6438/T6454] ARP table processing (38 entries from ARP, 6 from FTL's cache) took 22.5 ms

pihole-FTL sqlite3 /etc/pihole/pihole-FTL.db "SELECT * FROM network"

root@pi-Hole:~# sqlite3 /etc/pihole/pihole-FTL.db "SELECT * FROM network"
1|b2:59:47:08:e8:c1|eth0|1688411160|0|0||
2|20:1f:3b:01:e9:5c|eth0|1688411160|1688411200|6|Google, Inc.|
3|b8:27:eb:11:cb:35|eth0|1688411160|1688411273|3|Raspberry Pi Foundation|
4|5a:2a:8b:90:9c:16|eth0|1688411160|0|0||
5|50:e6:36:75:14:b0|eth0|1688411160|0|0|AVM Audiovisuelles Marketing und Computersysteme GmbH|
6|4a:b4:5f:b3:b2:06|eth0|1688411160|0|0||
7|48:9e:bd:91:8b:8f|eth0|1688411160|1688411372|21|HP Inc.|
8|f0:f0:a4:c2:61:31|eth0|1688411160|1688411345|6|Amazon Technologies Inc.|
9|80:fa:5b:15:6d:2e|eth0|1688411160|1688411130|5|Clevo Co.|
10|34:d2:70:8e:ba:20|eth0|1688411160|0|0|Amazon Technologies Inc.|
11|1c:4d:66:d2:b9:b9|eth0|1688411160|1688411336|5|Amazon Technologies Inc.|
12|62:ed:85:70:ce:45|eth0|1688411160|1688411382|52||
13|7c:d5:66:ce:7d:fd|eth0|1688411160|1688411280|6|Amazon Technologies Inc.|
14|c4:29:96:04:16:90|eth0|1688411160|0|0|Signify B.V.|
15|04:17:b6:14:2a:3a|eth0|1688411160|0|0|Smart Innovation LLC|
16|3c:37:12:eb:c5:0b|eth0|1688411160|0|0|AVM Audiovisuelles Marketing und Computersysteme GmbH|
17|70:85:c2:25:9e:61|eth0|1688411160|0|0|ASRock Incorporation|
18|28:11:a5:c2:ca:b4|eth0|1688411160|0|0|Bose Corporation|
19|48:e1:e9:16:e2:36|eth0|1688411160|0|0|Chengdu Meross Technology Co., Ltd.|
20|fe:14:4b:31:1b:dc|eth0|1688411160|0|0||
21|b0:e4:d5:b5:2a:bb|eth0|1688411160|1688411182|2|Google, Inc.|
22|b6:f2:08:30:3c:f1|eth0|1688411160|0|0||
24|00:00:00:00:00:00|lo|1688411160|1688411274|17|virtual interface|
25|5a:6f:40:55:7b:47|eth0@if17|1688411160|0|0||
26|50:2d:bb:85:00:4a|eth0|1688411280|1688411335|13|GD Midea Air-Conditioning Equipment Co.,Ltd.|

I hope you can read out the problem?

This is strange.
Do you see any messages on the browser? Can you please check the browser's devtools (F12 key) and select the "Console" tab.

nothing to see...

Unbenannt
Unbenannt1920×937 134 KB

7

ah es hat sich gerade aktualisiert... es geht wieder alles... Dankeschön für die Hilfe!

8

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