Learn F5 Technologies, Get Answers & Share Community Solutions Join DevCentral

Filter by:
  • Solution
  • Technology
Answers

Custom Health Check

Hi

I am hoping o get some help with a custom health check to SQL DB we have written the following strings Send String: select [status] from mydatabase.dbo._ABC_IsAlive Receive String: Alive username: f5healthcheck passord: sqldatabase

looking at my pool i can see it working because health monitors shows active

i will like to know the verbose curl command i can use to actually see that it is working because the server is sending back the correct string.

i want to know this because when we failover to our 2nd Data centre the pool does not go active the command will help me identify if the issue is server or else.

if you also know a health monitor debug and tcpdump command i can use that will be health

thank you for your time

D

0
Rate this Question

Answers to this Question

placeholder+image
USER ACCEPTED ANSWER & F5 ACCEPTED ANSWER

i don't believe you can use curl (tool to send HTTP(S) requests to a webserver) to execute SQL queries. you will need something else there.

what kind of health monitor are you using now?

easier would be probably to do a tcpdump -i 0.0 -nn host <ip of SQL server> -s0 -X

0
Comments on this Answer
Comment made 20-Feb-2017 by Dede-DevCentral 109

i am sending a string to look into status of sql table by using the following string

select [status] from mydatabase.dbo._ABC_IsAlive

0
Comment made 20-Feb-2017 by boneyard 4973

like i say, i doubt that will work with curl.

but if you want to check run the tcpdump.

0