I’m using the latest version of Aqua Data studio and have created a connection to a remote MySQL server. Everything was fine a week or so ago. But now when I choose the server from the list and try to connect I get a Communications link failure? Any ideas of what’s going or happening here?
The trace from ADS is below. When I ssh into the server and view the mysql log file, I get:
2022-08-21T16:25:53.022759Z 22514 [Note] Got an error reading communication packets
2022-08-21T16:51:00.944363Z 22521 [Note] Got an error reading communication packets
2022-08-21T16:51:01.019105Z 22522 [Note] Bad handshake
2022-08-21T16:55:10.953723Z 22524 [Note] Got an error reading communication packets
2022-08-21T16:55:11.030870Z 22525 [Note] Bad handshake
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
at java.base/sun.security.ssl.HandshakeContext.<init>(Unknown Source)
at java.base/sun.security.ssl.ClientHandshakeContext.<init>(Unknown Source)
at java.base/sun.security.ssl.TransportContext.kickstart(Unknown Source)
at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:187)
… 26 more
Response
Thomas Conrad 3 months ago
Hi Paul,
Maybe the DBA for that MySQL server now requires SSL to communicate. Might check with them. You can add those parameters in the Server Properties->Driver->Parameters like:
Hope that helps,
Tom