Disconnects with sql server

[ebolisa]

Hi,

My project runs several nodes, some connect to an external mqtt server and others to an internal (home network) sql server on a Diskstation unit.

When I go on extent vacations, I turn off my Diskstation server so, when that happens, I get (obviously) EHOSTUNREACH errors.

How can I prevent said error?

The most obvious answer would be to leave on the Diskstation ;)) but, I prefer not to do that.
So, I'm thinking in terms of a condition to check if the sql server is responsive or not and if it is, than proceed with the nodes.

TIA

[marcus-j-davies]

You could use the ping node?

and store its response in global context, and use that in a switch node
seems pretty perfect IMO

setup an interval to keep the response status updated

node-red-node-ping