Menu
▾
▴
Re: [Perfparse-users] Problems with MySQL and documentations
|
From: Ben C. <bcl...@pe...> - 2005-02-18 10:16:50
|
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 |
