Progress RDBMS Nagios plugin (ver. 1.2)
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.