Page 1 of 3
Check DB instance
Posted: Wed Jun 28, 2017 11:00 am
by donnyforbes
We have an informix db cluster setup here on our network. How do I setup nagios XI to check to see if the instance is up / down? This is a major factor in purchasing XI version of nagios.
Please get back to me ASAP as we are in the process and ready to purchase.
Thanks
Re: Check DB instance
Posted: Wed Jun 28, 2017 11:36 am
by mcapra
Looks like you can enable SNMP in Informix:
https://www.ibm.com/support/knowledgece ... fmx1000615
That's probably the way to go. Then you could use one of the various SNMP configuration wizards available in Nagios XI.
Re: Check DB instance
Posted: Wed Jun 28, 2017 11:43 am
by donnyforbes
I will look into this. I need to get this to work on one server so I can purchase this is what management is wanting me to do.
Re: Check DB instance
Posted: Wed Jun 28, 2017 12:15 pm
by donnyforbes
Looks like you can enable SNMP in Informix:
https://www.ibm.com/support/knowledgece ... fmx1000615
That's probably the way to go. Then you could use one of the various SNMP configuration wizards available in Nagios XI
I have enabled the SNMP on the informix. I am not in the process of setting up the SNMP through the wizard. What I need to know is what
value do I used in order to know up / down this is very important that when this "Informix" instance goes down we are notified. I have attached
what a config to see. Please let me know .
Re: Check DB instance
Posted: Wed Jun 28, 2017 12:56 pm
by mcapra
Here's the general information about what the Informix specific OIDs represent:
https://www.ibm.com/support/knowledgece ... mp_050.htm
I don't know what it means for Informix to be "up" or "down" relative to your organization's business process. Are you relying on specific databases? A parent Linux/Windows process that Informix lives under? The information given so far about the use case is rather thin.
Re: Check DB instance
Posted: Wed Jun 28, 2017 2:09 pm
by donnyforbes
I don't know what it means for Informix to be "up" or "down" relative to your organization's business process. Are you relying on specific databases? A parent Linux/Windows process that Informix lives under? The information given so far about the use case is rather thin.
yes informix rely's on the "sysmaster database" and the informix process is "rmcaaixscc, rmcascc, rmcacmhqscc, rmcacmaixscc, rmcacmyardscc, and http."
Re: Check DB instance
Posted: Wed Jun 28, 2017 3:50 pm
by donnyforbes
i was able to clarity in regards to the informix stuff. The sysmaster db does not mean anything there is no process for it. What I need to have checked to see up / down are the following process.
oninit, CMSM, and httpd...
Can you please tell me how I can go about doing this?
Re: Check DB instance
Posted: Wed Jun 28, 2017 4:27 pm
by donnyforbes
Here is what I did. I copy the the localhost config for httpd and then renamed it for my servers. Here is the config file when I go to configure -> Core config manager -> services
Code: Select all
###############################################################################
#
# Service configuration file
#
# Created by: Nagios Core Config Manager 2.6.7
# Date: 2017-06-28 14:25:26
# Version: Nagios 3.x config file
#
# --- DO NOT EDIT THIS FILE BY HAND ---
# Nagios CCM will overwrite all manual settings during the next update if you
# would like to edit files manually, place them in the 'static' directory or
# import your configs into the CCM by placing them in the 'import' directory.
#
###############################################################################
define service {
host_name duey.sg1.allamericanasphalt.com
service_description / Disk Usage
use xiwizard_nrpe_service
check_command check_nrpe!check_disk!-a '-w 20% -c 10% -p /'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}
define service {
host_name duey.sg1.allamericanasphalt.com
service_description CPU Stats
use xiwizard_nrpe_service
check_command check_nrpe!check_cpu_stats!-a '-w 85 -c 95'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}
define service {
host_name duey.sg1.allamericanasphalt.com
service_description Load
use xiwizard_nrpe_service
check_command check_nrpe!check_load!-a '-w 15,10,5 -c 30,20,10'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}
define service {
host_name duey.sg1.allamericanasphalt.com
service_description Memory Usage
use xiwizard_nrpe_service
check_command check_nrpe!check_mem!-a '-w 20 -c 10'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}
define service {
host_name duey.sg1.allamericanasphalt.com
service_description Ping
use xiwizard_linuxserver_ping_service
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}
define service {
host_name duey.sg1.allamericanasphalt.com
service_description Service Status - httpd - Infx_OAT
use local-service
display_name Infx
check_command check_xi_service_status!httpd!!!!!!!
register 1
}
define service {
host_name duey.sg1.allamericanasphalt.com
service_description Swap Usage
use xiwizard_nrpe_service
check_command check_nrpe!check_swap!-a '-w 50% -c 20%'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}
define service {
host_name duey.sg1.allamericanasphalt.com
service_description Users
use xiwizard_nrpe_service
check_command check_nrpe!check_users!-a '-w 5 -c 10'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}
###############################################################################
#
# Service configuration file
#
# END OF FILE
#
###############################################################################
What I need to know is when this service is not available or goes down for some reason I am notified. How can I make sure I will be notified?
Re: Check DB instance
Posted: Wed Jun 28, 2017 4:45 pm
by donnyforbes
Can someone tell me if "Manage Templates" have set things in it. I am asking because I have a service called service - status - httpd - Infx_OAT in which I copied from the localhost httpd config.
I went to the server and stop httpd service, however never got an email . I verified the server was stop by doing a ps -ef |grep httpd as well. I am attaching pics of the config. Please can someone
assist me with this. I need to get this working before we make the purchases.
Re: Check DB instance
Posted: Wed Jun 28, 2017 4:47 pm
by donnyforbes
I don't know what it means for Informix to be "up" or "down" relative to your organization's business process. Are you relying on specific databases? A parent Linux/Windows process that Informix lives under? The information given so far about the use case is rather thin.
Yes I need httpd, CMSM (informix) , and a service called oninit (informix)
Thanks