End Device Tracking Add-On for Cacti

[TheWitness]

Sounds blazingly familiar to an e-mail I sent out to a reader just the other day. I will setup a page, I promise...

TheWitness

[jforman]

I've got an odd situation. I just installed an svn checkout (co'd on 6/28/06) of MacTrack into my 0.8.6h install of cacti.

Only problem is, for my Cat 2950 and Cat 3560 switches when they are polled, only the trunk ports show up, and i get "No user ports on this network" outputted for every Vlan and port. No real data is ever inputted into the mactrack entries.

Has anyone ever seen this before? I'm not quite sure how to proceed.

[twelzy]

jforman,

I've got the same situation here!
I'm trying to make my macktrack plugin work for about 3 months and nothing!!!

I don't known what else I can do...

Thanks in Advance!
(And sorry for my poor english...)

[TheWitness]

jforman,

Are your device types properly setup? Look at the mysql table for the status of the device. It may say something like unknown or not found. I don't belive I ever added that information to the user interface.

TheWitness

[jforman]

[quote="TheWitness"]jforman,

Are your device types properly setup? Look at the mysql table for the status of the device. It may say something like unknown or not found. I don't belive I ever added that information to the user interface.

TheWitness[/quote]

Hopefully this pastes correctly. It is a mysql grab of the relevant data from the mac_track_devices table:

mysql> select site_id,device_id,device_type_id,hostname from mac_track_devices;
+---------+-----------+----------------+--------------+
| site_id | device_id | device_type_id | hostname |
+---------+-----------+----------------+--------------+
| 0 | 1 | 0 | 192.168.1.31 |
+---------+-----------+----------------+--------------+
1 row in set (0.00 sec)

It is a Cisco 2950 catalyst switch.

When I try to run scanner from the command line, this is what I see:
nms04 mactrack # php ./mactrack_scanner.php -d
Notice: Undefined variable: device_id in /var/www/localhost/htdocs/cacti/plugins/mactrack/mactrack_scanner.php on line 104
Notice: Undefined variable: device_id in /var/www/localhost/htdocs/cacti/plugins/mactrack/mactrack_scanner.php on line 108
Notice: Undefined variable: device_id in /var/www/localhost/htdocs/cacti/plugins/mactrack/mactrack_scanner.php on line 110
DEBUG: ERROR: Device with Id of '' not found in database. Can not continue.
Notice: Undefined variable: device_id in /var/www/localhost/htdocs/cacti/plugins/mactrack/mactrack_scanner.php on line 111

This is odd because as far as I can tell, device_id is set to '1' for this device.

Ideas?

[jforman]

in addition to php error output, here is what the cacti mactrack panel looks like.

[jforman]

I've made some progress on the 2950 in the chart. I had to add another 2950 in there with the proper device type. It now says the switch is up, but still not seeing anything other than trunk ports.

Still seeing those errors when I run "php ./mactrack_scanner.php -d"

Ideas?

[torstentfk]

Hello,

at mactrack lib/mactrack_functions.php at line 1323 the strtotime function is called with wrong parameter (singular instead of plural):
$retention_date = date("Y-m-d H:i:s", strtotime("-2 Weeks"));

Torsten

[gg234]

Hi Guys,

Finally i think i found some bug here i am trying to enter the SNMP Readstring with 22 characters and it will take only 20 characters because of this i am getting SNMP error for all my cisco switches and Routers

Which file i need to edit to incease the string lenght and i really need to fix this

Thanks for your help

[TheWitness]

Interesting,

Goto the mac_track_device(s) table and edit it using MySQL Query Browser and edit the size of the snmp_read_string/snmp_community (can't remember what I called it) variable to be what you would like it to be. This should fix your problem.

TheWitness

[gg234]

thanks for that i have changed the value and now snmp is working

I am trying to run scanner from command line i am getting the following error



#php mactrack_scanner.php -d

Notice: Undefined variable: device_id in /var/www/cacti/plugins/mactrack/mactrack_scanner.php on line 104

Notice: Undefined variable: device_id in /var/www/cacti/plugins/mactrack/mactrack_scanner.php on line 108

Notice: Undefined variable: device_id in /var/www/cacti/plugins/mactrack/mactrack_scanner.php on line 110
DEBUG: ERROR: Device with Id of '' not found in database. Can not continue.

Notice: Undefined variable: device_id in /var/www/cacti/plugins/mactrack/mactrack_scanner.php on line 111

thanks for your help

[TheWitness]

Did you install Cacti from source or from a distribution? If you installed from either, please make sure you have applied all of the following patches at:

www.cacti.net/patches/0.8.6h/

TheWitness

[jforman]

[quote="TheWitness"]Did you install Cacti from source or from a distribution? If you installed from either, please make sure you have applied all of the following patches at:

www.cacti.net/patches/0.8.6h/

TheWitness[/quote]

Yes, I am using Gentoo and it has all those patches already applied during installation.

[ddonohue]

I'm in the same boat, i'm having the identical problem.

I can create the devices, but they never get query'd.

impreza:/cacti-0.8.6h/plugins/mactrack # php ./mactrack_scanner.php -d
PHP Notice: Undefined variable: device_id in /cacti-0.8.6h/plugins/mactrack/mactrack_scanner.php on line 104
PHP Notice: Undefined variable: device_id in /cacti-0.8.6h/plugins/mactrack/mactrack_scanner.php on line 108
PHP Notice: Undefined variable: device_id in /cacti-0.8.6h/plugins/mactrack/mactrack_scanner.php on line 110
DEBUG: ERROR: Device with Id of '' not found in database. Can not ontinue.
PHP Notice: Undefined variable: device_id in /cacti-0.8.6h/plugins/mactrack/mactrack_scanner.php on line 111


I'm current on patches as per your link, and i'm also running suse 10.1


HOSTINFO:

Cacti Version - 0.8.6h
Poller Type - CMD.php
Server Info - Linux 2.6.16.13-4-smp
Web Server - Apache/2.2.0 (Linux/SUSE)
PHP - 5.1.2
PHP Extensions - libxml, xml, standard, SimpleXML, SPL, session, Reflection, date, pcre, apache2handler, gd, mysql, mysqli
MySQL - 5.0.18
RRDTool - 1.2.12
SNMP - 5.3.0.1
Plugins

• Thresholds (thold - v0.3.0)
  Network Discovery (discovery - v0.5)
  Update Checker (update - v0.2)
  Syslog Monitoring (haloe - v0.4)
  Host Info (hostinfo - v0.1)
  report
  Network Tools (tools - v0.2)
  Read-only Devices Tab (devices - v0.4)
  Device Tracking (mactrack - v0.0.1b)

Did some tooling, and was running the mactrack_scanner.php and saw this error when scanning a switch/router. This was how i ran it by hand

php ./mactracker_scanner.php -d -id=<devid> from DB. in my case it was


I think the below error is caused b/c i have a Sup 720 in it.

Which reads back like this.

Cisco Internetwork Operating System Software IOS (tm) s72033_rp Software (s72033_rp-PK9SV-M)

php./mactracker_scanner.php -d -id=2

impreza:/cacti-0.8.6h/plugins/mactrack # php mactrack_scanner.php -d -id=1
DEBUG: HOST: xxx.xxx.xxx.xxx is alive, processing has begun.
DEBUG: WARNING: SITE: SAFERENT, IP: xxx.xxx.xxx.xxx, TYPE: Cisco Internetwork Operating System Soft, Device Type Not Found in Device Type Table.
DEBUG: atifIndexes data collection complete
DEBUG: atPhysAddress data collection complete
DEBUG: atNetAddress data collection complete
DEBUG: atEntries assembly complete.

This is the output of my device_type table.

mysql> select * from mac_track_device_types ;
+----------------+----------------------------+-----------+-------------+----------------------+-------------------+------------------------------------+---------+----------+
| device_type_id | description | vendor | device_type | sysDescr_match | sysObjectID_match | scanning_function | lowPort | highPort |
+----------------+----------------------------+-----------+-------------+----------------------+-------------------+------------------------------------+---------+----------+
| 2 | 2E253 | Cabletron | 1 | 2E253-49R | .1.3.6.1.4.1.52 | get_cabletron_switch_ports | 0 | 0 |
| 3 | 2E42 | Cabletron | 1 | 2E42-27R | .1.3.6.1.4.1.52 | get_cabletron_switch_ports | 0 | 0 |
| 4 | 2H252 | Cabletron | 1 | 2H252-25R | .1.3.6.1.4.1.52 | get_cabletron_switch_ports | 0 | 0 |
| 5 | 6E132 | Cabletron | 1 | 6E132-25 | .1.3.6.1.4.1.52 | get_cabletron_switch_ports | 0 | 0 |
| 6 | 6E138 | Cabletron | 1 | 6E138-25 | .1.3.6.1.4.1.52 | get_cabletron_switch_ports | 0 | 0 |
| 7 | 6E233 | Cabletron | 1 | 6E233-49 | .1.3.6.1.4.1.52 | get_cabletron_switch_ports | 0 | 0 |
| 8 | 6H122 | Cabletron | 1 | 6H122-08 | .1.3.6.1.4.1.52 | get_cabletron_switch_ports | 0 | 0 |
| 9 | 6H202 | Cabletron | 1 | 6H202-24 | .1.3.6.1.4.1.52 | get_cabletron_switch_ports | 0 | 0 |
| 10 | 6H252-17 | Cabletron | 1 | 6H252-17 | .1.3.6.1.4.1.52 | get_cabletron_switch_ports | 0 | 0 |
| 11 | SEHI-24 | Cabletron | 1 | SEHI | .1.3.6.1.4.1.52 | get_repeater_rev4_ports | 0 | 0 |
| 12 | XP-6000 Router | Cabletron | 3 | XP-8600 | .1.3.6.1.4.1.52 | | 0 | 0 |
| 13 | 6H352 | Enterasys | 1 | 6H352-25 | .1.3.6.1.4.1.5624 | get_cabletron_switch_ports | 0 | 0 |
| 14 | VH-2402 | Enterasys | 1 | VH-2402S | .1.3.6.1.4.1.5624 | get_cabletron_switch_ports | 0 | 0 |
| 15 | Catalyst 2900XL | Cisco | 1 | C2900XL-C3H2S-M | .1.3.6.1.4.1.9 | get_IOS_dot1dTpFdbEntry_ports | 0 | 0 |
| 16 | Catalyst 2950 | Cisco | 1 | C2950-I6K2L2Q4-M | .1.3.6.1.4.1.9 | get_IOS_dot1dTpFdbEntry_ports | 0 | 0 |
| 17 | Catalyst 2950 | Cisco | 1 | C2950-I6Q4L2-M2 | .1.3.6.1.4.1.9 | get_IOS_dot1dTpFdbEntry_ports | 0 | 0 |
| 18 | Catalyst 3550 Switch | Cisco | 1 | C3550-I5K2L2Q3-M | .1.3.6.1.4.1.9 | get_IOS_dot1dTpFdbEntry_ports | 0 | 0 |
| 19 | Catalyst 3550 Switch | Cisco | 1 | C3550-I5Q3L2-M2 | .1.3.6.1.4.1.9 | get_IOS_dot1dTpFdbEntry_ports | 0 | 0 |
| 20 | Catalyst 3750 L3 Switch | Cisco | 2 | C3750-I5K91-M2 | .1.3.6.1.4.1.9 | get_IOS_dot1dTpFdbEntry_ports | 0 | 0 |
| 21 | Catalyst 3750 L3 Switch | Cisco | 2 | C3750-I5-M2 | .1.3.6.1.4.1.9 | get_IOS_dot1dTpFdbEntry_ports | 0 | 0 |
| 22 | 4500 Router | Cisco | 3 | C4500-JS-M2 | .1.3.6.1.4.1.9 | | 0 | 0 |
| 23 | Catalyst 5000 RSM | Cisco | 3 | C5RSM-JSV-M2 | .1.3.6.1.4.1.9 | | 0 | 0 |
| 24 | Catalyst 6000 MSFC Router | Cisco | 3 | C6MSFC2-JK2SV-M2 | .1.3.6.1.4.1.9 | | 0 | 0 |
| 25 | Catalyst 6000 MSFC Router | Cisco | 3 | C6MSFC2-JSV-M2 | .1.3.6.1.4.1.9 | | 0 | 0 |
| 26 | Catalyst 6000 MSM Router | Cisco | 3 | C6MSM-IN-M2 | .1.3.6.1.4.1.9 | | 0 | 0 |
| 27 | Catalyst 6000 Router SupII | Cisco | 2 | c6sup2_rp-JK2SV-M | .1.3.6.1.4.1.9 | get_IOS_dot1dTpFdbEntry_ports | 0 | 0 |
| 28 | Catalyst 6000 Router SupII | Cisco | 2 | c6sup2_rp-JS-M | .1.3.6.1.4.1.9 | get_IOS_dot1dTpFdbEntry_ports | 0 | 0 |
| 29 | 7301 Router | Cisco | 3 | C7301-JS-M2 | .1.3.6.1.4.1.9 | | 0 | 0 |
| 30 | Catalyst 8510 L2/L3 Switch | Cisco | 3 | C8510-IN-M | .1.3.6.1.4.1.9 | | 0 | 0 |
| 31 | Catalyst 8540 L2/L3 Switch | Cisco | 3 | C8540CSR-IN-M | .1.3.6.1.4.1.9 | | 0 | 0 |
| 32 | Catalyst 1900 | Cisco | 1 | Catalyst 1900 | .1.3.6.1.4.1.9 | get_generic_switch_ports | 0 | 0 |
| 33 | Catalyst 2820 | Cisco | 1 | Catalyst 2820 | .1.3.6.1.4.1.9 | get_generic_switch_ports | 0 | 0 |
| 34 | Route Switch Processor | Cisco | 3 | RSP-JSV-M2 | .1.3.6.1.4.1.9 | | 0 | 0 |
| 35 | Catalyst 3750 | Cisco | 2 | WS-C3750-IPSERVICESK | .1.3.6.1.4.1.9 | get_IOS_dot1dTpFdbEntry_ports | 0 | 0 |
| 36 | Catalyst 4003 | Cisco | 1 | WS-C4003 | .1.3.6.1.4.1.9 | get_catalyst_dot1dTpFdbEntry_ports | 0 | 0 |
| 37 | Catalyst 4006 | Cisco | 1 | WS-C4006 | .1.3.6.1.4.1.9 | get_catalyst_dot1dTpFdbEntry_ports | 0 | 0 |
| 38 | Catalyst 5500 | Cisco | 1 | WS-C5500 | .1.3.6.1.4.1.9 | get_catalyst_dot1dTpFdbEntry_ports | 0 | 0 |
| 39 | Catalyst 5505 | Cisco | 1 | WS-C5505 | .1.3.6.1.4.1.9 | get_catalyst_dot1dTpFdbEntry_ports | 0 | 0 |
| 40 | Catalyst 5509 | Cisco | 1 | WS-C5509 | .1.3.6.1.4.1.9 | get_catalyst_dot1dTpFdbEntry_ports | 0 | 0 |
| 41 | Catalyst 6506 | Cisco | 1 | WS-C6506 | .1.3.6.1.4.1.9 | get_catalyst_dot1dTpFdbEntry_ports | 0 | 0 |
| 42 | Catalyst 6509 | Cisco | 1 | WS-C6509 | .1.3.6.1.4.1.9 | get_catalyst_dot1dTpFdbEntry_ports | 0 | 0 |
| 43 | Catalyst 6513 | Cisco | 1 | WS-C6513 | .1.3.6.1.4.1.9 | get_catalyst_dot1dTpFdbEntry_ports | 0 | 0 |
+----------------+----------------------------+-----------+-------------+----------------------+-------------------+------------------------------------+---------+----------+
42 rows in set (0.00 sec)

[ddonohue]

Actually, I fixed it .....

With this inserted into the table in prior reference.

insert into mac_track_device_types (`device_type_id`,`description`,`vendor`,`device_type`,`sysDescr_match`,`sysObjectID_Match`,`scanning_function`,`lowPort`,`highPort`) values(44,'Catalyst 6000 router Sup720','Cisco','2','72033_rp-PK9SV-M','.1.3.6.1.4.1.9','get_IOS_dot1dTpFdbEntry_ports',0,0);


And now it's pulling back correctly.

Donohue