NetStumbler.org Forums

Go Back   NetStumbler.org Forums > NetStumbler Community > Scripts
Reload this Page OUI data collection
Register Search Today's Posts Mark Forums Read

Reply
Page 1 of 2 1 2 >
 
LinkBack Thread Tools Display Modes
Old 07-22-2004   #1 (permalink)
dwakeman
perlmonk
 
dwakeman's Avatar
 
Join Date: Jul 2004
Location: canadia
Posts: 57
OUI data collection
This isn't for NetStumbler per se, but I require it for some database reporting I plan on doing with NetStumbler data I have in a MySQL db.

This script takes the OUI data from IEEE SA (http://standards.ieee.org/), and inserts the MAC
address and Organization info into a MySQL DB. This is used to
later match MAC addresses to Organization names automatically.

Requires Perl and the oui.txt file from the IEEE site.

update: It collects 7592 mac/org matches as of this post date.

Thanks,
Dave
Attached Files
File Type: zip mungeOUI-1.0.zip (8.9 KB, 60 views)
Last edited by dwakeman : 07-22-2004 at 10:05 AM.
dwakeman is offline   Reply With Quote
Old 01-07-2005   #2 (permalink)
nashr
Uber Geek
 
nashr's Avatar
 
Join Date: Aug 2002
Location: Virginia
Posts: 1,603
Quote:
Originally Posted by dwakeman
This isn't for NetStumbler per se, but I require it for some database reporting I plan on doing with NetStumbler data I have in a MySQL db.

This script takes the OUI data from IEEE SA (http://standards.ieee.org/), and inserts the MAC
address and Organization info into a MySQL DB. This is used to
later match MAC addresses to Organization names automatically.

Requires Perl and the oui.txt file from the IEEE site.

update: It collects 7592 mac/org matches as of this post date.

Thanks,
Dave
I'm interested in this script, and hope to play with it this weekend. I also came across this similar script that you may wish to explore.
__________________
Help! I've been Simpsonized!
nashr is offline   Reply With Quote
Old 01-07-2005   #3 (permalink)
rjdenver
Registered Member
 
rjdenver's Avatar
 
Join Date: Nov 2004
Posts: 110
Quote:
Originally Posted by nashr
I'm interested in this script, and hope to play with it this weekend. I also came across this similar script that you may wish to explore.
Thanks for the info. I've been wanting to do some better processing against MACs. So far I've just been loading everything into Excel and writing rules.

Rj
rjdenver is offline   Reply With Quote
Old 01-07-2005   #4 (permalink)
nashr
Uber Geek
 
nashr's Avatar
 
Join Date: Aug 2002
Location: Virginia
Posts: 1,603
Even Better
On a hunch, I went to search.cpan.org and found Net::MAC::Vendor which I think just about covers everything you/I want to do.

I can see I'll be busy/sleepless this weekend.
__________________
Help! I've been Simpsonized!
nashr is offline   Reply With Quote
Old 01-07-2005   #5 (permalink)
rjdenver
Registered Member
 
rjdenver's Avatar
 
Join Date: Nov 2004
Posts: 110
Quote:
Originally Posted by nashr
On a hunch, I went to search.cpan.org and found Net::MAC::Vendor which I think just about covers everything you/I want to do.

I can see I'll be busy/sleepless this weekend.
Hey, look at that. Will definately have to play. thanks!

Rj
rjdenver is offline   Reply With Quote
Old 01-07-2005   #6 (permalink)
streaker69
Psychic Amish Stumbler
 
streaker69's Avatar
 
Join Date: Jul 2004
Location: Virginville, BlueBall, Bird In Hand, Intercourse, Paradise, PA
Posts: 11,650
It's so funny seeing all these scripts in here, because before I really started posting in here, I had already developed my own website with all my data in, which has OUI Data, and does a lookdown view of where the AP is located based upon the GPS coords.

PM me if you wanna have a look.
__________________
"One of these days, I'm going to cut you to pieces."

If you're offended by this post, please feel free to report it to one of the many helpful moderators of this forum.

Thank you.
streaker69 is offline   Reply With Quote
Old 01-07-2005   #7 (permalink)
RedSector
CoWF Priest
 
RedSector's Avatar
 
Join Date: Nov 2004
Location: Illinois
Posts: 673
Quote:
Originally Posted by streaker69
It's so funny seeing all these scripts in here, because before I really started posting in here, I had already developed my own website with all my data in, which has OUI Data, and does a lookdown view of where the AP is located based upon the GPS coords.

PM me if you wanna have a look.
streaker showed that. It was severely cool. The lookdown view was extra cool
__________________
Get thine ass into the Church
The Church of Wifi
RedSector is offline   Reply With Quote
Old 01-12-2005   #8 (permalink)
nashr
Uber Geek
 
nashr's Avatar
 
Join Date: Aug 2002
Location: Virginia
Posts: 1,603
Quote:
Originally Posted by nashr
On a hunch, I went to search.cpan.org and found Net::MAC::Vendor which I think just about covers everything you/I want to do.

I can see I'll be busy/sleepless this weekend.
I'm going to mess with this today. Wish me luck.
__________________
Help! I've been Simpsonized!
nashr is offline   Reply With Quote
Old 01-12-2005   #9 (permalink)
streaker69
Psychic Amish Stumbler
 
streaker69's Avatar
 
Join Date: Jul 2004
Location: Virginville, BlueBall, Bird In Hand, Intercourse, Paradise, PA
Posts: 11,650
Quote:
Originally Posted by nashr
I'm going to mess with this today. Wish me luck.
Whatcha messin' with?
__________________
"One of these days, I'm going to cut you to pieces."

If you're offended by this post, please feel free to report it to one of the many helpful moderators of this forum.

Thank you.
streaker69 is offline   Reply With Quote
Old 01-12-2005   #10 (permalink)
nashr
Uber Geek
 
nashr's Avatar
 
Join Date: Aug 2002
Location: Virginia
Posts: 1,603
Quote:
Originally Posted by streaker69
Whatcha messin' with?
Playing with a perl script to take mac addresses, pull vendor data, and dump to mysql.

Just the usual geek stuff
__________________
Help! I've been Simpsonized!
nashr is offline   Reply With Quote
Old 01-12-2005   #11 (permalink)
streaker69
Psychic Amish Stumbler
 
streaker69's Avatar
 
Join Date: Jul 2004
Location: Virginville, BlueBall, Bird In Hand, Intercourse, Paradise, PA
Posts: 11,650
Quote:
Originally Posted by nashr
Playing with a perl script to take mac addresses, pull vendor data, and dump to mysql.

Just the usual geek stuff
Do you want my Excel file of the OIU's?

Might save you some time.
__________________
"One of these days, I'm going to cut you to pieces."

If you're offended by this post, please feel free to report it to one of the many helpful moderators of this forum.

Thank you.
streaker69 is offline   Reply With Quote
Old 01-12-2005   #12 (permalink)
nashr
Uber Geek
 
nashr's Avatar
 
Join Date: Aug 2002
Location: Virginia
Posts: 1,603
Quote:
Originally Posted by streaker69
Do you want my Excel file of the OIU's?

Might save you some time.
Thanks, but that's the easy part.

I'm working from some various scripts and a PM I found at CPAN. Will let you all know if I come up with anything useful.
__________________
Help! I've been Simpsonized!
nashr is offline   Reply With Quote
Old 01-12-2005   #13 (permalink)
streaker69
Psychic Amish Stumbler
 
streaker69's Avatar
 
Join Date: Jul 2004
Location: Virginville, BlueBall, Bird In Hand, Intercourse, Paradise, PA
Posts: 11,650
Quote:
Originally Posted by nashr
Thanks, but that's the easy part.

I'm working from some various scripts and a PM I found at CPAN. Will let you all know if I come up with anything useful.
No problem.. Just thought it might save ya sometime on he project.
__________________
"One of these days, I'm going to cut you to pieces."

If you're offended by this post, please feel free to report it to one of the many helpful moderators of this forum.

Thank you.
streaker69 is offline   Reply With Quote
Old 01-12-2005   #14 (permalink)
nashr
Uber Geek
 
nashr's Avatar
 
Join Date: Aug 2002
Location: Virginia
Posts: 1,603
Quote:
Originally Posted by streaker69
No problem.. Just thought it might save ya sometime on he project.
No problem, good of you to offer. I'm working from a script that I found online called ouilookup.pl, and with mungeOUI found in this thread. I'm going to try and combine the best of both and see what I can come up with.

This is going to take longer than I thought... just not into it today I guess.
__________________
Help! I've been Simpsonized!
nashr is offline   Reply With Quote
Old 01-12-2005   #15 (permalink)
streaker69
Psychic Amish Stumbler
 
streaker69's Avatar
 
Join Date: Jul 2004
Location: Virginville, BlueBall, Bird In Hand, Intercourse, Paradise, PA
Posts: 11,650
Quote:
Originally Posted by nashr
No problem, good of you to offer. I'm working from a script that I found online called ouilookup.pl, and with mungeOUI found in this thread. I'm going to try and combine the best of both and see what I can come up with.

This is going to take longer than I thought... just not into it today I guess.
That's why I took the data from the IEEE site, put it into Excel so I could then put it into Access and query it from my website. It was easier than trying to read it from a remote site, because it didn't seem as though the data there was organized very well.
__________________
"One of these days, I'm going to cut you to pieces."

If you're offended by this post, please feel free to report it to one of the many helpful moderators of this forum.

Thank you.
streaker69 is offline   Reply With Quote
Reply
Page 1 of 2 1 2 >

« NS php->sql db parser | php as a scripting engine? »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



Google
 
Web NetStumbler.org

All times are GMT -7. The time now is 07:26 AM.

Contact Us - NetStumbler.org - NetStumbler.com - Online Backup - Archive - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0 ©2007, Crawlability, Inc.


All messages express the views of the author and are for entertainment purposes only. Netstumbler.org cannot be held responsible for the authenticity of the content or the actions of its members. By using this site and its services, you warrant that you will not post any messages that are discriminating, obscene, hateful, threatening, or otherwise violates any laws and you release Netstumbler.org from any future claims of any kind whatsoever including, but not limited to, addiction and loss of productivity. All forum messages, private messages and any other content are properties of Netstumbler.org. Even if publicly available, personal or copyrighted information are not to be posted without the consent of the owner. Distribution of licensed and copyrighted materials in any way not endorsed by the copyright owner is strictly prohibited. You may not use this site and its resources to spam other sites or individuals or perform any action that violates any law. Items sold or bought in the For Sale forum are sold as is and no warranty or insurance of any kind is provided. Netstumbler.org cannot be held responsible for the outcome of any transactions and no warranty of any kind is provided, either express or implied. Vulgar words are not allowed in the subject lines ; they may be used in the message body in any forum. The Administrator, Super Moderators and Moderators of Netstumbler.org have the right to remove, edit, move or close any thread for any reason and to reveal your identity and other known information in the event of a complaint or legal action arising from any message posted by you.