Hi,
In the DHCP lease table of (Web UI) Services: Kea DHCP: Leases DHCPv4, MAC address column shows vendor information if the database in somewhere has such information.
I do believe above-mentioned database is pretty much outdated as the table does not show the vendor information of some of my devices (e.g. D8:3B:DA, 10:00:3B, 5C:01:3B), which upon checking (https://standards-oui.ieee.org/), the OUI was registered in 2024.
I want to update the database (if the database is within the metal) or update the link to the database (if the database is on the internet). Where should I start from? Any help is appreciated.
Thanks in advance,
Hazuki
Hi
This has been issued earlier also, see forum post here:
https://forum.opnsense.org/index.php?topic=10380.0 (https://forum.opnsense.org/index.php?topic=10380.0)
and github:
https://github.com/opnsense/core/issues/3883 (https://github.com/opnsense/core/issues/3883)
hope that helps
https://github.com/netaddr/netaddr/commits/master/ looks pretty dead to me.
Cheers,
Franco
Thanks @RamSense!
So the answer to my question is basically in https://github.com/opnsense/core/issues/5205 (https://forum.opnsense.org/index.php?board=48;action=post2#!%20/bin/sh%20cd%20/usr/local/lib/python3.8/site-packages/netaddr/eui%20curl%20-s%20-o%20oui.txt%20http://standards-oui.ieee.org/oui/oui.txt%20curl%20-s%20-o%20iab.txt%20http://standards-oui.ieee.org/iab/iab.txt%20python3%20ieee.py)
#! /bin/sh
cd /usr/local/lib/python3.8/site-packages/netaddr/eui
curl -s -o oui.txt https://standards-oui.ieee.org/oui/oui.txt
curl -s -o iab.txt https://standards-oui.ieee.org/iab/iab.txt
python3 ieee.py
By the way, I do think we should not rely on the generated files from https://github.com/netaddr/netaddr/blob/master/netaddr/eui/iab.idx and https://github.com/netaddr/netaddr/blob/master/netaddr/eui/oui.idx. The script ieee.py still works as at today and I don't think the author is obligated to update these files in github/upstream as developers using his code shall generate the files on his own.
My 2 cents,
Hazuki
correct, although this depends on what version of OPNsense you are running. It is now python3.11
so you should change the location to : cd /usr/local/lib/python3.11/site-packages/netaddr/eui