[Nagios-users] check_oracle_health --mode=sql doesn't work with a $ sign in sql statment

[Rejoice999 <rej...@ya...>]

Environment:
  RHEL 4.7 x86
perl v5.8.5
perl-DBI-1.40-9
DBD-Oracle-1.19
Oracle client 9.2.0.4
Nagios 3.0.4
check_oracle_health-1.5
   
  command line test works:
  /usr/local/nagios/libexec/check_oracle_health --connect=test1 --user=nagios --password=nagios --mode=sql --name2="Sessions waiting for latch free" --name="select count(*) from v\$session_wait where event='latch free' "
OK - sessions waiting for latch free: 0 | 'sessions waiting for latch free'=0;1;5
   
  Following config not work:
  define command{
        command_name    check_oracle_health_latchfree-count
        command_line    $USER1$/check_oracle_health --connect=$ARG1$ --user=nagios --password=nagios --mode=sql --name2="Sessions waiting for latch free" --name="select count(*) from v\$session where event='latch free' "
        }
  define service{
        use                             local-service         ; Name of service template to use
        host_name                       vm2
        service_description             Sessions waiting for latch free
        check_command                   check_oracle_health_latchfree-count!test1
        }
  
Sessions waiting for latch free 
  UNKNOWN 10-25-2008 21:48:58 0d 0h 44m 26s 4/4 UNKNOWN - got no valid response for select count(*) from v$session where event='latch free'$  
I noticed a trailing "$" in the statement displayed on Nagios page.
   
  Thanks.
   

       
---------------------------------
 雅虎邮箱，您的终生邮箱！