End Device Tracking Add-On for Cacti

[TheWitness]

Spoonman,

You need to add the sup720 information to the sysDescr_match field and a valid starting OID for cisco and things will work just fine.

TheWitness

[TheWitness]

Dwayne,

What version of MySQL are you running. Please let me know. My guess would be 5.x.

TheWitness

[Dwayne_Dibbley]

Dwayne,

What version of MySQL are you running. Please let me know. My guess would be 5.x.

TheWitness

MySQL 4.1 here

Thanks

[sobacha]

Hi

Has anyone tried on Force10 E-series?

TIA
soba

[spoonman]

Thanks Witness......I tried that after I posted and it seemed to be up now, I have 1 Site and 1 Device the Cisco 6509. I just added a new Device type for 6509 and added that match for sysdescription. My question is now do I have to run that database upgrade item?? All i've done is add the plugin, make changes to proper config and import the mactrack.sql file into my cacti DB.


Thanks Witness.

[spoonman]

One more question about ports to ignore?? If this is operational?? Is there a way to add a span of ports, say on our core router the firs 15 or so gig interfaces are trunk ports?? Can I ignore gig1/1 thru gig1/17 ?? I tried adding each but ran out of space for that field>>

Thanks.

[torstentfk]

Hi,

I have two feature requests:
- Now you can search for a port name and Mac-Address;it would be nice to search for ports (=display all MACs on a specific port) or search by IP-Address or hostname
- ability to enter MAC-address in any format and cacti reformates it:
Enter 090806ab automatic change/search into 09:08:06:ab
or 06-7b-5a to 06:7b:5a

btw: the new version is really cool, stable etc.......
Torsten

[knobdy]

DNS is still not working how it should. I have added a simple fix on my side of things that looks like it will fix it permanently for me, but I need to get with Larry as to whether it is OK with him.

Do you have an update on this yet?

[TheWitness]

I'll have some time between now and Friday. Don't know how many issues I can get to, but I will try.

TheWitness

[cigamit]

DNS is still not working how it should. I have added a simple fix on my side of things that looks like it will fix it permanently for me, but I need to get with Larry as to whether it is OK with him.

Do you have an update on this yet?

How I fixed this for me, was to add this code

Code: Select all

			db_execute("UPDATE mac_track_temp_ports
						INNER JOIN mac_track_ips
						ON (mac_track_temp_ports.mac_address = mac_track_ips.mac_address
						AND mac_track_temp_ports.scan_date = mac_track_ips.scan_date
						AND mac_track_temp_ports.site_id = mac_track_ips.site_id)
						SET mac_track_temp_ports.ip_address = mac_track_ips.ip_address");

in mactrack_resolver.php after this part of the code

Code: Select all

/* loop until you are it */
while (1) {
	$processes_running = db_fetch_cell("SELECT COUNT(*) FROM mac_track_processes");

	if ($processes_running == 1) {
		$break_now = TRUE;

before the

Code: Select all

	}else{
		$break_now = FALSE;
	}

This would ensure that the resolver had every IP to work with before exitting. Otherwise in the poller, it isn't set to run that code again until after the resolver has already exited, which is already too late.

[knobdy]

Hmm... I've got this, is it the same or am I using an outdated version already?

Code: Select all

/* loop until you are it */
while (1) {
        $processes_running = db_fetch_cell("SELECT COUNT(*) FROM mac_track_processes WHERE device_id <> '0'");

        $run_status = db_fetch_assoc("SELECT last_rundate,
                COUNT(last_rundate) AS devices
                FROM mac_track_devices
                WHERE disabled = ''
                GROUP BY last_rundate
                ORDER BY last_rundate DESC;");

        if ((sizeof($run_status) == 1) && ($processes_running == 0)) {
                $break = TRUE;
        }else{
                $break = FALSE;
        }

[cigamit]

Hmm... I've got this, is it the same or am I using an outdated version already?

Code: Select all

/* loop until you are it */
while (1) {
        $processes_running = db_fetch_cell("SELECT COUNT(*) FROM mac_track_processes WHERE device_id <> '0'");

        $run_status = db_fetch_assoc("SELECT last_rundate,
                COUNT(last_rundate) AS devices
                FROM mac_track_devices
                WHERE disabled = ''
                GROUP BY last_rundate
                ORDER BY last_rundate DESC;");

        if ((sizeof($run_status) == 1) && ($processes_running == 0)) {
                $break = TRUE;
        }else{
                $break = FALSE;
        }

Nope you got the correct version, I pulled it off my production server which I apparrently haven't updated just yet to the newest. My updated test server still has the same resolver issue without the minor patch, so just add it right after the $break = TRUE; and see if it fixes it for you.

[knobdy]

That's where I put it.

Anyway to test this script outside of Cacti's normal polling routines?

[cigamit]

That's where I put it.

Anyway to test this script outside of Cacti's normal polling routines?

run the poller_mactrack.php manually with the -d -f options. So your command may look like this

Code: Select all

php -q /var/www/html/plugins/mactrack/poller_mactrack.php -d -f

[knobdy]

Nope, that didn't get it... I'll take a look at my DNS configuration - might be using our corp server which sometimes doesn't like forwarding requests it seems...