Welcome, Guest. Please login or register.

Author Topic: Update MAC Vendor OUI Database?  (Read 431 times)

SchmuFoo

  • Jr. Member
  • **
  • Posts: 72
    • View Profile
Update MAC Vendor OUI Database?
« on: November 18, 2019, 11:59:08 AM »
Hello,

don't remember anymore how the procedure was to update the MAC Vendor Database?

Update /var/nedi/inc/oui.csv and run /var/nedi/nedi.pl -N oui ?

If yes, some good source avaible for wget an oui.csv?

Thanks,
Jan

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2728
    • View Profile
    • NeDi
Re: Update MAC Vendor OUI Database?
« Reply #1 on: December 03, 2019, 10:01:17 AM »
I use this to update the distribution:

wget -O /var/nedi/inc/oui.csv https://standards.ieee.org/develop/regauth/oui/oui.csv
wget -O /var/nedi/inc/mam.csv https://standards.ieee.org/develop/regauth/oui28/mam.csv
wget -O /var/nedi/inc/oui36.csv https://standards.ieee.org/develop/regauth/oui36/oui36.csv
wget -O /var/nedi/inc/iab.csv https://standards.ieee.org/develop/regauth/iab/iab.csv
wget -O /var/nedi/inc/cid.csv https://standards.ieee.org/develop/regauth/cid/cid.csv
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

ascii

  • Jr. Member
  • **
  • Posts: 90
    • View Profile
Re: Update MAC Vendor OUI Database?
« Reply #2 on: December 12, 2019, 11:46:14 AM »
i tried it but the sql update failed for me
Code: [Select]
$ perl /var/nedi/nedi.pl -v -N oui
DNS :Net::Nslookup not available
CLI :IO-Pty loaded
WEB :LWP-UserAgent loaded
OUI :38299 NIC vendor entries read
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'L CO.' WHERE mac='448a5b7b506e'' at line 1 at /var/nedi/inc/libdb.pm line 2166.

I'm using NeDi 1.8.100p3

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2728
    • View Profile
    • NeDi
Re: Update MAC Vendor OUI Database?
« Reply #3 on: December 16, 2019, 11:03:03 AM »
Umpf, vendors use single quotes and I never encountered it...

Search the function ReadOUIs in libmisc.pm and change:

            $m[2] =~ s/"//g;
to:
            $m[2] =~ s/["']//g;
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

ascii

  • Jr. Member
  • **
  • Posts: 90
    • View Profile
Re: Update MAC Vendor OUI Database?
« Reply #4 on: December 17, 2019, 08:24:43 AM »
worked like a charm

Code: [Select]
root at krenoc in ~
$ perl /var/nedi/nedi.pl -v -N oui
DNS :Net::Nslookup not available
CLI :IO-Pty loaded
WEB :LWP-UserAgent loaded
OUI :38299 NIC vendor entries read
......
NOUI:Updated 8773 node vendors
END :Took 0 minutes

ghermant

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: Update MAC Vendor OUI Database?
« Reply #5 on: January 03, 2020, 12:53:56 PM »
Hello,
How to make this OUI update to work with NeDi 1.7?
It seems that the -N option refers to IP or names in 1.7.

[nedi]$ perl /var/nedi/nedi.pl -v -N oui
CLI :IO-Pty loaded
Invalid IP: oui.1.1.1 at /var/nedi/nedi.pl line 192.


Brgds,
GaŽl

gpinero

  • Newbie
  • *
  • Posts: 2
    • View Profile
Re: Update MAC Vendor OUI Database?
« Reply #6 on: January 13, 2020, 08:41:41 AM »
Hello,
How to make this OUI update to work with NeDi 1.7?
It seems that the -N option refers to IP or names in 1.7.

[nedi]$ perl /var/nedi/nedi.pl -v -N oui
CLI :IO-Pty loaded
Invalid IP: oui.1.1.1 at /var/nedi/nedi.pl line 192.


Brgds,
GaŽl

Same problem with 1.6
/var/nedi# /var/nedi/nedi.pl -N oui
Invalid IP: oui.1.1.1 at /var/nedi/nedi.pl line 193




rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2728
    • View Profile
    • NeDi
Re: Update MAC Vendor OUI Database?
« Reply #7 on: February 05, 2020, 09:00:02 AM »
Please update to 1.8 :-)
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo