Compute Engine Instance and SQL instance (2nd gen) in same project won't connect

[Michael Mancini]

Unfortunately I cannot seam to find an answer that fits my situation!

I have followed the following guides when trying to connect a compute instance running CentOS 7 and docker to my Cloud SQL instance using the docker-proxy and can never connect on completion!

https://cloud.google.com/sql/docs/mysql/connect-docker

when I run gcloud compute instances describe [instance-name] i can verify the scope for https://www.googleapis.com/auth/cloud-platform is enabled

I run: sudo yum install mysql

- no errors

I then run: sudo usermod -aG docker $USER

-no errors

I then run: docker pull gcr.io/cloudsql-docker/gce-proxy:1.09

- no errors

I then configure using TCP sockets as follows:

sudo docker run -d -v /cloudsql:/cloudsql \

-p 127.0.0.1:3306:3306 \

gcr.io/cloudsql-docker/gce-proxy:1.09 /cloud_sql_proxy \

-instances=mycloud-sql-connection-name:us-central1:mysql-cloud-db-name=tcp_0.0.0.0:3306

after I hit enter a logn string is passed back

6aa53XXXXXXd58b4622337XXXXXXXXc92dec645dXXXXXXXXXa7eXXXX

-no errors produced

NOTE: configuring the TCP socket (the directions say to exclude the -v [PATH_TO_KEY_FILE]:/config and -credential_file=/config when you are on a Compute Engine instance (which I am)

I then run: mysql -u username -p --host 127.0.0.1

and get this error:

ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

If anyone can point in the right direction to resolving this I would greatly appreciate it!

Again both these instances are under the same project on GCP and have credentials set to allow all access from apps and instances within the project!

I've been at this for hours with no luck...

~sidgrafix

[Pia Chamberlain]

Hi Michael,

Sorry you've been having issue. One suggestion-- 

this could possibly be SELinux issue. See step 4 here:

 

https://cloud.google.com/sql/docs/mysql/connect-compute-engine#gce-connect-proxy 

Let us know if that solves it!

[Duc Eric]

HI Pla.

I follow the instruction however I can not connect to sql cloud.

I get stuck in `./cloud_sql_proxy -instances=<INSTANCE_CONNECTION_NAME>=tcp:3306`

If possible, could you give me a short video ?

Thank you

[Pia Chamberlain]

Sorry, we don't have any videos for this task yet. 

--
You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/aGR33zDUDgg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/f5de2357-ad6a-4428-887e-21b90fe11a82%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Pia Chamberlain |

Technical Writer |

pi...@google.com |

Cloud SQL

[Duc Eric]

Thank you for supporting