CODEWITHSUNDEEP
dockernetwork-programminggoogle-cloud-platformgoogle-cloud-sqlgoogle-cloud-build
Pablo Marti Cordero
Pablo Marti Cordero

Reputation: 1145

Is there a way to allow cloudbuild steps to access the Cloud SQL in GCP

I'm setting up a cloud build trigger in order to deploy a PHP/Symfony Application. When the docker file runs the php app/console assetic:dump command in order to create the assets I get the following error.

SQLSTATE[HY000] [2002] Connection timed out 
[PDOException] 

SQLSTATE[HY000] [2002] Connection timed out
[Doctrine\DBAL\Driver\PDOException] 


An exception occurred in driver: SQLSTATE[HY000] [2002] 
Connection timed out 
[Doctrine\DBAL\Exception\ConnectionException]

I have resolved to trying to get the docker container to connect to the database instead of trying to fix the symfony application because I don't know enough about the framework or php.

Is it possible to set this up so that I can allow some kind of IP on the CLOUDSQL side to allow these connections?

Upvotes: 11

Views: 5034

Answers (1)

joost
joost

Reputation: 6659

A solution to setup the proxy in the same step is described in the answer here:

Run node.js database migrations on Google Cloud SQL during Google Cloud Build

Upvotes: 1

Related Questions