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 · Accepted solution]

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

[Omar Madrid]

Google sdk Is a set of tools needed to connect a VM to other Google cloud services.

And it is easy to install!!

[yvonnearnoldus]

Hi,

I did see the blue button. And I did perform the task behind the blue button.

But in order to use Google Cloud SQL I need to create my own confluence image and maintain this because I need to inject the Google SDK, far form Ideal.

Any change you will add support for Google Cloud SQL to Confluence, so customers do not need to install Google SDK?