|
|
| Author |
Message |
bambid
Joined: 02 Nov 2006 Posts: 22
|
Posted: Tue Jan 02, 2007 5:28 pm Post subject: |
|
|
| Full support for HP ProCurve switches ? |
|
| Back to top |
|
 |
gthe Cacti User
Joined: 29 Jul 2006 Posts: 102 Location: RU
|
Posted: Wed Jan 03, 2007 7:37 am Post subject: |
|
|
Excuse for my English
1. To add an opportunity of search to the MAC-ADDRESS in a format xx-xx-xx-xx-xx-xx AND xx:xx:xx:xx:xx:xx
2. To add one more object - the Subscriber and tables: (Subsc_id, Subsc_info, correct_mac, correct_ip), (Subsc_id, correct_IP_Device, correct_VLAN, correct_PORT) At viewing MAC-IP of the information to check each record on correctness with these data and to allocate with color correct and wrong.
It will allow to trace new subscribers, or those who has changed IP or MAC, or those who tries to substitute another's IP and MAC, being connected to other port of the device. |
|
| Back to top |
|
 |
egarnel Cacti Pro User
Joined: 21 Nov 2002 Posts: 630 Location: Austin, TX
|
Posted: Wed Jan 03, 2007 8:56 am Post subject: |
|
|
| The ability to run mactrack on the fly manually from the mactrack utilities under console |
|
| Back to top |
|
 |
TheWitness Developer
Joined: 14 May 2002 Posts: 9723 Location: MI, USA
|
Posted: Wed Jan 03, 2007 11:57 pm Post subject: |
|
|
egarnel,
I evaluated this at one time. Say, you have an issue "right now" and want to scan, say a site. Take's all of 30 seconds to complete. I'd say, way cool.
However, until I understand a little about Ajax and callbacks, I want to hold off for a bit. We'll see. I will need a tester
TheWitness |
|
| Back to top |
|
 |
egarnel Cacti Pro User
Joined: 21 Nov 2002 Posts: 630 Location: Austin, TX
|
Posted: Thu Jan 04, 2007 9:12 am Post subject: |
|
|
| Thanks. I will be happy to be a tester. given our dynamic environment, in which users come and go on an hourly/daily basis, running mactrack on the fly would be very helpful |
|
| Back to top |
|
 |
chadd Cacti User
Joined: 24 Mar 2005 Posts: 194 Location: Ocoee, Florida
|
Posted: Thu Jan 04, 2007 5:29 pm Post subject: |
|
|
| TheWitness wrote: | 1) Allow Export to work 100% of the time - Done
2) Allow Import to have fields out of order - Done
3) Allow Import to work with extra columns included (ignore these columns) - Done
4) Initial poll does not start as it should.
5) Sort columns - Done.
6) Add IEEE OUI Vendor MAC's Database to MacTrack - Done, and this RULES!!! |
Haven't completely trouble shot this, but I am getting no results in my 'vendor name' field.. I will look into this a bit more tomorrow. Thanks for the addition though, that will feature rock! |
|
| Back to top |
|
 |
TheWitness Developer
Joined: 14 May 2002 Posts: 9723 Location: MI, USA
|
Posted: Thu Jan 04, 2007 7:18 pm Post subject: |
|
|
If the "mac_track_oui_database" is empty, you may have to goto Tracking Utilities and import it. If you don't have "proxyless" access to the IEEE site, you will have to edit the "mactrack_import_ouidb.php" file and download the file in the comment section and instead of the "$oui_database = file("..."); you will have to replace that with the named file and then run the program.
Let me know if that get's it.
TheWitness |
|
| Back to top |
|
 |
cigamit Developer
Joined: 07 Apr 2005 Posts: 946 Location: B/CS Texas
|
Posted: Thu Jan 04, 2007 11:56 pm Post subject: |
|
|
Seems that imported Vendors that have a ' in the name or address fail to import and through a SQL error, as the ' is not properly sanitized first.
LARRY EDIT: Done!! |
|
| Back to top |
|
 |
TheWitness Developer
Joined: 14 May 2002 Posts: 9723 Location: MI, USA
|
Posted: Fri Jan 05, 2007 8:46 am Post subject: |
|
|
That's somewhat problematic. It works fine in MySQL 5.x. After having read the article on the "mis"-use of add slashes, I think I'll just strip them.
Thanks for the note Jimmy. Did you call what's his name?
TheWitness |
|
| Back to top |
|
 |
chadd Cacti User
Joined: 24 Mar 2005 Posts: 194 Location: Ocoee, Florida
|
Posted: Fri Jan 05, 2007 9:05 am Post subject: |
|
|
| I do have lots of vendors in my OUI database (besides the ones that have a ' in the name, as Jimmy said). I will spend a few minutes on it this morning to trying and figure out the problem. Thanks. |
|
| Back to top |
|
 |
streaker69 Cacti Pro User
Joined: 27 Mar 2006 Posts: 647 Location: Psychic Amish Network Administrator
|
Posted: Fri Jan 05, 2007 10:08 am Post subject: |
|
|
I believe I have an Excel spreadsheet at home with almost all the OUI/Vendors listed on it if anyone is interested in it.
Don't know if that'll help out with this project or not. |
|
| Back to top |
|
 |
chadd Cacti User
Joined: 24 Mar 2005 Posts: 194 Location: Ocoee, Florida
|
Posted: Fri Jan 05, 2007 11:38 am Post subject: |
|
|
| chadd wrote: | | I do have lots of vendors in my OUI database (besides the ones that have a ' in the name, as Jimmy said). I will spend a few minutes on it this morning to trying and figure out the problem. Thanks. |
Ok, almost fixed the problem with getting vendor names and addresses into the database which include '. These are the remaining onces I am having a problem with. It looks like it is because there are double quotes in the name/address field of theses.. Don't know how to get around that..
01/05/2007 11:27:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO mac_track_oui_database (vendor_mac, vendor_name, vendor_address, present) VALUES ('00:90:CE',"Tetra Gmbh","Tetra GmbhGewerbepark "amwald" 4D-98693 IlmenauGermany",'1')"
01/05/2007 11:27:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO mac_track_oui_database (vendor_mac, vendor_name, vendor_address, present) VALUES ('00:90:3C',"Atlantic Network Systems","Atlantic Network SystemsImmeuble "kennedy"Ziter Avenue Jf Kennedy33700 MerignacFrance",'1')"
01/05/2007 11:27:18 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO mac_track_oui_database (vendor_mac, vendor_name, vendor_address, present) VALUES ('00:17:32',"Science-technical Center "rissa"","Science-technical Center "rissa"St. Abramtsevskaja, H.9Moscow 128572Russian Federation",'1')"
Here is the code I changed in macktrack_functions.php:
db_execute("REPLACE INTO mac_track_oui_database
(vendor_mac, vendor_name, vendor_address, present)
VALUES ('" . $vendor_mac . "',\"" .
ucwords(strtolower($vendor_name)) . "\",\"" .
ucwords(strtolower($vendor_address)) . "\",'1')");
notice the '\' escape characters and the " quotes instead of ' quotes. I am using MySQL 5.x as well, and it is requiring me to use double quotes when including ' in data input. Hope this helps.
Still not getting any vendor info in the 'vendor name' field. All entries are 'NULL' in the database. Thanks for any help. |
|
| Back to top |
|
 |
chadd Cacti User
Joined: 24 Mar 2005 Posts: 194 Location: Ocoee, Florida
|
Posted: Fri Jan 05, 2007 11:47 am Post subject: |
|
|
I would like full support for Foundry switches as well  |
|
| Back to top |
|
 |
chadd Cacti User
Joined: 24 Mar 2005 Posts: 194 Location: Ocoee, Florida
|
Posted: Fri Jan 05, 2007 2:36 pm Post subject: |
|
|
| TheWitness wrote: | If the "mac_track_oui_database" is empty, you may have to goto Tracking Utilities and import it. If you don't have "proxyless" access to the IEEE site, you will have to edit the "mactrack_import_ouidb.php" file and download the file in the comment section and instead of the "$oui_database = file("..."); you will have to replace that with the named file and then run the program.
Let me know if that get's it.
TheWitness |
It's still not working. I tried some different things, but no luck. It looks like a few (not many) of the devices (when polled via poller_mactrack.php) get entries in the vendor_mac column in the mac_track_temp_ports table during the run - but the data never makes it to the mac_track_ports table. All that gets written to that table is 'NULL' for vendor_mac. I think there could be a couple of issues with this. One could be getting the data during the poll, and the other could be transferring that data to the perm table. Just guesses of course. |
|
| Back to top |
|
 |
chadd Cacti User
Joined: 24 Mar 2005 Posts: 194 Location: Ocoee, Florida
|
Posted: Fri Jan 05, 2007 2:59 pm Post subject: |
|
|
Ok I fixed one of the problems, which is getting the results for the vendor_macs moved from the mac_track_temp_ports table to the mac_track_ports table. I just had to add that column to the transfer after 'mac_address'. Here is the code:
/* transfer temp port results into permanent table */
db_execute("INSERT INTO mac_track_ports
(site_id, device_id, hostname, dns_hostname, description,
vlan_id, vlan_name, mac_address, vendor_mac, ip_address,
port_number, port_name, scan_date)
SELECT site_id, device_id, hostname, dns_hostname, description,
vlan_id, vlan_name, mac_address, vendor_mac, ip_address,
port_number, port_name, scan_date
FROM mac_track_temp_ports");
I still am not getting vendor_mac resolution for 90% of my macs.. Larry? I know your busy. I will help when I can . |
|
| Back to top |
|
 |
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|