[google-cloud-sql-discuss] Why do you have to create a service account under the entire project for cloud sql proxy to work?

Why do you have to create a service account under the entire project for cloud sql proxy to work? When I remove the service account under the entire project and assign it to only cloud sql instance, I get a " oauth2: cannot fetch token: 401 Unauthorized" 

--
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/29777299-a53c-47e1-8f7e-aad3c97d4db3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: A bit scary. Was able to connect to my instance using google cloud sql proxy after deleting my service role account

after an hour, now i'm getting

Post https://www.googleapis.com/sql/v1beta4/projects/hidden/instances/hidden/createEphemeral?alt=json: oauth2: cannot fetch token: 401 Unauthorized

Response: {

  "error" : "invalid_client",

  "error_description" : "The OAuth client was not found."

}

Does it take a while for google cloud sql proxy to sync up with changes to permissions?

On Thursday, March 31, 2016 at 12:49:47 PM UTC-4, wob...@yblew.com wrote:

A bit scary. Was able to connect to my instance using google cloud sql proxy after deleting my service role account

1. Created a service account under editor role

2. Was able to access my server using:

/usr/local/bin/cloud_sql_proxy -dir=/cloudsql -instances=my-project:us-central1:sql-instance=tcp:3306 -credential_file=/prod.json &

3. Deleted my service account

4. Was able to access my instance after deletion of service account using:

/usr/local/bin/cloud_sql_proxy -dir=/cloudsql -instances=my-project:us-central1:sql-instance=tcp:3306 -credential_file=/prod.json &

--
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/4b0da518-45c8-4bd1-967d-11ba1489c02e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] A bit scary. Was able to connect to my instance using google cloud sql proxy after deleting my service role account

A bit scary. Was able to connect to my instance using google cloud sql proxy after deleting my service role account

1. Created a service account under editor role

2. Was able to access my server using:

/usr/local/bin/cloud_sql_proxy -dir=/cloudsql -instances=my-project:us-central1:sql-instance=tcp:3306 -credential_file=/prod.json &

3. Deleted my service account

4. Was able to access my instance after deletion of service account using:

/usr/local/bin/cloud_sql_proxy -dir=/cloudsql -instances=my-project:us-central1:sql-instance=tcp:3306 -credential_file=/prod.json &

--
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/042a2622-79eb-40ea-9ee0-ab40aecb47e0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: use of closed network connection

Thank you Vadim, Kevin, and Herman.
Now it works fine!

--
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/63f77ee4-5050-4fb2-99bc-1365492390ed%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: use of closed network connection

We manually fixed the instance. Can you check if you can connect to it now? Thanks.

--
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/41a91cec-f090-432a-9e8b-954fd8b56247%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: use of closed network connection

Hey there, thanks for the post.

You've run into a known bug with one of our releases that some customers may hit, and I apologize for the friction you've encountered. Please send a mail to cloud-sql@google.com with your project and instance name and we will be able to do a spot update on your instance to fix the issue permanently.

We'll be rolling out an update to fix all other instances in the coming weeks to ensure they won't encounter the same bug.

On Wednesday, March 30, 2016 at 4:32:25 AM UTC-7, 小川純平 wrote:

I found my CakePHP based app cannot connect to Cloud SQL 2nd generation instance via Cloud SQL Proxy.
I once succeeded to connect, and today I found this problem occurs. I build infrastructure as code and I believe there is not so big change from then. (But I'm not sure.)

I tried to connect from mysql client and following error message is shown.

$ mysql -u USERNAME -S /tmp/cloudsql/PROJECT_NAME:asia-east1:INSTANCE_NAME
ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: NO)

I killed existing Cloud SQL Proxy and start Cloud SQL Proxy manually. Then following error message is shown.

$ sudo /usr/local/bin/cloud_sql_proxy -dir=/tmp/cloudsql -fuse
2016/03/30 10:58:57 Mounting "/tmp/cloudsql"...
2016/03/30 10:58:57 Mounted "/tmp/cloudsql"
2016/03/30 10:58:57 Socket prefix: /tmp/cloudsql
2016/03/30 10:59:01 to "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read unix /tmp/cloudsql-proxy-tmp/PROJECT_NAME:asia-east1:INSTANCE_NAME->@: use of closed network connection
2016/03/30 10:59:05 from "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read tcp GCE_INSTANCE_INTERNAL_IP:48482->INSTANCE_IP:3307: use of closed network connection
2016/03/30 10:59:24 to "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read unix /tmp/cloudsql-proxy-tmp/PROJECT_NAME:asia-east1:INSTANCE_NAME->@: use of closed network connection
2016/03/30 10:59:29 to "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read unix /tmp/cloudsql-proxy-tmp/PROJECT_NAME:asia-east1:INSTANCE_NAME->@: use of closed network connection
2016/03/30 10:59:29 to "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read unix /tmp/cloudsql-proxy-tmp/PROJECT_NAME:asia-east1:INSTANCE_NAME->@: use of closed network connection
...

I searched this Google Group with text "use of closed network connection" and find following posts. There is similar error message, but I'm not sure if it is related to my problem.

Trying to Connect to database in PHP using PDO and Cloud SQL Proxy
https://groups.google.com/forum/#!topicsearchin/google-cloud-sql-discuss/use$20of$20closed$20network$20connection/google-cloud-sql-discuss/AsVdpcRF5gA

Thanks in advance,
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/1854a99f-5593-4d80-a1b7-60bfa887bdc3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] use of closed network connection

Did this username have a password set before? 

I think we've previously seen an issue with how MySQL handles empty passwords.

If a password was set before, and then changed to empty, MySQL may revert back to the non-empty password on restart.

Can you try changing the password to empty for that user and see if that helps?

On Wed, Mar 30, 2016 at 4:32 AM 小川純平 <ogawa@growaspeople.org> wrote:

I found my CakePHP based app cannot connect to Cloud SQL 2nd generation instance via Cloud SQL Proxy.
I once succeeded to connect, and today I found this problem occurs. I build infrastructure as code and I believe there is not so big change from then. (But I'm not sure.)

I tried to connect from mysql client and following error message is shown.

$ mysql -u USERNAME -S /tmp/cloudsql/PROJECT_NAME:asia-east1:INSTANCE_NAME
ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: NO)

I killed existing Cloud SQL Proxy and start Cloud SQL Proxy manually. Then following error message is shown.

$ sudo /usr/local/bin/cloud_sql_proxy -dir=/tmp/cloudsql -fuse
2016/03/30 10:58:57 Mounting "/tmp/cloudsql"...
2016/03/30 10:58:57 Mounted "/tmp/cloudsql"
2016/03/30 10:58:57 Socket prefix: /tmp/cloudsql
2016/03/30 10:59:01 to "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read unix /tmp/cloudsql-proxy-tmp/PROJECT_NAME:asia-east1:INSTANCE_NAME->@: use of closed network connection
2016/03/30 10:59:05 from "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read tcp GCE_INSTANCE_INTERNAL_IP:48482->INSTANCE_IP:3307: use of closed network connection
2016/03/30 10:59:24 to "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read unix /tmp/cloudsql-proxy-tmp/PROJECT_NAME:asia-east1:INSTANCE_NAME->@: use of closed network connection
2016/03/30 10:59:29 to "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read unix /tmp/cloudsql-proxy-tmp/PROJECT_NAME:asia-east1:INSTANCE_NAME->@: use of closed network connection
2016/03/30 10:59:29 to "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read unix /tmp/cloudsql-proxy-tmp/PROJECT_NAME:asia-east1:INSTANCE_NAME->@: use of closed network connection
...

I searched this Google Group with text "use of closed network connection" and find following posts. There is similar error message, but I'm not sure if it is related to my problem.

Trying to Connect to database in PHP using PDO and Cloud SQL Proxy
https://groups.google.com/forum/#!topicsearchin/google-cloud-sql-discuss/use$20of$20closed$20network$20connection/google-cloud-sql-discuss/AsVdpcRF5gA

Thanks in advance,
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c7a658ba-afe8-4a97-b542-7159137c6611%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CABDU3p1hab4aitY-%3DtUD1zHMVhzrf4tB1aMpHEHZ1JHG5RPz6g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] use of closed network connection

I found my CakePHP based app cannot connect to Cloud SQL 2nd generation instance via Cloud SQL Proxy.
I once succeeded to connect, and today I found this problem occurs. I build infrastructure as code and I believe there is not so big change from then. (But I'm not sure.)

I tried to connect from mysql client and following error message is shown.

$ mysql -u USERNAME -S /tmp/cloudsql/PROJECT_NAME:asia-east1:INSTANCE_NAME
ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: NO)

I killed existing Cloud SQL Proxy and start Cloud SQL Proxy manually. Then following error message is shown.

$ sudo /usr/local/bin/cloud_sql_proxy -dir=/tmp/cloudsql -fuse
2016/03/30 10:58:57 Mounting "/tmp/cloudsql"...
2016/03/30 10:58:57 Mounted "/tmp/cloudsql"
2016/03/30 10:58:57 Socket prefix: /tmp/cloudsql
2016/03/30 10:59:01 to "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read unix /tmp/cloudsql-proxy-tmp/PROJECT_NAME:asia-east1:INSTANCE_NAME->@: use of closed network connection
2016/03/30 10:59:05 from "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read tcp GCE_INSTANCE_INTERNAL_IP:48482->INSTANCE_IP:3307: use of closed network connection
2016/03/30 10:59:24 to "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read unix /tmp/cloudsql-proxy-tmp/PROJECT_NAME:asia-east1:INSTANCE_NAME->@: use of closed network connection
2016/03/30 10:59:29 to "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read unix /tmp/cloudsql-proxy-tmp/PROJECT_NAME:asia-east1:INSTANCE_NAME->@: use of closed network connection
2016/03/30 10:59:29 to "PROJECT_NAME:asia-east1:INSTANCE_NAME" via INSTANCE_IP:3307: read unix /tmp/cloudsql-proxy-tmp/PROJECT_NAME:asia-east1:INSTANCE_NAME->@: use of closed network connection
...

I searched this Google Group with text "use of closed network connection" and find following posts. There is similar error message, but I'm not sure if it is related to my problem.

Trying to Connect to database in PHP using PDO and Cloud SQL Proxy
https://groups.google.com/forum/#!topicsearchin/google-cloud-sql-discuss/use$20of$20closed$20network$20connection/google-cloud-sql-discuss/AsVdpcRF5gA

Thanks in advance,
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c7a658ba-afe8-4a97-b542-7159137c6611%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: populate time zone table

The issue is that the MySQL time zone tables are not populated by default and need to be populated on the database instance prior to using the `CONVERT_TZ` function.  See "Populating the Time Zone Tables" here:

     https://dev.mysql.com/doc/refman/5.6/en/time-zone-support.html

Has anyone found a solution to this issue?

On Friday, February 12, 2016 at 11:32:06 AM UTC-6, David Newgas wrote:

If you have stored the column to group as a DATETIME or TIMESTAMP type, or if you have stored as a DATE and also have the TIME in a different then it is possible - just convert to the desired timezone with CONVERT_TZ before grouping etc. If you have only stored the DATE and the date was determined in UTC then you cannot do this, as you don't have enough info to determine which day it occured in the desired timezone.

Note that this question actually has nothing Cloud SQL specific - this simply applies to MySQL in general. Because the MySQL community is much larger than the Cloud SQL community you are better off asking questions like this in a general MySQL forum.  I recommend Stack Overflow, where this question was already asked and answered several times.

David

On Thu, Feb 11, 2016 at 11:45 PM, Jaap Taal <ja...@q42.nl> wrote:

I you want to GROUP BY dates in timezone X, but the dates are stored in UTC.

Did anyone ever solve this?

--
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/cf4c26b2-b9f7-4b33-9e93-6051ebfbca0f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/128f086b-09c0-4bdc-869d-73c7ac86fdde%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Trying to Connect to database in PHP using PDO and Cloud SQL Proxy

Sorry for the delay.

I'm a little confused by your question but I'll try to answer what I think you're asking. Feel free to ask again if I missed the mark.

If you create a user dev@'cloudsqlproxy~%' in a database named 'sql-inst' in 'us-central1' in the project 'my-project', then you can connect to that instance using the following 'mysql' command (while the proxy is running on that machine):

mysql -u dev -S /cloudsql/my-project:us-central1:sql-inst

The user that has the 'cloudsqlproxy~%' hostname is the one you want to provide as the '-u' flag (short for --user).

For your PHP/PDO script, it appears that the second parameter of the constructor is the username [0]. In your original post you put 'db' for this value; given a dev@'cloudsqlproxy~%' user, you should use 'dev' instead.

[0] http://php.net/manual/en/class.pdo.php

On Wed, Mar 16, 2016 at 9:48 PM, <wobeng@yblew.com> wrote:

It seems the only thing stable is below, however it seems I have to assign all databases in mysql to dev@'cloudsqlproxy~%' user before I can see interact with database through the proxy via non socket which is weird; can you confirm? I checked developmentDB.json and it's an editor of all my insitances. If I remember correctly, Kevin said I don't have to assign dev@'cloudsqlproxy~%' to anything, just create it and i'm all set. 

sudo ./cloud_sql_proxy -dir=/cloudsql -instances=my-project:us-central1:sql-inst=tcp:3308 -credential_file=/root/developmentDB.json &

I also tried below for php/mysqli and got permission denied on the browser but it worked for php/pdo in browser

./cloud_sql_proxy -dir=/cloudsql -instances=my-project:us-central1:sql-inst &
mysql -u <user_name> -S /cloudsql/my-project:us-central1:sql-inst

On Wednesday, March 16, 2016 at 5:07:10 PM UTC-4, Vadim Berezniker wrote:

No, I see the same problem. I filed an issue to investigate: https://github.com/GoogleCloudPlatform/cloudsql-proxy/issues/7

Can you use the non-fuse mode as a workaround until the issue is resolved?

On Wed, Mar 16, 2016 at 1:46 PM <wob...@yblew.com> wrote:

So after you disabled Selinux it worked 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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/58c2ac04-1a5e-4c47-91fc-2d3fa3116925%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/AsVdpcRF5gA/unsubscribe.
To unsubscribe from this group and all its topics, 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/b9f94b0d-6647-4ca4-9892-ae818f17cdeb%40googlegroups.com.

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

--
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/CAB%3DH8NXyf2m_cqaCbSezABt4bqFEESii%2BHMgSS40%3DxiO%3DeXc-Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Instance suspended while billing account attached

Apologies, there was an issue with the automated process for unsuspending instances, which should now be resolved.

Please let us know if you're still experiencing issues.

On Sun, Mar 20, 2016 at 10:45 AM <mooglethestore@gmail.com> wrote:

I'm having the same issue and the 'Restart' option is not clickable, just grayed-out. 

On Sunday, March 20, 2016 at 12:55:22 PM UTC-4, Adam (Cloud Platform Support) wrote:

The instance appears to have been shut down on account of the trial ending. I don't see anything to the effect of the project or instance being deleted though. Can you try going to the Developers Console -> 'SQL' -> <instance name> and trying to start or restart the instance?

On Sunday, March 20, 2016 at 10:16:21 AM UTC-4, Augustin Wenger wrote:

Hi everyone,

My instance has been suspended at the end of my free trial, while I'm under the impression that I enabled billing a long time ago : I can see my billing account associated to CloudSQL.

As of now, my instance is suspended (since yesterday evening it seems according to the storage graph) and is showing an alarming message in the console : "Being deleted..."

Is my database actually being deleted ? What did I do wrong in setting my account billing ? How can I fix my screw ups ?

I also sent a message to the billing support, but the "Being deleted..." make me scared of waiting a few business days.

Thanks in advance,

--
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/c9190462-36c2-4b98-a192-2d447df7f6be%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CABDU3p19haSHQDo0aEM48Q94ffK8UCStEx0ftSX6OSCEPwszzA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Suspended due to billing issue, wont unsuspend

Hi Cristian,

Apologies, there was an issue with the automated process for unsuspending instances, which should now be resolved.

On Sat, Mar 19, 2016 at 2:54 PM Cristian Sanchez <pepsiv6@gmail.com> wrote:

My cloud sql was suspended due to a billing issue i believe (free trial ended without warning)

I have already made a new billing account and made a payment, added to the project to it. however my instance is still suspended. i'm not sure what to do now, can't access my database or make backups at this point either.

I'm able to make a new instance, but i would like to get my data from the suspended instance. 

Instance name: supple-gearbox-629:us-central1:flood-01

--
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/4559f4d6-f56b-4080-8568-d614e7f7de57%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CABDU3p3bqOF1YP%3DahVynODMA7-LYdnpxSXhcQpKzu_8wqEcj6w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Pivoting result set

Thanks for posting your question here.

You are correct that you would not need use an aggregate function. However, what you seek to accomplish has some caveats. The data set you propose shows no limit to the number of companies a Original Company / Person Name may be a part of. If, one may be a board member of 21 companies, your result set would need to have the 21 additional columns to summarize said memberships. Accomplishing this with a single query may be possible but will be terribly inefficient and error. It's also not a recommended practice with SQL to turn rows into columns which is essentially what is requested with the 'Member of Board' data set column.

If this must be accomplished, you may be able to accomplish this with using cursors to iterate through your data set and upsert to your resulting table. Unfortunately, data relationships like these are often better represented by data systems like BigQuery which allows repeated records or Datastore which has repeated properties.

I hope this helps.

On Wednesday, March 16, 2016 at 2:56:32 PM UTC-4, Victor Chirinian wrote:

Hello Everyone,

I was asked to do a report and wanted to pivot the result set to mirror the destination format below. I don't think i need to use an aggregate function, and I am having a hard time navigating through existing reference material online. The goal is to have the first two columns of the second table be unique, and the third column broken down into individual columns. Any help would be appreciated, thank you!

Orignal Company	Person Name	Member of Board
Company D	John Doe	Company A
Company D	John Doe	Company B
Company D	John Doe	Company C
Orignal Company	Person Name	Board 1	Board 2	Board 3
Company D	John Doe	Company A	Company B	Company C

--
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/2082c4a2-1f81-4a0a-a361-904a52911775%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Cloud SQL instances keep getting suspended. Why?

Would you please send me your project ID privately? 

Sincerely,

On Saturday, March 19, 2016 at 2:13:56 AM UTC-4, mooglet...@gmail.com wrote:

Each time I create a Cloud SQL instance, I'm able to use it for a minutes and then it goes to the suspended state and I'm no longer able to access it. Any idea why this would be occurring? I've enabled billing.

--
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/510e0f7f-7755-4a1e-a61c-c5f87d00e981%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Instance suspended while billing account attached

I'm having the same issue and the 'Restart' option is not clickable, just grayed-out. 

On Sunday, March 20, 2016 at 12:55:22 PM UTC-4, Adam (Cloud Platform Support) wrote:

The instance appears to have been shut down on account of the trial ending. I don't see anything to the effect of the project or instance being deleted though. Can you try going to the Developers Console -> 'SQL' -> <instance name> and trying to start or restart the instance?

On Sunday, March 20, 2016 at 10:16:21 AM UTC-4, Augustin Wenger wrote:

Hi everyone,

My instance has been suspended at the end of my free trial, while I'm under the impression that I enabled billing a long time ago : I can see my billing account associated to CloudSQL.

As of now, my instance is suspended (since yesterday evening it seems according to the storage graph) and is showing an alarming message in the console : "Being deleted..."

Is my database actually being deleted ? What did I do wrong in setting my account billing ? How can I fix my screw ups ?

I also sent a message to the billing support, but the "Being deleted..." make me scared of waiting a few business days.

Thanks in advance,

--
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/c9190462-36c2-4b98-a192-2d447df7f6be%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Instance suspended while billing account attached

The instance appears to have been shut down on account of the trial ending. I don't see anything to the effect of the project or instance being deleted though. Can you try going to the Developers Console -> 'SQL' -> <instance name> and trying to start or restart the instance?

On Sunday, March 20, 2016 at 10:16:21 AM UTC-4, Augustin Wenger wrote:

Hi everyone,

My instance has been suspended at the end of my free trial, while I'm under the impression that I enabled billing a long time ago : I can see my billing account associated to CloudSQL.

As of now, my instance is suspended (since yesterday evening it seems according to the storage graph) and is showing an alarming message in the console : "Being deleted..."

Is my database actually being deleted ? What did I do wrong in setting my account billing ? How can I fix my screw ups ?

I also sent a message to the billing support, but the "Being deleted..." make me scared of waiting a few business days.

Thanks in advance,

--
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/e9c796f4-63e0-4601-ad4f-c3880435217b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Instance suspended while billing account attached

Hi everyone,

My instance has been suspended at the end of my free trial, while I'm under the impression that I enabled billing a long time ago : I can see my billing account associated to CloudSQL.

As of now, my instance is suspended (since yesterday evening it seems according to the storage graph) and is showing an alarming message in the console : "Being deleted..."

Is my database actually being deleted ? What did I do wrong in setting my account billing ? How can I fix my screw ups ?

I also sent a message to the billing support, but the "Being deleted..." make me scared of waiting a few business days.

Thanks in advance,

--
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/b625259e-100c-4976-84df-09be48462469%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Suspended due to billing issue, wont unsuspend

Hello Cristian,

Could you try to manually restart your Cloud SQL instance?

Sincerely,

On Saturday, March 19, 2016 at 5:54:05 PM UTC-4, Cristian Sanchez wrote:

My cloud sql was suspended due to a billing issue i believe (free trial ended without warning)

I have already made a new billing account and made a payment, added to the project to it. however my instance is still suspended. i'm not sure what to do now, can't access my database or make backups at this point either.

I'm able to make a new instance, but i would like to get my data from the suspended instance. 

Instance name: supple-gearbox-629:us-central1:flood-01

--
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/6a284daf-1a57-4216-9da7-f175fda18591%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Suspended due to billing issue, wont unsuspend

My cloud sql was suspended due to a billing issue i believe (free trial ended without warning)

I have already made a new billing account and made a payment, added to the project to it. however my instance is still suspended. i'm not sure what to do now, can't access my database or make backups at this point either.

I'm able to make a new instance, but i would like to get my data from the suspended instance. 

Instance name: supple-gearbox-629:us-central1:flood-01

--
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/4559f4d6-f56b-4080-8568-d614e7f7de57%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Cloud SQL instances keep getting suspended. Why?

Each time I create a Cloud SQL instance, I'm able to use it for a minutes and then it goes to the suspended state and I'm no longer able to access it. Any idea why this would be occurring? I've enabled billing.

--
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/da2644af-921b-4c35-b80f-ffd3b011a6ce%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Cannot stop import

Uh, so the only way is still to log in and do the show processlist/kill combo. The sql connect command is failing because it needs to authorize a new IP, but it can't do this while the import  is running.

Your instance already has 3 IPs authorized (which you can see in the authorizednetworks section of 'gcloud sql instances describe INSTANCE'). If you can connect from one of those IP addresses then you can kill from them. You can also do so from within your GAE app, but doing so is a bit harder.

On Fri, Mar 18, 2016 at 12:12 PM, <peter.shin@syw.com> wrote:

Using "gcloud beta sql connect [INSTANCE-ID]" results in "ERROR: (gcloud.beta.sql.connect) Operation failed because another operation was already in progress."

The storage is indeed increasing, and "Read/Write InnoDB Pages" is sustained at around 89 pages/sec, lowering occasionally.

Is there a way to kill the current operation, as I don't want it to finish anymore?

--
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/3eb2775f-99c7-45c0-ab03-7534735e4721%40googlegroups.com.

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

--
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/CAJZK_bbUxAG2n3sUhx5LsuOCLkqa%3DY3kHTUwvhsqkKpYRNjEqA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Cannot stop import

Using "gcloud beta sql connect [INSTANCE-ID]" results in "ERROR: (gcloud.beta.sql.connect) Operation failed because another operation was already in progress."

The storage is indeed increasing, and "Read/Write InnoDB Pages" is sustained at around 89 pages/sec, lowering occasionally.

Is there a way to kill the current operation, as I don't want it to finish anymore?

--
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/3eb2775f-99c7-45c0-ab03-7534735e4721%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Cannot stop import

Looking at the metrics on your instance it does appear that the load is till running - IOPS are elevated and storage used is increasing. Take a look at the "Read/Write InnoDB Pages" and "Storage Used" graphs on https://console.cloud.google.com/sql/instances/INSTANCE_ID/overview?project=YOUR_PROJECT .

I believe you are getting that error because your Cloud Shell instance is not authorized to access your Cloud SQL instance, and not for any reason relating to the import. Try using "gcloud beta sql connect INSTANCE_ID" to connect to the SQL instance from cloud shell. 

David

On Fri, Mar 18, 2016 at 11:34 AM, <peter.shin@syw.com> wrote:

Cloud Shell is a Google-provided command-line access, which includes a MySQL client. I cannot log into the instance as the client says "ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0"

I got a notification saying: "Import data into Cloud SQL instance / Unknown error. / Retry" from Google's notifications, but it doesn't seem the process has stopped, as the status is still "Running."

--
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/7350f3e9-3786-441e-8cea-fea58b56bec4%40googlegroups.com.

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

--
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/CAJZK_bYEKGrDLkOL762CSWmmJW9oo_noqWx7ZzS8Fk5myGOqug%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Cannot stop import

Cloud Shell is a Google-provided command-line access, which includes a MySQL client. I cannot log into the instance as the client says "ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0"

I got a notification saying: "Import data into Cloud SQL instance / Unknown error. / Retry" from Google's notifications, but it doesn't seem the process has stopped, as the status is still "Running."

--
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/7350f3e9-3786-441e-8cea-fea58b56bec4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Cannot stop import

Hi,

If you can log into the instance, you can use 'SHOW PROCESSLIST;' to find the id of the import thread and then use 'KILL ID;' to terminate it. As we don't provide a remote abort you can't cancel it if you can't log in. It will time out after 24 hours though.

I'm not actually sure which 'cloud shell' you are using to connect to you instance, could you show a screenshot or URL? What error message do you get connecting? Can you connect with the MySQL command line?

David

On Fri, Mar 18, 2016 at 10:30 AM, <peter.shin@syw.com> wrote:

I was importing a CSV in GCS into a table using the Import functionality, but it's taking a while. I cannot stop the import or connect to the instance from Cloud Shell. How can a I force stop the import?

--
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/5ea81770-3f1a-40d4-a7ea-48055a4c4790%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CAJZK_bbrK3oiBV%3DABB6X8YjYXojKLw%3DPoL8mPcx0zes6AOTyVA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Cannot stop import

I was importing a CSV in GCS into a table using the Import functionality, but it's taking a while. I cannot stop the import or connect to the instance from Cloud Shell. How can a I force stop the import?

--
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/5ea81770-3f1a-40d4-a7ea-48055a4c4790%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Schedule Uptime

Hello Khurram,

You cannot directly configure the instance to shut down at any given time. If your instance is surely going to be inactive, you can set the activation policy to ON DEMAND so it shuts itself off after 15 minutes of inactivity. The solution suggested by Vishnu above will also achieve what you want, however it will require using the API.

I hope it helps. Cheers!

--
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/57b97d16-775b-488f-9e7d-182a7534aa48%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Trying to Connect to database in PHP using PDO and Cloud SQL Proxy

To add to my previous question, below is the question I asked and answer I got from Kevin in our previous interaction 

On Thursday, March 17, 2016 at 12:48:22 AM UTC-4, wob...@yblew.com wrote:

It seems the only thing stable is below, however it seems I have to assign all databases in mysql to dev@'cloudsqlproxy~%' user before I can see interact with database through the proxy via non socket which is weird; can you confirm? I checked developmentDB.json and it's an editor of all my insitances. If I remember correctly, Kevin said I don't have to assign dev@'cloudsqlproxy~%' to anything, just create it and i'm all set. 

sudo ./cloud_sql_proxy -dir=/cloudsql -instances=my-project:us-central1:sql-inst=tcp:3308 -credential_file=/root/developmentDB.json &

I also tried below for php/mysqli and got permission denied on the browser but it worked for php/pdo in browser

./cloud_sql_proxy -dir=/cloudsql -instances=my-project:us-central1:sql-inst &
mysql -u <user_name> -S /cloudsql/my-project:us-central1:sql-inst

On Wednesday, March 16, 2016 at 5:07:10 PM UTC-4, Vadim Berezniker wrote:

No, I see the same problem. I filed an issue to investigate: https://github.com/GoogleCloudPlatform/cloudsql-proxy/issues/7

Can you use the non-fuse mode as a workaround until the issue is resolved?

On Wed, Mar 16, 2016 at 1:46 PM <wob...@yblew.com> wrote:

So after you disabled Selinux it worked 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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/58c2ac04-1a5e-4c47-91fc-2d3fa3116925%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/2cfb2f9b-2e80-46ee-b372-1bf43eb81d74%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Trying to Connect to database in PHP using PDO and Cloud SQL Proxy

It seems the only thing stable is below, however it seems I have to assign all databases in mysql to dev@'cloudsqlproxy~%' user before I can see interact with database through the proxy via non socket which is weird; can you confirm? I checked developmentDB.json and it's an editor of all my insitances. If I remember correctly, Kevin said I don't have to assign dev@'cloudsqlproxy~%' to anything, just create it and i'm all set. 

sudo ./cloud_sql_proxy -dir=/cloudsql -instances=my-project:us-central1:sql-inst=tcp:3308 -credential_file=/root/developmentDB.json &

I also tried below for php/mysqli and got permission denied on the browser but it worked for php/pdo in browser

./cloud_sql_proxy -dir=/cloudsql -instances=my-project:us-central1:sql-inst &
mysql -u <user_name> -S /cloudsql/my-project:us-central1:sql-inst

On Wednesday, March 16, 2016 at 5:07:10 PM UTC-4, Vadim Berezniker wrote:

No, I see the same problem. I filed an issue to investigate: https://github.com/GoogleCloudPlatform/cloudsql-proxy/issues/7

Can you use the non-fuse mode as a workaround until the issue is resolved?

On Wed, Mar 16, 2016 at 1:46 PM <wob...@yblew.com> wrote:

So after you disabled Selinux it worked 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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/58c2ac04-1a5e-4c47-91fc-2d3fa3116925%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/b9f94b0d-6647-4ca4-9892-ae818f17cdeb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Trying to Connect to database in PHP using PDO and Cloud SQL Proxy

No, I see the same problem. I filed an issue to investigate: https://github.com/GoogleCloudPlatform/cloudsql-proxy/issues/7

Can you use the non-fuse mode as a workaround until the issue is resolved?

On Wed, Mar 16, 2016 at 1:46 PM <wobeng@yblew.com> wrote:

So after you disabled Selinux it worked 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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/58c2ac04-1a5e-4c47-91fc-2d3fa3116925%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CABDU3p3A%2BCwFVOMe7H4JScJ12HyyX5Bo5DLAg5hYr%3DGr9to_MA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

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

Glad to hear it's working.

I have filed an issue to improve the error message: https://github.com/GoogleCloudPlatform/cloudsql-proxy/issues/6

On Wed, Mar 16, 2016 at 2:06 AM 小川純平 <ogawa@growaspeople.org> wrote:

I created instance with --scopes sql,sql-admin option, then successfully connected from MySQL client on the created instance.

$ gcloud compute instances create "$instance_to_create" … --scopes sql,sql-admin

My web app also successfully connected to DB.

Thank you so much for your kind support, Vadim!

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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/452595c6-6b46-4818-a2d4-3c0f9fb34424%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CABDU3p39Y%3DDH02iviNkUcc%2BeaThuBcC5V-%2BL_3ZfgbUjaSLbpA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Trying to Connect to database in PHP using PDO and Cloud SQL Proxy

So after you disabled Selinux it worked 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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/58c2ac04-1a5e-4c47-91fc-2d3fa3116925%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.