DHCP Hostnames

yubiuser · November 3, 2021, 1:10pm

It does exactly what you already did

advanced/Scripts/piholeARPTable.sh

b5e0f142c


      
          FTLconf="/etc/pihole/pihole-FTL.conf"
          if [ -e "$FTLconf" ]; then
              DBFILE="$(sed -n -e 's/^\s*DBFILE\s*=\s*//p' ${FTLconf})"
          fi
          # Test for empty string. Use standard path in this case.
          if [ -z "$DBFILE" ]; then
              DBFILE="/etc/pihole/pihole-FTL.db"
          fi
          
          
          flushARP(){
              local output
              if [[ "${args[1]}" != "quiet" ]]; then
                  echo -ne "  ${INFO} Flushing network table ..."
              fi
          
              # Truncate network_addresses table in pihole-FTL.db
              # This needs to be done before we can truncate the network table due to
              # foreign key constraints
              if ! output=$(sqlite3 "${DBFILE}" "DELETE FROM network_addresses" 2>&1); then
                  echo -e "${OVER}  ${CROSS} Failed to truncate network_addresses table"

But it's good that the issue seems solved now.

markthomas · November 3, 2021, 2:36pm

It's solved in that the ancient entries have now gone but I've now got no hostnames being shown at all, which makes tracking down badly behaved devices tricky. Should I open a new topic for this?

yubiuser · November 3, 2021, 9:34pm

Let's continue here, as the whole story is written here. Please generate a new debug token.

markthomas · November 4, 2021, 11:55am

Debug token is > CnEibV1w

For the absense of doubt, hostnames used to appear in the network table, now they do not. Pi-hole runs my DHCP. The only entries in tools > network with hostnames are those that have a static IP assigned in the DHCP settings. . Half of the devices in the DHCP lease table have a hostname, half do not, no reason I can think of to explain.

markthomas · November 4, 2021, 1:37pm

yubiuser · November 5, 2021, 10:53pm

Only 3 static DHCP leases are applied in your current configuration. Those are the only ones which appear in the network table?

-rw-r--r-- 1 root root 157 Nov  2 13:53 /etc/dnsmasq.d/04-pihole-static-dhcp.conf
   dhcp-host=DC:A6:sdsddsd,192.168.1.22,raspberrypi4
   dhcp-host=B8:27:sdsds,192.168.1.21,raspberrypi3
   dhcp-host=30:2sddss,192.168.1.111,router

I guess those devices do not have a static IP assigment?

markthomas · November 6, 2021, 12:45pm

Almost, pi3 & pi4 appear in the network table, the router doesn't query the pi-hole in any way so does not appear. Again, devices added in the last month did appear in the netowrk table until I started to attempt to remove the phantom entries.

markthomas · November 6, 2021, 6:16pm

I've got to the bottom of this....

Vaguely remember seeing a very chatty 'localhost' in the Dashboard > Top Clients. Seems my fix for this was to blacklist *.in-addr.arpa.

Removing this blacklist entry has resulted in my network table starting to fill with hostnames.

Problem solved!

yubiuser · November 6, 2021, 8:38pm

Good catch! This was non-obvious when working through your debug log. Good Job!

Glad it is resolved now.

Out of curiosity: was the blacklisted domain a regex?

markthomas · November 6, 2021, 10:44pm

Yup regex for everything in in-addr.arpa.

Much respect for everyone involved in this, have a wee stack of Pi computers, all doing useful stuff, none more useful than Pi-hole, keep up the good work!

system · November 27, 2021, 10:44pm

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