Until very recently I was able to succesfully use the mySQL database connector node to connect to a mySQL database, but now I suddenly get an immediate connection timeout. The database is accessible through telnet and another client application that uses port 3306. I cannot put my finger on what has changed suddenly.
ERROR MySQL Connector Execute failed: Could not create connection to database: Connection to database 'jdbc:mysql://helledaydb:3306/hts?useOldAliasMetadataBehavior=true' timed out
I'm using Knime 2.11.2. I have not configured any database drivers.
Any suggestions appreciated!
might it be an issue with a to short connection time out and MySQL taking sometimes a bit longer to establishing the connection. What ist the connection time out that you use in the KNIME preferences page? To check the connection time out open KNIME and go to File->Preferences. In the Preferences dialog go to KNIME->Databases. Can you access the db with another java client? Did the problem occured after you have upgraded KNIME?
HI PLEASE GIVE ME SOME SUGGESTION TO OVERCOME F THIS PROBLEM WHILE USING POSTGRES SQL IN KNIME
Execute failed: Could not create connection to database: Connection attempt timed out.
ERROR Database Connector Execute failed: Could not create connection to database: Connection attempt timed out.
The database is not responding. This can be due to the database being down, wrong hostname, wrong port, or a firewall blocking your requests.
I got the same error often after updating Knime. My Workaround is to save a copy of the knime directory before every update. If this results in the "connect time out" error after updating, I just use the saved directory.
But this cannot be the problem solver. Something is wrong woth the update process I think.
Just adding a solution:
On shared hosting plans, a workaround is to use one of the Name Servers instead of IP address or Hostname.