Google Cloud SQL (Second Generation) - Read Replica Instances Inoperable - Bug Report

57 views
Skip to first unread message

Graphics Geeks

unread,
Jan 26, 2016, 11:11:27 AM1/26/16
to Google Cloud SQL discuss
I want to officially report that the Google Cloud SQL read replica/slave instances are currently inoperable from my project.

I can connect to the master with no problems - both with SSL and not.

But the slave is totally inaccessible, no matter what I do. 

Error : (1045) Access denied for user 'root'@'1.2.3.4' (using password: YES)

I am using the correct IP4 address of the slave instance.

I am using exactly the same connection username and password as the master. I have also tried every authorized network name. 


I have tried opening up all IP4 addresses as the authorized network.

I have tried connecting from different servers using PHP, just like I did with the master, connecting using a client on my laptop from different locations.

I have even tried deleting the slave and creating a new slave.

So now it's over to you guys to please fix this.

Lee Schumacher

unread,
Jan 26, 2016, 12:00:57 PM1/26/16
to google-cloud...@googlegroups.com
You need to set the user passwords for the replica separately.  You can do this from the cloud console under 'access control > users'.  The system tables don't get replicated so the users have to be created on each replica separately.

--
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/b58fe66a-5c49-4da4-9daa-3969f3a7c32e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Lee Schumacher | Software Engineer | lschu...@google.com | (650) 336-5330

Graphics Geeks

unread,
Jan 26, 2016, 12:31:04 PM1/26/16
to Google Cloud SQL discuss
Hello Lee,

Thanks for helping me.

I'm a bit confused about this, since it doesn't seem from the interface that I can even set any users for a read replica instance.

And setting the root password is not allowed for the replica - it says it has to be the same as the master?



Kind regards
replicaconnecct.jpg

Vishnu Fafat

unread,
Jan 26, 2016, 1:25:33 PM1/26/16
to google-cloud...@googlegroups.com
Hi,

The users from the master are replicated to the replica. So, you should be able to connect to the replica if you provide the right information. These are the steps I followed:

1. Add a user on master instance for all hosts. (CREATE USER 'abcdefg'@'%' IDENTIFIED BY 'abcdef';)
2. Flush privileges.
3. Connect to the replica instance.


--
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/98c7fec1-e5cb-443f-8122-c2a53a072caa%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--
Vishnu Fafat

Graphics Geeks

unread,
Jan 26, 2016, 2:47:05 PM1/26/16
to Google Cloud SQL discuss
Ok, I added a user on the master with a new password. And I made sure it had all the same privileges as the root.

I also flushed the privileges.

Doesn't seem to connect still? Does it take a day or something to be replicated over into the slave?

I totally appreciate your help. From the google architecture side of things though this all seems pretty crazy. 

Why not just have a configurable user list on the control panel? I know making forms is a pain, but come on - seriously?

On Tuesday, January 26, 2016 at 7:25:33 PM UTC+1, Vishnu Fafat wrote:
Hi,

The users from the master are replicated to the replica. So, you should be able to connect to the replica if you provide the right information. These are the steps I followed:

1. Add a user on master instance for all hosts. (CREATE USER 'abcdefg'@'%' IDENTIFIED BY 'abcdef';)
2. Flush privileges.
3. Connect to the replica instance.

On Tue, Jan 26, 2016 at 9:31 AM, Graphics Geeks <graphic...@gmail.com> wrote:
Hello Lee,

Thanks for helping me.

I'm a bit confused about this, since it doesn't seem from the interface that I can even set any users for a read replica instance.

And setting the root password is not allowed for the replica - it says it has to be the same as the master?



Kind regards




On Tuesday, January 26, 2016 at 6:00:57 PM UTC+1, Lee S. wrote:
You need to set the user passwords for the replica separately.  You can do this from the cloud console under 'access control > users'.  The system tables don't get replicated so the users have to be created on each replica separately.


--
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.



--
Vishnu Fafat

Vishnu Fafat

unread,
Jan 26, 2016, 3:08:09 PM1/26/16
to google-cloud...@googlegroups.com
On Tue, Jan 26, 2016 at 11:47 AM, Graphics Geeks <graphic...@gmail.com> wrote:
Ok, I added a user on the master with a new password. And I made sure it had all the same privileges as the root.

I also flushed the privileges.

Doesn't seem to connect still? Does it take a day or something to be replicated over into the slave?

The changes are near-instantly propagated. Please send an email to clou...@google.com with the instance details and the commands that you are running to help you debug this issue. (Also, ignore its auto reply).
 

I totally appreciate your help. From the google architecture side of things though this all seems pretty crazy. 

Why not just have a configurable user list on the control panel? I know making forms is a pain, but come on - seriously?

The feature still needs work to be enabled for Second Generation instances.
 

On Tuesday, January 26, 2016 at 7:25:33 PM UTC+1, Vishnu Fafat wrote:
Hi,

The users from the master are replicated to the replica. So, you should be able to connect to the replica if you provide the right information. These are the steps I followed:

1. Add a user on master instance for all hosts. (CREATE USER 'abcdefg'@'%' IDENTIFIED BY 'abcdef';)
2. Flush privileges.
3. Connect to the replica instance.

On Tue, Jan 26, 2016 at 9:31 AM, Graphics Geeks <graphic...@gmail.com> wrote:
Hello Lee,

Thanks for helping me.

I'm a bit confused about this, since it doesn't seem from the interface that I can even set any users for a read replica instance.

And setting the root password is not allowed for the replica - it says it has to be the same as the master?



Kind regards




On Tuesday, January 26, 2016 at 6:00:57 PM UTC+1, Lee S. wrote:
You need to set the user passwords for the replica separately.  You can do this from the cloud console under 'access control > users'.  The system tables don't get replicated so the users have to be created on each replica separately.


--
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.



--
Vishnu Fafat

--
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/36317033-2900-4e20-adad-6a56f027dfd0%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--
Vishnu Fafat

Graphics Geeks

unread,
Jan 26, 2016, 3:16:35 PM1/26/16
to Google Cloud SQL discuss
Ok, yes it is in beta, I'm not upset about it. And thanks again....

Just would really love to get access to that read server so I can shift all the heavy duty reads over there...
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.



--
Vishnu Fafat

--
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.



--
Vishnu Fafat
Reply all
Reply to author
Forward
0 new messages