Sunday, September 9, 2018

[google-cloud-sql-discuss] Problem with privileges : can't run a query with postgres user with generated symfony db

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 ):

  1. Create sql postgres instance
  2. Add proxy to k8s container to connect to the sql instance with all credentials as is described in gcp doc
  3. 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...
  4. 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