performance data not kept for some services

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
lyle
Posts: 158
Joined: Sun Nov 21, 2010 3:05 am

Re: performance data not kept for some services

Post 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
lyle
Posts: 158
Joined: Sun Nov 21, 2010 3:05 am

Re: performance data not kept for some services

Post 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
mguthrie
Posts: 4380
Joined: Mon Jun 14, 2010 10:21 am

Re: performance data not kept for some services

Post by mguthrie »

Hey Lyle,

Sending support by email....
lyle
Posts: 158
Joined: Sun Nov 21, 2010 3:05 am

Re: performance data not kept for some services

Post 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
mguthrie
Posts: 4380
Joined: Mon Jun 14, 2010 10:21 am

Re: performance data not kept for some services

Post 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?
lyle
Posts: 158
Joined: Sun Nov 21, 2010 3:05 am

Re: performance data not kept for some services

Post by lyle »

That may be all I need. If I can get a copy, I'll try it out.

Thanks...Lyle
mguthrie
Posts: 4380
Joined: Mon Jun 14, 2010 10:21 am

Re: performance data not kept for some services

Post by mguthrie »

Place this in your /usr/local/nagiosxi/tools directory. Run:

Code: Select all

chmod +x rrd2csv.php
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.
You do not have the required permissions to view the files attached to this post.