@DL6ER The sql statement throws an error “Error: attempt to write a readonly database”.
Guessing here…it looks like a timing issue. What I mean is…when I flush the table (using the gui), returning to the network page, the first thing I see are no rows. Clicking repeatedly, they populate in groups and the first group contains the non-MAC ID record, then followed by the correctly resolved MAC ID record (duplicate). Not sure if that helps pin it down.
Testing again just now (using GUI), flush table, click and zero rows display. Then nine rows, six devices on my primary LAN (the iPad showing no MAC ID again but no duplicate record yet) and three rows of my VLAN devices. The table continues to fill in over time. The first rows fill in after just a couple clicks…so within 15 seconds of flushing. Could this be related to the mock issue from the other thread? This did not just show up from your last code change, I noticed it just before that as well (before I mentioned some devices were showing N/A).
Testing again, this time I get four devices that are now missing MAC IDs (and all become duplicate IP records). Sixteen devices populating the first group (while clicking Network repeatedly…obviously even though that’s what I’m seeing there could be multiple iterations of building this table occurring behind the scenes).
Edit: Also, one of my two network switches is missing, but on my other pihole (I run two in parallel independent) it does show. That pihole is running the standard pi-hole beta 5 branch, not this network branch. That’s strange in that it’s really no different from my other switch and resolves similarly.
dig -x 192.168.1.5 @192.168.1.1
; <<>> DiG 9.11.5-P4-5.1-Raspbian <<>> -x 192.168.1.5 @192.168.1.1
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 57274
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1
;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 4096
;; QUESTION SECTION:
;126.96.36.199.in-addr.arpa. IN PTR
;; ANSWER SECTION:
188.8.131.52.in-addr.arpa. 3600 IN PTR TL-SG108E.home.
;; Query time: 0 msec
;; SERVER: 192.168.1.1#53(192.168.1.1)
;; WHEN: Wed Mar 25 08:58:15 EDT 2020
;; MSG SIZE rcvd: 81