Use DependencyTrack with Cloud SQL (Postgres)

[sdibernardo]

Hi there,

I am currently trying to figure out how to correctly configure DT to use my external provisioned Cloud SQL database.
The stacktrace prints the following message:

Caused by: java.lang.IllegalArgumentException: [dependency-track] Cloud SQL connection name is invalid, expected string in the form of "<PROJECT_ID>:<REGION_ID>:<INSTANCE_ID>". at com.google.common.base.Preconditions.checkArgument(Preconditions.java:143) at com.google.cloud.sql.core.CloudSqlInstanceName.<init>(CloudSqlInstanceName.java:47) at com.google.cloud.sql.core.RefreshAheadConnectionInfoCache.<init>(RefreshAheadConnectionInfoCache.java:52) at com.google.cloud.sql.core.Connector.createConnectionInfo(Connector.java:171) at com.google.cloud.sql.core.Connector.lambda$getConnection$0(Connector.java:144) at java.base/java.util.concurrent.ConcurrentHashMap.computeIfAbsent(Unknown Source) at com.google.cloud.sql.core.Connector.getConnection(Connector.java:144) at com.google.cloud.sql.core.Connector.connect(Connector.java:112) at com.google.cloud.sql.core.InternalConnectorRegistry.connect(InternalConnectorRegistry.java:179) at com.google.cloud.sql.postgres.SocketFactory.createSocket(SocketFactory.java:81) at org.postgresql.core.PGStream.createSocket(PGStream.java:248) at org.postgresql.core.PGStream.<init>(PGStream.java:121) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:140) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:268) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:273) at org.postgresql.Driver.makeConnection(Driver.java:446) at org.postgresql.Driver.connect(Driver.java:298) ... 23 common frames omitted

As mentioned in the docs, the URL for the db is configured the following way:

      - name: ALPINE_DATABASE_URL
        value: "jdbc:postgresql:///<redacted>:europe-west3:db?cloudSqlInstance=dependency-track&socketFactory=com.google.cloud.sql.postgres.SocketFactory"

I am using the latest Helm Chart for DependencyTrack and providing the necessary values via Helm as environment variables.

Any help on how to achieve the connection properly is highly appreciated <3

[nscuro]

I never used CloudSQL, but it seems like you need to provide cloudSqlInstance in the form of project:region:instance.

According to this, the instance connection name can be "found on the instance details page".

[sdibernardo]

Reading the documentation properly helps. Thanks for pointing out the correct piece of information 👍