Let me try adding a new IPv4/IPv6 addr, then discovery.php > discovery.txt
$ grep 172.25.247.4 discovery.txt
0:87:64:33:79:41 => 172.25.247.4
SQL[insert into ipv4_mac
(context_name
, device_id
, ipv4_address
, mac_address
, port_id
) values (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?) [“”,1753,“159.238.217.123”,“bce92f8eb0b9”,109480,“”,1753,“10.22.1.6”,“b0a4603ed20d”,160860,“”,1753,“172.25.247.4”,“008764337941”,161299] 7.99ms]
librenms@nacho:~$ grep 79:41 discovery.txt
IP-MIB::ipNetToPhysicalPhysAddress[72][ipv4][““] = b0:90:7e:d0:79:41
IP-MIB::ipNetToPhysicalPhysAddress[174][ipv4][””] = 0:87:64:33:79:41
IP-MIB::ipNetToPhysicalPhysAddress[174][ipv6][“26:20:00:31:40:02:00:aa:02:87:64:ff:fe:33:79:41”] = 0:87:64:33:79:41
IP-MIB::ipNetToPhysicalPhysAddress[174][ipv6][“fe:80:00:00:00:00:00:00:02:87:64:ff:fe:33:79:41”] = 0:87:64:33:79:41
IP-MIB::ipNetToMediaPhysAddress[72][] = b0:90:7e:d0:79:41
IP-MIB::ipNetToMediaPhysAddress[174][] = 0:87:64:33:79:41
b0:90:7e:d0:79:41 => 172.25.225.12
0:87:64:33:79:41 => 172.25.247.4
BRIDGE-MIB::dot1dTpFdbPort[b0:90:7e:d0:79:41] = 15
BRIDGE-MIB::dot1dTpFdbPort[0:87:64:33:79:41] = 15
MariaDB [librenms]> select * from ipv4_addresses where ipv4_address = "172.25.247.4";
Empty set (0.002 sec)
MariaDB [librenms]> select * from ipv6_addresses where ipv6_compressed like "%7941";
Empty set (0.000 sec)
MariaDB [librenms]> select * from ipv4_mac where ipv4_address = "172.25.247.4";
+----------+---------+-----------+--------------+--------------+--------------+
| id | port_id | device_id | mac_address | ipv4_address | context_name |
+----------+---------+-----------+--------------+--------------+--------------+
| 10019564 | 161299 | 1753 | 008764337941 | 172.25.247.4 | |
+----------+---------+-----------+--------------+--------------+--------------+
1 row in set (0.023 sec)
WELL… I see no statement in that discover to suggest it added to ipv4/ipv6_addresses. But, my cohort said the interface wasn’t there so he ran a discover. (with no debug. Obscenities were uttered.)
MariaDB [librenms]> select ipv6_compressed from ipv6_addresses where ipv6_compressed like "%7941";
+------------------------------------+
| ipv6_compressed |
+------------------------------------+
| 2620:31:4002:aa:287:64ff:fe33:7941 |
+------------------------------------+
1 row in set (0.001 sec)
Surely, I must be losing my mind.