Monday, September 11, 2017

[google-cloud-sql-discuss] Export using gcloud cli and api not working, but working via console

Hi there,

This issue seems to have cropped up since somewhere between last Friday 12:53:19 PM CEST and 5:38:07 PM CEST. We have an application which makes database backups by exporting specific database to one of our storage buckets on demand by issuing a request via an API call. This started failing with a message in the operations log like "gs://<bucketname>/<path_in_bucket>.sql: Access denied for account <small_base64_string>@speckle-umbrella-9.iam.gserviceaccount.com (permission issue?)".

Running a manual export via the gcloud cli, like "gcloud sql instances export <instance_name> gs://<bucketname>/<path_in_bucket>.sql --database=<database_name>",  also fails with the same message in the operations log and with a message on the terminal like:

Exporting Cloud SQL instance...failed.
ERROR
: (gcloud.sql.instances.export) ERROR_RDBMS

Running a manual export via the web console is working, though.

To eliminate the possibility of a permission issue with a service account or with the bucket, I made a cloudsql instance and bucket on a separate GCP project and account and I seem to run into the same situation there. Exporting via gcloud cli fails, but running it from the web console is working. The difference seem to be there even when not using a services account, but the same user account on both the cli and the console.

I am wondering, are there any others experiencing something similar indicating a wider issue, or am I making a logical thinking error and failing to see what I'm doing wrong here?

--
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/d7c31eaa-e006-4677-a4da-d5f7e5a630f8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment