Cannot change root password

[小川純平]

Hi,

I'm using Google Cloud SQL 2nd generation instance.
I tried to change root password but I couldn't because of unknown reason.

1. Go to Access Control > Users (https://console.cloud.google.com/sql/instances/[instance_name]/access-control/users)
2. Press "Change root password" button
3. Yellow tooltip: "Operation completed with errors, check the operation log for details." is shown.

I referred operation log [https://console.cloud.google.com/sql/instances/[instance_name]/operations]
It says:

Date/Time                    | Type                    | Status | Message
----------------------------------------------------------------------------------------------------------------------
Feb 29, 2016, 17:31:36 | Set root password | Done   | ⚠ An unknown error occurred

It happens on a instance, but it didn't happen on another error.

Is it a bug, or did I do something wrong?

Thanks,
Jumpei

[Chris Lewis]

Sounds like something weird happened. Please email clou...@google.com with your full instance name and I will look into it for you.

--
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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6105492b-7ae6-48a2-9e86-365ecb27eeac%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[David Newgas]

Hi,

It looks like your instance has it's "activation policy" set to "NEVER". Because of this the instance isn't running, so we can't make changes to the user. I'll try and see if we can get the error message improved. For now you can get back up by editing your instance in the cloud console and setting "activation policy" to "Always On" under the advanced settings.

Yours,

David

On Monday, February 29, 2016 at 9:33:49 AM UTC-8, Chris Lewis wrote:

Sounds like something weird happened. Please email clou...@google.com with your full instance name and I will look into it for you.

On Mon, Feb 29, 2016 at 1:01 AM 小川純平 <og...@growaspeople.org> wrote:

Hi,

I'm using Google Cloud SQL 2nd generation instance.
I tried to change root password but I couldn't because of unknown reason.

1. Go to Access Control > Users (https://console.cloud.google.com/sql/instances/[instance_name]/access-control/users)
2. Press "Change root password" button
3. Yellow tooltip: "Operation completed with errors, check the operation log for details." is shown.

I referred operation log [https://console.cloud.google.com/sql/instances/[instance_name]/operations]
It says:

Date/Time                    | Type                    | Status | Message
----------------------------------------------------------------------------------------------------------------------
Feb 29, 2016, 17:31:36 | Set root password | Done   | ⚠ An unknown error occurred

It happens on a instance, but it didn't happen on another error.

Is it a bug, or did I do something wrong?

Thanks,
Jumpei

--
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+unsub...@googlegroups.com.

[小川純平]

Thanks Chris and David.

Got it. I changed activation policy to ALWAYS ON, and I could changed password.