Forum Discussion
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.
Help guide the future of your DevCentral Community!
What tools do you use to collaborate? (1min - anonymous)Recent Discussions
Related Content
* Getting Started on DevCentral
* Community Guidelines
* Community Terms of Use / EULA
* Community Ranking Explained
* Community Resources
* Contact the DevCentral Team
* Update MFA on account.f5.com