Page 4 of 4
Re: performance data not kept for some services
Posted: Wed Apr 27, 2011 2:03 pm
by lyle
The patch is installed, but now I seem to be getting a growing number of directories in /usr/local/nagios/share/perfdata, each with a new PID as suffix.
For example, one host with 4 services being monitored has producing 48 directories so far, each named something like: <hostname>-PID-8139
No graphs seem to be available, and my original data collected may be gone.
I emailed Mike a log of the patch installation and examples of the growing number of directories.
Thanks for any advice....Lyle
Re: performance data not kept for some services
Posted: Wed Apr 27, 2011 3:33 pm
by lyle
Just an update:
After about 3 hours, I'm up to 726 directories created so far for 5 servers and a total of maybe 15 services monitored (with process_perf_data=1).
So I'm going to stop npcd, though that might make the spooled data pile up.
Thanks...Lyle
Re: performance data not kept for some services
Posted: Wed Apr 27, 2011 4:16 pm
by mguthrie
Hey Lyle,
Sending support by email....
Re: performance data not kept for some services
Posted: Thu Apr 28, 2011 5:13 pm
by lyle
Since replacing the process_perfdata.pl we seem to be keeping performance data and generating graphs just fine. Thank you.
Any thoughts on my answer to your previous question:
lyle wrote:
I was hoping PNP 0.6 would allow me to export the data in CSV format. For several reasons, we can not upgrade from V10 of Crystal Reports, and that version does not import XML, but is just fine with CSV. I've been posting on the RRDTool list looking for a solution, but all I've received back were suggestions to write my own XML to CSV converter. The PNP 0.6.3 release notes I quoted above gave me some hope.
Thanks again....Lyle
Re: performance data not kept for some services
Posted: Fri Apr 29, 2011 9:33 am
by mguthrie
What's your comfort level with a script that grabs the performance data and converts to CSV? I can write up a quick script that will make the conversion.
I've got some existing code I could turn into a script rather quickly if it would do what you need. Here's probably would it would look like from the command-line:
./fetch_csv.php --host=localhost --service=ping --start=-7d --end=-4d > mycsvfile.csv
(the dates could also be in YYYYMMDD format as well)
Would that work?
Re: performance data not kept for some services
Posted: Mon May 02, 2011 10:42 am
by lyle
That may be all I need. If I can get a copy, I'll try it out.
Thanks...Lyle
Re: performance data not kept for some services
Posted: Mon May 02, 2011 12:10 pm
by mguthrie
Place this in your /usr/local/nagiosxi/tools directory. Run:
Here are some example usages:
Code: Select all
./rrd2csv.php --host=localhost --service=PING --start=-5d -end=-3d > tmp.csv
./rrd2csv.php --host=localhost > tmp.csv
./rrd2csv.php --host=localhost --service=PING --start=20110426 -end=20110430 > tmp.csv
./rrd2csv.php --host=localhost --service=PING --start=20110426 > tmp.csv
The CSV data dumps to standard output, so you can redirect it however you need it. Let me know if it needs any tweaks.