OUI - Revision history

Admin at 02:00, 21 April 2017

2017-04-21T02:00:12Z

← Older revision		Revision as of 02:00, 21 April 2017
Line 5:		Line 5:
	Lookup file (3.3 MB): [[File:oui.txt]]		Lookup file (3.3 MB): [[File:oui.txt]]

	It's kind of a lookup table. ~~So, I decided to make~~ it an actual lookup table.		It's kind of a lookup table. Github user pwldp made it an actual lookup table: https://gist.github.com/pwldp/dee6d5f9868a1dd1d076

	Lookup script:		Lookup script:

Admin at 01:57, 21 April 2017

2017-04-21T01:57:38Z

← Older revision		Revision as of 01:57, 21 April 2017
Line 1:		Line 1:
	This ~~is a~~ mega-big 3 MB file serves as a kind of look up table for MAC addresses to manufacturers:		This mega-big 3 MB file serves as a kind of look up table for MAC addresses to manufacturers:

	http://standards-oui.ieee.org/oui.txt		http://standards-oui.ieee.org/oui.txt

Admin at 11:19, 17 April 2017

2017-04-17T11:19:35Z

← Older revision		Revision as of 11:19, 17 April 2017
Line 113:		Line 113:
	[[Category:Networking]]		[[Category:Networking]]
	[[Category:Security]]		[[Category:Security]]
			[[Category:Android]]
			[[Category:Wireless]]

Admin at 11:19, 17 April 2017

2017-04-17T11:19:08Z

← Older revision		Revision as of 11:19, 17 April 2017
Line 1:		Line 1:
			This is a mega-big 3 MB file serves as a kind of look up table for MAC addresses to manufacturers:

			http://standards-oui.ieee.org/oui.txt

	Lookup file (3.3 MB): [[File:oui.txt]]		Lookup file (3.3 MB): [[File:oui.txt]]

			It's kind of a lookup table. So, I decided to make it an actual lookup table.

	Lookup script:		Lookup script:

Admin at 07:47, 26 February 2017

2017-02-26T07:47:14Z

← Older revision		Revision as of 07:47, 26 February 2017
Line 1:		Line 1:
	Lookup file (3.3 MB): [[File:oui.txt]]		Lookup file (3.3 MB): [[File:oui.txt]]

			Lookup script:

			<pre>
			$ cat load_iou_to_pgsql.py
			#!/usr/bin/env python
			#
			# Scripts download oui.txt from web and load data to PostgreSQL database.
			#
			# Dariusz Pawlak <pawlakdp@gmail.com>
			# 2014.05.16
			#
			#
			import re
			import urllib
			#
			import psycopg2
			from psycopg2.extensions import ISOLATION_LEVEL_AUTOCOMMIT
			from psycopg2 import errorcodes
			#
			# PgSQl connection
			#
			DBHOST=""
			DBNAME=""
			DBUSER=""
			DBPSWD=""
			"""

			SQL minimal table needed by script:

			-- Table: TABLENAME

			-- DROP TABLE TABLENAME;

			CREATE TABLE TABLENAME
			(
			oui character varying(8) NOT NULL,
			vendor character varying NOT NULL,
			id serial NOT NULL,
			CONSTRAINT pk_mac_vendors PRIMARY KEY (oui)
			)
			WITH (
			OIDS=FALSE
			);
			ALTER TABLE TABLENAME
			OWNER TO DBUSER;

			"""
			#
			OUI_URL = "http://standards.ieee.org/develop/regauth/oui/oui.txt"
			OUI_FILE = "oui.txt"
			#
			#
			if __name__ == "__main__":
			#
			# download oui.txt
			#print "Downloading ",OUI_URL
			#urllib.urlretrieve(OUI_URL, OUI_FILE)
			#
			#connect to db
			try:
			conn = psycopg2.connect("dbname='%s' user='%s' host='%s' password='%s'" % (DBNAME,DBUSER,DBHOST,DBPSWD))
			except:
			sys.exit("I am unable to connect to the database")
			#
			conn.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT)
			cur = conn.cursor()
			# parsing oui.txt data
			print "Parsing data..."
			with open(OUI_FILE) as infile:
			for line in infile:
			#do_something_with(line)
			if re.search("(hex)", line):
			try:
			mac,vendor = line.strip().split("(hex)")
			except:
			mac = vendor = ''
			#print line.strip().split("(hex)")
			#print mac.strip().replace("-",":").lower(), vendor.strip()
			if mac!='' and vendor!='':
			sql = "INSERT INTO mac_vendors "
			sql+= "(oui,vendor) "
			sql+= "VALUES ("
			sql+= "'%s'," % mac.strip().replace("-",":").lower()
			sql+= "'%s'" % vendor.strip().replace("'","`")
			sql+= ")"
			print sql
			try:
			cur.execute(sql)
			except Exception, e:
			print "Not inserted because error: ",errorcodes.lookup(e.pgcode)

			#
			cur.close()
			conn.close()
			#
			# EOF
			#
			</pre>



			=Flags=

			[[Category:Python]]
			[[Category:Networking]]
			[[Category:Security]]

Admin: Created page with "Lookup file (3.3 MB): File:oui.txt"

2017-02-26T07:46:08Z

Created page with "Lookup file (3.3 MB): File:oui.txt"

New page

Lookup file (3.3 MB): [[File:oui.txt]]