Skip to content

OUI Database, switch serial numbers

Compare
Choose a tag to compare
@barryo barryo released this 17 Feb 20:41
· 4519 commits to master since this release

This release contains a small number of bug fixes and two new features:

  1. Show switch serial numbers on the switch table (if switch model is supported)
  2. Add an OUI database and show OUI manufacturer in the MAC address table

Schema update required:

CREATE TABLE oui (
        id INT AUTO_INCREMENT NOT NULL, 
        oui VARCHAR(6) NOT NULL, 
        organisation VARCHAR(255) NOT NULL, 
        UNIQUE INDEX UNIQ_DAEC0140DAEC0140 (oui), 
        PRIMARY KEY(id)
    ) 
    DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci 
    ENGINE = InnoDB;

You can find additional documentation on populating the OUI database here.

  • [BF] Begun a transaction (unnecessarily) that was not ended
  • [NF] Show manufacturer of an OUI in the MAC address table listing. Closes #87 (f25fb78 - Barry O'Donovan - 2014-02-17)
  • [HK] Documentation (7c10126 - Barry O'Donovan - 2014-02-17)
  • [NF] Update OUI database from named file or IEEE website - for issue #87 (641c7eb - Barry O'Donovan - 2014-02-17)
  • [NF] OUI utility class to download and parse the IEEE OUI data file - for issue #87 (ecfe124 - Barry O'Donovan - 2014-02-17)
  • [DB] New table to store OUI organisation details. For issue #87 (3766c84 - Barry O'Donovan - 2014-02-17)
  • [HK] Pre V3 OUI / SEC stuff that is no longer valid (a42ff4f - Barry O'Donovan - 2014-02-17)
  • [IM] Update bundled OUI file (0791d7e - Barry O'Donovan - 2014-02-17)
  • [IM] don't die if a switch is unreadable. complain loudly instead.k (7235ebb - Nick Hilliard - 2014-02-13)
  • [IM] don't die if the switch FDB cannot be read (eddfcf6 - Nick Hilliard - 2014-02-07)
  • [HK] Freshly pressed CSS / JS files (9dd00d8 - Barry O'Donovan - 2014-02-03)
  • [IM] Show switch serial number - closes #109 (d358298 - Barry O'Donovan - 2014-02-03)