DB connection failure for DB configuration in TAC

Highlighted
Five Stars

DB connection failure for DB configuration in TAC

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

 

 

 

 

Employee

Re: DB connection failure for DB configuration in TAC

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.

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

Re: DB connection failure for DB configuration in TAC

@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.)

 

Moderator

Re: DB connection failure for DB configuration in TAC

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: DB connection failure for DB configuration in TAC

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

 

Four Stars

Re: DB connection failure for DB configuration in TAC

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.

Six Stars

Re: DB connection failure for DB configuration in TAC

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 

 

 



http://www.talendbrasil.com.br
Four Stars

Re: DB connection failure for DB configuration in TAC

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

Moderator

Re: DB connection failure for DB configuration in TAC

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

The Forrester Wave: Strategic iPaaS and Hybrid Integration Platforms, Q1 2019

Find out how Forrester rate different iPaaS and Hybrid Integration Platforms

Read

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now