Menu
▾
▴
[Perfparse-users] Problems with MySQL and documentations
|
From: Jessica H. <Je...@gm...> - 2005-02-18 10:05:14
|
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
|
