Monitoring MySQL Database using Nagios


#1

[size=100]Hi,

We are using Fedora Core6 system. We have installed Nagios2.8 with the official plugins nagios-plugins-1.4.11. We have installed mysql-server packages using yum. Also we insalled ndoutils-1.4b7 for connecting nagios with MySQL database. All the related tables of nagios are stored in MySQL database.

Output from MySQL:

mysql> select * from nagios_services;
±-----------±------------±------------±---------------±------------------±----------------±------------------------±-------------------------±-------------------------------±--------------------------±----------------------------------±---------------------------±---------------------------±---------------±---------------±-------------------±-------------------------±----------------------±------------------±------------------±-------------------±-------------------±-------------------±-------------------±------------±-----------------±-----------------±------------------±------------±-----------------------±---------------------±--------------------------±--------------------------±---------------------------±-------------------±--------------------±-------------------------±-------------------------±--------------------±-----------------------±----------------------±----------------------±--------------------------±-----------------------------±----------------------±--------------------±---------------------------±------±----------±-----------±-----------±---------------+
| service_id | instance_id | config_type | host_object_id | service_object_id | display_name | check_command_object_id | check_command_args | eventhandler_command_object_id | eventhandler_command_args | notification_timeperiod_object_id | check_timeperiod_object_id | failure_prediction_options | check_interval | retry_interval | max_check_attempts | first_notification_delay | notification_interval | notify_on_warning | notify_on_unknown | notify_on_critical | notify_on_recovery | notify_on_flapping | notify_on_downtime | stalk_on_ok | stalk_on_warning | stalk_on_unknown | stalk_on_critical | is_volatile | flap_detection_enabled | flap_detection_on_ok | flap_detection_on_warning | flap_detection_on_unknown | flap_detection_on_critical | low_flap_threshold | high_flap_threshold | process_performance_data | freshness_checks_enabled | freshness_threshold | passive_checks_enabled | event_handler_enabled | active_checks_enabled | retain_status_information | retain_nonstatus_information | notifications_enabled | obsess_over_service | failure_prediction_enabled | notes | notes_url | action_url | icon_image | icon_image_alt |
±-----------±------------±------------±---------------±------------------±----------------±------------------------±-------------------------±-------------------------------±--------------------------±----------------------------------±---------------------------±---------------------------±---------------±---------------±-------------------±-------------------------±----------------------±------------------±------------------±-------------------±-------------------±-------------------±-------------------±------------±-----------------±-----------------±------------------±------------±-----------------------±---------------------±--------------------------±--------------------------±---------------------------±-------------------±--------------------±-------------------------±-------------------------±--------------------±-----------------------±----------------------±----------------------±--------------------------±-----------------------------±----------------------±--------------------±---------------------------±------±----------±-----------±-----------±---------------+
| 1 | 1 | 1 | 1 | 5 | Current Load | 19 | 5.0,4.0,3.0!10.0,6.0,4.0 | 0 | | 2 | 2 | | 5 | 1 | 4 | 0 | 60 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 2 | 1 | 1 | 1 | 6 | Current Users | 21 | 20!50 | 0 | | 2 | 2 | | 5 | 1 | 4 | 0 | 60 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 3 | 1 | 1 | 1 | 7 | PING | 23 | 100.0,20%!500.0,60% | 0 | | 2 | 2 | | 5 | 1 | 4 | 0 | 60 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 4 | 1 | 1 | 1 | 8 | Root Partition | 18 | 20%!10%!/ | 0 | | 2 | 2 | | 5 | 1 | 4 | 0 | 60 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 5 | 1 | 1 | 1 | 9 | Total Processes | 20 | 250!400!RSZDT | 0 | | 2 | 2 | | 5 | 1 | 4 | 0 | 60 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 6 | 1 | 1 | 3 | 10 | Current Users | 21 | 20!50 | 0 | | 0 | 0 | | 5 | 1 | 10 | 0 | 960 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 7 | 1 | 1 | 3 | 11 | PING | 23 | 100.0,20%!500.0,60% | 0 | | 0 | 0 | | 5 | 1 | 10 | 0 | 960 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
| 8 | 1 | 1 | 3 | 12 | Total Processes | 20 | 250!400!RSZDT | 0 | | 0 | 0 | | 5 | 1 | 10 | 0 | 960 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | | | | |
±-----------±------------±------------±---------------±------------------±----------------±------------------------±-------------------------±-------------------------------±--------------------------±----------------------------------±---------------------------±---------------------------±---------------±---------------±-------------------±-------------------------±----------------------±------------------±------------------±-------------------±-------------------±-------------------±-------------------±------------±-----------------±-----------------±------------------±------------±-----------------------±---------------------±--------------------------±--------------------------±---------------------------±-------------------±--------------------±-------------------------±-------------------------±--------------------±-----------------------±----------------------±----------------------±--------------------------±-----------------------------±----------------------±--------------------±---------------------------±------±----------±-----------±-----------±---------------+
8 rows in set (0.00 sec)

How to store performance data from nagios to MySQL? We tried to install check_mysql_perf-1.3 in our system.while configuring check_mysql_perf using the command ./configure --prefix= /usr/local/nagios/ --with-officialplugins= / usr/local/nagios/libexec/libexec/ we get the error

configure:error:You need the official plugins to compile this one…

but we have already installed the official plugins but the error still persists…

kindly also tell us whether we need any other additional plugins to monitor the performance data from nagios and store it in mysql database…[/size]