Netgear switches

[adrianmarsh]

Anyone know if mactrack is compatible with netgear switches (eg FS700TS ) ?

[adrianmarsh]

Well, I was able to figure out the sysDescription is FS700TS Switch and that the Vendor OID is : .1.3.6.1.4.1.4526

I've added the devices, its found the users ports and active Macs, but the IP count stays at 0...

I figure that the Scanning Function must need to be something other than get_generic_switch_ports.. but not a clue as to which one it should be..


I'm also getting errors when mactrack runs:

Code: Select all

10/30/2006 05:31:50 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='2'"  
10/30/2006 05:31:50 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='3'"  
10/30/2006 05:31:46 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='0'"  
10/30/2006 05:31:45 PM - SYSTEM MACTRACK STATS: Time:4.3041 ConcurrentProcesses:7 Devices:2  
10/30/2006 05:31:45 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "UPDATE `mac_track_ip_ranges` SET ips_max=ips_current, ips_max_date=ips_current_date WHERE ips_current > ips_max"  
10/30/2006 05:31:45 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed "SELECT * FROM mac_track_processes WHERE device_id = 0"  
10/30/2006 05:31:45 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='-1'"  
10/30/2006 05:31:45 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT count(*) FROM mac_track_processes WHERE device_id > 0"  
10/30/2006 05:31:43 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT COUNT(*) FROM mac_track_processes WHERE device_id <> '0'"  
10/30/2006 05:31:43 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('0', '8002', 'Running', NOW())"  
10/30/2006 05:31:41 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('3', '7997', 'Running', NOW())"  
10/30/2006 05:31:40 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('2', '7993', 'Running', NOW())"  
10/30/2006 05:31:40 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES  

[streaker69]

You're getting similar results that I'm getting with my 3Com switches.

[TheWitness]

Every switch must be married with a router, or be declared itself as a switch/router and then contain the standard ARP OID's. If the ARP located somewhere out of the ordinary, you will have to write a custom scanning function for the layer 2-3 information (ARP). This has had to be done for some Nortel gear, so I would not be surprised if you had to do this as well.

TheWitness

[adrianmarsh]

Could you give us a 2 paragraph "quick-start" guide as to what files to go looking at/what they do/OIDs of interest etc ?

According to the spec, my Netgear (FS752TS) supports :

RFC 1213 MIB II
RFC 1643 Ethernet Interface MIB
RFC 1493 Bridge MIB
Private Enterprise MIB

http://kbserver.netgear.com/datasheets/ ... 06_qxd.pdf

[TheWitness]

Have you added the router that is servicing this switch to the system? Is it associated with the same site? If you do that, it will be magic.

TheWitness

[adrianmarsh]

Hmmm... thats might be a problem... My networks here are:

NG <> Draytek 2900VG <> Cisco

NG <> Draytek 2910G <> Cisco


Both drayteks plug into the same Cisco, but thats owned by my ISP and I've no access to it at all.

I've added the two drayteks to Cacti... but I'm not hopeful..

[adrianmarsh]

I added the two drayteks to the Dev Track list, as Routers.. I added a template fro draytek as a "Not applicable Router" Type... but I get nothing more from the NGs and nothin from the Drayteks..

When I visit the NG www management page, I can see the port/mac association:

D VLAN ID MAC Interface
1 VLAN 1 0001e361a9da 1/g2
2 VLAN 1 00064f2db172 1/g2
3 VLAN 1 000c293c6e7a 1/e38

[adrianmarsh]

I'm adding an snmpwalk of the netgear here if that helps... Which OIDs would we be looking for??

[streaker69]

Yo Adrian! (sorry had to)

If you haven't solved this problem yet, I think I found the solution in another thread.

make sure you run database_upgrade.php from the mactrack directory.

Then do a Remove All Scan Results.

I was getting the same errors you were, even though it was polling my gear, but it wouldn't resolve the end hosts. After doing this it resolved the ends hosts properly and I stopped getting these errors.

[adrianmarsh]

I'll have to make sure I pick up some new ribs when I'm next in the supermarket...

Did you have to add any other devices (than the netgears) to the list?

I've tried what you said.. but beside a whole bunch of SQL errors below... nuthin happened..

Code: Select all

 11/16/2006 01:00:12 AM - THOLD: Poller[0] Checking Thresholds
11/16/2006 01:00:10 AM - SYSTEM STATS: Time:8.4044 Method:cactid Processes:1 Threads:2 Hosts:14 HostsPerProcess:14 DataSources:411 RRDsProcessed:264
11/16/2006 12:55:57 AM - SYSTEM MACTRACK STATS: Time:17.7270 ConcurrentProcesses:7 Devices:4
11/16/2006 12:55:57 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "UPDATE `mac_track_ip_ranges` SET ips_max=ips_current, ips_max_date=ips_current_date WHERE ips_current > ips_max"
11/16/2006 12:55:40 AM - THOLD: Poller[0] Checking Thresholds
11/16/2006 12:55:39 AM - SYSTEM STATS: Time:3.7951 Method:cactid Processes:1 Threads:2 Hosts:14 HostsPerProcess:14 DataSources:411 RRDsProcessed:264
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_temp_ports` ADD INDEX `ip_address`(`ip_address`);"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_ports` ADD INDEX `dns_hostname`(`dns_hostname`);"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_ports` ADD INDEX `port_name`(`port_name`);"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD INDEX `device_type_id`(`device_type_id`);"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `device_type_id` INT(10) UNSIGNED DEFAULT 0 AFTER `device_id`;"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD INDEX `snmp_sysDescr`(`snmp_sysDescr`), ADD INDEX `snmp_sysObjectID`(`snmp_sysObjectID`);"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE `mac_track_scan_dates` (`scan_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY(`scan_date`));"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_device_types` DROP PRIMARY KEY, ADD PRIMARY KEY(`sysDescr_match`, `sysObjectID_match`, `device_type`), ADD INDEX `device_type_id`(`device_type_id`);"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_sites` ADD COLUMN `total_oper_ports` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `total_user_ports`;"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` DROP PRIMARY KEY, ADD PRIMARY KEY(`hostname`, `snmp_port`, `site_id`), ADD INDEX `device_id`(`device_id`);"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE `mac_track_scanning_functions` (`scanning_function` VARCHAR(100) NOT NULL DEFAULT '', `description` VARCHAR(200) NOT NULL DEFAULT '', PRIMARY KEY(`scanning_function`));"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_sysContact` VARCHAR(100) DEFAULT '' AFTER `snmp_sysLocation`;"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_sysLocation` VARCHAR(100) DEFAULT '' AFTER `snmp_sysName`;"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_sysName` VARCHAR(100) DEFAULT '' AFTER `snmp_retries`;"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `macs_active` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `ports_trunk`;"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_port` INT(10) UNSIGNED NOT NULL DEFAULT '161' AFTER `snmp_version`;"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_ips` ADD COLUMN `dns_hostname` VARCHAR(200) DEFAULT '' AFTER `ip_address`;"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_temp_ports` ADD COLUMN `dns_hostname` VARCHAR(200) DEFAULT '' AFTER `ip_address`;"
11/16/2006 12:52:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_ports` ADD COLUMN `dns_hostname` VARCHAR(200) DEFAULT '' AFTER `ip_address`;"
11/16/2006 12:50:07 AM - THOLD: Poller[0] Checking Thresholds

[streaker69]

I've added my routers on each end of my WAN links to each site as well as each Managed Switch.

While I'm getting results, my new 3com switch I just installed yesterday isn't giving results on all the active ports. I haven't figured out why yet.

[adrianmarsh]

What config did you have for the routers and switches (which script?)?

[streaker69]

Device type is Switch/Hub and scanning function is get_generic_snmp_ports. But I did find my problem from the previous message, just forgot to post it. I had created my Device Type for a 26 port switch and set the maximum number of scan ports to 26. When I got my 50 port switch I forgot to set my maximum number of scan ports to 50, and that's why I wasn't getting all the ports.

It's working fine now.

[adrianmarsh]

streaker,

Sorry - did you say you had other devices attached (other than the netgears?) that may be what I'm missing, in that the Netgears are only L2 switches, so theres no "router" in my network (just 2 sepearated LANs at present).