Pronlem with a monitor

Hi I guess your second suggestion may be available in V11.5, I can't see it here. We tried Debug too. Strange it looks as though the monitor actually runs too, yet nothing in the tcpdump. The SQL DBA says he doesn't see any checks hitting his server from the offline box. Debug output shown below: Working ********** Debugging session beginning at: Tue Jul 7 13:59:09 2015

Arguments 1-2: ::ffff:172.31.61.51 50198

Environment variables: COUNT=0 DATABASE= DEBUG=yes MON_TMPL_NAME=/SQL/MONITOR_PROD_SQL2_INTERNAL_LIVE NODE_IP=::ffff:172.31.61.51 NODE_PORT=50198 PASSWORD=xxxxxxxxxxxxxxx RECVCOLUMN= RECVROW= RECV_I= SEND=USE ts_74_prod_lsds;SELECT DB_NAME()

count='0' converts to '0' MakePidFile: ::ffff:172.31.61.51-0..50198 pidfile exists -- checking for correctness of pid... DBDaemon says its pid is 10375 pid of 10375 is correct! Recvd: 'com.microsoft.sqlserver.jdbc.SQLServerDriver ' Recvd: 'jdbc:sqlserver://172.31.61.51:50198;databaseName=; ' Recvd: 'bigip ' Recvd: 'xxxxxxxxxxxxxxx ' Recvd: 'USE ts_74_prod_lsds;SELECT DB_NAME() ' Recvd: 'jdbc:sqlserver://172.31.61.51:50198;databaseName=;(Thread-154072): ' Recvd: '!Up! ' up

Not working ********** Debugging session beginning at: Tue Jul 7 13:43:48 2015

Arguments 1-2: ::ffff:172.31.61.51 50198

Environment variables: COUNT=0 DATABASE= DEBUG=yes MON_TMPL_NAME=/SQL/MONITOR_PROD_SQL2_INTERNAL_LIVE NODE_IP=::ffff:172.31.61.51 NODE_PORT=50198 PASSWORD=xxxxxxxxxxxxxxx RECVCOLUMN= RECVROW= RECV_I= SEND=USE ts_74_prod_lsds;SELECT DB_NAME()

count='0' converts to '0' MakePidFile: ::ffff:172.31.61.51-0..50198 pidfile exists -- checking for correctness of pid... DBDaemon says its pid is 14013 pid of 14013 is correct! Recvd: 'com.microsoft.sqlserver.jdbc.SQLServerDriver ' Recvd: 'jdbc:sqlserver://172.31.61.51:50198;databaseName=; ' Recvd: 'bigip ' Recvd: 'xxxxxxxxxxxxxxx ' Recvd: 'USE ts_74_prod_lsds;SELECT DB_NAME() ' Recvd: 'jdbc:sqlserver://172.31.61.51:50198;databaseName=;(Thread-3448787): ' Recvd: '!Down! ' Database down, see /var/log/DBDaemon.log for details. DBDaemon.log shown below: 7/15/15 11:07 AM: jdbc:sqlserver://172.31.63.47:50206;databaseName=;(Thread-3630637): closed connection!!!

7/15/15 11:07 AM: (Thread-3630639): Count : 1 7/15/15 11:07 AM: jdbc:sqlserver://172.31.61.51:50206;databaseName=;(Thread-3630639): new pinger created.connect str =jdbc:sqlserver://172.31.61.51:50206;databaseName=; 7/15/15 11:07 AM: jdbc:sqlserver://172.31.61.51:50206;databaseName=;(Thread-3630639): attempt =0 7/15/15 11:07 AM: jdbc:sqlserver://172.31.61.51:50206;databaseName=;(Thread-3630639): closing connection after 1 uses.

7/15/15 11:07 AM: jdbc:sqlserver://172.31.61.51:50206;databaseName=;(Thread-3630639): closed connection!!!

7/15/15 11:07 AM: (Thread-3630641): Count : 0 7/15/15 11:07 AM: jdbc:sqlserver://172.31.63.47:50198;databaseName=;(Thread-3630641): new pinger created.connect str =jdbc:sqlserver://172.31.63.47:50198;databaseName=; 7/15/15 11:07 AM: jdbc:sqlserver://172.31.63.47:50198;databaseName=;(Thread-3630641): attempt =0 7/15/15 11:07 AM: (Thread-3630643): Count : 0 7/15/15 11:07 AM: jdbc:sqlserver://172.31.61.51:50198;databaseName=;(Thread-3630643): new pinger created.connect str =jdbc:sqlserver://172.31.61.51:50198;databaseName=; 7/15/15 11:07 AM: jdbc:sqlserver://172.31.61.51:50198;databaseName=;(Thread-3630643): attempt =0 7/15/15 11:07 AM: (Thread-3630645): Count : 1 7/15/15 11:07 AM: jdbc:sqlserver://172.31.63.47:50206;databaseName=;(Thread-3630645): new pinger created.connect str =jdbc:sqlserver://172.31.63.47:50206;databaseName=; 7/15/15 11:07 AM: jdbc:sqlserver://172.31.63.47:50206;databaseName=;(Thread-3630645): attempt =0 7/15/15 11:07 AM: jdbc:sqlserver://172.31.63.47:50206;databaseName=;(Thread-3630645): closing connection after 1 uses.

7/15/15 11:07 AM: jdbc:sqlserver://172.31.63.47:50206;databaseName=;(Thread-3630645): closed connection!!!

7/15/15 11:07 AM: (Thread-3630647): Count : 1 7/15/15 11:07 AM: jdbc:sqlserver://172.31.61.51:50206;databaseName=;(Thread-3630647): new pinger created.connect str =jdbc:sqlserver://172.31.61.51:50206;databaseName=; 7/15/15 11:07 AM: jdbc:sqlserver://172.31.61.51:50206;databaseName=;(Thread-3630647): attempt =0 7/15/15 11:07 AM: jdbc:sqlserver://172.31.61.51:50206;databaseName=;(Thread-3630647): closing connection after 1 uses.

7/15/15 11:07 AM: jdbc:sqlserver://172.31.61.51:50206;databaseName=;(Thread-3630647): closed connection!!!

7/15/15 11:07 AM: (Thread-3630649): Count : 0 7/15/15 11:07 AM: jdbc:sqlserver://172.31.63.47:50198;databaseName=;(Thread-3630649): new pinger created.connect str =jdbc:sqlserver://172.31.63.47:50198;databaseName=; 7/15/15 11:07 AM: jdbc:sqlserver://172.31.63.47:50198;databaseName=;(Thread-363