MDM - IT

IT Software and Systems Development

Progress RDBMS Nagios plugin (ver. 1.2)

Download

List of plugins:
      check_areaS_space_utilization.sh
      check_progress_actserver.sh
      check_progress_bufferact.sh
      check_progress_checkpoint.sh
      check_progress_dbread.sh
      check_progress_lockact.sh
      check_progress_users.sh

Installation
------------------------------

- Extract plugins into a destination location:
      cd /usr/local/nagios/libexec
      tar xvf progress-x.y.z.tar

- Copy all files: *.sh, *.pf, *.p to Nagios plugins directory
Shell scripts:
   check_areaS_space_utilization.sh
   check_progress_actserver.sh
   check_progress_bufferact.sh
   check_progress_checkpoint.sh
   check_progress_dbread.sh
   check_progress_lockact.sh
   check_progress_users.sh

Progress procedures:
   p_actserver.p
   p_actsummary.p
   p_areaS_space_utilization.p
   p_bufferact.p
   p_checkpoint.p
   p_lockact.p
   p_users.p

Config files:
   config.dlc
   *.pf

- Edit config.dlc.   Set the following:
#Path to Progress install instance
DLC=/opt/dlc91d64

- Edit example.pf.   Set the following:
#Coding of characters
   -cpcase Basic
   -cpcoll Polish
   -cpinternal Mazovia
   -cpstream Mazovia

#Host
   -H [host_db.example.com]

#Name of database service
   -S [service_db]

#Name of database
   -db [db_name]

#Other parameters
   -Bt 1024
   -Mm 2048
   -T /tmp
   -E

For example copy example.pf to db_crm.pf end edit
   -cpcase Basic
   -cpcoll Polish
   -cpinternal Mazovia
   -cpstream Mazovia
   -H db_crm.example.com     #name of host
   -S db_crm_service             #name of service with srvices file
   -db db_crm
#Other parameters with Progress documentation
   -Bt 1024
   -Mm 2048
   -T /tmp
   -E


- Add commands from Nagios/commands/commands.cfg to Nagios command.cfg

- Edit file Nagios/example/example_database.cfg
Modify
[example host_name or IP]
[name_of_database]
[path to nagios install libexec]
[name_of_database].pf

For example:


define service{
      use                 generic-service ; Name of service template to use
      host_name            192.168.1.2
      service_description  db_crm
      is_volatile   0
      check_period   24x7
      max_check_attempts   3
      normal_check_interval    5
      retry_check_interval   2
      contact_groups   linux-admins
      notification_interval   240
      notification_period  24x7
      notification_options   w,u,c,r
      check_command   check_db!40001  ;TCP port running progress broker
}

define service{
      use                generic-service    ; Name of service template to use
      host_name    192.168.1.2
      service_description   db_crm_Area_Utilization
      is_volatile   0
      check_period  24x7
      max_check_attempts   3
      normal_check_interval   3
      retry_check_interval   2
      contact_groups   linux-admins
      notification_interval   240
      notification_period   praca
      notification_options   w,u,c,r
      check_command   check_progress_areaS_space_utilization!/usr/local/nagios/libexec/db_crm.pf
}


define service{
      use          generic-service   ; Name of service template to use
      host_name    192.168.1.2
      service_description   db_crm_Logged_Users
      is_volatile   0
      check_period   24x7
      max_check_attempts  3
      normal_check_interval   3
      retry_check_interval   2
      contact_groups   linux-admins
      notification_interval   240
      notification_period   praca
      notification_options   w,u,c,r
      check_command   check_progress_users!/usr/local/nagios/libexec/db_crm.pf!580!590
}

And copy to nagios configuration directory.

Reload Nagios.