topic Re: DB connection failure for DB configuration in TAC in Installing and Upgrading

DB connection failure for DB configuration in TAC

Rajesh_Reddy1 — Sat, 16 Nov 2024 09:08:11 GMT

Hi Team,

I have installed Talend latest version. when i'm configuring the TAC. its sending me error for DB connection.

I have cleared the temp and work folder in tomcat-apache folder it got worked for the first time and then after sometime its getting disconnecting.

Regards,

Rajesh REddy

Re: DB connection failure for DB configuration in TAC

Anonymous — Thu, 26 Oct 2017 18:42:34 GMT

Try changing the URL field with the IP address of your MySQL server instead of using localhost.

In addition, try configuring the TAC db connection to indicate to MySQL server that
it is a non SSL connection to be established between the TAC and MySQL server.
To implement this solution, the "useSSL" property set to "false" is passed via MySQL JDBC connect string.

Against this specific issue, just replace the TAC Database parameter Url value
jdbc:mysql://127.0.0.1:3306/talend_administrator
by this value :
jdbc:mysql://127.0.0.1:3306/talend_administrator?useSSL=false

Please don't forget to kudo and accept as resolution if this resolves the issue.

Re: DB connection failure for DB configuration in TAC

Rajesh_Reddy1 — Fri, 03 Nov 2017 06:53:14 GMT

@jhackworth: Thank you for the reply, I have tried replacing the localhost with IP address but its still the same. i'm facing the below error

ERROR: Cannot connect to database (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)

Re: DB connection failure for DB configuration in TAC

Anonymous — Mon, 06 Nov 2017 07:49:33 GMT

Hello,

Have you tried to modify 'wait_timeout' in your MySql DB to see if it works?

Best regards

Sabrina

Re: DB connection failure for DB configuration in TAC

ThWabi — Mon, 06 Nov 2017 13:56:26 GMT

Hello Rajesh Reddy,

have you tried to place the mysql-connector-java.jar file in "<Tomcat_Directory>\webapps\org.talend.administrator\WEB-INF\lib"?

Best regards,

Thomas

Re: DB connection failure for DB configuration in TAC

arjunrv88 — Fri, 15 Feb 2019 23:59:18 GMT

I am facing the same issue for Talend Data Fabric 7.0.1 version.

I am using "mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64)". I did place mysql java connector file in apache-tomcat/webapps/org.talend.administrator/WEB-INF/lib folder. Tried changing the connection string with FQDN, IP address and also by adding ?useSSL=false at the end of the connection string, still get the same error message. (Cannot connect to database (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.))

Any help would be appreciated.

Re: DB connection failure for DB configuration in TAC

anselmopeixoto — Fri, 22 Mar 2019 17:11:11 GMT

I was facing the same issue on Talend Data Fabric 7.0.1 trying to connect to MySQL 8.0.15 on localhost.

Adding ?useSSL=false to the connection string solved the problem with no need to change localhost to the host IP.

Thank you @jhackworth

Re: DB connection failure for DB configuration in TAC

Anonymous — Thu, 28 Mar 2019 14:02:47 GMT

Thank you for the suggestions. I did try your first suggestion before I posted to this forum. I just tried your REPLACE method and the editor complains about the syntax and throws an error. I will open up a TAC case and see what happens. Will update the thread if TAC or I come up with a solution.

Thanks,

Regards,

Stephen

Showbox

Re: DB connection failure for DB configuration in TAC

Anonymous — Fri, 29 Mar 2019 03:22:26 GMT

Hello @Staphenjaxk

Feel free to let us know if there is no response about your issue.

Please post your support case id and I will escalate this to the support team.

Best regards

Sabrina