After doing a lot of mysql locally i am trying something from one to another server now It works but after about 8 seconds i get etimedout When i trigger the node again i get a correct output then 8 sec later again a etimedout What could be the cause of the this?

Not sure - there seem to be quite a few indications on google that it means there is a connection issue to your server.

i found some. most are about firewall disabled the firewall, the de timedout comes from 4 seconds so the error is faster then. any other ideas are more then welcome, couldnt find other ideas

If you connect from the node red server machine using the msyql command line does it fail after a while in a similar way? Also look in the mysql logs for any clues.

Ok i will try it from the command line. But ehhh how can i do that?

[image] RogierQ: But ehhh how can i do that? By installing a mysql command line client. On Ubuntu that is mysql-client I believe.

Is running and no errors or problems with cmd line So i gues it is nodejs or something??

Did you have a look in the mysql logs? Also start node-red in a terminal and see if there are any other errors or warnings there. What version of node-red, nodjs and the sql node are you using? In fact it might be worth starting node-red in a terminal and copying the log in the terminal up to the…

My provider and friend checked all but cannot find a solution. I can create a test account if you like so you can have a look at it to check if it is not NR related. Is that an idea?

While searching thru the forum i found out that i did not include the error message "Error: connect ECONNREFUSED 99.99.97.99:3306" maybe this helps or someone else in the future... i continue to find a fix :wink:

[image] RogierQ: 99.99.97.99 Is that really the IP address of the mysql server? Show us a picture of the config where you enter the mysql server address.

Node-RED

Node-RED Forum

Mysql etimedout

General

RogierQ 1 May 2020 21:12 15

whoohooo i think i got it working now

truned on skip-external-locking on sql server side

Topic		Replies	Views
"Error: connect ETIMEDOUT" persist error after delete General	1	1457	1 March 2021
Node-red mysql connection refused General mysql	9	264	15 March 2024
Connect to MYSQL server which is powered off during night General	6	474	27 January 2022
MySQL fails after an hour or so General	17	1971	20 April 2021
NODE-RED MYSQL NODE connection refused General	26	14946	16 February 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Mysql etimedout

Related topics