perfparse-users

[Perfparse-users] Newbie's question

[<zs...@ax...>]

Hi List!

Now I use Nagios 1.2 on Debian Woody 3.1 and Nagios-plugins 1.4.0-alpha3. I
read about some "Chart-tool" and I would like to implement PerfPrase, after
migrating to Nagios 2.0.


Before my work I have some unanswered questions (I read through Installation
guide, digging in FAQs, etc.):

1. I like "Method 4 : Ask Nagios to write into a pipe". Is it compatible
with Nagios 2.0?

2. There is a "perfparse_nagios_pipe_command.pl" in Chapter 5| Method 4 of
the Installation Guide. Because I'm not a programmer it would be very good
for me, if I'll be able to download this script. An example is OK, maybe I
can modify it, or revrite in a shell script (I know it better then Perl).
How can I get this script?

3. In Chapter 4 there is: "Please use InnoDB tables ...". What does InnoDB
mean? Hoiw can I configure MySQL to satisfy this requirement?

4. In Chapter 4 there is: "Create a database ... and a user in that
database. NEXT, use the mysql_create script in the contrib directory to
create the necessary tables within the database. Eg, with user 'bob' and
database 'nagios': $ cat mysql_create.sql | mysql -u bob -p -D nagios"

This example do exactly what I have to do, or according to the text before I
run this example I have to create a database and a user in that database? If
this latter case is true how can I do this?

5. Is PerfParse capable to graph Check performance data, or just the Plugin
performance data?

6. How PerfParse graph "data", if there is no data?

7. How Perfparse handle plugin timeouts?

Sorry, if my questions was silly, but I'm not a programmer and not a
Database administrator.

Thank you very much!

I Whish Everybody Merry Christmas!

Tamas!

Re: [Perfparse-users] Newbie's question

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

> Hi List!
>
> Now I use Nagios 1.2 on Debian Woody 3.1 and Nagios-plugins 1.4.0-alpha=
3. I
> read about some "Chart-tool" and I would like to implement PerfPrase, a=
fter
> migrating to Nagios 2.0.
>
>
> Before my work I have some unanswered questions (I read through Install=
ation
> guide, digging in FAQs, etc.):
>
> 1. I like "Method 4 : Ask Nagios to write into a pipe". Is it compatibl=
e
> with Nagios 2.0?

Not tested. But I coded it for easier migration to nagios 2.0 in the futu=
re :)

> 2. There is a "perfparse_nagios_pipe_command.pl" in Chapter 5| Method 4=
 of
> the Installation Guide. Because I'm not a programmer it would be very g=
ood
> for me, if I'll be able to download this script. An example is OK, mayb=
e I
> can modify it, or revrite in a shell script (I know it better then Perl=
).
> How can I get this script?

Download perfparse and find it in the config/ directory.

> 3. In Chapter 4 there is: "Please use InnoDB tables ...". What does Inn=
oDB
> mean? Hoiw can I configure MySQL to satisfy this requirement?

 contrib/mysql_create.sql is a script that does it for you.
What does InnoDB mean ? I don't really know, but ask Ben or read the Mysq=
l documentation :)

> 4. In Chapter 4 there is: "Create a database ... and a user in that
> database. NEXT, use the mysql_create script in the contrib directory to
> create the necessary tables within the database. Eg, with user 'bob' an=
d
> database 'nagios': $ cat mysql_create.sql | mysql -u bob -p -D nagios"
>
> This example do exactly what I have to do, or according to the text bef=
ore I
> run this example I have to create a database and a user in that databas=
e? If
> this latter case is true how can I do this?

You have to create a user and a database yourself.
This is a lack of the documentation.

CREATE DATABASE perfparse;
GRANT ALL ON perfparse.* TO 'perfparse'@'%' IDENTIFIED BY 'password';

Then you have a database called "perfparse", a user "perfparse" with a pa=
ssword "password".

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


> 5. Is PerfParse capable to graph Check performance data, or just the Pl=
ugin
> performance data?

Both
One is perfchart and the other is perfgant.

> 6. How PerfParse graph "data", if there is no data?

I think there is a text to say "no data" or something similar. I don't re=
member what was
done.

> 7. How Perfparse handle plugin timeouts?

This is the job of nagios.
When there is a plugin timeout, nagios does not get the data, and does no=
t send data to
perfparse.

> Sorry, if my questions was silly, but I'm not a programmer and not a
> Database administrator.

I'm not a dba either.
Ben and others may give a better answer about database questions :)

> Thank you very much!
>
> I Whish Everybody Merry Christmas!

You too :)
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://perfparse.sf.net/                           -

Re: [Perfparse-users] Newbie's question

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

Hi Tamas,

These are good questions, expect the FAQ to include these answers soon!

I'll see if I can add anything to Yves reply :)

> 3. In Chapter 4 there is: "Please use InnoDB tables ...". What does InnoDB
> mean? Hoiw can I configure MySQL to satisfy this requirement?

MySQL uses many table types.  The most advances is InnoDB tables. 
(Although not quite the fastest).  I chose these because they offer 
significant advantages:

- Referential Integrity.
- Transactions.
- Concurrent Backup.

These protect the database from corruption.  For instance if a program 
crashes.  They also bind the data together.  You cannot, for instance, 
delete a 'host' if there is still valid data for this host.  Therefore 
avoiding hundreds of meg of data you cannot see or delete without 
specialist coding :)

They also offer concurrent backup.  'Hot Backups'.  You can dump the 
contents of the database without stopping PP.  Even if that dump takes 
many days, you always get a snapshot of how the database was at the 
start of the backup.

More information on InnoDB tables from http://www.innodb.com.


> 6. How PerfParse graph "data", if there is no data?

Any plugin not providing valid graphable (performance) data will not be 
shown to select.  In the future we may change this to list all 
host/service but mark them as containing no data.  If the users wish this :)


> I Whish Everybody Merry Christmas!

Your self as well,

Ben

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

Re: [Perfparse-users] Newbie's question

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

Horváth Tamás wrote:

> 3. In Chapter 4 there is: "Please use InnoDB tables ...". What does InnoDB
> mean? Hoiw can I configure MySQL to satisfy this requirement?

Sorry I missed the second part of your question.

You have to download the 'max' version of MySQL.  Nothing else is required.

Ben



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