perfparse-users

[Perfparse-users] (no subject)

[Sand P. <Phi...@sy...>]

Hi,

I just tried out the perfparse_db_purge, and I don't know what I'm doing =
wrong, but I won't work properly...but without giving error messages...
I simply start it from the command-line e.g. with #./perfparse-db-purge -=
n 1
The the program seems to run and after a while it returns, that it has de=
leted some million lines. Looks fine i think.
But when I commect to the Database, and do some selects on the perfdata_h=
ost, or on the perfdata_service_raw, I got a lot of Data which is older t=
han this 1 day.
Which Data is deleted by the perfparse-db-purge tool?=20
BTW, does perfdata needs the data in the perfdata_service_raw table, or c=
an it be deleted after perfparse got its bin-data?
Would be great if you guys could post somethng like which table got which=
 functions, thanks!

Regards,
Philipp=20
=20

_____________________________

Philipp Sand
OC-CC-TEC-SYS

SYCOR GmbH
Heinrich-von-Stephan-Stra=DFe 1-5
D - 37073 G=F6ttingen

Telefon	+49 (0) 551 / 490 - 0
Telefax	+49 (0) 551 / 490 - 232468

phi...@sy...
www.sycor.de
------------------------------------------------



************************************************

sycor plastics - die neue Branchenl=F6sung f=FCr die Kunststoffindustrie

www.sycor-plastics.de

************************************************




Diese E-Mail ist vertraulich und kann dar=FCber hinaus pers=F6nliche Info=
rmationen beinhalten. Wenn Sie nicht der bestimmungsgem=E4=DFe Empf=E4nge=
r sind, l=F6schen Sie bitte die E-Mail und deren Anh=E4nge sofort und ben=
achrichtigen Sie uns dar=FCber. Die Firma sycor willigt in keine Vertr=E4=
ge oder vertragliche Verpflichtungen ein oder =FCbermittelt rechtsverbind=
liche Angebote, die in Form von E-Mail versandt werden, sofern dies nicht=
 ausdr=FCcklich in schriftlicher Form zwischen den Parteien vereinbart wu=
rde.

This e-mail is confidential and may contain personal and/or privileged in=
formation. If you are not the intended recipient please delete this e-mai=
l and all attachments immediately and inform us. The company sycor does n=
ot agree with contracts or contract obligations sent by e-mail, neither d=
o we transmit legally binding offers by e-mail, unless this is not expres=
sly agreed upon between the parties and documented in written form.

[Perfparse-users] (no subject)

[Jessica H. <Je...@gm...>]

Hi,

Another problem is that no data is storaged into the database. The
tables are all there, because I've seen them with show tables and
describe <name>

The database:

./mysql  (as root)
dann
mysql> create database perfparse;
mysql> quit

now in my perfparse directory:

cat mysql_create.sql | mysql -u root -p -D perfparse

This only works as root (i don't know why)

now ./mysql again and a look to the database:

mysql> use perfparse;
Database changed
mysql> show tables;
+---------------------------------+
| Tables_in_perfparse |
+---------------------------------+
| perfdata_bin_summary |
| perfdata_bin_summary_data |
| perfdata_bin_summary_del_policy |
| perfdata_bin_summary_header |
| perfdata_delete_policy |
| perfdata_graphs |
| perfdata_host |
| perfdata_host_group |
| perfdata_prefs |
| perfdata_raw_summary |
| perfdata_raw_summary_data |
| perfdata_registry |
| perfdata_service |
| perfdata_service_bin |
| perfdata_service_metric |
| perfdata_service_raw |
| perfdata_state |
| perfdata_users |
+---------------------------------+
18 rows in set (0.00 sec)

mysql> describe
perfdata_service;
+------------------------+--------------------------------+------+-----+----------+-------+
| Field | Type | Null | Key | Default | Extra
|
+------------------------+--------------------------------+------+-----+----------+-------+
| service_id | int(11) | | UNI | 0 | |
| host_name | varchar(75) | | PRI | | |
| service_description | varchar(75) | | PRI | | |
| last_perfdata_raw | int(11) | YES | MUL | NULL | |
| raw_delete_policy | int(11) | YES | | NULL | |
| raw_delete_policy_name | varchar(20) | YES | MUL | NULL | |
| raw_delete_policy_type | enum('template','user','host') | | | template | |
| is_deleted | tinyint(4) | YES | | 0 |
|
+------------------------+--------------------------------+------+-----+----------+-------+
8 rows in set (0.00 sec)

mysql> select host_name
-> from perfdata_service;
Empty set (0.00 sec) 


This is empty... I've worked after this documentation:

http://wiki.perfparse.org/tiki-index.php?page=BuildingMethod4Example



In the perfdata-service log, are always the newest datas and it is
updated regularly.


Then create a Nagios command to run perfparse-log2mysql every time a
log is
generated.

Is this the command???

# vi perfparse_nagios_pipe_command.pl
add at the end...
system ('/opt/nagios/bin/perfparse-log2mysql --serviceperf-log
/opt/nagios/var/perfdata-service.log');

I do this this like in this documentation:
http://wiki.perfparse.org/tiki-index.php?page=BuildingMethod4Example

But in the original documentation are more things described like:

5.2. Periodic Nagios Log Parse


Then add the following four lines to the 'HOST AND SERVICE
PERFORMANCE DATA PROCESSING COMMANDS' section:


xpdfile_host_perfdata_file=/usr/local/nagios/var/hostperf.log
xpdfile_host_perfdata_template=$TIMET$\t$HOSTNAME$\t$OUTPUT
$\t$PERFDATA$

xpdfile_service_perfdata_file=/usr/local/nagios/var/serviceperf.log
xpdfile_service_perfdata_template=$TIMET$\t$HOSTNAME$\t$SERVICEDESC
$\t$OUTPUT$\t$SERVICESTATE$\t$PERFDATA$                                     
            
                                                   
                                                                    
       Should I write this down? or not?                            
                                                                    


5.3. Nagios Invokes Perfparse


Edit misccommands.cfg and add the following :


define command{
        command_name    process-service-perfdata
        command_line    /usr/bin/printf "%b" "$TIMET$\t$HOSTNAME
$\t$SERVICEDESC$\t$OUTPUT$\t$SERVICESTATE$\t$PERFDATA$\n" |
$USER2$/bin/perfparse-log2mysql -c $USER2$/etc/perfparse.cfg
        }

                                                                    
      $USER2$ is defined in resources.cfg and points to the         
      Perfparse installation directory.                             
                                                                    



                                                                    
        In perfparse.cfg, Service_Log must be defined as "-".       
                                                                   


5.4. Periodic User Log Parse


Edit misccommands.cfg and add the following :


define command{
        command_name    process-service-perfdata
        command_line    $USER2$/bin/perfparse_nagios_command.pl
$USER2$/var/perfdata-service.log "$TIMET$" "$HOSTNAME$"
"$SERVICEDESC$" "$OUTPUT$" "$SERVICESTATE$" "$PERFDATA$"
        }

                                                                    
      $USER2$ is defined in resources.cfg and points to the         
      Perfparse installation directory.                             
                                                                    



What's up with this??? Can I write down two of the same misccommands
in one cfg? I think not! I think I can use a command_name only once
a time, or I'm wrong?



Edit a script like this :


#!/bin/sh
$USER2=/perfparse/installation/directory

mv ${USER2}/var/perfdata-service.log
${USER2}/var/perfdata-service.log1
cat ${USER2}/var/perfdata-service.log1 |
${USER2}/bin/perfparse-log2mysql -c ${USER2}/etc/perfparse.cfg
rm ${USER2}/var/perfdata-service.log1

                                                                    
        In perfparse.cfg, Service_Log must be defined as "-".       
                                                                    

And what is this? Where should I let this script, How should I name
this? Must I write down something in a config file?


Sorry for my questions which looks like I'm a dummbass but I know
not so mus about this. I'm learning all these things but I don't
know what I should do now.
Wenn I look at googel for my problems I don't find many things. For
nagios I've found a very good german forum but I've found no english
or german perfparse forum. :-(

-- 
Lassen Sie Ihren Gedanken freien Lauf... z.B. per FreeSMS
GMX bietet bis zu 100 FreeSMS/Monat: http://www.gmx.net/de/go/mail

[Perfparse-users] Problems with MySQL and documentations

[Jessica H. <Je...@gm...>]

Hi,

Another problem is that no data is storaged into the database. The
tables are all there, because I've seen them with show tables and
describe <name>

The database:

./mysql  (as root)
dann
mysql> create database perfparse;
mysql> quit

now in my perfparse directory:

cat mysql_create.sql | mysql -u root -p -D perfparse

This only works as root (i don't know why)

now ./mysql again and a look to the database:

mysql> use perfparse;
Database changed
mysql> show tables;
+---------------------------------+
| Tables_in_perfparse |
+---------------------------------+
| perfdata_bin_summary |
| perfdata_bin_summary_data |
| perfdata_bin_summary_del_policy |
| perfdata_bin_summary_header |
| perfdata_delete_policy |
| perfdata_graphs |
| perfdata_host |
| perfdata_host_group |
| perfdata_prefs |
| perfdata_raw_summary |
| perfdata_raw_summary_data |
| perfdata_registry |
| perfdata_service |
| perfdata_service_bin |
| perfdata_service_metric |
| perfdata_service_raw |
| perfdata_state |
| perfdata_users |
+---------------------------------+
18 rows in set (0.00 sec)

mysql>
describe
perfdata_service;
+------------------------+--------------------------------+------+-----+----------+-------+
| Field | Type | Null | Key | Default |
Extra
|
+------------------------+--------------------------------+------+-----+----------+-------+
| service_id | int(11) | | UNI | 0 | |
| host_name | varchar(75) | | PRI | | |
| service_description | varchar(75) | | PRI | | |
| last_perfdata_raw | int(11) | YES | MUL | NULL | |
| raw_delete_policy | int(11) | YES | | NULL | |
| raw_delete_policy_name | varchar(20) | YES | MUL | NULL | |
| raw_delete_policy_type | enum('template','user','host') | | | template | |
| is_deleted | tinyint(4) | YES | | 0
|
|
+------------------------+--------------------------------+------+-----+----------+-------+
8 rows in set (0.00 sec)

mysql> select host_name
-> from perfdata_service;
Empty set (0.00 sec) 


This is empty... I've worked after this documentation:

http://wiki.perfparse.org/tiki-index.php?page=BuildingMethod4Example



In the perfdata-service log, are always the newest datas and it is
updated regularly.


Then create a Nagios command to run perfparse-log2mysql every time a
log is
generated.

Is this the command???

# vi perfparse_nagios_pipe_command.pl
add at the end...
system ('/opt/nagios/bin/perfparse-log2mysql --serviceperf-log
/opt/nagios/var/perfdata-service.log');

I do this this like in this documentation:
http://wiki.perfparse.org/tiki-index.php?page=BuildingMethod4Example

But in the original documentation are more things described like:

5.2. Periodic Nagios Log Parse


Then add the following four lines to the 'HOST AND SERVICE
PERFORMANCE DATA PROCESSING COMMANDS' section:


xpdfile_host_perfdata_file=/usr/local/nagios/var/hostperf.log
xpdfile_host_perfdata_template=$TIMET$\t$HOSTNAME$\t$OUTPUT
$\t$PERFDATA$

xpdfile_service_perfdata_file=/usr/local/nagios/var/serviceperf.log
xpdfile_service_perfdata_template=$TIMET$\t$HOSTNAME$\t$SERVICEDESC
$\t$OUTPUT$\t$SERVICESTATE$\t$PERFDATA$                                     
            
                                                   
                                                                    
       Should I write this down? or not?                            
                                                                    


5.3. Nagios Invokes Perfparse


Edit misccommands.cfg and add the following :


define command{
        command_name    process-service-perfdata
        command_line    /usr/bin/printf "%b" "$TIMET$\t$HOSTNAME
$\t$SERVICEDESC$\t$OUTPUT$\t$SERVICESTATE$\t$PERFDATA$\n" |
$USER2$/bin/perfparse-log2mysql -c $USER2$/etc/perfparse.cfg
        }

                                                                    
      $USER2$ is defined in resources.cfg and points to the         
      Perfparse installation directory.                             
                                                                    



                                                                    
        In perfparse.cfg, Service_Log must be defined as "-".       
                                                                   


5.4. Periodic User Log Parse


Edit misccommands.cfg and add the following :


define command{
        command_name    process-service-perfdata
        command_line    $USER2$/bin/perfparse_nagios_command.pl
$USER2$/var/perfdata-service.log "$TIMET$" "$HOSTNAME$"
"$SERVICEDESC$" "$OUTPUT$" "$SERVICESTATE$" "$PERFDATA$"
        }

                                                                    
      $USER2$ is defined in resources.cfg and points to the         
      Perfparse installation directory.                             
                                                                    



What's up with this??? Can I write down two of the same misccommands
in one cfg? I think not! I think I can use a command_name only once
a time, or I'm wrong?



Edit a script like this :


#!/bin/sh
$USER2=/perfparse/installation/directory

mv ${USER2}/var/perfdata-service.log
${USER2}/var/perfdata-service.log1
cat ${USER2}/var/perfdata-service.log1 |
${USER2}/bin/perfparse-log2mysql -c ${USER2}/etc/perfparse.cfg
rm ${USER2}/var/perfdata-service.log1

                                                                    
        In perfparse.cfg, Service_Log must be defined as "-".       
                                                                    

And what is this? Where should I let this script, How should I name
this? Must I write down something in a config file?


Sorry for my questions which looks like I'm a dummbass but I know
not so mus about this. I'm learning all these things but I don't
know what I should do now.
Wenn I look at googel for my problems I don't find many things. For
nagios I've found a very good german forum but I've found no english
or german perfparse forum. :-(

-- 
Lassen Sie Ihren Gedanken freien Lauf... z.B. per FreeSMS
GMX bietet bis zu 100 FreeSMS/Monat: http://www.gmx.net/de/go/mail

-- 
Lassen Sie Ihren Gedanken freien Lauf... z.B. per FreeSMS
GMX bietet bis zu 100 FreeSMS/Monat: http://www.gmx.net/de/go/mail

[Perfparse-users] Problems with MySQL and documentations

[Jessica H. <Je...@gm...>]

I have some more problem, or only one... we will see and I hope aou answer
quick... :-)


My SQL database work fine now :-)
I can say I'm be proud of myself

But now I have a problems with the bin data... 

My database looks so:

mysql> select * from
perfdata_service_raw;
+----+-----------+---------------------+---------------------+-------------------------------------------+---------------+
| id | host_name | service_description | ctime               | txt_data     
                            | nagios_status
|
+----+-----------+---------------------+---------------------+-------------------------------------------+---------------+
|  1 | jholle    | Ping                | 2005-02-18 10:23:37 | PING OK -
Packet loss = 0%, RTA = 0.33 ms |             0 |
|  2 | jholle    | Ping                | 2005-02-18 10:24:37 | PING OK -
Packet loss = 0%, RTA = 0.29 ms |             0 |
|  3 | jholle    | Ping                | 2005-02-18 10:25:37 | PING OK -
Packet loss = 0%, RTA = 0.33 ms |             0 |
|  4 | jholle    | Ping                | 2005-02-18 10:26:37 | PING OK -
Packet loss = 0%, RTA = 0.33 ms |             0 |
|  5 | jholle    | Ping                | 2005-02-18 10:27:37 | PING OK -
Packet loss = 0%, RTA = 0.34 ms |             0 |
|  6 | jholle    | Ping                | 2005-02-18 10:28:37 | PING OK -
Packet loss = 0%, RTA = 0.35 ms |             0 |
|  7 | jholle    | Ping                | 2005-02-18 10:29:37 | PING OK -
Packet loss = 0%, RTA = 0.38 ms |             0 |
|  8 | jholle    | Ping                | 2005-02-18 10:30:37 | PING OK -
Packet loss = 0%, RTA = 0.31 ms |             0 |
|  9 | jholle    | Ping                | 2005-02-18 10:31:37 | PING OK -
Packet loss = 0%, RTA = 0.33 ms |             0 |
| 10 | jholle    | Ping                | 2005-02-18 10:32:37 | PING OK -
Packet loss = 0%, RTA = 0.33 ms |             0 |
| 11 | jholle    | Ping                | 2005-02-18 10:33:37 | PING OK -
Packet loss = 0%, RTA = 0.29 ms |             0 |
| 12 | jholle    | Ping                | 2005-02-18 10:46:15 | PING OK -
Packet loss = 0%, RTA = 0.30 ms |             0 |
| 13 | jholle    | Ping                | 2005-02-18 10:48:03 | PING OK -
Packet loss = 0%, RTA = 0.30 ms |             0 |
| 14 | jholle    | Ping                | 2005-02-18 10:49:03 | PING OK -
Packet loss = 0%, RTA = 0.34 ms |             0 |
| 15 | jholle    | Ping                | 2005-02-18 10:50:03 | PING OK -
Packet loss = 0%, RTA = 0.31 ms |             0 |
| 16 | jholle    | Ping                | 2005-02-18 10:51:03 | PING OK -
Packet loss = 0%, RTA = 0.29 ms |             0 |
| 17 | jholle    | Ping                | 2005-02-18 10:52:03 | PING OK -
Packet loss = 0%, RTA = 0.33 ms |             0 |
| 18 | jholle    | Ping                | 2005-02-18 10:53:03 | PING OK -
Packet loss = 0%, RTA = 0.50 ms |             0 |
| 19 | jholle    | Ping                | 2005-02-18 10:54:03 | PING OK -
Packet loss = 0%, RTA = 0.43 ms |             0 |
| 20 | jholle    | Ping                | 2005-02-18 10:55:03 | PING OK -
Packet loss = 0%, RTA = 0.34 ms |             0
|
+----+-----------+---------------------+---------------------+-------------------------------------------+---------------+
20 rows in set (0.00 sec)

mysql> select * from perfdata_service_bin;
Empty set (0.00 sec)


I the raw data section is all of the right data but in the bin data section
is no data. I thing that no graphs can be established because of this. 

I've read the information from Yve about this site:

http://wiki.perfparse.org/tiki-view_faq.php?faqId=6#q7

And I tested my plugin on the command mode:

nagios@rzvlabwks:/usr/local/nagor/nagios/libexec> ./check_ping -H
172.16.1.114 -w 100.0,20% -c 500.0,60%
PING OK - Packet loss = 0%, RTA = 0.32 ms


And this doesn't look like the right output.

# PROCESS PERFORMANCE DATA OPTION
# This determines whether or not Nagios will process performance
# data returned from service and host checks.  If this option is
# enabled, host performance data will be processed using the
# host_perfdata_command (defined below) and service performance
# data will be processed using the service_perfdata_command (also
# defined below).  Read the HTML docs for more information on
# performance data.
# Values: 1 = process performance data, 0 = do not process performance data

process_performance_data=1



# HOST AND SERVICE PERFORMANCE DATA PROCESSING COMMANDS
# These commands are run after every host and service check is
# performed.  These commands are executed only if the
# enable_performance_data option (above) is set to 1.  The command
# argument is the short name of a command definition that you
# define in your host configuration file.  Read the HTML docs for
# more information on performance data.

host_perfdata_command=process-host-perfdata
service_perfdata_command=process-service-perfdata


This is in my nagios.cfg set. 

And my nagios web interface says:
Performance Data Being Processed?	Yes


But I don't know how I get the bin data...

Please help me....

PS to Ben or Yves: After it all works here I write a conclusion and in which
way I've done this. Should I mail this to you? I can mail it to you in
german and in my broken english... :-)

-- 
DSL Komplett von GMX +++ Supergünstig und stressfrei einsteigen!
AKTION "Kein Einrichtungspreis" nutzen: http://www.gmx.net/de/go/dsl

Re: [Perfparse-users] Problems with MySQL and documentations

[Ben C. <bcl...@pe...>]

Jessica,

There are a few reasons for this.  It may be best to start from the 
beginning.

Can you run a check plugin from the command line and see what you get?

I hope you get something like:

$ libexec/check_load -w 2,2,2 -c 3,3,3
OK - load average: 1.59, 1.33, 1.12|load1=1.59;2.00;3.00;0.00 
load5=1.332.00;3.00;0.00 load15=1.12;2.00;3.00;0.00

You have another problem.

If you get:

$ libexec/check_load -w 2,2,2 -c 3,3,3
OK - load average: 1.59, 1.33, 1.12

You will have to download and install the latest plugins.

Please let us know,

Ben




Jessica Holle wrote:

> I have some more problem, or only one... we will see and I hope aou answer
> quick... :-)
> 
> 
> My SQL database work fine now :-)
> I can say I'm be proud of myself
> 
> But now I have a problems with the bin data... 
> 
> My database looks so:
> 
> mysql> select * from
> perfdata_service_raw;
> +----+-----------+---------------------+---------------------+-------------------------------------------+---------------+
> | id | host_name | service_description | ctime               | txt_data     
>                             | nagios_status
> |
> +----+-----------+---------------------+---------------------+-------------------------------------------+---------------+
> |  1 | jholle    | Ping                | 2005-02-18 10:23:37 | PING OK -
> Packet loss = 0%, RTA = 0.33 ms |             0 |
> |  2 | jholle    | Ping                | 2005-02-18 10:24:37 | PING OK -
> Packet loss = 0%, RTA = 0.29 ms |             0 |
> |  3 | jholle    | Ping                | 2005-02-18 10:25:37 | PING OK -
> Packet loss = 0%, RTA = 0.33 ms |             0 |
> |  4 | jholle    | Ping                | 2005-02-18 10:26:37 | PING OK -
> Packet loss = 0%, RTA = 0.33 ms |             0 |
> |  5 | jholle    | Ping                | 2005-02-18 10:27:37 | PING OK -
> Packet loss = 0%, RTA = 0.34 ms |             0 |
> |  6 | jholle    | Ping                | 2005-02-18 10:28:37 | PING OK -
> Packet loss = 0%, RTA = 0.35 ms |             0 |
> |  7 | jholle    | Ping                | 2005-02-18 10:29:37 | PING OK -
> Packet loss = 0%, RTA = 0.38 ms |             0 |
> |  8 | jholle    | Ping                | 2005-02-18 10:30:37 | PING OK -
> Packet loss = 0%, RTA = 0.31 ms |             0 |
> |  9 | jholle    | Ping                | 2005-02-18 10:31:37 | PING OK -
> Packet loss = 0%, RTA = 0.33 ms |             0 |
> | 10 | jholle    | Ping                | 2005-02-18 10:32:37 | PING OK -
> Packet loss = 0%, RTA = 0.33 ms |             0 |
> | 11 | jholle    | Ping                | 2005-02-18 10:33:37 | PING OK -
> Packet loss = 0%, RTA = 0.29 ms |             0 |
> | 12 | jholle    | Ping                | 2005-02-18 10:46:15 | PING OK -
> Packet loss = 0%, RTA = 0.30 ms |             0 |
> | 13 | jholle    | Ping                | 2005-02-18 10:48:03 | PING OK -
> Packet loss = 0%, RTA = 0.30 ms |             0 |
> | 14 | jholle    | Ping                | 2005-02-18 10:49:03 | PING OK -
> Packet loss = 0%, RTA = 0.34 ms |             0 |
> | 15 | jholle    | Ping                | 2005-02-18 10:50:03 | PING OK -
> Packet loss = 0%, RTA = 0.31 ms |             0 |
> | 16 | jholle    | Ping                | 2005-02-18 10:51:03 | PING OK -
> Packet loss = 0%, RTA = 0.29 ms |             0 |
> | 17 | jholle    | Ping                | 2005-02-18 10:52:03 | PING OK -
> Packet loss = 0%, RTA = 0.33 ms |             0 |
> | 18 | jholle    | Ping                | 2005-02-18 10:53:03 | PING OK -
> Packet loss = 0%, RTA = 0.50 ms |             0 |
> | 19 | jholle    | Ping                | 2005-02-18 10:54:03 | PING OK -
> Packet loss = 0%, RTA = 0.43 ms |             0 |
> | 20 | jholle    | Ping                | 2005-02-18 10:55:03 | PING OK -
> Packet loss = 0%, RTA = 0.34 ms |             0
> |
> +----+-----------+---------------------+---------------------+-------------------------------------------+---------------+
> 20 rows in set (0.00 sec)
> 
> mysql> select * from perfdata_service_bin;
> Empty set (0.00 sec)
> 
> 
> I the raw data section is all of the right data but in the bin data section
> is no data. I thing that no graphs can be established because of this. 
> 
> I've read the information from Yve about this site:
> 
> http://wiki.perfparse.org/tiki-view_faq.php?faqId=6#q7
> 
> And I tested my plugin on the command mode:
> 
> nagios@rzvlabwks:/usr/local/nagor/nagios/libexec> ./check_ping -H
> 172.16.1.114 -w 100.0,20% -c 500.0,60%
> PING OK - Packet loss = 0%, RTA = 0.32 ms
> 
> 
> And this doesn't look like the right output.
> 
> # PROCESS PERFORMANCE DATA OPTION
> # This determines whether or not Nagios will process performance
> # data returned from service and host checks.  If this option is
> # enabled, host performance data will be processed using the
> # host_perfdata_command (defined below) and service performance
> # data will be processed using the service_perfdata_command (also
> # defined below).  Read the HTML docs for more information on
> # performance data.
> # Values: 1 = process performance data, 0 = do not process performance data
> 
> process_performance_data=1
> 
> 
> 
> # HOST AND SERVICE PERFORMANCE DATA PROCESSING COMMANDS
> # These commands are run after every host and service check is
> # performed.  These commands are executed only if the
> # enable_performance_data option (above) is set to 1.  The command
> # argument is the short name of a command definition that you
> # define in your host configuration file.  Read the HTML docs for
> # more information on performance data.
> 
> host_perfdata_command=process-host-perfdata
> service_perfdata_command=process-service-perfdata
> 
> 
> This is in my nagios.cfg set. 
> 
> And my nagios web interface says:
> Performance Data Being Processed?	Yes
> 
> 
> But I don't know how I get the bin data...
> 
> Please help me....
> 
> PS to Ben or Yves: After it all works here I write a conclusion and in which
> way I've done this. Should I mail this to you? I can mail it to you in
> german and in my broken english... :-)
> 


-- 
Ben Clewett  bcl...@pe...
PerfParse    http://www.perfparse.org
PP FAQ       http://wiki.perfparse.org/tiki-list_faqs.php

Re: [Perfparse-users] Problems with MySQL and documentations

[Yves <yme...@pe...>]

> http://wiki.perfparse.org/tiki-view_faq.php?faqId=3D6#q7
>
> And I tested my plugin on the command mode:
>
> nagios@rzvlabwks:/usr/local/nagor/nagios/libexec> ./check_ping -H
> 172.16.1.114 -w 100.0,20% -c 500.0,60%
> PING OK - Packet loss =3D 0%, RTA =3D 0.32 ms
>
> And this doesn't look like the right output.

You are right.
The bug is in the plugin, not in nagios or perfparse.
If ping is not just a test but a real need, check at nagiosplug.sf.net if=
 you have the
latest version of the plugins.
If yes, the only thing I can say is : edit it and fix the bug yourself. M=
aybe somebody
here can help you to do it (not me... lack of time)

If ping was just a test, forget about ping and try a plugin you need : do=
es it return
perfdata (with the pipe '|' character in the output) ?

> PS to Ben or Yves: After it all works here I write a conclusion and in =
which
> way I've done this. Should I mail this to you? I can mail it to you in
> german and in my broken english... :-)

I answer only for me : when all works, a mail should not help a lot. I'm =
more pleased
that you try and try again to use perfparse and send intelligent mails wh=
en you have
problems. I'ts like a cake : I prefer to see you having pleasure to eat t=
he cake than to
know that you finished it :)
If you want to contribute, I see 2 ways to do it at least :
- write down all the questions you asked us or that you asked yourself, w=
rite the
answer, and put them on the wiki.perfparse.org in the FAQ section. This w=
ay, it can help
others in the future.
- write a documentation on how to install perfparse (and nagios too if yo=
u want). I'm
sure that Germans will be happy to have such a documentation in their lan=
guage, not in
English. You can rewrite it in English too if you think you can do it : o=
ur
documentation is so bad now :)

I suggest that you contribute because if somebody had done it before, may=
be you would
read it and install perfparse faster :)

Yves


--=20
- Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
- GPG key     - http://ymettier.free.fr/gpg.txt                    -
- Maitretarot - http://www.nongnu.org/maitretarot/                 -
- Perfparse   - http://www.perfparse.org/                          -

Re: [Perfparse-users] Problems with MySQL and documentations

[Jessica H. <Je...@gm...>]

Yes I found out that it is because of the new version of check_ping.
In our comany we use the new plugins but with the old check_ping...

So I need the plugin with the other output with the '|'

When anybody has an idea or an fixed plugin i'm very very happy.


I've looked to the plugin to write it in the right way, but it is not so
easy if you can't something like perl, c or c++. When I've  found a plugin i
let you know.

But when anybody can help, do this :-)















> > http://wiki.perfparse.org/tiki-view_faq.php?faqId=6#q7
> >
> > And I tested my plugin on the command mode:
> >
> > nagios@rzvlabwks:/usr/local/nagor/nagios/libexec> ./check_ping -H
> > 172.16.1.114 -w 100.0,20% -c 500.0,60%
> > PING OK - Packet loss = 0%, RTA = 0.32 ms
> >
> > And this doesn't look like the right output.
> 
> You are right.
> The bug is in the plugin, not in nagios or perfparse.
> If ping is not just a test but a real need, check at nagiosplug.sf.net if
> you have the
> latest version of the plugins.
> If yes, the only thing I can say is : edit it and fix the bug yourself.
> Maybe somebody
> here can help you to do it (not me... lack of time)
> 
> If ping was just a test, forget about ping and try a plugin you need :
> does it return
> perfdata (with the pipe '|' character in the output) ?
> 
> > PS to Ben or Yves: After it all works here I write a conclusion and in
> which
> > way I've done this. Should I mail this to you? I can mail it to you in
> > german and in my broken english... :-)
> 
> I answer only for me : when all works, a mail should not help a lot. I'm
> more pleased
> that you try and try again to use perfparse and send intelligent mails
> when you have
> problems. I'ts like a cake : I prefer to see you having pleasure to eat
> the cake than to
> know that you finished it :)
> If you want to contribute, I see 2 ways to do it at least :
> - write down all the questions you asked us or that you asked yourself,
> write the
> answer, and put them on the wiki.perfparse.org in the FAQ section. This
> way, it can help
> others in the future.
> - write a documentation on how to install perfparse (and nagios too if you
> want). I'm
> sure that Germans will be happy to have such a documentation in their
> language, not in
> English. You can rewrite it in English too if you think you can do it :
> our
> documentation is so bad now :)
> 
> I suggest that you contribute because if somebody had done it before,
> maybe you would
> read it and install perfparse faster :)
> 
> Yves
> 
> 
> -- 
> - Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
> - GPG key     - http://ymettier.free.fr/gpg.txt                    -
> - Maitretarot - http://www.nongnu.org/maitretarot/                 -
> - Perfparse   - http://www.perfparse.org/                          -
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.

-- 
DSL Komplett von GMX +++ Supergünstig und stressfrei einsteigen!
AKTION "Kein Einrichtungspreis" nutzen: http://www.gmx.net/de/go/dsl

Re: [Perfparse-users] Problems with MySQL and documentations

[Steve G. <st...@ls...>]

On Fri, Feb 18, 2005 at 11:29:07AM +0100, Yves wrote:
> If ping is not just a test but a real need, check at nagiosplug.sf.net
> if you have the latest version of the plugins.

The 1.4 release version of check_ping doesn't do performance data. It's
a little sad, because the big claim of 1.4 is perfdata support, and of
course the first plugin everyone tries is check_ping, and ta-da! it
doesn't do it. This caused me some alarm on my initial testing of 1.4.

The other plagins I've tried *do* do perfdata. 

Steve


-- 
"Outlook not so good." That magic 8-ball knows everything! I'll ask
about Exchange Server next.
                           -- (Stolen from the net)

[Perfparse-users] (no subject)

[Gonzales, Y. <ygo...@me...>]

I am running nagios-2.0b4 and perfparse-0.105.6 on fedora 4 core(Linux
nagios.medassets.com 2.6.12-1.1398_FC4 #1 Fri Jul 15 00:52:32 EDT 2005
i686 i686 i386 GNU/Linux.)

I have everything up and running, but when I go to
/nagios/cgi-bin/perfparse.cgi?all_bin=3D1, the links to the graphs do =
not
work because they do not have the host names in them. If I use the menu
and choose the host, the graphs work, but some of the legends are wrong
- ie the left side of the graph is labeled 21 all the way up and down
the graph.

Any suggestions?

Youn Gonzales
Network Engineer
MedAssets Supply Chain Systems
280 S Mount Auburn Rd
Cape Girardeau, MO  63703
(573) 332-2285  Phone
(573) 332-2300 Fax
ygo...@me...

"The information transmitted is intended only for the person or entity to=
 which it is addressed and may contain confidential, proprietary, and/or =
privileged material. Any review, retransmission, dissemination or other u=
se of, or taking of any action in reliance upon this information by perso=
ns or entities other than the intended recipient is prohibited. If you re=
ceived this in error, please contact the sender and delete the material f=
rom all computers"
=0D

Re: [Perfparse-users] (no subject)

[Yves M. <yme...@li...>]

Back from holidays, but many things to do like always after coming back :=
)
So I answer quick and short.
You talk about perfparse-db-purge, so you have a perfparse version higher=
 than 0.99.03.
I don't remember any bug in that tool after 0.99.03. But please tell us w=
hat version you
are using.

> Hi,
>
> I just tried out the perfparse_db_purge, and I don't know what I'm doin=
g wrong, but I
> won't work properly...but without giving error messages...
> I simply start it from the command-line e.g. with #./perfparse-db-purge=
 -n 1
> The the program seems to run and after a while it returns, that it has =
deleted some
> million lines. Looks fine i think.
> But when I commect to the Database, and do some selects on the perfdata=
_host, or on the
> perfdata_service_raw, I got a lot of Data which is older than this 1 da=
y.

There is something strange.
In my version, perfparse-db-purge does not recognize -n option. So no old=
 data was
removed. Use --del-old 1 instead of -n 1 if you want to remove old lines =
with 0.99.08.

Why did it take so much time ? Because there is a feature that is already=
 implemented in
perfparse-db-purge, but not yet in the CGI. There is a record "is_deleted=
" in some
tables. They are set as 0. If you set it at 1, it will be purged when run=
ning
perfparse-db-purge (and all related data, like binary data and raw data i=
f you remove a
host).
This takes some time.

> Which Data is deleted by the perfparse-db-purge tool?

1/ some data when there is is_deleted set to 1
2/ old data, older than what you specify to --del-old.

> BTW, does perfdata needs the data in the perfdata_service_raw table, or=
 can it be
> deleted after perfparse got its bin-data?

Raw data contain the return of the plugin (the message, the state...)
Bin data contain the perf data, after the | character in the plugin messa=
ge

They are independant. Remove what you like.
Of course, do it at your own risks, we are not responsible for... :)

> Would be great if you guys could post somethng like which table got whi=
ch functions,
> thanks!

Better if there is some document somewhere.

Yves

>
> Regards,
> Philipp
>
>
> _____________________________
>
> Philipp Sand
> OC-CC-TEC-SYS
>
> SYCOR GmbH
> Heinrich-von-Stephan-Stra=DFe 1-5
> D - 37073 G=F6ttingen
>
> Telefon	+49 (0) 551 / 490 - 0
> Telefax	+49 (0) 551 / 490 - 232468
>
> phi...@sy...
> www.sycor.de
> ------------------------------------------------
>
>
>
> ************************************************
>
> sycor plastics - die neue Branchenl=F6sung f=FCr die Kunststoffindustri=
e
>
> www.sycor-plastics.de
>
> ************************************************
>
>
>
>
> Diese E-Mail ist vertraulich und kann dar=FCber hinaus pers=F6nliche In=
formationen
> beinhalten. Wenn Sie nicht der bestimmungsgem=E4=DFe Empf=E4nger sind, =
l=F6schen Sie bitte die
> E-Mail und deren Anh=E4nge sofort und benachrichtigen Sie uns dar=FCber=
. Die Firma sycor
> willigt in keine Vertr=E4ge oder vertragliche Verpflichtungen ein oder =
=FCbermittelt
> rechtsverbindliche Angebote, die in Form von E-Mail versandt werden, so=
fern dies nicht
> ausdr=FCcklich in schriftlicher Form zwischen den Parteien vereinbart w=
urde.
>
> This e-mail is confidential and may contain personal and/or privileged =
information. If
> you are not the intended recipient please delete this e-mail and all at=
tachments
> immediately and inform us. The company sycor does not agree with contra=
cts or contract
> obligations sent by e-mail, neither do we transmit legally binding offe=
rs by e-mail,
> unless this is not expressly agreed upon between the parties and docume=
nted in written
> form.
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>
>


--=20
- Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
- GPG key     - http://ymettier.free.fr/gpg.txt                    -
- Maitretarot - http://www.nongnu.org/maitretarot/                 -
- GTKtalog    - http://www.nongnu.org/gtktalog/                    -

Re: [Perfparse-users] (no subject)

[Ben C. <Be...@cl...>]

Hi Philipp,

Can you tell me which version you are now using?

My guess is that you need to check the deletion policies through the CGI=20
interface.  (Make sure you have set the permissions to view these, look=20
at the perfparse.cfg.example in the latest version.)  This is the only=20
place where you define the length of time the data is stored.

If you want to reset all your deletion policies to some good starting=20
value, there is an option in perfparse-db-tool to set this.  Take a look=20
at the HOWTO for more information.

The raw data in perfdata_service_raw is used to archive the raw output=20
from the plugins, both the state and the textual output.  This has no=20
connection to the binary data used for the graph.  If you want=20
historical information of the state returned by the plugins, this will=20
keep this.  There is also a nice 'outage' report showing for each=20
service, how much time this has been in states OK, WARN, CRITICAL and=20
UNKNOWN.

Hope this is of some use,

Ben


Sand Philipp wrote:

> Hi,
>=20
> I just tried out the perfparse_db_purge, and I don't know what I'm doin=
g wrong, but I won't work properly...but without giving error messages...
> I simply start it from the command-line e.g. with #./perfparse-db-purge=
 -n 1
> The the program seems to run and after a while it returns, that it has =
deleted some million lines. Looks fine i think.
> But when I commect to the Database, and do some selects on the perfdata=
_host, or on the perfdata_service_raw, I got a lot of Data which is older=
 than this 1 day.
> Which Data is deleted by the perfparse-db-purge tool?=20
> BTW, does perfdata needs the data in the perfdata_service_raw table, or=
 can it be deleted after perfparse got its bin-data?
> Would be great if you guys could post somethng like which table got whi=
ch functions, thanks!
>=20
> Regards,
> Philipp=20
> =20
>=20
> _____________________________
>=20
> Philipp Sand
> OC-CC-TEC-SYS
>=20
> SYCOR GmbH
> Heinrich-von-Stephan-Stra=DFe 1-5
> D - 37073 G=F6ttingen
>=20
> Telefon	+49 (0) 551 / 490 - 0
> Telefax	+49 (0) 551 / 490 - 232468
>=20
> phi...@sy...
> www.sycor.de
> ------------------------------------------------
>=20
>=20
>=20
> ************************************************
>=20
> sycor plastics - die neue Branchenl=F6sung f=FCr die Kunststoffindustri=
e
>=20
> www.sycor-plastics.de
>=20
> ************************************************
>=20
>=20
>=20
>=20
> Diese E-Mail ist vertraulich und kann dar=FCber hinaus pers=F6nliche In=
formationen beinhalten. Wenn Sie nicht der bestimmungsgem=E4=DFe Empf=E4n=
ger sind, l=F6schen Sie bitte die E-Mail und deren Anh=E4nge sofort und b=
enachrichtigen Sie uns dar=FCber. Die Firma sycor willigt in keine Vertr=E4=
ge oder vertragliche Verpflichtungen ein oder =FCbermittelt rechtsverbind=
liche Angebote, die in Form von E-Mail versandt werden, sofern dies nicht=
 ausdr=FCcklich in schriftlicher Form zwischen den Parteien vereinbart wu=
rde.
>=20
> This e-mail is confidential and may contain personal and/or privileged =
information. If you are not the intended recipient please delete this e-m=
ail and all attachments immediately and inform us. The company sycor does=
 not agree with contracts or contract obligations sent by e-mail, neither=
 do we transmit legally binding offers by e-mail, unless this is not expr=
essly agreed upon between the parties and documented in written form.
>=20
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>=20