End Device Tracking Add-On for Cacti

twelzy · Post by **twelzy** » Wed Mar 29, 2006 2:53 pm

I am having the same problem of 'knobdy', but with all my Catalyst switches:

Host                      Device                           Total   User    User       Trunk   Active   Last
Description   Site Name   Status   Hostname   Type         IP's    Ports   Ports Up   Ports   Macs     Duration
----------------------------------------------------------------------------------------------------------------
(6509Sp)      XXXXXXXXX   Up       YYYYYYYY   Switch/Hub   N/A     196     0          36      0        341.5
(295024GDC)   XXXXXXXXX   Up       YYYYYYYY   Switch/Hub   N/A     26      0          0       0        4.1
(c2950)       XXXXXXXXX   Up       YYYYYYYY   Switch/Hub   N/A     26      0          0       0        7.8
(355048)      XXXXXXXXX   Up       YYYYYYYY   Switch/Hub   N/A     50      0          3       0        13.0
(6509neba)    XXXXXXXXX   Up       YYYYYYYY   Switch/Hub   N/A     116     0          15      0        72.6
(4507)        XXXXXXXXX   Up       YYYYYYYY   Switch/Hub   N/A     16      0          0       0        0.8

Anyone have any idea to resolve this problem?!

Thanks in advance!
(...and sorry for my poor English!)

knobdy · Post by **knobdy** » Wed Mar 29, 2006 3:18 pm

Check your vlan and trunking configuration - that was my issue with the 4000 switch.

Haven't figured anything out on the wireless yet though...

twelzy · Post by **twelzy** » Wed Mar 29, 2006 3:20 pm

knobdy,

What kind of issue?!

Thanks in advance!

knobdy · Post by **knobdy** » Wed Mar 29, 2006 4:36 pm

Auxillary vlans for VoIP, trunking mode on the ports, etc..

chadd · Post by **chadd** » Wed Mar 29, 2006 5:10 pm

chadd wrote: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?

Anybody??

It seems that when the "Site IP Range Report" loads, it has

"Showing Rows 61 to 76 of 76 [1,2,3]"

in the head - indicating that there is data to be displayed. You can click on "next page" and get there, but still no info in the page is displayed.. Bafalling.. This is all it says:

No Mac Track Site IP Ranges Found.

chadd · Post by **chadd** » Fri Mar 31, 2006 3:52 pm

Here is what the log shows when I click on site ip range report:

03/31/2006 03:42:53 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT mac_track_sites.site_id, mac_track_sites.site_name, mac_track_ip_ranges.ip_range, mac_track_ip_ranges.ips_max, mac_track_ip_ranges.ips_current, mac_track_ip_ranges.ips_max_date, mac_track_ip_ranges.ips_current_date FROM mac_track_ip_ranges INNER JOIN mac_track_sites ON (mac_track_ip_ranges.site_id=mac_track_sites.site_id) LIMIT 0,30"
03/31/2006 03:43:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT mac_track_sites.site_id, mac_track_sites.site_name, mac_track_ip_ranges.ip_range, mac_track_ip_ranges.ips_max, mac_track_ip_ranges.ips_current, mac_track_ip_ranges.ips_max_date, mac_track_ip_ranges.ips_current_date FROM mac_track_ip_ranges INNER JOIN mac_track_sites ON (mac_track_ip_ranges.site_id=mac_track_sites.site_id) WHERE mac_track_ip_ranges.site_id='1' LIMIT 0,30"

chadd · Post by **chadd** » Mon Apr 03, 2006 12:39 pm

This is for Larry..

I was using the import/export utility to rebuild my mactrack database, and found the following:

Import only allows you to import 15 devices at a time, and errors on the rest.
Export only allows you to export 30 at a time, and errors on the rest.

Not sure if that is supposed to happen that way, or if it is a bug. Just thought I would let you know.

Otherwise, still working on getting the "site IP report" function to display the results..

-chadd.

chadd · Post by **chadd** » Mon Apr 03, 2006 4:06 pm

I added mac_track_ip_ranges.ips_current_date as a duplicate of mac_track_ip_ranges.ips_max_date (aside from the name of course) - using the mysql ALTER command, and reverted back to my un-patched poller - and it is working fine. It also corrected the problem I am having with the "site IP report" not displaying anything. Now though, I have a new problem. Name to IP resolution is no longer working... I have DNS servers configured (same as before when it was working). I am getting no errors when I run the poller manually or otherwise. Does anyone have a suggestion?

-chadd.

chadd · Post by **chadd** » Tue Apr 04, 2006 8:07 pm

Ok, DNS is working fine.

The fix posted earlier in this post for "beginning at line 419" of the poller_mactrack.php file is not needed. Just add the column I stated in the post above and things work much better.

Is this pluggin still being developed? I hope so, it is one of the most usefull tools I have found!

Post by **TheWitness** » Tue Apr 04, 2006 8:46 pm

Thanks Chadd. I am in a new job right now and drinking from a firehose at the moment. All my free time is being dedicated to understanding my companies tool set.

So, I would like to keep things going, but it will take a while. I would be willing to spend some personal time on this working directly with you on proposed changes. I would be able to do this on the weekend. Let me know your availability.

TheWitness
aka Larry Adams

torstentfk · Post by **torstentfk** » Wed Apr 05, 2006 3:42 am

Look here:

http://cactiusers.org/forums/viewtopic. ... highlight=

chadd wrote:
chadd wrote: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?
Anybody??

It seems that when the "Site IP Range Report" loads, it has

"Showing Rows 61 to 76 of 76 [1,2,3]"

in the head - indicating that there is data to be displayed. You can click on "next page" and get there, but still no info in the page is displayed.. Bafalling.. This is all it says:

No Mac Track Site IP Ranges Found.

chadd · Post by **chadd** » Wed Apr 05, 2006 7:50 am

Sounds good. I just started a new job as well, which is why I started using mactrack. I went from an all WAN enviornment, to an almost all LAN enviornment. I have been spending most of my time so far getting cacti setup with all the devices in my network. I am almost done:

04/05/2006 08:34:00 AM - SYSTEM STATS: Time:59.4600 Method:cactid Processes:1 Threads:10 Hosts:196 HostsPerProcess:196 DataSources:26141 RRDsProcessed:8779

04/05/2006 08:23:54 AM - SYSTEM MACTRACK STATS: Time:293.2755 ConcurrentProcesses:10 Devices:194

My LAN extends over sub T1 frame circuits, so with 90 or so sites, you have lots of room for errors

..

I will check my weekend schedule with boss (the real boss) and PM you with some time. Thanks for working on this. Great piece of software!

pepj · Post by **pepj** » Wed Apr 05, 2006 10:15 am

Hello

When I enter "http://cacti/plugins/mactrack/ " without to login before I can browse all under mactrac and start the php,html,.. scripts.

with other plugins there is no problem

(this problem is for all browser...)

chadd · Post by **chadd** » Wed Apr 05, 2006 12:11 pm

try:

http://cacti/plugins/mactrack/mactrack_view.php

There is no "index" file in the mactrack plugin directory.

-chadd.

pepj · Post by **pepj** » Wed Apr 05, 2006 12:55 pm

[quote="chadd"]try:
http://cacti/plugins/mactrack/mactrack_view.php
quote]

- with "http://cacti/plugins/mactrack/mactrack_view.php" I get the login.
- I put index.php , but the result with http://cacti/plugins/mactrack is the same --> I can browse and start without rigth or login.

Jean-Michel

Cacti

End Device Tracking Add-On for Cacti

Security issue only with Mactrack !!!

Who is online