topic Re: MySQL Connection Failure in Talend Studio

MySQL Connection Failure

Anonymous — Sat, 16 Nov 2024 12:13:42 GMT

Hi,
I just installed Talend on a new machine. When I am trying to create a connection to a MySQL database I am getting the error "com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: 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 Ideas? Do I need to install a new MySQL driver? If so what folder would I store this in?
Thanks!

Re: MySQL Connection Failure

Anonymous — Mon, 30 Jul 2012 02:27:01 GMT

Hi
Have you checked the correct DB version?
Maybe you need to try with Mysql 5 on tMysqlConnection.
Regards,
Pedro

Re: MySQL Connection Failure

janhess — Mon, 30 Jul 2012 09:04:58 GMT

It's a permissions problem.

Re: MySQL Connection Failure

Anonymous — Mon, 30 Jul 2012 18:59:14 GMT

Thanks guys! I just needed to white list the IP.

Re: MySQL Connection Failure

Anonymous — Tue, 31 Jul 2012 03:02:50 GMT

Hi
Thanks for your feedback.
Regards,
Pedro

Re: MySQL Connection Failure

_AnonymousUser — Mon, 11 Mar 2013 06:21:34 GMT

I am also getting same error "com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: 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 Ideas? Do I need to install a new MySQL driver? If so what folder would I store this in? also i have
bind-address 127.0.0.1 i.e localhost in my.cnf.

Re: MySQL Connection Failure

Anonymous — Mon, 11 Mar 2013 06:37:44 GMT

Hi yogeshballani,
The technical article http://stackoverflow.com/questions/2983248/com-mysql-jdbc-exceptions-jdbc4-communicationsexception-communications-link-fai about the error("com.mysql.jdbc.exceptions.jdbc4.Communications Exception : Communications link) will point a light to you.

Best regards
Sabrina

Re: MySQL Connection Failure

Anonymous — Mon, 11 Mar 2013 06:57:58 GMT

Hi yogeshballani,
I had faced same problem. I'm sharing here what I had done then.
Plz check the below things to identify the problem.
1. Check ur internet connection.
2. Check ur DB connection parameters settings in Talend job.
3.Check whether the user which u r using to run this job has the permissions from admin to access the respective DB.

Hope it is helpful to u.
Thanks,
Saty.

Re: MySQL Connection Failure

_AnonymousUser — Wed, 13 Mar 2013 10:51:33 GMT

Hi yogeshballani,
I had faced same problem. I'm sharing here what I had done then.
Plz check the below things to identify the problem.
1. Check ur internet connection.
2. Check ur DB connection parameters settings in Talend job.
3.Check whether the user which u r using to run this job has the permissions from admin to access the respective DB.

Hope it is helpful to u.
Thanks,
Saty.

Hi
I have tried every thing have re-installed Talend, MySQL and also java but still not having any success as it is connecting from remote machine but not able to connect talend with my local machine having MySQL Instance. I have already commented out bind-address in my.cnf and restarted mysql instance several times but not having success.

Re: MySQL Connection Failure

janhess — Wed, 13 Mar 2013 11:04:07 GMT

It's a permissions problem. Check the access permissions in the MySQL admin.

Re: MySQL Connection Failure

_AnonymousUser — Wed, 13 Mar 2013 11:08:58 GMT

Hi yogeshballani,
The technical article http://stackoverflow.com/questions/2983248/com-mysql-jdbc-exceptions-jdbc4-communicationsexception-communications-link-fai about the error("com.mysql.jdbc.exceptions.jdbc4.Communications Exception : Communications link) will point a light to you.

Best regards
Sabrina

Re: MySQL Connection Failure

_AnonymousUser — Wed, 13 Mar 2013 11:10:04 GMT

It's a permissions problem. Check the access permissions in the MySQL admin.

Hi ,
I am accessing mysql using root user having all permission's

Re: MySQL Connection Failure

janhess — Wed, 13 Mar 2013 11:45:14 GMT

Have you given the host permission?

Re: MySQL Connection Failure

Anonymous — Wed, 13 Mar 2013 11:45:49 GMT

Hi All,
The Issue has Been solved as the localhost was blocked from network settings in talend in general tab.

Re: MySQL Connection Failure

Anonymous — Thu, 14 Mar 2013 04:06:14 GMT

Hi,
Thanks for your feedback. Your solution provide us with another aspect about the error "com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure.
Best regards
Sabrina

Re: MySQL Connection Failure

Anonymous — Thu, 14 Mar 2013 04:51:42 GMT

Hi All,
The Issue has Been solved as the localhost was blocked from network settings in talend in general tab.

Thanks Yogesh.
I learnt from ur issue that this could one of the reasons for communication link failure.
Saty.