MAMP - WSO2 DSS - Error establishing data source connection: Communications link failure The last packet sent successfully to the server

Question

I'm running MAMP and WSO2 Carbon data service at the same time. What I'm trying to do is adding a new data source by connecting to mysql server. I have added the com.mysql.jdbc.Driver to lib folder.

Full error which I'm getting when trying to test the connection

Error establishing data source connection: 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.

enter image description here

score 4 · Answer 1 · answered Jan 29 '19 at 02:13

4

In my case simply putting useSSL=false on end of connection string did the magic

jdbc:mysql://localhost:3306/USERS?useSSL=false

answered Jan 29 '19 at 02:13

lpastor

169
10

score 0 · Accepted Answer · edited May 23 '17 at 11:48

0

This seems to be a problem with mysql server configuration. Please have a look at following threads.

Solving a "communications link failure" with JDBC and MySQL

Why I get this error 'Communications link failure The last packet sent...' when connecting to MySQL with Java (Netbeans)?

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure

edited May 23 '17 at 11:48

Community

1
1

answered Dec 02 '12 at 17:52

Shelan Perera

1,753
1
11
10

It was the port. It should be 8889 instead of 3306. Thanks for the support anyway. – Techie Dec 02 '12 at 18:21

score 0 · Answer 3 · answered Feb 14 '23 at 11:22

0

I tried this and it's working by my side:

jdbc:mysql://localhost:3306/wso2_test?useUnicode=true&characterEncoding=UTF-8

answered Feb 14 '23 at 11:22

Abd Abughazaleh

4,615
3
44
53

MAMP - WSO2 DSS - Error establishing data source connection: Communications link failure The last packet sent successfully to the server

3 Answers3