Disconnects with sql server


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.


You could use the ping node?

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

setup an interval to keep the response status updated

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.