perfparse-log2mysql doesn't load 2 MYsql

John Christian potus98 at yahoo.com
Thu Sep 15 16:35:35 CEST 2005
Previous message: Multiple Nagios processes
Next message: Simple windows client
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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


-------------------------------------------------------
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
Nagios-users at lists.sourceforge.net
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
Previous message: Multiple Nagios processes
Next message: Simple windows client
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Users mailing list