Re: [google-cloud-sql-discuss] Cannot change root password

Hi,

It looks like your instance has it's "activation policy" set to "NEVER". Because of this the instance isn't running, so we can't make changes to the user. I'll try and see if we can get the error message improved. For now you can get back up by editing your instance in the cloud console and setting "activation policy" to "Always On" under the advanced settings.

Yours,

David

On Monday, February 29, 2016 at 9:33:49 AM UTC-8, Chris Lewis wrote:

Sounds like something weird happened. Please email cloud-sql@google.com with your full instance name and I will look into it for you.

On Mon, Feb 29, 2016 at 1:01 AM 小川純平 <ogawa@growaspeople.org> wrote:

Hi,

I'm using Google Cloud SQL 2nd generation instance.
I tried to change root password but I couldn't because of unknown reason.

1. Go to Access Control > Users (https://console.cloud.google.com/sql/instances/[instance_name]/access-control/users)
2. Press "Change root password" button
3. Yellow tooltip: "Operation completed with errors, check the operation log for details." is shown.

I referred operation log [https://console.cloud.google.com/sql/instances/[instance_name]/operations]
It says:

Date/Time                    | Type                    | Status | Message
----------------------------------------------------------------------------------------------------------------------
Feb 29, 2016, 17:31:36 | Set root password | Done   | ⚠ An unknown error occurred

It happens on a instance, but it didn't happen on another error.

Is it a bug, or did I do something wrong?

Thanks,
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/6105492b-7ae6-48a2-9e86-365ecb27eeac%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/3960d84f-49bf-4f8d-8c66-6f333d19b2db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: lost connection to mysql server (GCE/Cloud SQL)

Is your instance availability "on-demand" or "always-on"?

On Monday, February 29, 2016 at 2:00:05 PM UTC-5, Jay Christopherson wrote:

I'm seeing a lot of this error from my GCE instance to my Cloud SQL instance:

lost connection to mysql server at 'reading authorization packet' system error: 4

Particularly this last Friday and Saturday.  I am not sure why this would be happening, since I have my GCE instance fully allowed to access the Cloud SQL instance.  I also don't see this on other setups where I am not using GCE/Cloud SQL, but using the same software app & setup (other than the Google hosting).

This doesn't seem normal, but maybe I've overlooked some setting or configuration.

--
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/3da1203a-1e03-41ba-a2b5-31f1cef4b326%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: please, I would want to sum whose identifiers are identical

Hey Ismael,

This forum is for discussion of Cloud SQL itself, and the better place to go for assistance with this is an SQL query resource. This is a common pattern in SQL and doesn't relate to Cloud SQL specifically.

On Monday, February 29, 2016 at 12:01:04 PM UTC-5, Ismael Tchonang wrote:

please, I would want to sum whose identifiers are identical

--
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/4e0b0b92-c45e-4615-9745-a7bad96a4416%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] lost connection to mysql server (GCE/Cloud SQL)

I'm seeing a lot of this error from my GCE instance to my Cloud SQL instance:

lost connection to mysql server at 'reading authorization packet' system error: 4

Particularly this last Friday and Saturday.  I am not sure why this would be happening, since I have my GCE instance fully allowed to access the Cloud SQL instance.  I also don't see this on other setups where I am not using GCE/Cloud SQL, but using the same software app & setup (other than the Google hosting).

This doesn't seem normal, but maybe I've overlooked some setting or configuration.

--
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/fcce3678-b135-4ce9-a598-f293ee6cf09f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] problem with import image or picture file from bucket to sql cloud database

Hi Chris

Thanks for the suggestions.  I have the images stored in the driveapp.  

Do you suggest any other places within google to store the images?

Thanks

Kevin

On Mon, Feb 29, 2016 at 12:44 PM, 'Chris Lewis' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

LOAD DATA LOCAL INFILE is not supported by our platform: https://cloud.google.com/sql/docs/introduction

My suggestion is that you probably don't really want images in your database anyway: it's more expensive in time to retrieve and more expensive when stored at rest. Instead, I would leave it where it is in GCS and just keep the link to it your database.

On Sat, Feb 27, 2016 at 11:19 AM <strategicpartners27@gmail.com> wrote:

 When I created the database table, I included only a field to store the photos using app scripts

and imported an photo file((jpg file) to a bucket.  However, I encountered a problem trying to

import the image file to a table.  The table field in the database is of the mediumblob data type.

The character set as defined in the sql import instruction is of utf8 type.  Is this a problem when

importing into database table?  The image file is not in a csv file.  Is it supposed to be included in a 

csv file?  If it is supposed to be included in a csv file,  how do I reference the image file in the csv file?

I was also trying to import image file using the app scripts function by using the following:

  var instanceUrl = 'jdbc:mysql://' + address;

  var dbUrl = instanceUrl + '/' + db;

  var conn = Jdbc.getConnection(dbUrl, user, userpwd);

  conn.createStatement().execute("UPDATE companylogo SET logo = LOAD DATA LOCAL INFILE(gs://imagedb/code_logo.png)");

// or using   conn.createStatement().execute("LOAD DATA LOCAL INFILE 'gs://imagedb/code_logo.png' INTO TABLE companylogo CHARACTER SET utf8");

Should I use a different character set like hex blob or varbinary? 

However,  I am getting a syntax error when trying to use either of the two statements.What is the correct syntax for the statements?

Oracle isn't too explanatory.  Are other methods of importing an image file to the database?

Thanks very much

Kevin

--
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/10b4207c-bfd2-4e26-8b8f-733b8080fa76%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/ksAOJMQBnt4/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/CAAfRv6GfwWfNqOsZ5LXi9KOMMsQNXchW_du5LEyGLbtyEmWKWg%40mail.gmail.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/CAJOKVi9PDDD378QoDPi1TmvoF%3D0xMPC950rsD8Px5FVMfsxESg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] problem with import image or picture file from bucket to sql cloud database

LOAD DATA LOCAL INFILE is not supported by our platform: https://cloud.google.com/sql/docs/introduction

My suggestion is that you probably don't really want images in your database anyway: it's more expensive in time to retrieve and more expensive when stored at rest. Instead, I would leave it where it is in GCS and just keep the link to it your database.

On Sat, Feb 27, 2016 at 11:19 AM <strategicpartners27@gmail.com> wrote:

 When I created the database table, I included only a field to store the photos using app scripts

and imported an photo file((jpg file) to a bucket.  However, I encountered a problem trying to

import the image file to a table.  The table field in the database is of the mediumblob data type.

The character set as defined in the sql import instruction is of utf8 type.  Is this a problem when

importing into database table?  The image file is not in a csv file.  Is it supposed to be included in a 

csv file?  If it is supposed to be included in a csv file,  how do I reference the image file in the csv file?

I was also trying to import image file using the app scripts function by using the following:

  var instanceUrl = 'jdbc:mysql://' + address;

  var dbUrl = instanceUrl + '/' + db;

  var conn = Jdbc.getConnection(dbUrl, user, userpwd);

  conn.createStatement().execute("UPDATE companylogo SET logo = LOAD DATA LOCAL INFILE(gs://imagedb/code_logo.png)");

// or using   conn.createStatement().execute("LOAD DATA LOCAL INFILE 'gs://imagedb/code_logo.png' INTO TABLE companylogo CHARACTER SET utf8");

Should I use a different character set like hex blob or varbinary? 

However,  I am getting a syntax error when trying to use either of the two statements.What is the correct syntax for the statements?

Oracle isn't too explanatory.  Are other methods of importing an image file to the database?

Thanks very much

Kevin

--
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/10b4207c-bfd2-4e26-8b8f-733b8080fa76%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/CAAfRv6GfwWfNqOsZ5LXi9KOMMsQNXchW_du5LEyGLbtyEmWKWg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Cannot change root password

Sounds like something weird happened. Please email cloud-sql@google.com with your full instance name and I will look into it for you.

On Mon, Feb 29, 2016 at 1:01 AM 小川純平 <ogawa@growaspeople.org> wrote:

Hi,

I'm using Google Cloud SQL 2nd generation instance.
I tried to change root password but I couldn't because of unknown reason.

1. Go to Access Control > Users (https://console.cloud.google.com/sql/instances/[instance_name]/access-control/users)
2. Press "Change root password" button
3. Yellow tooltip: "Operation completed with errors, check the operation log for details." is shown.

I referred operation log [https://console.cloud.google.com/sql/instances/[instance_name]/operations]
It says:

Date/Time                    | Type                    | Status | Message
----------------------------------------------------------------------------------------------------------------------
Feb 29, 2016, 17:31:36 | Set root password | Done   | ⚠ An unknown error occurred

It happens on a instance, but it didn't happen on another error.

Is it a bug, or did I do something wrong?

Thanks,
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/6105492b-7ae6-48a2-9e86-365ecb27eeac%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/CAAfRv6EHL9_nuK0Y9BTboPMOb%2B43%2B%3D3TtW28J2XGyrHDu5iRwA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Mysql 5.7 support release date

We plan to continually support MySQL version upgrades, but it takes time to deploy a new version. I can't give you a timeline, but please know we are working on it!

Thank you for being a Cloud SQL customer,

Chris

On Mon, Feb 29, 2016 at 6:10 AM <nomanscloud@gmail.com> wrote:

Hi ,

Because Mysql 5.7 got huge improvements from geo search gis perspective , we strongly need to use the Mysql  5.7 version ..

Do you plan to upgrade to 5.7 current of month /s , year ?!

regards,

jess

--
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/512e1342-4edd-4af7-a07c-5b89dfddfd40%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/CAAfRv6GbBCA84hD%3D5adcTWA%2BtUZqQSyUzXtsfSvBNJm8-CR%2BLw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] please, I would want to sum whose identifiers are identical

please, I would want to sum whose identifiers are identical

--
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/98a37a8c-beb8-426a-8f2a-053e5a3d8197%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Mysql 5.7 support release date

Hi ,

Because Mysql 5.7 got huge improvements from geo search gis perspective , we strongly need to use the Mysql  5.7 version ..

Do you plan to upgrade to 5.7 current of month /s , year ?!

regards,

jess

--
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/512e1342-4edd-4af7-a07c-5b89dfddfd40%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] The Most Important Things are not Things, so We’ll Design Experiences

A good quality website helps clients to effectively pick, choose and order your products online. Millions of people search the internet looking for products or services, which you may have but would be unable to reach you in the absence of a rich designed, professional website.

Objective:

1. PHP and MySQL Project – MVC & CakePHP to develop a website

• Project 1:The main aim of this project is to create an HTML Registration Form using CakePHP helpers. Perform data posting and finally send an email
  
• Project 2: Develop a website using CakePHP helpers that will cover details about Institutions, Courses available and Student Information using
  
• Creating the website layout
  
• Perform functions Add/View/Edit/Delete on Institute details
  
• Perform functions Add/View/Edit/Delete on Course details
  
• Perform functions Add/View/Edit/Delete on Student information
  

2. JQuery and HTML Project – Login Page and Load the data

Problem Statement – It creates a login page which contains two fields that is username and password. If user enters the correct value then it will show a successful message and redirect to the another page which includes three options:

• Load Data
  
• Reload Data
  
• Load Content
  

Start learning Website Development:- PHP, MySQL, HTML, jQuery from basics to advance levels here...

https://goo.gl/1tNkW0

--
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/d1861091-5f2a-4678-974e-60fe9426d775%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Cannot change root password

Hi,

I'm using Google Cloud SQL 2nd generation instance.
I tried to change root password but I couldn't because of unknown reason.

1. Go to Access Control > Users (https://console.cloud.google.com/sql/instances/[instance_name]/access-control/users)
2. Press "Change root password" button
3. Yellow tooltip: "Operation completed with errors, check the operation log for details." is shown.

I referred operation log [https://console.cloud.google.com/sql/instances/[instance_name]/operations]
It says:

Date/Time                    | Type                    | Status | Message
----------------------------------------------------------------------------------------------------------------------
Feb 29, 2016, 17:31:36 | Set root password | Done   | ⚠ An unknown error occurred

It happens on a instance, but it didn't happen on another error.

Is it a bug, or did I do something wrong?

Thanks,
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/6105492b-7ae6-48a2-9e86-365ecb27eeac%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Cannot connect to Cloud SQL via SSL from PHP

Thanks David.

Then PDO should be changed rather than Cloud SQL.

# Sorry, this post was not sent by some reason.

--
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/de992486-c975-40eb-9ec2-3a06245ed6c9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] problem with import image or picture file from bucket to sql cloud database

 When I created the database table, I included only a field to store the photos using app scripts

and imported an photo file((jpg file) to a bucket.  However, I encountered a problem trying to

import the image file to a table.  The table field in the database is of the mediumblob data type.

The character set as defined in the sql import instruction is of utf8 type.  Is this a problem when

importing into database table?  The image file is not in a csv file.  Is it supposed to be included in a 

csv file?  If it is supposed to be included in a csv file,  how do I reference the image file in the csv file?

I was also trying to import image file using the app scripts function by using the following:

  var instanceUrl = 'jdbc:mysql://' + address;

  var dbUrl = instanceUrl + '/' + db;

  var conn = Jdbc.getConnection(dbUrl, user, userpwd);

  conn.createStatement().execute("UPDATE companylogo SET logo = LOAD DATA LOCAL INFILE(gs://imagedb/code_logo.png)");

// or using   conn.createStatement().execute("LOAD DATA LOCAL INFILE 'gs://imagedb/code_logo.png' INTO TABLE companylogo CHARACTER SET utf8");

Should I use a different character set like hex blob or varbinary? 

However,  I am getting a syntax error when trying to use either of the two statements.What is the correct syntax for the statements?

Oracle isn't too explanatory.  Are other methods of importing an image file to the database?

Thanks very much

Kevin

--
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/10b4207c-bfd2-4e26-8b8f-733b8080fa76%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Cannot access Google Cloud Shell

Thanks David! I went through the contents of https://cloud.google.com/sql/docs/create-user and was able to access Google Cloud Shell.

On Wednesday, February 24, 2016 at 6:43:48 PM UTC+5:30, Appu wrote:

I am trying to access Google Cloud Shell. When I enter the command 'gcloud beta sql connect -------instance--- --user=root' into the console, I get a response 'Whitelisting your IP for incoming connection for 1 minute...done. Enter password:'............When I enter the password that I can recollect I get the response 'Access denied for user '-----------------------' (using password: YES)'. I don't know how to find out the correct password. Please help. 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/32603b4a-25dc-4602-8f1a-59d7b30f3a12%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Cannot access Google Cloud Shell

Our documentation for managing users and passwords is at: https://cloud.google.com/sql/docs/create-user.

David

On Wed, Feb 24, 2016 at 5:13 AM, Appu <apurb@unitedpro.in> wrote:

I am trying to access Google Cloud Shell. When I enter the command 'gcloud beta sql connect -------instance--- --user=root' into the console, I get a response 'Whitelisting your IP for incoming connection for 1 minute...done. Enter password:'............When I enter the password that I can recollect I get the response 'Access denied for user '-----------------------' (using password: YES)'. I don't know how to find out the correct password. Please help. 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/986d0120-e660-454d-90ef-e6a33ed60a07%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_bb%2B1rzMT-9K4Oh9pUXKTyLKRmuPWsronR%3DVF3tO-JO%2BQA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Cannot access Google Cloud Shell

I am trying to access Google Cloud Shell. When I enter the command 'gcloud beta sql connect -------instance--- --user=root' into the console, I get a response 'Whitelisting your IP for incoming connection for 1 minute...done. Enter password:'............When I enter the password that I can recollect I get the response 'Access denied for user '-----------------------' (using password: YES)'. I don't know how to find out the correct password. Please help. 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/986d0120-e660-454d-90ef-e6a33ed60a07%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Export my SQL DB / Import to CloudSQL....HELP!!!!

thank you!

On Sat, Feb 20, 2016 at 9:44 PM, 'Vadim Berezniker' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

On the import screen, click on "Advanced settings" and enter the database name.

Alternatively, uncomment the "- USE `gtc_wrdp1`;' line in the import file.

On Sat, Feb 20, 2016 at 7:26 AM GTC <socialmedia@gpatech.org> wrote:

this is my error: 

 mysql_query No database selected (CREATE TABLE IF NOT EXISTS `wp_aiowps_events` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `event_type` varchar(150) NOT NULL DEFAULT '', `username` varchar(150) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `event_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ip_or_host` varchar(100) DEFAULT NULL, `referer_info` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `event_data` longtext, `country_code` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1)

this is what i have in my dump: 

-- phpMyAdmin SQL Dump

-- version 4.0.10.7

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Feb 20, 2016 at 07:22 AM

-- Server version: 5.5.45-cll-lve

-- PHP Version: 5.4.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

--

-- Create Database: `gtc_wrdp1`;

-- USE `gtc_wrdp1`;

-- --------------------------------------------------------

--

-- Table structure for table `wp_aiowps_events`

--

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/9b8f5111-ef66-4ece-870d-a928219b8ea3%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/t4389--rxiU/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/CABDU3p3LM%2BC6pQbbF5xWCAPmjcJVCN8o12%2BrTwF9uervnPZZ1A%40mail.gmail.com.

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

--

Aisha Lewis

--

G.P.A. Tech Center, Inc.

P: 913.915.8388
F: 866.531.4979
E: questions@gpatech.org
W: http://www.gpatech.org

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

Re: [google-cloud-sql-discuss] Re: Cannot connect to Cloud SQL via SSL from PHP

Thanks David.

Then PDO should be changed rather than Cloud SQL.

--
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/b7747706-d461-49f6-aeee-d2040d154843%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Export my SQL DB / Import to CloudSQL....HELP!!!!

This seems like not as much of a useful discussion forum thread as it is an error output. I highly recommend that you post such a thread over at Stack Overflow or at Server Fault since this forum is meant for discussion, not for specific-issue technical support, which is what Stack Exchange sites were designed for. You'll have much more success posting there.

On Saturday, February 20, 2016 at 10:26:45 AM UTC-5, GTC wrote:

this is my error: 

 mysql_query No database selected (CREATE TABLE IF NOT EXISTS `wp_aiowps_events` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `event_type` varchar(150) NOT NULL DEFAULT '', `username` varchar(150) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `event_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ip_or_host` varchar(100) DEFAULT NULL, `referer_info` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `event_data` longtext, `country_code` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1)

this is what i have in my dump: 

-- phpMyAdmin SQL Dump

-- version 4.0.10.7

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Feb 20, 2016 at 07:22 AM

-- Server version: 5.5.45-cll-lve

-- PHP Version: 5.4.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

--

-- Create Database: `gtc_wrdp1`;

-- USE `gtc_wrdp1`;

-- --------------------------------------------------------

--

-- Table structure for table `wp_aiowps_events`

--
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/a2b89164-2395-48bc-a0ca-05da6a59f954%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Export my SQL DB / Import to CloudSQL....HELP!!!!

On the import screen, click on "Advanced settings" and enter the database name.

Alternatively, uncomment the "- USE `gtc_wrdp1`;' line in the import file.

On Sat, Feb 20, 2016 at 7:26 AM GTC <socialmedia@gpatech.org> wrote:

this is my error: 

 mysql_query No database selected (CREATE TABLE IF NOT EXISTS `wp_aiowps_events` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `event_type` varchar(150) NOT NULL DEFAULT '', `username` varchar(150) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `event_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ip_or_host` varchar(100) DEFAULT NULL, `referer_info` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `event_data` longtext, `country_code` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1)

this is what i have in my dump: 

-- phpMyAdmin SQL Dump

-- version 4.0.10.7

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Feb 20, 2016 at 07:22 AM

-- Server version: 5.5.45-cll-lve

-- PHP Version: 5.4.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

--

-- Create Database: `gtc_wrdp1`;

-- USE `gtc_wrdp1`;

-- --------------------------------------------------------

--

-- Table structure for table `wp_aiowps_events`

--
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/9b8f5111-ef66-4ece-870d-a928219b8ea3%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/CABDU3p3LM%2BC6pQbbF5xWCAPmjcJVCN8o12%2BrTwF9uervnPZZ1A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Export my SQL DB / Import to CloudSQL....HELP!!!!

this is my error: 

 mysql_query No database selected (CREATE TABLE IF NOT EXISTS `wp_aiowps_events` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `event_type` varchar(150) NOT NULL DEFAULT '', `username` varchar(150) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `event_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ip_or_host` varchar(100) DEFAULT NULL, `referer_info` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `event_data` longtext, `country_code` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1)

this is what i have in my dump: 

-- phpMyAdmin SQL Dump

-- version 4.0.10.7

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Feb 20, 2016 at 07:22 AM

-- Server version: 5.5.45-cll-lve

-- PHP Version: 5.4.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

--

-- Create Database: `gtc_wrdp1`;

-- USE `gtc_wrdp1`;

-- --------------------------------------------------------

--

-- Table structure for table `wp_aiowps_events`

--
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/9b8f5111-ef66-4ece-870d-a928219b8ea3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Cannot connect to Cloud SQL via SSL from PHP

We do not have a usable CN because, depending on user config, there might not be an IP address at all and the IP address can change. Additionally because we provide a CA that is distributed by the user and is the sole trusted CA of clients verifying CN isn't actually needed for security: a man in the middle attack is not possible because an attacker cannot generate a certificate that would be trusted.

We do see the fact that users such as yourself have difficulties as a problem and we have an internal issue open to address this. Unfortunately poor configurability of client libraries like PDO make this difficult.

David

On Fri, Feb 19, 2016 at 12:57 AM, 小川純平 <ogawa@growaspeople.org> wrote:

Hi Matsuo san

Unfortunately I decided to use Amazon RDS this time.

> Unfortunately you're correct as long as you want to use the SSL connection and somewhat newer versions of PHP

I found SSL verification is introduced on 5.6,
http://php.net/manual/en/migration56.openssl.php#migration56.openssl.peer-verification

I considered to use 5.5 or older, but 5.5 EOL is next July.

CentOS 6 provides PHP 5.3.3, but CakePHP requires 5.3.7+ for SSL connection to MySQL.

RedHat / CentOS 7 provides PHP 5.4 and it looks the best solution to use Google Cloud SQL, but because my task is heavily delaying, it is difficult to choose to rewrite my Ansible configs.

I wonder if it is possible to include Cloud SQL instance IP as CN in the certificate. It looks better rather than adding function to make it less secure to PDO.
Sorry if I misunderstand David's explanation.

--
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/16b92ac7-450b-4083-ae5f-49bfe4fb8fe0%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_bbM0twhT4EwOMq-6F2MZZvXk1X_2g%2BcR_N4S7sB3r35qw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] SQL SERVER INTERNAL AND TROUBLESHOOTING ONLINE CLASS FOR 20 DAYS, JUST FOR 5999/- RUPEES ONLY

Hello SQL SERVER Professionals

Greeting from rameshbabu.in
We are starting SQL Server Internals and Troubleshooting Classes.

This session includes deep drive Knowledge on SQL Server Internal and Troubleshooting techniques.

 

Interested candidate enroll on below link for DEMO Class.
http://rameshbabu.in/online-class/

 

Online class just for 5999 /- Rupees only

Duration 20 days, Timing 6:30 AM (IST)

Batch starts from 6^th March 2016

--
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/92244db3-ba8c-443d-bbee-13943a3846b1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Cannot connect to Cloud SQL via SSL from PHP

Hi Matsuo san

Unfortunately I decided to use Amazon RDS this time.

> Unfortunately you're correct as long as you want to use the SSL connection and somewhat newer versions of PHP

I found SSL verification is introduced on 5.6,
http://php.net/manual/en/migration56.openssl.php#migration56.openssl.peer-verification

I considered to use 5.5 or older, but 5.5 EOL is next July.

CentOS 6 provides PHP 5.3.3, but CakePHP requires 5.3.7+ for SSL connection to MySQL.

RedHat / CentOS 7 provides PHP 5.4 and it looks the best solution to use Google Cloud SQL, but because my task is heavily delaying, it is difficult to choose to rewrite my Ansible configs.

I wonder if it is possible to include Cloud SQL instance IP as CN in the certificate. It looks better rather than adding function to make it less secure to PDO.
Sorry if I misunderstand David's explanation.

--
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/16b92ac7-450b-4083-ae5f-49bfe4fb8fe0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Cannot connect to Cloud SQL via SSL from PHP

Ogawa-san,

Unfortunately you're correct as long as you want to use the SSL connection and somewhat newer versions of PHP. Maybe you can vote the bug above so that PHP devs will look into it sooner?

On Thu, Feb 18, 2016 at 8:08 PM 小川純平 <ogawa@growaspeople.org> wrote:

Thanks, David.

Hmm... so there is no way to use Google Cloud SQL with CakePHP, which doesn't support MySQLi?

--
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/c86db0e9-1801-4355-beb9-5f76b2a2024b%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/CADWEYXj7gcJWvmiQmTP1YgnS1tx7rm2m%2BkqbK2T%2B25aSPoxsXw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Cannot connect to Cloud SQL via SSL from PHP

Thanks, David.

Hmm... so there is no way to use Google Cloud SQL with CakePHP, which doesn't support MySQLi?

--
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/c86db0e9-1801-4355-beb9-5f76b2a2024b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Cannot connect to Cloud SQL via SSL from PHP

As you noticed Cloud SQL does not make the common name match the IP address of the instance. Instead of relying on public CAs and verifying certificate chain, with Cloud SQL a one-off ca certificate is distributed to the client. This is more secure as it avoids trusting the hundreds of trusted CAs.

To make this work requires the client to be configured to use the provided CA certificate and disable peer name verification. With PDO you can do the former with MYSQL_ATTR_SSL_CA. PDO doesn't offer an option to do the latter.

If you are able to switch to the mysqli interface then you can use the MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT flag to mysqli_real_connect to disable peer name verification.

On Thu, Feb 18, 2016 at 3:26 AM, 小川純平 <ogawa@growaspeople.org> wrote:

Sorry, I forgot to write some info.

1. I'm using Google Cloud SQL 1st generation
2. I'm using PHP 5.6 from Remi repo.

--
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/0ae3d9f7-5c3a-4dde-800a-1f25ba9502b1%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_baBbJMcKcGDxi%2BfEfqFw2-t1Ab%2BfkR%3Dma4r9NOoN4t6dQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Cannot connect to Cloud SQL via SSL from PHP

Sorry, I forgot to write some info.

1. I'm using Google Cloud SQL 1st generation
2. I'm using PHP 5.6 from Remi repo.

--
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/0ae3d9f7-5c3a-4dde-800a-1f25ba9502b1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Cannot connect to Cloud SQL via SSL from PHP

Hi, I have the same problem as following question. Does anyone have idea to solve this problem?

http://stackoverflow.com/questions/34478265/ssl-self-signed-certifications-to-connect-with-mysql-with-php/34478690#34478690

I'm using CakePHP and connecting from CentOS 6 (applied all updates via yum) on GCE.

According to the error message, Common Name of Cloud SQL certificate seems invalid.
Any solutions to fix Cloud SQL's certificate, or any workaround?

BTW I can connect using mysql client (5.1.x) from the same GCE instance
$ mysql -u dbname -p -h (Cloud SQL IPv4 address) notel --ssl-ca=/path/to/ca.pem --ssl-cert=/path/to/cert.pem --ssl-key=/path/to/key.pem


Following is full logs:

2016-02-18 19:41:44 Warning: Warning (2): PDO::__construct() [<a href='http://php.net/pdo.construct'>pdo.construct</a>]: Peer certificate CN=`(CGP project name):(Cloud SQL instance name)' did not match expected CN=`(Cloud SQL instance IP)' in [/var/www/notel/data/lib/Cake/Mod
el/Datasource/Database/Mysql.php, line 175]
Trace:
PDO::__construct() - [internal], line ??
Mysql::connect() - CORE/Cake/Model/Datasource/Database/Mysql.php, line 175
DboSource::__construct() - CORE/Cake/Model/Datasource/DboSource.php, line 260
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 105
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3502
Model::schema() - CORE/Cake/Model/Model.php, line 1355
Model::_setAliasData() - CORE/Cake/Model/Model.php, line 1220
Model::set() - CORE/Cake/Model/Model.php, line 1183
Model::save() - CORE/Cake/Model/Model.php, line 1713
DatabaseSession::write() - CORE/Cake/Model/Datasource/Session/DatabaseSession.php, line 117
MySession::write() - CORE/Cake/Model/Datasource/Session/MySession.php, line 31
session_write_close - [internal], line ??
[main] - [internal], line ??

2016-02-18 19:41:44 Warning: Warning (2): PDO::__construct() [<a href='http://php.net/pdo.construct'>pdo.construct</a>]: Cannot connect to MySQL by using SSL in [/var/www/notel/data/lib/Cake/Model/Datasource/Database/Mysql.php, line 175]
Trace:
PDO::__construct() - [internal], line ??
Mysql::connect() - CORE/Cake/Model/Datasource/Database/Mysql.php, line 175
DboSource::__construct() - CORE/Cake/Model/Datasource/DboSource.php, line 260
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 105
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3502
Model::schema() - CORE/Cake/Model/Model.php, line 1355
Model::_setAliasData() - CORE/Cake/Model/Model.php, line 1220
Model::set() - CORE/Cake/Model/Model.php, line 1183
Model::save() - CORE/Cake/Model/Model.php, line 1713
DatabaseSession::write() - CORE/Cake/Model/Datasource/Session/DatabaseSession.php, line 117
MySession::write() - CORE/Cake/Model/Datasource/Session/MySession.php, line 31
session_write_close - [internal], line ??
[main] - [internal], line ??

2016-02-18 19:41:44 Warning: Warning (2): PDO::__construct() [<a href='http://php.net/pdo.construct'>pdo.construct</a>]: [2002]  (trying to connect via tcp://(Cloud SQL instance IP):3306) in [/var/www/notel/data/lib/Cake/Model/Datasource/Database/M
ysql.php, line 175]
Trace:
PDO::__construct() - [internal], line ??
Mysql::connect() - CORE/Cake/Model/Datasource/Database/Mysql.php, line 175
DboSource::__construct() - CORE/Cake/Model/Datasource/DboSource.php, line 260
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 105
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3502
Model::schema() - CORE/Cake/Model/Model.php, line 1355
Model::_setAliasData() - CORE/Cake/Model/Model.php, line 1220
Model::set() - CORE/Cake/Model/Model.php, line 1183
Model::save() - CORE/Cake/Model/Model.php, line 1713
DatabaseSession::write() - CORE/Cake/Model/Datasource/Session/DatabaseSession.php, line 117
MySession::write() - CORE/Cake/Model/Datasource/Session/MySession.php, line 31
session_write_close - [internal], line ??
[main] - [internal], line ??

--
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/4270109c-610a-4ba2-a9e6-105058672a94%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Issues connecting to Google Cloud SQL for wordpress

Hi,

Confirm that the name you used when you created your db (on cloud sql) is the same name you have in your wp-config.php file

Also, confirm that you have user 'root' for your DB.


On Friday, February 12, 2016 at 6:49:16 AM UTC-8, Hai Xu wrote:

Hi

I have the same issue when I tried to install wordpress to app engine.

I have followed all steps at https://googlecloudplatform.github.io/appengine-php-wordpress-starter-project/

And, everything local works well, and I can even deploy successfully, however, when I tried to install wordpress on app engine by

http://<project_id>.appspot.com/wp-admin/install.php

I get an error page saying 

"

Error establishing a database connection

This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at :/cloudsql/<project_id>:testsqlv1. This could mean your host's database server is down.

.....

"

if I try http://<project_id>.appspot.com, I get page showing:

"

Error establishing a database connection

"

I first tried second gen, and then first gen, none works for me.

I have app.yaml modified with <project_id> at the first line of the file

and I have wp-config.php modified with db name, db host, username password, etc.

I use root with empty password.

I also connect into mysql using instance IP and create database, say, 'wp_wordpress', 

It took me a whole day, and still the error page when I tried to install wordpress on app engine.

Can anyone help me on this issue?

Thanks a lot in advance

Hai

On Saturday, January 23, 2016 at 10:23:26 PM UTC-5, NP wrote:

I'm trying to host a wordpress blog on google app engine (GAE). I am following the steps outlined on the link below

http://googlecloudplatform.github.io/appengine-php-wordpress-starter-project/

I have created my project, deployed it, created an SQL instance and also created a database using the steps outlined in the link above (Note: I can't see the databases directly on Google Cloud SQL but when I query it from my console, I can see it).

One of the steps in the link above says to navigate to http://.appspot.com/wp-admin/install.php

When I do that, I get the following error

Error establishing a database connection  This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at :/cloudsql/<PROJECT_ID>:production. This could mean your host's database server is down.

Please note that 'production' is my SQL instance name. I had earlier tried 'wordpress' as recommended in the starter-project but deleted it when i had issues and I'm unable to reuse it.

I also noticed that the Google Cloud SQl window has the following entry

Instance connection name     <PROJECT_ID>:us-central1:production

i.e. it automatically appended the location to my project id and instance name. So I tried using that in my config.php file in the place where it said to use ':/cloudsql/your-project-id:your-instance-name' but that still doesn't solve the problem.

Anybody have a solution?

--
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/55ab3b82-7007-45d7-a178-12273ad50a20%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.