Getting Error: The connection was forcibly closed

[ahitankar]

Hello Team,

I've been working on establishing a connection with Cloud SQL - Postgres. I've ensured that I have all the required permissions both for myself and the service account. Additionally, I've successfully created the instance in Cloud SQL - Postgres, along with the necessary user and database configurations. However, during the connector setup process in Application Integration, after providing all the requisite details, I encounter an issue where the connection attempt loads for a few minutes before ultimately failing with one of the following error messages: "The Connection has been closed", "The connection was forcibly closed", or "Connection deployment timeout". Interestingly, I'm encountering a similar issue with the Cloud SQL - MySQL connector as well. I'm seeking assistance in resolving this issue and understanding the underlying cause. Any insights or guidance you can provide would be greatly appreciated. I've attached a screenshot of the error for reference.

Thanks

[Graham-Vosper]

Hi Ahitankar, 

in my team we have been using this postgres connector successfully for the last year. It sounds more like a networking issue preventing connection to your database.  Have you allowed "Private IP connectivity" to your database (edit database, scroll down to connections, enable 'private ip')

[ahitankar]

Hi Graham-Vosper,

Even after enabling "Private IP connectivity" in my database settings with default network configurations, the error persists. I've included a screenshot of the connections tab for reference. Can you speculate on other potential causes for this issue?

PREVIEW

[Graham-Vosper · Accepted solution]

Hi Ahitankar, 

Probably worth checking what permissions you have given the service account, we gave ours:

Otherwise not sure what else to suggest, probably needs a case raised with Google.

[ahitankar]

Hi Graham - Vosper,

We have all the above three mentioned permissions to the service account.