I'm facing a very hard problem to solve with GCP cloud SQL. My tech stack is GCP with k8s for the hosting, using proxy to connect to sql db. Symfony project for the backend.
I follow these steps to create and populate ( without success ):
- Create sql postgres instance
- Add proxy to k8s container to connect to the sql instance with all credentials as is described in gcp doc
- Enter inside my Symfony ( phpfpm ) pod and run the command
php bin/console doctrine:schema:update --force
and all the query are executed in the database, so the schema is created and so on... - I try to open the DB fron de SQL Console connection of GCP with the postgres user and try to execute a simple
select * from foo;
and the response is Insufficient privilege: 7 ERROR: permission denied for relation
Any suggestion?
I try all the query to grant privileges to a user but no one works...
Thank you, regards
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/7ec2e64c-9c62-4866-943b-fd9cddbe9287%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment