End Device Tracking Add-On for Cacti

Support questions about the MAC Track plugin

Moderators: Developers, Moderators

Post Reply
chadd
Cacti User
Posts: 382
Joined: Thu Mar 24, 2005 3:53 pm
Location: Ocoee, Florida

Post by chadd »

chadd wrote:Yes I did. Here is the latest:

I nuked all the tables for mactracker.
I reimported the .sql file.
now, I have no devices configured in mactracker, but I am still getting this error. i.e. I have it set to poll every 1hour:

03/08/2006 12:14:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('-1', '0', 'Running', NOW())"

I made sure that the table is there, and it is, but it is an empty set.

Any suggestions?

Also, why is it using CMDPHP instead of Cactid?

Also Cigamit, are you going to have this plugin on cactiusers.org for download, or is this being done in a different way?

Thanks,

-chadd.
Ok, did some things, and this is the error I get now when the mactracker poller runs:

03/08/2006 01:52:18 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"

Also, the status on all my devices in the mactracker view show 'error'.
User avatar
psyber
Cacti User
Posts: 84
Joined: Tue Aug 02, 2005 7:18 pm

Post by psyber »

I think the fix to that is back a couple posts (pg 33 )
You'll have to modify some code. I went ahead and sent a patch in for the plugin a week or two ago, but I haven't heard anything back. hopefully that will get resolved.
cigamit
Developer
Posts: 3369
Joined: Thu Apr 07, 2005 3:29 pm
Location: B/CS Texas
Contact:

Post by cigamit »

psyber wrote:I think the fix to that is back a couple posts (pg 33 )
You'll have to modify some code. I went ahead and sent a patch in for the plugin a week or two ago, but I haven't heard anything back. hopefully that will get resolved.
Sorry, I have been a bit pre-occupied with trying to work on the new Event Manager stuff, and migrating my others hosts to the new server (its major pain). I should have time this weekend to get everything done.
chadd
Cacti User
Posts: 382
Joined: Thu Mar 24, 2005 3:53 pm
Location: Ocoee, Florida

Post by chadd »

psyber wrote:I think the fix to that is back a couple posts (pg 33 )
You'll have to modify some code. I went ahead and sent a patch in for the plugin a week or two ago, but I haven't heard anything back. hopefully that will get resolved.
Great!! Thanks a ton!

Thanks Cigamit. I think this plugin could really help around here, and I really want to get it working.
chadd
Cacti User
Posts: 382
Joined: Thu Mar 24, 2005 3:53 pm
Location: Ocoee, Florida

Post by chadd »

Ok, I implemented the code into poller_macktrack.php as suggested, and all errors went away. Problem is, when you look at the 'Device Tracking - Device Report View' all the devices show 'Status' error. And, the only are with any information in it is the device view and the site view. The columns populated are the 'IP's' column and the 'Last Duration' column. I have 10 devices in the mactracker and they are all cisco: 1 2821 router, 8 3550s, and 1 3750. Any suggestions?
chadd
Cacti User
Posts: 382
Joined: Thu Mar 24, 2005 3:53 pm
Location: Ocoee, Florida

Post by chadd »

Another update. I changed to snmpv1 polling, and my router changed 'status' to up from 'error', but all the other switches did not.
User avatar
psyber
Cacti User
Posts: 84
Joined: Tue Aug 02, 2005 7:18 pm

Post by psyber »

I have some 2950s that were showing error status and I noticed that the parsed model did not match any of the equipment templates (probably the IOS release, its a couple years old) so I had to create a new template (basically a copy of the others) that resolved that issue though its still showing all the trunk ports but I can live withthat for now. On another switch I had t o change the function to generic switch device or something like that (i'm going from memory)

hope that was helpful.
chadd
Cacti User
Posts: 382
Joined: Thu Mar 24, 2005 3:53 pm
Location: Ocoee, Florida

Post by chadd »

psyber wrote:I have some 2950s that were showing error status and I noticed that the parsed model did not match any of the equipment templates (probably the IOS release, its a couple years old) so I had to create a new template (basically a copy of the others) that resolved that issue though its still showing all the trunk ports but I can live withthat for now. On another switch I had t o change the function to generic switch device or something like that (i'm going from memory)

hope that was helpful.
Well, I tried to change one of my L3switches to 'Device Type = router' and it went to an up status at next poll cycle. It looks like a problem with the functions for the other switches.

"Scanning Function
The MacTrack scanning function to call in order to obtain and store port details. The function name is all that is required. The following four parameters are assumed and will always be appended: 'my_function($site, &$device, $lowport, $highport)'. There is no function required for a pure router."

That is out of the interface from "Mac Track Device Types [edit: Catalyst 3550 Switch]". The last line kind of explains why it changed to up when I called it a router.

The problem is that I don't know what to change, and what to change it to to get a 'function' that will properly scan my switches.. Any thoughts?
chadd
Cacti User
Posts: 382
Joined: Thu Mar 24, 2005 3:53 pm
Location: Ocoee, Florida

Post by chadd »

Got it working.. Just needed to create new 'Device Types' - an exact copy of the ones there, just with the correct 'version' information in the 'System Description Match' field, i.e. C3750-IPSERVICESK9-M.

Hope this helps other people.. Not a problem with the program, just user not knowing how the plugin works ;-)..
knobdy
Cacti User
Posts: 495
Joined: Wed Sep 28, 2005 1:39 pm

Post by knobdy »

I'm wondering whats going on with my wireless devices. I've verified that the OIDs used in the generic wireless function work on these Cisco APs, and they do. When I run an snmpwalk using them, I get addresses back, but mactrack isn't putting anything in the database. Anyone else have Cisco APs and want to share notes??

Let me clarify. In the mactrack devices page I see:

Code: Select all

Host	Site Name	Status	Hostname			          Device Type	Total		User		User		Trunk	Active	Last
Desc											                                 IPs		Ports		Ports Up	Ports	MACs		Duration
1a1     Building    Up  		1a1.ecom.mycompany.com  Switch/Hub  N/A  		4  		3  		0  	0  		0.3  	
2a1 	 Building 	Up 		2a1.ecom.mycompany.com 	Switch/Hub 	N/A 		4 		3 		0 	0 		0.4 	
2a2 	 Building 	Up 		2a2.ecom.mycompany.com 	Switch/Hub 	N/A 		4 		3 		0 	0 		0.5 	
2a3 	 Building 	Up 		2a3.ecom.mycompany.com 	Switch/Hub 	N/A 		4 		3 		0 	0 		0.3 	
2a4 	 Building 	Up 		2a4.ecom.mycompany.com 	Switch/Hub 	N/A 		4 		3 		0 	0 		0.3
It should be seeing at least 1 association/MAC on each of these (I'm graphing those connections successfully even).
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Well, before I left my last job, where I was making updates regularily to MacTrack, I was attempting to break the 802.1x storage with Cisco AP's. Unfortunately, I made my announcement to leave the company right in the middle of completing that development and therefore spent the last two weeks on training my replacement rather than finishing the work.

At this point, if you would like to have me finish this for you and the Cacti community, it will take a donation to my Paypal yearly Golf outing in Myrtle Beach to get me to make changes in that section of the code. You can PM me if you are interested.

I guess what I am trying to say is that I would like to finish that up, but in order to help me prioritize, I need further incentive.

Larry
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
knobdy
Cacti User
Posts: 495
Joined: Wed Sep 28, 2005 1:39 pm

Post by knobdy »

TheWitness wrote:Well, before I left my last job, where I was making updates regularily to MacTrack, I was attempting to break the 802.1x storage with Cisco AP's.
What do you mean by "break" and "802.1x storage"?
TheWitness wrote:I guess what I am trying to say is that I would like to finish that up, but in order to help me prioritize, I need further incentive.
Man-o-man do I wish I could help you out with that trip - and take it with you. Unfortunately my employer doesn't pay me enough and I only want it for them anyway... :)

I can supply you with whatever I can scrape from these devices though. Looking through the function for generic wireless devices I noticed that one of the OIDs being looked at does not exist (.1.3.6.1.2.1.17.2.7.0) on the cisco AP, so perhaps the following information would be helpful to you - or anyone else picking up the torch:
  • .1.3.6.1.2.1.17.1.1.0 = Hex-STRING: 00 11 5C 93 ED 30
    .1.3.6.1.2.1.17.1.2.0 = INTEGER: 3
    .1.3.6.1.2.1.17.1.3.0 = INTEGER: srt(4)
    .1.3.6.1.2.1.17.1.4.1.1.4 = INTEGER: 4
    .1.3.6.1.2.1.17.1.4.1.1.5 = INTEGER: 5
    .1.3.6.1.2.1.17.1.4.1.1.6 = INTEGER: 6
    .1.3.6.1.2.1.17.1.4.1.1.7 = INTEGER: 7
    .1.3.6.1.2.1.17.1.4.1.1.10 = INTEGER: 10
    .1.3.6.1.2.1.17.1.4.1.1.11 = INTEGER: 11
    .1.3.6.1.2.1.17.1.4.1.2.4 = INTEGER: 4
    .1.3.6.1.2.1.17.1.4.1.2.5 = INTEGER: 5
    .1.3.6.1.2.1.17.1.4.1.2.6 = INTEGER: 6
    .1.3.6.1.2.1.17.1.4.1.2.7 = INTEGER: 7
    .1.3.6.1.2.1.17.1.4.1.2.10 = INTEGER: 10
    .1.3.6.1.2.1.17.1.4.1.2.11 = INTEGER: 11
    .1.3.6.1.2.1.17.1.4.1.3.4 = OID: .0.0
    .1.3.6.1.2.1.17.1.4.1.3.5 = OID: .0.0
    .1.3.6.1.2.1.17.1.4.1.3.6 = OID: .0.0
    .1.3.6.1.2.1.17.1.4.1.3.7 = OID: .0.0
    .1.3.6.1.2.1.17.1.4.1.3.10 = OID: .0.0
    .1.3.6.1.2.1.17.1.4.1.3.11 = OID: .0.0
    .1.3.6.1.2.1.17.1.4.1.4.4 = Counter32: 0
    .1.3.6.1.2.1.17.1.4.1.4.5 = Counter32: 0
    .1.3.6.1.2.1.17.1.4.1.4.6 = Counter32: 0
    .1.3.6.1.2.1.17.1.4.1.4.7 = Counter32: 0
    .1.3.6.1.2.1.17.1.4.1.4.10 = Counter32: 0
    .1.3.6.1.2.1.17.1.4.1.4.11 = Counter32: 0
    .1.3.6.1.2.1.17.1.4.1.5.4 = Counter32: 0
    .1.3.6.1.2.1.17.1.4.1.5.5 = Counter32: 0
    .1.3.6.1.2.1.17.1.4.1.5.6 = Counter32: 0
    .1.3.6.1.2.1.17.1.4.1.5.7 = Counter32: 0
    .1.3.6.1.2.1.17.1.4.1.5.10 = Counter32: 0
    .1.3.6.1.2.1.17.1.4.1.5.11 = Counter32: 0
    .1.3.6.1.2.1.17.4.1.0 = Counter32: 0
    .1.3.6.1.2.1.17.4.2.0 = INTEGER: 300
    .1.3.6.1.2.1.17.4.3.1.1.0.7.133.146.100.67 = Hex-STRING: 00 07 85 92 64 43
    .1.3.6.1.2.1.17.4.3.1.1.0.7.133.146.102.147 = Hex-STRING: 00 07 85 92 66 93
    .1.3.6.1.2.1.17.4.3.1.1.0.10.183.254.64.212 = Hex-STRING: 00 0A B7 FE 40 D4
    .1.3.6.1.2.1.17.4.3.1.1.0.13.188.58.229.95 = Hex-STRING: 00 0D BC 3A E5 5F
    .1.3.6.1.2.1.17.4.3.1.1.0.14.53.165.63.39 = Hex-STRING: 00 0E 35 A5 3F 27
    .1.3.6.1.2.1.17.4.3.1.1.0.14.53.165.65.156 = Hex-STRING: 00 0E 35 A5 41 9C
    .1.3.6.1.2.1.17.4.3.1.2.0.7.133.146.100.67 = INTEGER: 4
    .1.3.6.1.2.1.17.4.3.1.2.0.7.133.146.102.147 = INTEGER: 6
    .1.3.6.1.2.1.17.4.3.1.2.0.10.183.254.64.212 = INTEGER: 4
    .1.3.6.1.2.1.17.4.3.1.2.0.13.188.58.229.95 = INTEGER: 4
    .1.3.6.1.2.1.17.4.3.1.2.0.14.53.165.63.39 = INTEGER: 4
    .1.3.6.1.2.1.17.4.3.1.2.0.14.53.165.65.156 = INTEGER: 4
    .1.3.6.1.2.1.17.4.3.1.3.0.7.133.146.100.67 = INTEGER: mgmt(5)
    .1.3.6.1.2.1.17.4.3.1.3.0.7.133.146.102.147 = INTEGER: mgmt(5)
    .1.3.6.1.2.1.17.4.3.1.3.0.10.183.254.64.212 = INTEGER: mgmt(5)
    .1.3.6.1.2.1.17.4.3.1.3.0.13.188.58.229.95 = INTEGER: mgmt(5)
    .1.3.6.1.2.1.17.4.3.1.3.0.14.53.165.63.39 = INTEGER: mgmt(5)
    .1.3.6.1.2.1.17.4.3.1.3.0.14.53.165.65.156 = INTEGER: mgmt(5)
    .1.3.6.1.2.1.17.7.1.1.1.0 = INTEGER: 1
    .1.3.6.1.2.1.17.7.1.1.2.0 = INTEGER: 4095
    .1.3.6.1.2.1.17.7.1.1.3.0 = Gauge32: 16
    .1.3.6.1.2.1.17.7.1.1.4.0 = Gauge32: 3
    .1.3.6.1.2.1.17.7.1.1.5.0 = INTEGER: 2
    .1.3.6.1.2.1.17.7.1.2.1.1.2.1 = Counter32: 0
    .1.3.6.1.2.1.17.7.1.2.1.1.2.41 = Counter32: 0
    .1.3.6.1.2.1.17.7.1.2.2.1.2.1.0.7.133.146.100.67 = INTEGER: 4
    .1.3.6.1.2.1.17.7.1.2.2.1.2.1.0.7.133.146.102.147 = INTEGER: 6
    .1.3.6.1.2.1.17.7.1.2.2.1.2.1.0.10.183.254.64.212 = INTEGER: 4
    .1.3.6.1.2.1.17.7.1.2.2.1.2.1.0.13.188.58.229.95 = INTEGER: 4
    .1.3.6.1.2.1.17.7.1.2.2.1.2.1.0.14.53.165.63.39 = INTEGER: 4
    .1.3.6.1.2.1.17.7.1.2.2.1.2.1.0.14.53.165.65.156 = INTEGER: 4
    .1.3.6.1.2.1.17.7.1.2.2.1.3.1.0.7.133.146.100.67 = INTEGER: 5
    .1.3.6.1.2.1.17.7.1.2.2.1.3.1.0.7.133.146.102.147 = INTEGER: 5
    .1.3.6.1.2.1.17.7.1.2.2.1.3.1.0.10.183.254.64.212 = INTEGER: 5
    .1.3.6.1.2.1.17.7.1.2.2.1.3.1.0.13.188.58.229.95 = INTEGER: 5
    .1.3.6.1.2.1.17.7.1.2.2.1.3.1.0.14.53.165.63.39 = INTEGER: 5
    .1.3.6.1.2.1.17.7.1.2.2.1.3.1.0.14.53.165.65.156 = INTEGER: 5
    .1.3.6.1.2.1.17.7.1.4.2.1.3.0.1 = Gauge32: 0
    .1.3.6.1.2.1.17.7.1.4.2.1.3.0.40 = Gauge32: 1
    .1.3.6.1.2.1.17.7.1.4.2.1.3.0.41 = Gauge32: 41
    .1.3.6.1.2.1.17.7.1.4.2.1.4.0.1 = Hex-STRING: 00 00
    .1.3.6.1.2.1.17.7.1.4.2.1.4.0.40 = Hex-STRING: 14 40
    .1.3.6.1.2.1.17.7.1.4.2.1.4.0.41 = STRING: " "
    .1.3.6.1.2.1.17.7.1.4.2.1.5.0.1 = Hex-STRING: 00 00
    .1.3.6.1.2.1.17.7.1.4.2.1.5.0.40 = Hex-STRING: 14 40
    .1.3.6.1.2.1.17.7.1.4.2.1.5.0.41 = Hex-STRING: 00 00
    .1.3.6.1.2.1.17.7.1.4.2.1.6.0.1 = INTEGER: 2
    .1.3.6.1.2.1.17.7.1.4.2.1.6.0.40 = INTEGER: 2
    .1.3.6.1.2.1.17.7.1.4.2.1.6.0.41 = INTEGER: 2
    .1.3.6.1.2.1.17.7.1.4.2.1.7.0.1 = Timeticks: (0) 0:0
    .1.3.6.1.2.1.17.7.1.4.2.1.7.0.40 = Timeticks: (0) 0:0
    .1.3.6.1.2.1.17.7.1.4.2.1.7.0.41 = Timeticks: (0) 0:0
    .1.3.6.1.2.1.17.7.1.4.5.1.1.4 = Gauge32: 0
    .1.3.6.1.2.1.17.7.1.4.5.1.1.5 = Gauge32: 0
    .1.3.6.1.2.1.17.7.1.4.5.1.1.6 = Gauge32: 0
    .1.3.6.1.2.1.17.7.1.4.5.1.1.7 = Gauge32: 0
    .1.3.6.1.2.1.17.7.1.4.5.1.1.10 = Gauge32: 0
    .1.3.6.1.2.1.17.7.1.4.5.1.1.11 = Gauge32: 0
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

That is essentially a non-802.1x encrypted router. You are likely either clear channel or WEP is that correct?

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
knobdy
Cacti User
Posts: 495
Joined: Wed Sep 28, 2005 1:39 pm

Post by knobdy »

That is a C1200, and we use LEAP authentication.... (I know...we'll be changing that soon as well).
chadd
Cacti User
Posts: 382
Joined: Thu Mar 24, 2005 3:53 pm
Location: Ocoee, Florida

Post by chadd »

I have a problem where, in the gui "Site IP Range Report" produces nothing for none of my sites - but if I go to the database and select * from mac_track_ip_ranges, I get lots of stuff.. Anyone know what I could be doing wrong not to have it show up in the gui?
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests