End Device Tracking Add-On for Cacti

jforman · Post by **jforman** » Wed Jul 12, 2006 9:40 pm

TheWitness wrote:Your IP's appear to be IPv6. Is this correct. I currently do not support IPv6. Please respond.

TheWitness

Definitely not running any IPv6 at all inside our corporate lan.

Post by **TheWitness** » Wed Jul 12, 2006 9:46 pm

The reason I ask this is the following:

Code: Select all

DEBUG: SQL: REPLACE INTO mac_track_ips (site_id,device_id,hostname,description,port_number,mac_address,ip_address,scan_date) VALUES ('1','16','192.168.1.3','CR-01','1','00:00:10:00:00:00','7F:00:00:34','2006-07-12 21:03:13')

TheWitness[/b]

jforman · Post by **jforman** » Wed Jul 12, 2006 9:56 pm

TheWitness wrote:The reason I ask this is the following:

Code: Select all

DEBUG: SQL: REPLACE INTO mac_track_ips (site_id,device_id,hostname,description,port_number,mac_address,ip_address,scan_date) VALUES ('1','16','192.168.1.3','CR-01','1','00:00:10:00:00:00','7F:00:00:34','2006-07-12 21:03:13')

TheWitness[/b]

Then I am totally at a loss here.

One of my coworkers is running the Cacti-EZ cd and it runs mactrack just fine. We're only seeing this issue on a cacti install (0.6.8h with patches) that we did by hand. I'll have to diff it tomorrow when I am back in the office and not running out of battery over VPN.

Post by **TheWitness** » Wed Jul 12, 2006 10:07 pm

It may be that your snmp config is returning data with the incorrect mib type. This can be corrected by setting the MIBS environment variable to something simple like "RFC-1215.xxx" where xxx represents your mib extension.

Give that a try.

TheWitness

ddonohue · Post by **ddonohue** » Wed Jul 12, 2006 10:32 pm

TheWitness wrote:Ok, so here's the trick, you need to open a console and run each device in debug mode. Here is the syntax:
Code: Select all
>php mactrack_scanner.php -h
Network Mac Tracker Version 1.0, Copyright 2005 - Larry Adams

usage: mactrack_device.php -id=host_id [-d] [-h] [--help] [-v] [--version]

-id=host_id   - the mac_track_devices host_id to scan
-d            - Display verbose output during execution
-t            - Test mode, don't log a process id and interfere with system
-v --version  - Display this help message
-h --help     - display this help message
So, if the switch in question is a L3 switch, and definately for the router run the command using the "-d" option. Post the results.

TheWitness

I actually wrote a perl script, to take care of this, and then setup a cronjob to run it automagically.

my $dbh = DBI->connect("dbi:mysql:<DBNAME>", "<UID>", "<PASS>");

my $sth = $dbh->prepare(<<SQL);
select device_id
from mac_track_devices
SQL
$sth->execute;

while (my @row = $sth->fetchrow_array()) {
my ($device) = @row;
system "php /cacti-0.8.6h/plugins/mactrack/mactrack_scanner.php -id=$device 2>&1 >/dev/null";
}

Post by **TheWitness** » Wed Jul 12, 2006 10:40 pm

Yes, but by doing that, you loose all the other processing that goes on in the poller_mactrack.php function that does all the consolidation and additional detailed reporting.... In addition, mactrack gives you a real good if not poorly written way of monitoring progress of you scanning real time.

TheWitness

ddonohue · Post by **ddonohue** » Wed Jul 12, 2006 10:44 pm

I still have the poller running. Just when i need to startup new devices or similar, i run it this way, since you can't run it by hand w/o specifying the device_id.

donohue

Post by **TheWitness** » Wed Jul 12, 2006 10:51 pm

Oh, ok. Np then...

I am thinking that the environment variable MIBS=RFC-1215 will make the output look better.

TheWitness

ddonohue · Post by **ddonohue** » Wed Jul 12, 2006 11:02 pm

a future add into to the mac/ip report? could you possiable arrange a sort button, ie, Sort by Port or IP addy, or similar?

Post by **TheWitness** » Wed Jul 12, 2006 11:04 pm

Actually, when I get around to it, I have added a sort module to Cacti 0.8.6i that you should be able to take advantage of once we release it. Won't be soon enough for some, I know.

TheWitness

jforman · Post by **jforman** » Thu Jul 13, 2006 7:29 am

TheWitness wrote:Oh, ok. Np then...

I am thinking that the environment variable MIBS=RFC-1215 will make the output look better.

TheWitness

No difference what so ever.
export MIBS=RFC-1215.txt
then i ran both mactrack_scanner and poller_mactrack on all devices.

I'm completely at a loss as to what is going on.

I am not sure whether it makes any difference, but we have VoIP phones (on seperate vlan and subnet) which our desktop computers plug into, so there will be 2 IP and MAC's off of each desktop switch (DS-#) port.

jforman · Post by **jforman** » Thu Jul 13, 2006 7:31 am

does anyone have the correct Object ID OID for a cisco 2950 and 3560 switch running IOS? (and a 4500 or 6000 if also)

i'm thinking something might be going on with that, if at all possible.

shakey_1 · Post by **shakey_1** » Thu Jul 13, 2006 8:15 am

My Cisco 2950's (C2950-I6Q4L2-M) show an ObjectID of .1.3.6.1.4.1.9.1.324.

emerillat · Post by **emerillat** » Thu Jul 13, 2006 1:21 pm

Okay, i have the plugin installed, some devices created and can manual poll using the id # but they don't seem to be updating. I think I have missed a step somewhere. Do I need to use something other than cactid for this to update?

Thanks!

ddonohue · Post by **ddonohue** » Thu Jul 13, 2006 2:07 pm

This is because as witness said, when you don't run the mactrack_poller.php you loose alot of the functions.

so you want to setup a cronjob for your mactrack_poller.php to run.

quick way to test it out by hand is

php /cacti/plugins/mactrack/mactrack_poller.php

Donohue

Cacti

End Device Tracking Add-On for Cacti

objectID's

Who is online