im trying to connect vvvv to database using database (mysql) node, but i always get status like "cant connect to mysql server ‘host’ " or get error status " lost connection to mysql server during query.
i try to connect using command line and mysql workbench to server, and it work perfectly. but i cant connect it using vvvv
is there any solution for this? or any suggestion?
i already include vvvv in the firewall both inbound and outbound and already tried using 64bit but the result is same " lost connection during query ", i try to search about it and how to solve it is to make longer time out at mysql global config. is there any option to make longer time out connection to mysql database in vvvv ?
i’ve checked the MySQL_Example.v4p and it work perfectly fine. im able to connect and sent the query and retrive the data. but i still cant connect to the server that i want ( 18.104.22.168 ) using the same method in that example.
yes the “Lost connection…” message is coming after that time, is there something that i could change to increase that ConnectionTimeout in vvvv?
Hallo, as far as I know, the timeout parameter should be set in the server configuration typically in /etc/mysql/my.cnf .It would be fair to assume that vvvv is taking a bit longer to connect and timing out at 15 seconds?