Tuesday, August 30, 2016

[google-cloud-sql-discuss] Re: Errors when setting root password or attempting to list users on second gen instance using gcloud

Hey Mark,

Thanks for getting in touch with us about this. A few questions:

Is this still occurring?

How long after creating the instance were you running these commands? 

What is the output of "gcloud beta sql instances list"?

If you could email me directly with your project ID and the name of the instance, we could also take a look directly. Usually issues like this should be reported to the Cloud SQL Public Issue Tracker, but we're happy to start work here and transfer there if something is found which will require progress updates. 

Cheers,

Nick
Cloud Platform Community Support

On Friday, August 26, 2016 at 3:51:49 PM UTC-4, Mark Betz wrote:
Hi, folks. I have a second gen. instance that has been created in our project using mysql 5.7. Nothing else has been done after using the console to create this instance. If I try to execute ...

$ gcloud sql instances set-root-password my_instance --password my_password

... I get the error "ERROR: (gcloud.sql.instances.set-root-password) The instance or operation is not in an appropriate state to handle the request."

On a perhaps related note if I try ...

$ gcloud beta sql users list --instance my_instance

... I get "ERROR: (gcloud.beta.sql.users.list) This operation isn"t valid for this instance."

Any help would be appreciated. The ability to execute these commands in script is intrinsic to our approach for managing access to database secrets in our kubernetes cluster.

Thanks very much!

--Mark

--
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/6d091c3d-a265-47df-8966-9696bf299bf3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment