Cannot Connect to Java (Spring Boot) Application via connection strings

[Kikiodazie]

Connecting via proxy works perfectly, I am having issues connecting to PlanetScale via connection strings. I have Debugged it for hours, my last attempt was to allow all access to my machine by changing my.cnf from bind-address = 127.0.0.1 To bind-address = 0.0.0.0.

code:

Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn = DriverManager.getConnection(
  "jdbc:mysql://url?sslMode=VERIFY_IDENTITY",
  "username", "*password");

See full stacktrace below.

Exception in thread "main" com.mysql.cj.jdbc.exceptions.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.
	at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
	at com.odazie.planetscalespringbootexample.PlanetscaleSpringbootExampleApplication.main(PlanetscaleSpringbootExampleApplication.java:16)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: 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.
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
	at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
	at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:317)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:203)
	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1369)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:133)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818)
	... 6 more
Caused by: javax.net.ssl.SSLHandshakeException: extension (5) should not be presented in certificate_request
	at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131)
	at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:117)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:314)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:270)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:261)
	at java.base/sun.security.ssl.SSLExtensions.<init>(SSLExtensions.java:89)
	at java.base/sun.security.ssl.CertificateRequest$T13CertificateRequestMessage.<init>(CertificateRequest.java:818)
	at java.base/sun.security.ssl.CertificateRequest$T13CertificateRequestConsumer.consume(CertificateRequest.java:922)
	at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:392)
	at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:451)
	at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:428)
	at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:184)
	at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:164)
	at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1151)
	at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1062)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:402)
	at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:335)
	at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:194)
	at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:101)
	at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:308)
	... 11 more

[sajidbarcha]

Hi Kikiodazie, did you figure it out? I am considering using PlanetScale with my Spring Boot Restful app instead of a managed Postgres at AWS, and you're the only one (in this discussion) that seems to have tried PS with Spring Boot.

[Kikiodazie]

Hey @sajidbarcha sadly no.

I tried for hours, and left it because i had other pressing issues.

I reached out to one of their Dev Advocates on twitter but didn't get a reply.

Where you able to connect via proxy?

I was working on a tutorial for connecting with springboot when i had this issue. I kind of think it's a config on my machine causing it.

[sajidbarcha]

@Kikiodazie I have not tried, judging from Plantescale's website, It doesn't look like Java or Spring ecosystem is one of their main target markets, since there are dedicated sections for some backend technologies and it doesn't include Spring. For my current project, I decided to proceed with a managed Postgres solution, I will come back to PS may be for a future project.

[fooforge]

Apologies for the long wait, @Kikiodazie!

I'm not well-versed in Java/Spring, but I've tried reproducing the issue and ran into no issues connecting to PlanetScale with the below code. Generally, any framework or language should work with PlanetScale as long as there's a robust MySQL connector implementation that supports SSL/TLS.

Terminal

❯ /opt/homebrew/Cellar/openjdk/17.0.2/bin/java -jar dist/PlanetScaleJava-20220315.jar 
Successfully connected to PlanetScale!

Code

package com.planetscale.example;

import java.sql.*;

class Mysql {
    public static void main(String args[]){
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection(
                "jdbc:mysql://[HOSTNAME]/[DATABASE]?sslMode=VERIFY_IDENTITY",
                "[USERNAME]",
                "[PASSWORD]");
            conn.close();
            System.out.println("Successfully connected to PlanetScale!");
        } catch(Exception e) {
            e.printStackTrace();
            System.exit(1);
        }
    }
}

This is with the mysql-connector-java version 8.0.26 and on a Mac.

Your code snippet looks relatively similar to mine and considering the SSL related error in your stack trace I'm wondering if your host is simply unable to verify the SSL certificate chain. The official documentation for the connector has so much information on that topic that I couldn't possibly repeat it all here, but I can at least link you to it. We also have some more information on secure connections in our knowledge base, though you might have seen this one already.

If none of the above has helped, can you perhaps follow the steps under Debugging an SSL connection from the official documentation and report back either here or via https://planetscale.com/support? Cheers!

[Kikiodazie]

Hey @fooforge,

Thanks for the reply. I will spend some time digging into it. This weekend. I believe the issue is my host machine.

Thanks for the links you shared they will come in handy.

Also one more thing, I was writing a Springboot specific connection guide that follows Spring ways of doing things which I believe would be helpful for anyone to get started with springboot and PlanetScale faster. Here is a link to the draft: https://www.dropbox.com/scl/fi/37bisuq0z83w6zw59hoop/Connect-a-Spring-Boot-application-to-PlanetScale.paper?dl=0&rlkey=ullbp2xiw5rcm266dzahw1jw9

Mind if I create a PR to the documentation tutorials when I am done resolving the issue and writing?

I hope this meets you well.

[fooforge]

You're welcome!

Let me know how you get on. I'll take another 👀 early next week to see where things are at. :-)

As for contributions to our docs, they're most welcome! Whenever you're ready, file a PR against https://github.com/planetscale/docs and loop in @hollylawly for a review. Thank you!

[Kikiodazie]

Sure thing @fooforge.

Thank you. Have a great rest of the week.

[anasbinarif]

spring:
datasource:
url: jdbc:mysql://aws.connect.psdb.cloud:3306/database_name?verifyServerCertificate=true&useSSL=true&requireSSL=true
username: {your_username}
password: {your_password}
driver-class-name: com.mysql.cj.jdbc.Driver

use this URL to connect PS to spring boot