Affects: Sping boot 3.0.1
I'm trying to use IAM on google cloud sql in combination with Spring boot and R2DBC. My application.yml contains:
spring:
cloud:
gcp:
project-id: ...
sql:
database-name: ...
enable-iam-auth: true
instance-connection-name: ...
r2dbc:
username: ...
password: IgnoredButRequired
The r2dbc url gets constructed using properties from spring.cloud.sql (database name and instance-connection-name). However, the enable-iam-auth is not used. In order to make IAM work for R2DBC, I have to specify: spring.r2dbc.properties.ENABLE_IAM_AUTH=true
It is not very clear that this property needs to be set. It would be more clear if spring.cloud.sql.enable-iam-auth is used (as is done with database-name and instance-connection-name).
Comment From: vy
We also needed set ENABLE_IAM_AUTH=true
(by means of either spring.r2dbc.properties
or spring.r2dbc.jdbcUrl
) to make R2DBC work against an IAM-enabled Google Cloud SQL instance. We expected this flag to be automatically set due to spring.cloud.gcp.sql.enable-iam-auth: true
property.
Comment From: vy
I don't think this is the right project for this question. I have moved it to GoogleCloudPlatform/spring-cloud-gcp#1513. @dvrietschoten, would you mind closing this ticket, please?