Connecting Confluence to Google Cloud SQL

yvonnearnoldus

Hi,

I have been trying to connect Confluence to a Postgresql database in Google Cloud SQL.

It is possible to connect using jdbc but it needs a jdbc library from google com.google.cloud.sql.postgres.SocketFactory (https://cloud.google.com/sql/docs/postgres/connect-external-app#java). 

But when I use jdbc as specified in the Google documentation I get an error "The SocketFactory class provided com.google.cloud.sql.postgres.SocketFactory could not be instantiated".

I checked on the Docker image atlassian/confluence-server:6.3.2 and there is no SockerFactory on disc.

I we are deploying confluence using Kubernetes so we will be using Docker images.

Is there a way to use Google Cloud SQL with Confluence?

AnnWorley

Hi Yvonne,

I clicked on the link you provided and saw the Java connection instructions:

 

The JDBC socket factory provides an alternative to the client-side proxy software, and requires the Cloud SQL API to be enabled, just as the Cloud SQL Proxy does. The socket factory provides the same level of encryption as the proxy, and authenticates with Cloud SDK credentials, so the Cloud SDK must be installed and authenticated.

Please make sure the Cloud SDK  is installed and the Cloud SQL API is enabled. There is a giant blue button on this page you linked to before to enable it if you haven't already.

I look forward to working with you on this.

Thanks,

Ann