Connect to MYSQL server which is powered off during night

General
1

Hello,

I connected Node Red to a remote MySQL server, which is powered off during nights, starting between 4pm and 8pm randomly. When it is powered on, I can connect to it.

But at night, when it is powered off, I keep receiving every 4-8 seconds the Error: connect ETIMEDOUT message.

Is it possible to connect to it when the remote server is powered on? Or get rid of these messages?

Thanks for your precious time,

Botond

2

Capture the Error with a Catch node

3

I put a catch node with parameter: all and without output. The error message still comes to the debug panel every 2-3 seconds.

4

OK another idea could be to use the ping node - so it will automatically be recognized when the remote server is on-or offline and you can block your flow as long as the server is unreachable or even check each message send to MySQL server if server is reachable.

5

This could work when the flow starts only when triggered. But I do not trigger the flow, but it still wants to connect to MySQL, and as the remote server is powered off, it can not connect to it. So I keep on receiving the error message to the debug panel.

6

OK - if the error occurs even if no message receives the mySQL node - then I have no idea as well. Sorry. :frowning:

7

Thanks for your efforts, mickym2! :slight_smile:

8

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