GCloud SQL Proxy cannot connect, unclear errors

Question

I am having difficulty getting the gcloud sql proxy working on my local machine. I have gone through all the steps here however I am getting the following errors. It is unclear to me what is actually going wrong. Important things to note, I am not using a service account, I am authenticating with my own account through gcloud auth login and I am following the TCP sockets steps.

MySQL

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

GCloud SQL Proxy

couldn't connect to "<my instance connection name>": googleapi: Error 400: This operation isn"t valid for this instance., invalidOperation

GCloud Logs

...  status: {
   code:  2     
   message:  "UNKNOWN"     
  }
 }
 receiveTimestamp:  "2017-09-08T15:45:10.179994989Z"   
 resource: {…}  
 severity:  "ERROR"   
 timestamp:  "2017-09-08T15:45:04.289Z"   
}

Is it a first generation instance? Proxy connectivity only works for Second Generation instances. — Vadim
– Vadim, Commented Sep 8, 2017 at 17:53
yes, this is a first generation instance. That is a bummer. Good call, I see that requirement now in the docs, I don't know how I missed it before. — moonboy
– moonboy, Commented Sep 8, 2017 at 18:57

Vadim · Accepted Answer · 2017-09-09 00:04:30Z

1

The most likely reason you are receiving this error message is because you are using a First Generation instance.

Proxy connectivity is only supported for Second Generation instances.

answered Sep 9, 2017 at 0:04

Vadim

5,1261 gold badge28 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

GCloud SQL Proxy cannot connect, unclear errors

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related