Tuesday, March 15, 2016

[google-cloud-sql-discuss] Re: "Lost connection to MySQL server" in Cloud Proxy

I run Cloud SQL Proxy client via cron (@reboot) but when I tried to kill proxy client process and re-run it, additional error message is shown (maybe by Cloud SQL Proxy client)

$ sudo /usr/local/bin/cloud_sql_proxy -dir=/tmp/cloudsql -fuse &
2016/03/16 04:20:22 Mounting "/tmp/cloudsql"...
2016/03/16 04:20:22 Mounted "/tmp/cloudsql"
2016/03/16 04:20:22 Socket prefix: /tmp/cloudsql

$ mysql -u notel -S /tmp/cloudsql/notelcrms:asia-east1:productions
2016/03/16 04:20:57 couldn't connect to "notelcrms:asia-east1:productions": POST "https://www.googleapis.com/sql/v1beta4/projects/notelcrms/instances/productions/createEphemeral": 403 Forbidden; Body="{\n \"error\": {\n \"errors\": [\n {\n \"domain\": \"global\",\n \"reason\": \"insufficientPermissions\",\n \"message\": \"Insufficient Permission\"\n }\n ],\n \"code\": 403,\n \"message\": \"Insufficient Permission\"\n }\n}\n"; read error: <nil>
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

In the first post of this thread, I thought this error message is shown when -credential_file is not specified, but actually it wasn't shown on my first trial because Proxy client runs from cron.

I will re-check MySQL users registration.

--
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/8f548c0c-94c4-45cf-a281-9a817aa18454%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment