End Device Tracking Add-On for Cacti

Dwayne_Dibbley · Post by **Dwayne_Dibbley** » Wed Jan 04, 2006 9:16 am

I have a site with 6 Cat 5500 and 2 3600 routers that i have added, The MACTRACK tab shows results from these devices, bu looking in the cacti.log its reporting CMDPHP Poller ERROR SQL Exec Failed "INSERT INTO mac_track_ips (site_id,devide_id,hostname,description,port_number,mac_address,ip_address,scan_data) VALUES ('2','3','172.16.4.98','PL3540BT','9','NOT USER','10.9.1.1','2006-01-04 13:00:06')"

the device 172.16.4.98 is the router should this not be the catalist?

I am using the 1b plugin with the final release version h of cacti with plugin arch for h

Thanks

Post by **TheWitness** » Wed Jan 04, 2006 10:30 am

Dwayne,

In the two functions in lib/mactrack/mactrack_functions.php

get_arp_ip_ranges and
db_store_device_port_results

Change "INSERT INTO" to "REPLACE INTO".

I discovered this myself this morning.

Larry

Post by **TheWitness** » Wed Jan 04, 2006 10:30 am

I have also found a few more issues that will affect Cisco switches. They are corner cases and will be patched today.

Larry

knobdy · Post by **knobdy** » Wed Jan 04, 2006 10:43 am

TheWitness wrote:I have also found a few more issues that will affect Cisco switches. They are corner cases and will be patched today.

Any of them cover the 4006?

I'm still having the issue where mactrack is only picking up addresses from 1 blade of a 4006 switch. I have compared the configurations of that switch and its twin on another floor and there are no significant difference. I've compared the configurations for the 5 switch blades and found no differences. Is there anything I should be looking for, specifically, that might be causing mactrack to fail?

Also, is there a way to clear out all of the data thus far collected to start "fresh" (not devices, just mac addresses)? Just do it through mysql?

Post by **TheWitness** » Wed Jan 04, 2006 12:13 pm

You are using snmpv1 for the 4006 right? It has issues with snmpv2. For now, simply "truncate table mac_track_ports". I have to add that feature.

knobdy · Post by **knobdy** » Wed Jan 04, 2006 12:27 pm

TheWitness wrote:You are using snmpv1 for the 4006 right? It has issues with snmpv2.

I hadn't, but do now.

I was going to try that before making this post but since I have two, and the one was working, I didn't think that should be an issue. However the two switches are at different code levels and perhaps that's the difference.

What cisco code versions have you seen problems with SNMPv2? Which have been okay, if any? (anyone else have a 4006 with which they might provide feedback)

{UPDATE}
version 1 didn't help, still get the one blade - ?? Very strange - open to any suggestions!

Post by **TheWitness** » Wed Jan 04, 2006 7:50 pm

knobby, can I remotely access the device? Can you push me a dump of the entire MIB? I would need it two ways, with and without numeric OID's.

TheWitness

knobdy · Post by **knobdy** » Wed Jan 04, 2006 8:53 pm

Uhmm..it would be difficult to impossible to give you access - but I can try and provide you - privately - what you need to help. This tool will be VERY helpful to us and if we can help in its development we'll be willing to do what ever we can within company policies to do so.

What do I need to do, specifically, and where do I send it?

Guessing an snmpwalk to text file with a couple of different options?

knobdy · Post by **knobdy** » Wed Jan 04, 2006 9:35 pm

I've got a severe problem now. I went ahead and upgraded to h and the updated plugin architecture - which destroyed this (mac_track) plugin. Fonts and graphics are all wrong. Is there an easy fix?

Post by **TheWitness** » Wed Jan 04, 2006 10:26 pm

Here are the files. There are some more updates to be made. This will get you back in business though.

http://svn.cacti.net/cgi-bin/viewcvs.cg ... t=MacTrack

Once you have copied all the files, you need to change directories to:

"<cacti_webroot>/lib/mactrack"

Then run:

"php database_upgrade.php"

You will then be back in business. Oh, when you do, your device types table will have to be populated in order for scanning to work.

TheWitness

Dwayne_Dibbley · Post by **Dwayne_Dibbley** » Thu Jan 05, 2006 7:04 am

TheWitness wrote:Here are the files. There are some more updates to be made. This will get you back in business though.

http://svn.cacti.net/cgi-bin/viewcvs.cg ... t=MacTrack

Once you have copied all the files, you need to change directories to:

"<cacti_webroot>/lib/mactrack"

Then run:

"php database_upgrade.php"

You will then be back in business. Oh, when you do, your device types table will have to be populated in order for scanning to work.

TheWitness

I still get theses errors with your latest:

CMDPHP Poller ERROR SQL Exec Failed "INSERT INTO mac_track_ips (site_id,devide_id,hostname,description,port_number,mac_address,ip_address,scan_data) VALUES ('2','3','172.16.4.98','PL3540BT','9','NOT USER','10.9.1.1','2006-01-04 13:00:06')"

Do i need to still change INSERT with REPLACE as per above ?

Post by **TheWitness** » Thu Jan 05, 2006 7:07 am

Yes, if you look at that SVN page, there is a "plugin" and a "native" version of the code. Cigamit is a day behind right now. However, I'm not too sure about the "magic" he performs to migrate to the "plugin" architecture. So, I would simply change the "INSERT INTO" to "REPLACE INTO" as noted above and you should be Ok.

I do have a few features that I forgot about that I need to make to the code. However, I am tracking database changes in the "database_upgrade.php" file, so you should be ok.

Let me know how you like the new UI...

TheWitness

knobdy · Post by **knobdy** » Thu Jan 05, 2006 9:43 am

How do I get all of the code - easily? I can't do a check out so...?

cigamit · Post by **cigamit** » Thu Jan 05, 2006 10:19 am

TheWitness wrote:Yes, if you look at that SVN page, there is a "plugin" and a "native" version of the code. Cigamit is a day behind right now. However, I'm not too sure about the "magic" he performs to migrate to the "plugin" architecture. So, I would simply change the "INSERT INTO" to "REPLACE INTO" as noted above and you should be Ok.

I do have a few features that I forgot about that I need to make to the code. However, I am tracking database changes in the "database_upgrade.php" file, so you should be ok.

Let me know how you like the new UI...

TheWitness

It was the wife's BD yesterday, so had to take her out for a night on the town, so no computer for me. I should be able to get it caught up tonight.

Dwayne_Dibbley · Post by **Dwayne_Dibbley** » Thu Jan 05, 2006 10:23 am

I have replaced the INSERT with REPLACE in the plugin version no more errors.

On the MACTRACK tab i now see End Device IP etc no problems.

When on Sites under the Device Tracking Menu, Site Name is displayed with Number of devices and Total IP's but User Ports User Ports Up MACS Found are all 0?

Same goes for the Devices under the Device tracking Menu.

Nothing else to report as yet

Thanks

End Device Tracking Add-On for Cacti

Who is online