End Device Tracking Add-On for Cacti

Post by **TheWitness** » Sun Apr 09, 2006 10:09 pm

please post a modified file.

knobdy · Post by **knobdy** » Mon Apr 10, 2006 8:36 am

Yes, please do post updated file!

Witness:
1) I hope you do get the time for the overhaul - my company is really putting it to use these days (especially since I got that 4000 to start reporting)!
2) I'll try and get a traffic capture for you today, might I send it to you privately though - so I don't have to be so overly cautious with my cleaning?

knobdy · Post by **knobdy** » Mon Apr 10, 2006 1:40 pm

I'm still waiting for it to run again so that I can capture the DNS failures, but while doing so I greped the cacti.log and found the following:

Code: Select all

04/10/2006 11:36:34 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO `mac_track_ip_ranges`      (`ip_range`, `site_id`, `ips_current`, `ips_max_date`)      VALUES ('17.4.4','3',5','2006-04-10 11:32:14')"

Mean anything to anybody?

Btw, I decided to grep the log because mactrack's "process status" page keeps telling me it should have started again 7 minutes ago (it hasn't yet).

knobdy · Post by **knobdy** » Mon Apr 10, 2006 1:44 pm

While running, it briefly displayed the following.

knobdy · Post by **knobdy** » Mon Apr 10, 2006 2:03 pm

Witness, you have a new private message from me.

tadavis · Post by **tadavis** » Tue Apr 11, 2006 3:59 pm

knobdy wrote:I'm still waiting for it to run again so that I can capture the DNS failures, but while doing so I greped the cacti.log and found the following:
Code: Select all
04/10/2006 11:36:34 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO `mac_track_ip_ranges`      (`ip_range`, `site_id`, `ips_current`, `ips_max_date`)      VALUES ('17.4.4','3',5','2006-04-10 11:32:14')"
Mean anything to anybody?

Btw, I decided to grep the log because mactrack's "process status" page keeps telling me it should have started again 7 minutes ago (it hasn't yet).

Try running the upgrade_database script I posted..

Else, what version of MySQL are you running?

knobdy · Post by **knobdy** » Tue Apr 11, 2006 4:16 pm

tadavis wrote: Try running the upgrade_database script I posted..

Else, what version of MySQL are you running?

I did, pretty sure, and I'm running:

mysql Ver 14.7 Distrib 4.1.13, for suse-linux (powerpc) using readline 5.0

tadavis · Post by **tadavis** » Tue Apr 11, 2006 4:52 pm

Ok, the mysql is new enough..

Ah, have you dropped all the contents of the database since you ran the database_upgrade script?

It's probably trying to "replace" a value that does not exist..

knobdy · Post by **knobdy** » Wed Apr 12, 2006 9:19 am

Is it enough to do it through the mactrack tools provided in the plugin?

Nope:

Code: Select all

04/12/2006 09:35:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO `mac_track_ip_ranges`      (`ip_range`, `site_id`, `ips_current`, `ips_max_date`)      VALUES ('10.10.14','3',4','2006-04-12 09:30:37')"

How would I do it otherwise (I went through and deleted all results via the plugin utilities)? Or, what else might be wrong?

spayne · Post by **spayne** » Wed Apr 12, 2006 10:44 am

knobdy wrote:Is it enough to do it through the mactrack tools provided in the plugin?

Nope:
Code: Select all
04/12/2006 09:35:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "REPLACE INTO `mac_track_ip_ranges`      (`ip_range`, `site_id`, `ips_current`, `ips_max_date`)      VALUES ('10.10.14','3',4','2006-04-12 09:30:37')"
How would I do it otherwise (I went through and deleted all results via the plugin utilities)? Or, what else might be wrong?

the problem is that you are missing a quotation mark

VALUES ('10.10.14','3','4','2006-04-12 09:30:37'

you need to edit poller_mactrack.php

old:

Code: Select all

$ip_range["site_id"] . "',"

new:

Code: Select all

$ip_range["site_id"] . "','"

knobdy · Post by **knobdy** » Wed Apr 12, 2006 11:04 am

spayne wrote: the problem is that you are missing a quotation mark

Found it on line 429 - but how would that have happened?!

spayne · Post by **spayne** » Wed Apr 12, 2006 12:37 pm

knobdy wrote: Found it on line 429 - but how would that have happened?!

It looks like this is a bug in the new poller_mactrack.php file that was posted a few days ago.

Post by **TheWitness** » Thu Apr 13, 2006 5:24 am

The database_upgrade.php file was altered by Cigamit the other day to add a missing field to the mac_track_ip_ranges (sp) table. So users having issues with the IP range management, you should rerun the upgrade script.

TheWitness

fozzy · Post by **fozzy** » Fri Apr 14, 2006 3:36 am

another very nice addon

thank you .

I'd just point out a couple of issues i'm having.

it could be worth putting some download instructions as to how to get th elatest release in the first post of the thread.. it's been more or les a tresure hunt

in the mac/ip reports it would be nice to have an ALL option for sites too. at least now using site: N/A and device all doesn't give me any output
Would it be possible to order numerically the ports?

right now it's alphabeticaly so 3/24 comes before 3/3.

Stil working to find out why some devices aren't iscovered correctly but that must be a chair/keyboard intrerface problem

Thanks again for the nice work.
Luca

EDIT: a small additional note: cat 2980 and cat3524 require the use of get_generic_switch_ports

jhunterlogin · Post by **jhunterlogin** » Sun Apr 23, 2006 1:33 am

Cacti

End Device Tracking Add-On for Cacti

mactrack poller not working automatically.

Who is online