Hi,
Below is the service definition for all 4 cases:
define service {
use generic-service
host_name DBIGASDS
service_description Reachability via tnsping 1
check_command check_oracle_health! --connect IGAS
--username ABC --password ABC --mode=tnsping --method sqlplus
contacts cosmin
}
define service {
use generic-service
host_name DBIGASDS
service_description Reachability via tnsping 2
check_command check_oracle_health_tnsping
contacts cosmin
define service {
use generic-service
host_name DBIGASDS
service_description Connection time to DB 1
check_command check_oracle_health!--connect IGAS
--username ABC --password ABC --mode=connection-time
contacts cosmin
}
define service {
use generic-service
host_name DBIGASDS
service_description Connection time to DB 2
check_command check_oracle_health_time
contacts cosmin
And this is the command definition:
define command{
command_name check_oracle_health
command_line $USER1$/check_oracle_health $ARG1$
define command{
command_name check_oracle_health_tnsping
command_line $USER1$/check_oracle_health_tnsping
}
define command{
command_name check_oracle_health_time
command_line $USER1$/check_oracle_health_time
BUT - a huge discovery when composing this mail. The only service
definition that worked from Nagios was the one which has the
undocumented argument "--method sqlplus".
I think i saw on some forums the use of that paramether in the
beginning, and it remained in the definition.
Anyway, after adding that parammeter to all other service and command
definitions, they started to work miracouslly (but still, from command
line, the plugin is working without --method argument)
Thank you for asking for command and service definition ;)
Cosmin Neagu
NOC Team Leader
Str. I. G. Duca nr. 36
Otopeni, Judetul Ilfov, 075100 Romania
Tel: 021 303 3159 / 0732 669 193
www.omnilogic.ro
On 11/07/2012 05:48 PM, Claudio Kuenzler wrote:
So my question for someone who has made check_oracle_healt work is:
How come all 4 invocation from CLI as nagios user work, but when
Nagios runs them, only 2 of them work.
I know that the error message tells me that there is some env
variable path problem, but why are the first 2 calls of
check_oracle_healt work then?
Can you, for completion, show your command definitions as well as the
service definition?
Just fyi: On my installation I used a different way to use --connect,
I used EZCONNECT.
See:
http://labs.consol.de/lang/de/blog/uncategorized/check_oracle_health-kann-ezconnect/
My command definition:
# check_oracle_health
define command {
command_name check_oracle_health
command_line $USER1$/check_oracle_health --username $USER3$
--password $USER4$ --mode $ARG1$ --connect $HOSTADDRESS$:$ARG2$/$ARG3$
}
And one of the service definitions:
# Check Oracle
define service{
use generic-service
host_name myoraserver
service_description Oracle Connections
check_command check_oracle_health!connected-users!1521!SERVICENAME
}
------------------------------------------------------------------------------
LogMeIn Central: Instant, anywhere, Remote PC access and management.
Stay in control, update software, and manage PCs from one command center
Diagnose problems and improve visibility into emerging IT issues
Automate, monitor and manage. Do more in less time with Central
http://p.sf.net/sfu/logmein12331_d2d
_______________________________________________
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting
any issue.
::: Messages without supporting info will risk being sent to /dev/null
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_nov
_______________________________________________
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting
any issue.
::: Messages without supporting info will risk being sent to /dev/null
