Re: [google-cloud-sql-discuss] Exceptions using Cloud SQL MySQL Socket Factory

Please include the full stack trace from the exception. 

Without seeing the exception cause, it's hard to say what happened.

On Fri, Apr 7, 2017 at 9:29 AM Trevor Hartman <trevorhartman@gmail.com> wrote:

I'm trying to connect to a Cloud SQL MySQL database for JVM apps.

Followed the instructions at https://github.com/GoogleCloudPlatform/cloud-sql-mysql-socket-factory

I was able to generate a connection string using examples/getting-started.

I've tried using the root account as well as a dev account, but regardless, I an exception:

CompilerException java.util.concurrent.ExecutionException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.

Logs show:

INFO: Connecting to Cloud SQL instance [myproject:us-central1:mydb-staging].

Apr 07, 2017 10:00:54 AM com.google.cloud.sql.mysql.SslSocketFactory getInstance

INFO: First Cloud SQL connection, generating RSA key pair.

Apr 07, 2017 10:00:55 AM com.google.cloud.sql.mysql.SslSocketFactory fetchInstanceSslInfo

INFO: Obtaining ephemeral certificate for Cloud SQL instance [myproject:us-central1:mydb-staging].

Apr 07, 2017 10:00:55 AM com.google.cloud.sql.mysql.SocketFactory connect

INFO: Connecting to Cloud SQL instance [myproject:us-central1:mydb-staging].

Apr 07, 2017 10:00:55 AM com.google.cloud.sql.mysql.SslSocketFactory getInstanceSslInfo

WARNING: Re-throwing cached exception due to attempt to refresh instance information too soon after error.

Apr 07, 2017 10:00:55 AM com.google.cloud.sql.mysql.SocketFactory connect

INFO: Connecting to Cloud SQL instance [myproject:us-central1:mydb-staging].

Apr 07, 2017 10:00:55 AM com.google.cloud.sql.mysql.SslSocketFactory getInstanceSslInfo

I am able to connect directly using the mysql client but not from my JVM (clojure) app.

Thanks,

Trevor

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/8ba44aff-a3e3-4ec2-b68c-32f7e91ab8fc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CABDU3p06UKKHzKKfePbceWZYrsqHGzb4jrhRb15z_01K4tjO7Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.