Forum Discussion

Gopinath_Vedagi's avatar
Gopinath_Vedagi
Icon for Nimbostratus rankNimbostratus
Oct 16, 2014

MSSQL Health Monitor _ Not working Help Needed

Hi ,

 

I Created the MSSQL Monitor with below options configured , to monitor the Backend database servers .

 

Send String : SELECT * FROM dbo.hm WHERE value = 'Success'

 

Receive String : Success

 

Username : F5

 

Password : Start123

 

Database : F5Healthmonitor

 

Alies Port : 2383

 

But Monitoring is failed , iam getting below Debug Logs

 

********** Debugging session beginning at: Thu Oct 16 17:42:34 2014

 

Arguments 1-2: ::ffff:10.145.166.244 2383

 

Environment variables: COUNT=0 DATABASE=F5Healthmonitor DEBUG=yes MON_TMPL_NAME=/Prod/SQL NODE_IP=::ffff:10.145.166.244 NODE_PORT=2383 PASSWORD=Start123 RECVCOLUMN= RECVROW= RECV_I=Success SEND=SELECT * FROM dbo.hm WHERE value = 'Success'

 

USERNAME=F5

count='0' converts to '0' MakePidFile: ::ffff:10.145.166.244-0..2383 pidfile exists -- checking for correctness of pid... DBDaemon says its pid is 3229 pid of 3229 is correct! Recvd: 'com.microsoft.sqlserver.jdbc.SQLServerDriver ' Recvd: 'jdbc:sqlserver://10.145.166.244:2383;databaseName=F5Healthmonitor; ' Recvd: 'F5 ' Recvd: 'Start123 ' Recvd: 'SELECT * FROM dbo.hm WHERE value = 'Success' ' Recvd: 'Success ' Recvd: '1 ' Recvd: '1 ' Recvd: 'jdbc:sqlserver://10.145.166.244:2383;databaseName=F5Healthmonitor;(Thread-637): ' Recvd: '!Down! ' Database down, see /var/log/DBDaemon.log for details.

 

No RepliesBe the first to reply