perfparse-users — Problems using PerfParse

Re: [Perfparse-users] Fwd: SQL Errors

[Jonnathan C. <jc...@di...>]

Thanks to the help from a couple people on this list I have gotten a lot
farther, but still have no data, hosts, or much of anything displaying
in the perfparse cgi.  I noticed when Perfparse is running that it
creates a file perfdata-service.log, and when Perfpase is no longer
running that the file disappears.  The file size always remains at 0.  I
believe this is where the nagios pipe method should be populating this
file with data but for some reason its not.  I have pasted my perfparse
--show_config below to see if I am missing something obvious.  

Thanks for any input and/or suggestions.

Jon

===

[root@new-host-6 bin]# ./perfparsed --show_config

Perfparsed [options]


# File where Perfparse logs messages
# Error_Log = "string"
Error_Log = "/usr/local/nagios/var/perfparse.log"

# Rotate Perfparse log files
# Error_Log_Rotate = "Y/N"
Error_Log_Rotate = "Yes"


# Keep N days of error log. Compress recent logs and remove too old ones
# Error_Log_Keep_N_Days = "value"
Error_Log_Keep_N_Days = "7"


# When perfparse cannot parse a line, it drops it to that file
# Drop_File = "string"
Drop_File = "/usr/local/nagios/var/perfparse.drop"


# Drop_File_Rotate = "Y/N"
Drop_File_Rotate = "no"


# Keep N days of drop file log. Compress recent logs and remove too old
ones
# Drop_File_Keep_N_Days = "value"
Drop_File_Keep_N_Days = "7"


# Port for perfparsed server
# Put 0 or "" to disable the server
# Server_Port = "value"
Server_Port = "1976"


# Log source from nagios (or other tools) that perfparse will scan
# Authorized values: a file name, '-' for stdin, '|' for a fifo and '>'
for a host:port socket
# For sockets, a command 'history' will be sent before retreiving the
data
# Service_Log = "string"
Service_Log = "|/usr/local/nagios/var/perfdata-service.log"


# Save the read position in the nagios log file ? If yes, perfparse will
start from that position instead of from the beginning
# Service_Log_Save_Position = "Y/N"
Service_Log_Save_Position = "yes"

# Path for files containing the read position for nagios log files
# Service_Log_Position_Mark_Path = "string"
Service_Log_Position_Mark_Path = "/usr/local/nagios/var"

# Lock file for perfparsed
# Daemon_Lock = "string"
Daemon_Lock = "/usr/local/nagios/var/perfparsed.lock"


# Run perfparsed as a daemon
# Daemonize = "Y/N"
Daemonize = "no"


# Perform some periodic cleanup every day
# Periodic_Cleanup = "Y/N"
Periodic_Cleanup = "yes"


# Lock file for perfparsed periodic cleanup process
# Periodic_Cleanup_Lock = "string"

Periodic_Cleanup_Lock =
"/usr/local/nagios/var/perfparsed_periodic_cleanup.lock"


# Perform some periodic cleanup every day at HHMM
# Periodic_Cleanup_Hour = "value"

Periodic_Cleanup_Hour = "0230"


# Dummy hostname if gethostname() does not work
# Dummy_Hostname = "string"
Dummy_Hostname = "dummy"


# Don't store raw data
# No_Raw_Data = "Y/N"
No_Raw_Data = "no"


# Don't store bin data
# No_Bin_Data = "Y/N"
No_Bin_Data = "no"


# Path where storage modules are
# Storage_Modules_Dir = "string"
Storage_Modules_Dir = "/usr/local/nagios/lib"

# Modules to load (Coma separated values)
# Storage_Modules_Load = "string"
Storage_Modules_Load = "mysql"

# File to contain Storage Modules Status
# Storage_Modules_Status_File = "string"
Storage_Modules_Status_File =
"/usr/local/nagios/var/storage_modules.status"

# Storage Module : mysql
# ==============================

# Database user
# DB_User = "string"
DB_User = "nagios"


# Database password
# DB_Pass = "string"
DB_Pass = "nagios"


# Database name
# DB_Name = "string"
DB_Name = "nagios"


# Database hostname
# DB_Host = "string"
DB_Host = "localhost.localdomain"

Re: [Perfparse-users] Fwd: SQL Errors

[Jonnathan C. <jc...@di...>]

I finally got to the bottom of these errors and got the databases
"installed" or --updated as the case may be.  Now I can load the CGI and
see the administration page.  The problem is I am getting no data from
Nagios.  I have checked and double checked my settings.  I feel like i
may be missing something obvious....what can I post to help people help
me?  Sorry -- I am new to Nagios as well as Perfparse...

Thanks!

On Fri, 2005-09-23 at 11:47 -0700, Jonnathan Colt wrote:
> When I run --update for databases I get (see below) -- any ideas?
> 
> [root@new-host-6 bin]# ./perfparse-db-tool  --update
> Auto-convert database up to version 0.19...
> 
> Starting...
> 
> Warning, this stage may take some time:
> An error occured with the SQL:
> 
>   "CREATE TABLE IF NOT EXISTS perfdata_bin_summary_data (
> metric_id INT NOT NULL, frequency INT NOT NULL, ctime DATETIME NOT NULL,
> PRIMARY KEY (metric_id, frequency, ctime),      FOREIGN KEY (metric_id,
> frequency)             REFERENCES perfdata_bin_summary_header
> (metric_id, frequency)            ON DELETE RESTRICT,     val_count
> INTEGER NOT NULL DEFAULT 0,   sum_val DOUBLE NOT NULLsum_square_val
> DOUBLE NOT NULL,  max_val DOUBLE NOT NULL,        min_val DOUBLE NOT
> NULL,        max_warn DOUBLE NOT NULL,       min_warn DOUBLE NOT NULL,
> max_critical DOUBLE NOT NULL,    min_critical DOUBLE NOT
> NULL            ) type=InnoDB"
> 
> Failure Message:
> 
>   "Can't create table './nagios/perfdata_bin_summary_data.frm' (errno:
> 150)"
> 
> 
> 
> Thanks,
> Jonnathan
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. 
> Download it for free - -and be entered to win a 42" plasma tv or your very
> own Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users

[Perfparse-users] Fwd: SQL Errors

[Jonnathan C. <jc...@di...>]

When I run --update for databases I get (see below) -- any ideas?

[root@new-host-6 bin]# ./perfparse-db-tool  --update
Auto-convert database up to version 0.19...

Starting...

Warning, this stage may take some time:
An error occured with the SQL:

  "CREATE TABLE IF NOT EXISTS perfdata_bin_summary_data (
metric_id INT NOT NULL, frequency INT NOT NULL, ctime DATETIME NOT NULL,
PRIMARY KEY (metric_id, frequency, ctime),      FOREIGN KEY (metric_id,
frequency)             REFERENCES perfdata_bin_summary_header
(metric_id, frequency)            ON DELETE RESTRICT,     val_count
INTEGER NOT NULL DEFAULT 0,   sum_val DOUBLE NOT NULLsum_square_val
DOUBLE NOT NULL,  max_val DOUBLE NOT NULL,        min_val DOUBLE NOT
NULL,        max_warn DOUBLE NOT NULL,       min_warn DOUBLE NOT NULL,
max_critical DOUBLE NOT NULL,    min_critical DOUBLE NOT
NULL            ) type=InnoDB"

Failure Message:

  "Can't create table './nagios/perfdata_bin_summary_data.frm' (errno:
150)"



Thanks,
Jonnathan

[Perfparse-users] upgrade and database size

[Steinbacher M. <man...@sc...>]

Hallo

=20

I have perfparse 0.100.6 in use. Can I upgrade to the latest version.

=20

An other problem is the size of the ibdata1 file. It=B4s now 15 GB and =
how can I solve this.=20

=20

Thanks

manfred

=20

=20

[Perfparse-users] perfparse-log2mysql doesn't load 2 MYsql

[John C. <po...@ya...>]

Hi Gurus,

I'm trying to integrate nagios and perfparse using
Method 1: Periodic Nagios Log Parse. (I've abandoned
pipes for now.)

As far as I know, MySQL, perfparsed, and Nagios are
all running fine. When I try to perfparse-log2mysql
the following error is recorded:

foohost:/usr/local/nagios/bin # ./perfparse-log2mysql
-e log2mysql.error -r
foohost:/usr/local/nagios/bin # echo $?
1
foohost:/usr/local/nagios/bin # tail
log2mysql.error.20050915.log
2005/09/15 10:09:41 [   storage.c:95    113   ]
storage_mysql module successfully loaded
2005/09/15 10:10:32 [      dbms.c:306   113   ] INSERT
INTO perfdata_registry (host,rkey, rvalue,ctime)
VALUES ('dummy','pp/perfparse/version', '0.105.6',
FROM_UNIXTIME(1126793381))  (Lock wait timeout
exceeded; try restarting transaction)

I've tried restarting services, stop/starting mysql,
but the error persists. This host is not a busy box.
Mysql is dedicated to perfparse.

Is this a bug?
Any suggestions are greatly appreciated!

BTW: Does anyone have perfparse with nagios working on
Solaris 9 using ANY method? Care to share your exact
configs? I'm going nutty with this stuff.

Nagios 2.0b4
# ./configure  --with-command-group=nobody
--enable-embedded-perl --with-perlcache
--with-file-perfdata

PerfParse v0.105.6
Solaris 9 112233-12

##################################
BACKGROUND:

##################################
START DATABASE:

foohost:/usr/local/nagios #
/usr/local/mysql/bin/mysqld_safe &
[1]     29613
foohost:/usr/local/nagios # Starting mysqld daemon
with databases from /usr/local/mysql/var

##################################
LOGIN TO DATABASE:

foohost:/usr/local/nagios # mysql --user=perfparse -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or
\g.
Your MySQL connection id is 1 to server version:
4.1.14-log

Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.

mysql>

##################################
CHECK 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)

##################################
START PERFPARSED:

foohost:/usr/local/nagios # ./bin/perfparsed -e
pperror -d
foohost:/usr/local/nagios # echo $?
0
foohost:/usr/local/nagios # ps -ef | grep perfparsed
    root 29649     1  9 10:00:15 ?        0:09
./bin/perfparsed -e pperror -d
    root 29654 28005  0 10:00:24 pts/2    0:00 grep
perfparsed
foohost:/usr/local/nagios # tail
var/pperror.20050915.log
2005/09/15 10:00:15 [perfparsed.c:176   29649 ]
Perfparsed successfully daemonized (pid=29649)
2005/09/15 10:00:15 [   storage.c:95    29649 ]
storage_mysql module successfully loaded
2005/09/15 10:00:15 [   storage.c:264   29652 ]
Perfparsed : periodic cleanup

##################################
START NAGIOS:

foohost:/usr/local/nagios # /etc/init.d/nagios start
Starting network monitor: nagios

foohost:/usr/local/nagios # echo $?
0
foohost:/usr/local/nagios # ps -ef | grep nagios
  nagios 29683     1  0 10:01:23 ?        0:00
/usr/local/nagios/bin/nagios -d
/usr/local/nagios/etc/nagios.cfg
    root 29705 28005  0 10:01:43 pts/2    0:00 grep
nagios

foohost:/usr/local/nagios # tail var/nagios.log
[1126792883] Nagios 2.0b4 starting... (PID=29682)
[1126792883] LOG VERSION: 2.0
[1126792883] Finished daemonizing... (New PID=29683)

##################################
VERIFY PERFORMANCE DATA IS BEING PRODUCED:

foohost:/usr/local/nagios/var # tail
perfdata-service.log
[SERVICEPERFDATA]       1126792913      foohost CPU
Load        0.083   0.108   CPU Load 2% (15 min
average)    '15 min avg Load'=2%;90;98;0;100
[SERVICEPERFDATA]       1126792923      foohost     
Check disk via NRPE     0.082   0.048   DISK OK - free
space: / 1790 MB (92%): /usr 3436 MB (70%): /var 3966
MB (86%): /tmp 19510 MB (100%): /opt 4841 MB (98%):
/dev_backup 25811 MB (87%): /ora 4352 MB (11%):
/export/home 1811 MB (93%):   
/=148MB;1744;1841;0;1938 /usr=1487MB;4429;4675;0;4922
/var=655MB;4158;4389;0;4621
/tmp=11MB;17568;18544;0;19521
/opt=82MB;4429;4675;0;4922 /dev_back
[SERVICEPERFDATA]       1126792923      foohost   
PING    4.033   0.138   PING OK - Packet loss = 0%,
RTA = 0.00 ms
[SERVICEPERFDATA]       1126792933      foohost      
Check disk via NRPE     0.082   0.257   DISK OK - free
space: / 1789 MB (92%): /usr 2682 MB (54%): /var 1371
MB (30%): /tmp 21153 MB (100%): /opt 1620 MB (33%):
/export/home 1519 MB (78%):   
/=150MB;1744;1841;0;1938 /usr=2240MB;4429;4675;0;4922
/var=3250MB;4158;4389;0;4621
/tmp=9MB;19044;20102;0;21161
/opt=3302MB;4429;4675;0;4922
/export/home=420MB;1744;1841;0;1938
[SERVICEPERFDATA]       1126792933      foohost      
Check disk via NRPE     0.081   0.007   DISK OK - free
space: / 1786 MB (92%): /usr 8099 MB (82%): /var 14202
MB (98%): /tmp 14617 MB (100%): /opt 12460 MB (84%):
/export/home 6550 MB (67%):  /=152MB;1744;1841;0;1938
/usr=1745MB;8858;9350;0;9843
/var=265MB;13019;13742;0;14466
/tmp=8MB;13162;13893;0;14625
/opt=2306MB;13289;14027;0;14766
/export/home=3294MB;8858;9350;0;9843
[SERVICEPERFDATA]       1126792943      foohost   
Check disk via NRPE     0.082   0.178   DISK WARNING -
free space: / 1688 MB (28%): /var 1175 MB (59%): /tmp
8904 MB (96%): /dev_backup 14673 MB (43%): /backup2
3043 MB (75%): /ora 698 MB (7%): /var/mqm 3991 MB
(99%):       /=4360MB;5442;5744;0;6047
/var=830MB;1804;1904;0;2005
/tmp=336MB;8316;8778;0;9240
/dev_backup=19515MB;30769;32478;0;34188
/backup2=989MB;3627;3829;0;4031 /ora=9382MB;9
[SERVICEPERFDATA]       1126792943      foohost  Check
disk via NRPE     0.080   0.127   DISK OK - free
space: / 4782 MB (97%): /usr 4580 MB (66%): /var 12334
MB (90%): /tmp 38579 MB (100%): /opt 7796 MB (99%):
/export/home 3896 MB (99%):   /=145MB;4434;4680;0;4927
/usr=2315MB;6205;6550;0;6895
/var=1398MB;12357;13044;0;13731
/tmp=9MB;34728;36657;0;38587
/opt=88MB;7094;7488;0;7883
/export/home=49MB;3549;3746;0;3944
[SERVICEPERFDATA]       1126792953      foohost  SSH  
  0.045   0.076   SSH OK - OpenSSH_4.0 (protocol 2.0)
[SERVICEPERFDATA]       1126792953      foohost 
Service-A       7.004   0.171   HTTP OK HTTP/1.1 200
OK - 6.969 second response time   
time=6.968852s;7.000000;15.000000;0.000000
size=1181B;;;0
[SERVICEPERFDATA]       1126792953      foohost  SSH  
  0.047   0.026   SSH OK - OpenSSH_4.0 (protocol 2.0)


##################################
So at this point, MySQL is running, perfparsed is
running, and Nagios is running. Nagios is logging
performance data to
/usr/local/nagios/var/perfdata-service.log

foohost:/usr/local/nagios # cd bin
foohost:/usr/local/nagios/bin # ./perfparse-log2mysql
-e log2mysql.error -r
foohost:/usr/local/nagios/bin # echo $?
1
foohost:/usr/local/nagios/bin # tail
log2mysql.error.20050915.log
2005/09/15 10:09:41 [   storage.c:95    113   ]
storage_mysql module successfully loaded
2005/09/15 10:10:32 [      dbms.c:306   113   ] INSERT
INTO perfdata_registry (host,rkey, rvalue,ctime)
VALUES ('dummy','pp/perfparse/version', '0.105.6',
FROM_UNIXTIME(1126793381))  (Lock wait timeout
exceeded; try restarting transaction)




		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com

Re: [Perfparse-users] Question about the perfparse pipe method

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

I have not worked on it for a long time, but I remember that I wrote the =
stdout plugin
for that.
Try to load your favorite plugin and the stdout plugin. Then use the outp=
ut of the
stdout plugin to inject the data into your other program.

Yves

> Perhaps you could use "tee"? I've not used it in your
> specific scenario, but maybe it will get you moving
> down a good path.
>
> Maybe some of the examples here will help
> http://www.cpqlinux.com/redirect.html
>
> HTH!
> -John
>
> --- John Vincent <lus...@gm...> wrote:
>
>> We've been using the perfparse pipe method
>> successfully for over a year now.
>> We're very happy with the whole setup.
>>
>> However I have a need where I need to create rrdtool
>> style graphs with
>> multiple values. What I would like to do is monitor
>> the pipe with an
>> external process and insert the data into an rrd
>> file for creating these
>> graphs. I don't want to run another monitor and
>> double the number of times I
>> poll a server. I'm getting the data I need from
>> Nagios just fine.
>>
>> From my own tests with creating a pipe and running
>> two tail sessions against
>> the pipe, only the last attached reader gets the
>> data from the pipe. Is
>> there a safe way to from the perfparse pipe so that
>> I don't interrupt
>> perfparse and cause missed perfomance data?
>>
>> This is probably more of a general Linux question
>> but for some reason, the
>> answer seems to be eluding me.
>>
>> Thanks.
>>
>> --
>> John E. Vincent
>> lus...@gm...
>>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server.
> Download it for free - -and be entered to win a 42" plasma tv or your v=
ery
> own Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.p=
hp
> _______________________________________________
> 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/                 -
- Perfparse   - http://www.perfparse.org/                          -

[Perfparse-users] Re: [Nagios-users] perfparse doesn't display hosts, services - UPDATE

[John C. <po...@ya...>]

Oops. I should also have included this handy message
from nagios.log:

[1126658872] Nagios 2.0b4 starting... (PID=28393)
[1126658872] LOG VERSION: 2.0
[1126658872] Finished daemonizing... (New PID=28394)
[1126658872] Warning: File
'/usr/local/nagios/var/perfdata-service.log' could not
be opened - service performance data will not be
written to file!


--- John Christian <po...@ya...> wrote:

> Hi Gurus,
> 
> I'm trying to integrate PerfParse with Nagios. When
> I
> access the PerfData Graphs page, I get the PerfParse
> logo, but no hosts or services are listed. I read
> that
> these fields should be auto-populated if the
> performance data is being delivered correctly. As a
> result, I suspect the performance data is not making
> it all the way to PerfParse.
> 
> Nagios is logging performance data when I point it
> to
> a file. But when I connect Nagios to PerfParse via a
> pipe, I don't know how to check that the performance
> data is going into the pipe or arriving in the MySQL
> database. How do I "look" at the pipe? Or view the
> contents of the 'perfparse' database in MySQL?
> 
> Any suggestions on what may be broken or how to
> continue diagnosing the problem? TIA! -John
> 
> Additional Info:
> 
> Nagios 2.04b
> PerfParse v0.105.6
> SunOS 5.9 Generic_112233-12 Sun-Fire-880
> 
> It seems PerfParse can connect to the MySQL
> database:
> /usr/local/nagios/bin/check_perfparse_version
> OK Perfparse Database Version Correct: 0.19. |
> pp_ver=0.19 true_ver=0.19
> 
> I start perfparsed first and it creates a pipe in
> /usr/local/nagios/var:
> prw-r-----   1 root     other          0 Sep 13
> 12:08
> perfdata-service.log
> ...Then I start nagios and it seems to run fine,
> perform checks, and provide the normal web
> interface. 
> 
> 
> Relevent entries from nagios.cfg:
> 
> cfg_file=/usr/local/nagios/etc/nagios_perfparse.cfg
> nagios_user=nagios
> nagios_group=nagios
> perfdata_timeout=5
> process_performance_data=1
> host_perfdata_command=process-host-perfdata
> service_perfdata_command=process-service-perfdata
>
service_perfdata_file=/usr/local/nagios/var/perfdata-service.log
>
host_perfdata_file_template=[HOSTPERFDATA]\t$TIMET$\t$HOSTNAME$\t$HOSTEXECUTIONTIME$\t$HOSTOUTPUT$\t$HOSTPERFDATA$
>
service_perfdata_file_template=[SERVICEPERFDATA]\t$TIMET$\t$HOSTNAME$\t$SERVICEDESC$\t$SERVICEEXECUTIONTIME$\t$SERVICELATENCY$\t$SERVICEOUTPUT$\t$SERVICEPERFDATA$
> #host_perfdata_file_mode=a
> #service_perfdata_file_mode=a
> #host_perfdata_file_processing_interval=0
> #service_perfdata_file_processing_interval=0
>
#host_perfdata_file_processing_command=process-host-perfdata-file
>
#service_perfdata_file_processing_command=process-service-perfdata-file
> 
> 
> Relevent entries from nagios_perfparse.cfg:
> 
> define command{
>         command_name    process-service-perfdata
>         command_line   
>
/usr/local/nagios/bin/perfparse_nagios_pipe_command.pl
> "$TIMET$" "$HOSTNAME$" "$SERVICEDESC$" "$OUTPUT$"
> "$SERVICESTATE$" "$PERFDATA$"
>         }
> 
> define command{
>         command_name    process-host-perfdata
>         command_line   
>
/usr/local/nagios/bin/perfparse_nagios_pipe_command.pl
> "$TIMET$" "$HOSTNAME$" "$OUTPUT$" "$PERFDATA$"
>         }
> 
> 
> Relevent entries from perfparse.cfg:
> 
> Service_Log =         
> "|/usr/local/nagios/var/perfdata-service.log"
> Host_Log =         
> "|/usr/local/nagios/var/perfdata-host.log"
> Storage_Modules_Load = "mysql"
> 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam
> protection around 
> http://mail.yahoo.com 
> 
> 
>
-------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's
> Geronimo App Server. 
> Download it for free - -and be entered to win a 42"
> plasma tv or your very
> own Sony(tm)PSP.  Click here to play:
> http://sourceforge.net/geronimo.php
> _______________________________________________
> Nagios-users mailing list
> Nag...@li...
>
https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version
> (-v) and OS when reporting any issue. 
> ::: Messages without supporting info will risk being
> sent to /dev/null
> 



		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com

Re: [Perfparse-users] Question about the perfparse pipe method

[John C. <po...@ya...>]

Perhaps you could use "tee"? I've not used it in your
specific scenario, but maybe it will get you moving
down a good path.

Maybe some of the examples here will help
http://www.cpqlinux.com/redirect.html

HTH!
-John

--- John Vincent <lus...@gm...> wrote:

> We've been using the perfparse pipe method
> successfully for over a year now. 
> We're very happy with the whole setup.
> 
> However I have a need where I need to create rrdtool
> style graphs with 
> multiple values. What I would like to do is monitor
> the pipe with an 
> external process and insert the data into an rrd
> file for creating these 
> graphs. I don't want to run another monitor and
> double the number of times I 
> poll a server. I'm getting the data I need from
> Nagios just fine.
> 
> From my own tests with creating a pipe and running
> two tail sessions against 
> the pipe, only the last attached reader gets the
> data from the pipe. Is 
> there a safe way to from the perfparse pipe so that
> I don't interrupt 
> perfparse and cause missed perfomance data?
> 
> This is probably more of a general Linux question
> but for some reason, the 
> answer seems to be eluding me.
> 
> Thanks.
> 
> -- 
> John E. Vincent
> lus...@gm...
> 



		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com

[Perfparse-users] perfparse doesn't display hosts, services

[John C. <po...@ya...>]

Hi Gurus,

I'm trying to integrate PerfParse with Nagios. When I
access the PerfData Graphs page, I get the PerfParse
logo, but no hosts or services are listed. I read that
these fields should be auto-populated if the
performance data is being delivered correctly. As a
result, I suspect the performance data is not making
it all the way to PerfParse.

Nagios is logging performance data when I point it to
a file. But when I connect Nagios to PerfParse via a
pipe, I don't know how to check that the performance
data is going into the pipe or arriving in the MySQL
database. How do I "look" at the pipe? Or view the
contents of the 'perfparse' database in MySQL?

Any suggestions on what may be broken or how to
continue diagnosing the problem? TIA! -John

Additional Info:

Nagios 2.04b
PerfParse v0.105.6
SunOS 5.9 Generic_112233-12 Sun-Fire-880

It seems PerfParse can connect to the MySQL database:
/usr/local/nagios/bin/check_perfparse_version
OK Perfparse Database Version Correct: 0.19. |
pp_ver=0.19 true_ver=0.19

I start perfparsed first and it creates a pipe in
/usr/local/nagios/var:
prw-r-----   1 root     other          0 Sep 13 12:08
perfdata-service.log
...Then I start nagios and it seems to run fine,
perform checks, and provide the normal web interface. 


Relevent entries from nagios.cfg:

cfg_file=/usr/local/nagios/etc/nagios_perfparse.cfg
nagios_user=nagios
nagios_group=nagios
perfdata_timeout=5
process_performance_data=1
host_perfdata_command=process-host-perfdata
service_perfdata_command=process-service-perfdata
service_perfdata_file=/usr/local/nagios/var/perfdata-service.log
host_perfdata_file_template=[HOSTPERFDATA]\t$TIMET$\t$HOSTNAME$\t$HOSTEXECUTIONTIME$\t$HOSTOUTPUT$\t$HOSTPERFDATA$
service_perfdata_file_template=[SERVICEPERFDATA]\t$TIMET$\t$HOSTNAME$\t$SERVICEDESC$\t$SERVICEEXECUTIONTIME$\t$SERVICELATENCY$\t$SERVICEOUTPUT$\t$SERVICEPERFDATA$
#host_perfdata_file_mode=a
#service_perfdata_file_mode=a
#host_perfdata_file_processing_interval=0
#service_perfdata_file_processing_interval=0
#host_perfdata_file_processing_command=process-host-perfdata-file
#service_perfdata_file_processing_command=process-service-perfdata-file


Relevent entries from nagios_perfparse.cfg:

define command{
        command_name    process-service-perfdata
        command_line   
/usr/local/nagios/bin/perfparse_nagios_pipe_command.pl
"$TIMET$" "$HOSTNAME$" "$SERVICEDESC$" "$OUTPUT$"
"$SERVICESTATE$" "$PERFDATA$"
        }

define command{
        command_name    process-host-perfdata
        command_line   
/usr/local/nagios/bin/perfparse_nagios_pipe_command.pl
"$TIMET$" "$HOSTNAME$" "$OUTPUT$" "$PERFDATA$"
        }


Relevent entries from perfparse.cfg:

Service_Log =         
"|/usr/local/nagios/var/perfdata-service.log"
Host_Log =         
"|/usr/local/nagios/var/perfdata-host.log"
Storage_Modules_Load = "mysql"



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Perfparse-users] Question about the perfparse pipe method

[John V. <lus...@gm...>]

We've been using the perfparse pipe method successfully for over a year now=
.=20
We're very happy with the whole setup.

However I have a need where I need to create rrdtool style graphs with=20
multiple values. What I would like to do is monitor the pipe with an=20
external process and insert the data into an rrd file for creating these=20
graphs. I don't want to run another monitor and double the number of times =
I=20
poll a server. I'm getting the data I need from Nagios just fine.

From my own tests with creating a pipe and running two tail sessions agains=
t=20
the pipe, only the last attached reader gets the data from the pipe. Is=20
there a safe way to from the perfparse pipe so that I don't interrupt=20
perfparse and cause missed perfomance data?

This is probably more of a general Linux question but for some reason, the=
=20
answer seems to be eluding me.

Thanks.

--=20
John E. Vincent
lus...@gm...

[Perfparse-users] changing groups

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

I accidentally put a host in the wrong group and I can't figure out how
to remove it. 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] Graphs

[Garrett H. <gh...@3g...>]

Use check_icmp instead.

On Thu, 2005-09-08 at 13:18 -0500, Gonzales, Youn wrote:
> I am running PerfParse v0.105.6 and Nagios 2.0b4. The performance graphs
> work on all of the services I have setup so far except check_ping. Is
> there an alternative to check_ping that will let us graph the ping times
> to different network devices or am I just missing something in the
> config?
> 
> My generic-service config:
> define service{
> 	name                            generic-service
> active_checks_enabled           1
> 	passive_checks_enabled          1
> 	parallelize_check               1
> 	obsess_over_service             1
> 	check_freshness                 0
> 	notifications_enabled           1
> 	event_handler_enabled           1
> 	flap_detection_enabled          1
> 	failure_prediction_enabled      1
> 	process_perf_data               1
> 	retain_status_information       1
> 	retain_nonstatus_information    1
> 	register                        0
> 	}
> 
> 
> One of my host configs:
> define service{
> 	use                             generic-service
> 	host_name                       uscpg1stwap1
> 	service_description             PING
> 	is_volatile                     0
> 	check_period                    24x7
> 	max_check_attempts              4
> 	normal_check_interval           5 
> 	retry_check_interval            1
> 	contact_groups                  admins
> 	notification_interval           960
> 	notification_period             24x7
> 	check_command                   check_ping!100.0,20%!500.0,60%
> 	}
> 
> 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 use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all computers"
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
-- 
// Garrett Honeycutt
// Sr. Systems Administrator
// 3GUpload.com, Inc.
// 317.472.4969 Office

[Perfparse-users] Graphs

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

I am running PerfParse v0.105.6 and Nagios 2.0b4. The performance graphs
work on all of the services I have setup so far except check_ping. Is
there an alternative to check_ping that will let us graph the ping times
to different network devices or am I just missing something in the
config?

My generic-service config:
define service{
	name                            generic-service
active_checks_enabled           1
	passive_checks_enabled          1
	parallelize_check               1
	obsess_over_service             1
	check_freshness                 0
	notifications_enabled           1
	event_handler_enabled           1
	flap_detection_enabled          1
	failure_prediction_enabled      1
	process_perf_data               1
	retain_status_information       1
	retain_nonstatus_information    1
	register                        0
	}


One of my host configs:
define service{
	use                             generic-service
	host_name                       uscpg1stwap1
	service_description             PING
	is_volatile                     0
	check_period                    24x7
	max_check_attempts              4
	normal_check_interval           5=20
	retry_check_interval            1
	contact_groups                  admins
	notification_interval           960
	notification_period             24x7
	check_command                   check_ping!100.0,20%!500.0,60%
	}

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

[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

[Perfparse-users] RE: DB mantainance

[Philip V. <ph...@we...>]

I also had this problem, try using the --no_transactions option:

$ perfparse-db-purge -r --no_transactions


Philip


-----Original Message-----
From: per...@li...
[mailto:per...@li...] On Behalf Of
Daniele Coli`
Sent: Monday, 8 August 2005 9:50 PM
To: per...@li...
Subject: [Perfparse-users] DB mantainance

Hi folks,
I'm using perfparse 0.105.6 with nagios to monitor a large network=20
environment; so my Db has grown up to 9 GB. I scheduled every week to=20
call the program perfparse-db-purge in order to keep only last three=20
month, but last time it ended with the error:

An error occurred with the SQL:

   "DELETE perfdata_service_raw FROM perfdata_service_raw,perfdata_host=20
WHERE perfdata_service_raw.host_name =3D perfdata_host.host_name AND=20
perfdata_host.is_deleted =3D 1"

Failure Message:

   "The total number of locks exceeds the lock table size"

I'm running MySQL 4.1.10 (ver. 14.7) on FreeBSD 5.3, but I'm not very=20
familiar with MySQL.

Can someone help me?

Thanks.

Daniele Coli`


-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle
Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing &
QA
Security * Process Improvement & Measurement *
http://www.sqe.com/bsce5sf
_______________________________________________
Perfparse-users mailing list
Per...@li...
https://lists.sourceforge.net/lists/listinfo/perfparse-users

[Perfparse-users] DB mantainance

[Daniele C. <dan...@ti...>]

Hi folks,
I'm using perfparse 0.105.6 with nagios to monitor a large network 
environment; so my Db has grown up to 9 GB. I scheduled every week to 
call the program perfparse-db-purge in order to keep only last three 
month, but last time it ended with the error:

An error occurred with the SQL:

   "DELETE perfdata_service_raw FROM perfdata_service_raw,perfdata_host 
WHERE perfdata_service_raw.host_name = perfdata_host.host_name AND 
perfdata_host.is_deleted = 1"

Failure Message:

   "The total number of locks exceeds the lock table size"

I'm running MySQL 4.1.10 (ver. 14.7) on FreeBSD 5.3, but I'm not very 
familiar with MySQL.

Can someone help me?

Thanks.

Daniele Coli`

[Perfparse-users] compile time issues with perfparse while trying to install on AIX

[Ryan W G. <rw...@us...>]

Hi, I have recently been trying to install perfparse to go along with t=
he
current nagios setup which I have gotten to run on the AIX machine that=
 I
was given. I ran into trouble when compiling. When I run make, I get th=
e
message "ld: 0711-317 ERROR: Undefined symbol: .rpl_malloc" as well as =
"ld:
0711-317 ERROR: Undefined symbol: .rpl_realloc"  I know that this is du=
e to
imcompatibilities between autoconf and AIX malloc and realloc.

I have removed the AC_FUNC_MALLOC and AC_FUNC_REALLOC lines from
configure.ac and rebuilt the package (libtoolize -f;aclocal -I
m4;autoconf;autoheader;automake -a -c) and this will allow the package =
to
build, however, running any of the tools installed from this build resu=
lts
in a seg fault (ex. perfparse-db-tool, perfparsed).

Thus, I am wondering if you have any suggestions as to getting perfpars=
e to
compile and run on AIX. Listed below are some of the basic parameters o=
f
the system that relate to the installation of perfparse.

Thanks,
Ryan


System Info:

perfarse: LDFLAGS=3D"-L/usr/local/lib" ./configure --prefix=3D/usr/loca=
l/nagios
--with-imagedir=3D/usr/local/nagios/share/images
--with-cgidir=3D/usr/local/nagios/sbin --with-http_image_path=3D/nagios=
/images
--with-mysql_config_dir=3D/usr/local/mysql/bin
--with-gdlib_config_dir=3D/usr/local/bin

AIX 5.3

Gcc version 3.3.2 configured with: ../configure --with-as=3D/usr/bin/as=

--with-ld=3D/usr/bin/ld --disable-nls --enable-languages=3Dc,c++
--prefix=3D/opt/freeware --enable-threads
--enable-version-specific-runtime-libs --host-powerpc-ibm-aix5.3.0.0

GD Library: 2.0.33
includedir: /usr/local/include
cflags: -I/usr/local/include
ldflags: -L/opt/freeware/lib -L/usr/lib/lib
libs: -ljpeg, -lfreetype -lpng -lz -lm -liconv
libdir: /usr/local/lib
features: GD_JPEG GD_FREETYPE GD_PNG GD_GIF

MySQL: 4.0.25
cflags: -I/sr/local/mysql/include/mysql
include: -I/usr/local/mysql/include/mysql
libs: -L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lcrypt
libs_r: -L/usr/local/mysql/lib/mysql -lmysqlclient_r -lz -lcrypt -lnsl_=
r
-lm -lpthread
libmysqld-libs: -L/usr/local/mysql/lib/mysql -lmysqld -lz -lcrypt -lnsl=
_r
-lm -lpthread -lrt

Glib: 2.2.3
cflags: -I/opt/freeware.include/glib-2.0 -I/opt/freeware/lib/glib-2.0
/include
libs: -L/opt/freeware/lib -lglib-2.0 -lintl -liconv

pkg-config 0.15=

[Perfparse-users] Nagios hangs with perfparse enabled

[Richard D. <de...@ya...>]

I have been running Nagios 1.2 on a older host and
decided to upgrade the existing version to a new
server with more power (load was 5+ on older system). 
The changes were also:

1.  RHES3 => RHES4
2.  Nagios pluging 1.3.x to 1.4
3.  Enabled MySQL 4.1.x

The initial migration of the Nagios 1.2 went as
planned and everything in Nagios worked as expected.  
I then went to add perfparse using the older default
cron job perfparse.sh method to start and learn how it
worked.  Initially, everything was working and MySQL
was updating.  

So after doing a few QA days, I put the new system
into full production.  Everthing started out okay, but
I found the next morning that Nagios itself was hung. 
I got Nagios restarted and monitored.  Nagios hung
again after several hours.  The time factor varied so
it was from a few to over 12 hours, but when Nagios
hung,the processes would all be in a write state
(strace check).  I needed to killall to remove the
hung Nagios processes.  I did this a few more times to
verify, then backed out perfparse (commented out
nagios.cfg section and disabled by setting
process_performance_data=0).  I commented out the cron
job which was running every 10 minutes.  I reboot the
system to be sure and Nagios has been up and
processing (load now 0.5) without any hanging.  

The question is, has anyone had this experience and
what can I do about it.  I want to capture the data
with perfparse and will use an alternative method as
suggested.  Again, any advice on setting up perfparse
to avoid this hanging.  If you need more data, I can
get that too.

Thanks,

Richard


		
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs 
 

Re: [Perfparse-users] performance data in Nagios

[Garrett H. <gh...@3g...>]

On Mon, 2005-07-18 at 14:54 +0200, Frederik Vanhee wrote:
> Hello,
> 
> I'm doing some experiments with performance data, but experience some 
> strange behaviour
> I have a plugin 'check_iftraffic.pl' that returns this :
> 
> Total RX Bytes : 145.74 MB, Total TX Bytes: 242,75 MB, Average Traffic: 
> 2,89 kB/s (0,0%) in, 6,25 kB/s (0,0%) out | inUsage=0.0,85,98 
> outUsage=0.0,85,98
> 
> In nagios.cfg, I put 'process_performance_data=1'
> So I expect that Nagios splits the plugin output in two Macros :
> The text before the | should be the service output and the text after 
> the | should be recognized as performance data
> 
> $SERVICEOUTPUT$=Total RX Bytes : 145.74 MB, Total TX Bytes: 242,75 MB, 
> Average Traffic: 2,89 kB/s (0,0%) in, 6,25 kB/s (0,0%) out
> $SERVICEPERFDATA$=inUsage=0.0,85,98 outUsage=0.0,85,98
> 
> Instead of what I expect, Nagios drops the text before the | and the 
> text after the | is treated as the plugin output, so in my status-cgi's, 
> I get :
> 
> inUsage=0.0,85,98 outUsage=0.0,85,98
> 
> and I don't get any performance data.
> 
> I thought it had something to do with an illegal character, this is what 
> I have in nagios.cfg :
> illegal_macro_output_chars=`~$&|'"<>
> 
> 
> Any hints ?
> Apart from perfparse, what programs are you using to interpret 
> performance data ?
> 
> Thanks,
> Frederik
> 

http://nagiosplug.sourceforge.net/developer-guidelines.html

You should use semicolons instead of commas as the delimiter. Also, make
sure you are returning the values in the correct order. 

<snip from page>
'label'=value[UOM];[warn];[crit];[min];[max]
</snip>


Hope this gets you going,
-g
-- 
// Garrett Honeycutt
// Sr. Systems Administrator
// 3GUpload.com, Inc.
// 317.472.4969 Office

[Perfparse-users] performance data in Nagios

[Frederik V. <fre...@pe...>]

Hello,

I'm doing some experiments with performance data, but experience some 
strange behaviour
I have a plugin 'check_iftraffic.pl' that returns this :

Total RX Bytes : 145.74 MB, Total TX Bytes: 242,75 MB, Average Traffic: 
2,89 kB/s (0,0%) in, 6,25 kB/s (0,0%) out | inUsage=0.0,85,98 
outUsage=0.0,85,98

In nagios.cfg, I put 'process_performance_data=1'
So I expect that Nagios splits the plugin output in two Macros :
The text before the | should be the service output and the text after 
the | should be recognized as performance data

$SERVICEOUTPUT$=Total RX Bytes : 145.74 MB, Total TX Bytes: 242,75 MB, 
Average Traffic: 2,89 kB/s (0,0%) in, 6,25 kB/s (0,0%) out
$SERVICEPERFDATA$=inUsage=0.0,85,98 outUsage=0.0,85,98

Instead of what I expect, Nagios drops the text before the | and the 
text after the | is treated as the plugin output, so in my status-cgi's, 
I get :

inUsage=0.0,85,98 outUsage=0.0,85,98

and I don't get any performance data.

I thought it had something to do with an illegal character, this is what 
I have in nagios.cfg :
illegal_macro_output_chars=`~$&|'"<>


Any hints ?
Apart from perfparse, what programs are you using to interpret 
performance data ?

Thanks,
Frederik

Re: [Perfparse-users] Problems with slow insert into mysql DB

[Flo G. <fl...@bi...>]

Hi,

generally the time needed for a insert in a table with N rows is=20
proportional to log N if the table has indexes.

http://dev.mysql.com/doc/mysql/en/insert-speed.html

In many rdbms one additionally can see a performance drop if cache memory=
=20
is used up. In this case the memory used to cache table index data may be=
=20
to small. Since perfparse uses innodb tables, you should increase the size=
=20
of:

-------- http://dev.mysql.com/doc/mysql/en/innodb-start.html ----------
innodb_buffer_pool_size

The size of the memory buffer InnoDB uses to cache data and indexes of its=
=20
tables. The larger you set this value, the less disk I/O is needed to=20
access data in tables. On a dedicated database server, you may set this to=
=20
up to 80% of the machine physical memory size. However, do not set it too=
=20
large because competition for the physical memory might cause paging in=20
the operating system.

------------------------------------------------------------------------

You should also consider to increase innodb_log_file_size and probably=20
innodb_log_files_in_group to avoid frequent checkpoints. On a big machines=
=20
play with innodb_thread_concurrency.


Hope this helps.

Flo





On Thu, 14 Jul 2005, Sand Philipp wrote:

> Hi,
>
> don't know if some can help me out with that in this list...but here's th=
e question:
>
> my perfparse mysql DB has grown in size over the last months...the poor l=
ittle mysql DB is about 41GB of size ;)
> For inserting the Data in the Database I use the Method, where Nagios put=
s the Data into a serviceperf.log, perfparse gets to this data every 10 min=
utes and Nagios is reloaded then.
> For an insert of about 200KB it takes about 1.30minutes and it seems as i=
t keeps getting slower and slower...
>
> Are there some limits for mysql databases regarding the lines of one tabl=
e or something?? Any "tuning" tips?
>
> Currently I'm using mysql 4.0.21 on fedora core 2 and a Dual 1,4GHz CPU S=
erver with 2GB RAM and 2 Ultra 320 SCSI Harddrives...
>
>
> BTW,
> About half a year ago, there was a plan to redesign the perfparse databas=
e... any news to this? ;)
>
> Thanks in advance!
> Philipp
>
> _____________________________
>
> Philipp Sand
> OC-CC-TEC-SYS
>
> SYCOR GmbH
> Heinrich-von-Stephan-Stra=DFe 1-5
> D - 37073 G=F6ttingen
>
> Telefon=09+49 (0) 551 - 490 - 0
> Telefax=09+49 (0) 551 - 490 - 232468
>
> phi...@sy...
> www.sycor.de
> ------------------------------------------------
> =A0
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the 'Do More With Dual!' webinar happen=
ing
> July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
> core and dual graphics technology at this free one hour event hosted by H=
P,
> AMD, and NVIDIA.  To register visit http://www.hp.com/go/dualwebinar
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>

RE: [Perfparse-users] Problems with slow insert into mysql DB

[Ben C. <BC...@pa...>]

Same issue here, after about a month monitoring about 1100 services I =
was at
4+GB and then my Db got corrupted (hardware issue).  At the time I =
think I
had about 10 million rows in the bin/data tables.

I've got a bigger, faster server now, I'm not sure what to do beyond =
setting
the delete retention and using the 'is_deleted' column in some of the
tables.  You can set the bin/data deletion policy, and use
perfparse-db-purge, maybe that will help. =20

Over all it stinks if you have to delete valuable data.

Ben

-----Original Message-----
From: Sand Philipp [mailto:Phi...@sy...]
Sent: Thursday, July 14, 2005 7:10 AM
To: per...@li...
Subject: [Perfparse-users] Problems with slow insert into mysql DB


Hi,

don't know if some can help me out with that in this list...but here's =
the
question:

my perfparse mysql DB has grown in size over the last months...the poor
little mysql DB is about 41GB of size ;)
For inserting the Data in the Database I use the Method, where Nagios =
puts
the Data into a serviceperf.log, perfparse gets to this data every 10
minutes and Nagios is reloaded then.
For an insert of about 200KB it takes about 1.30minutes and it seems as =
it
keeps getting slower and slower...

Are there some limits for mysql databases regarding the lines of one =
table
or something?? Any "tuning" tips?

Currently I'm using mysql 4.0.21 on fedora core 2 and a Dual 1,4GHz CPU
Server with 2GB RAM and 2 Ultra 320 SCSI Harddrives...


BTW,
About half a year ago, there was a plan to redesign the perfparse
database... any news to this? ;)

Thanks in advance!
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
------------------------------------------------
=A0



-------------------------------------------------------
This SF.Net email is sponsored by the 'Do More With Dual!' webinar =
happening
July 14 at 8am PDT/11am EDT. We invite you to explore the latest in =
dual
core and dual graphics technology at this free one hour event hosted by =
HP,=20
AMD, and NVIDIA.  To register visit http://www.hp.com/go/dualwebinar
_______________________________________________
Perfparse-users mailing list
Per...@li...
https://lists.sourceforge.net/lists/listinfo/perfparse-users

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email=20
______________________________________________________________________

[Perfparse-users] Problems with slow insert into mysql DB

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

Hi,

don't know if some can help me out with that in this list...but here's =
the question:

my perfparse mysql DB has grown in size over the last months...the poor =
little mysql DB is about 41GB of size ;)
For inserting the Data in the Database I use the Method, where Nagios =
puts the Data into a serviceperf.log, perfparse gets to this data every =
10 minutes and Nagios is reloaded then.
For an insert of about 200KB it takes about 1.30minutes and it seems as =
it keeps getting slower and slower...

Are there some limits for mysql databases regarding the lines of one =
table or something?? Any "tuning" tips?

Currently I'm using mysql 4.0.21 on fedora core 2 and a Dual 1,4GHz CPU =
Server with 2GB RAM and 2 Ultra 320 SCSI Harddrives...


BTW,
About half a year ago, there was a plan to redesign the perfparse =
database... any news to this? ;)

Thanks in advance!
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
------------------------------------------------
=A0

[Perfparse-users] Re: Perfparse graph scale problem

[Hans E. <eng...@gm...>]

I had a similar problem. I preferred to change the value reported by
the plugin instead. It's a little more work maybe but in the end made
more sense too. Instead of having both Nagios and Perfparse report
memory in bytes for example I now routinely convert these values to
kilobytes and megabytes instead. This makes the values more readable
all round. Of course this might not be possible for all values so. The
same could be done for your T1 line unless of course you need such
high resolution (i.e. bytes/sec) on your measured values.

Either way it's an alternative you could consider.

Cheers,
Hans

On 6/29/05, Ben Clewett <bcl...@pe...> wrote:
> Ben,
>=20
> The code for this may be found in the function 'drawYScale()'.  Look for=
=20
> line 1031 in file cgi/perfchart.c.
>=20
> Ben.
>=20
>=20
> Ben Conrad wrote:
> > Hi Folks,
> >=20
> > I'm using Nagios + Perfparse to graph bytes/sec on some of my networkin=
g
> > equipment (T1 speed).  It seems that when the data value goes over a
> certain
> > number (100,000??) that the Perfparse graphs switch to using exponents =
on
> > the Y-axis.  So right now for my T1 usage of about 138785 (bytes/sec)
> > Perfparse displays this value as 1.80+e05 on the chart, it doesn't read
> > very well.
> >=20
> > Is there any way to change this so that the actual value stored in the =
Db
> is
> > displayed in the graph?
> >=20
> >=20
> > Thanks,
> >=20
> > Ben

Re: [Perfparse-users] Log rotate

[Daniele C. <dan...@ti...>]

Hi,
I use PP 0.105.6 on FreeBSD 5.3 and log rotation works correctly...
I have the following settings in perparse.cfg:
	Error_Log = /var/spool/nagios/perfparse/perfparse.log"
	Error_Log_Rotate = "Yes"
	Error_Log_Keep_N_Days = "7"

Try to delete manually old logs and set read/write permissions for all 
users on logs directory.

Good luck!

Daniele


Horvath Tamas wrote:
> Hi List!
> 
> I use PP 0.105.6 on Debian Woody 3.1.
> 
> I have the following settings in perparse.cfg:
> Error_Log = "/var/log/perfparse/perfparse.log"
> Error_Log_Rotate = "Y"
> Error_Log_Keep_N_Days = "7"
> 
> Despite the above settings I have old files in /var/log/perfparse/
> directory. The oldest ones are those which were created when I installed PP:
> 
> perfparse.log.20050518.log
> perfparse.log.20050519.log
> ...
> 
> 
> I think the older than 7 day files have to be removed. Am I wrong?
> 
> Any help would be appreciated.
> 
> Thanks, Tamas!
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>