[google-cloud-sql-discuss] Re: Is it feasible to connect modern Java webapps (e.g. Vert.x) from Cloud Run to Cloud SQL?

Hi David,

Thanks I appreciate the response. It's good to know at least that I'm not missing something obvious (and that other folks are interested in this topic, as per the github link you provided).

On Tuesday, March 31, 2020 at 12:46:22 PM UTC-7, David (Cloud Platform Support) wrote:

Hello,

As of right now, I could not find any official supported solution so it seems that you would have to pick one of your own options. However, you can check out this github link, as it seems there may be plans to integrate Cloud SQL with r2dbc. You can also officially create a feature request for Cloud SQL as well as for Cloud Run If you would like to see TCP connection support.

--
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/d92665f7-3891-4eec-8153-e5525d97567c%40googlegroups.com.

[google-cloud-sql-discuss] Re: Is it feasible to connect modern Java webapps (e.g. Vert.x) from Cloud Run to Cloud SQL?

Hello,

As of right now, I could not find any official supported solution so it seems that you would have to pick one of your own options. However, you can check out this github link, as it seems there may be plans to integrate Cloud SQL with r2dbc. You can also officially create a feature request for Cloud SQL as well as for Cloud Run If you would like to see TCP connection support.

--
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/410c9d50-2d14-460b-891b-2c48c3d9a447%40googlegroups.com.

[google-cloud-sql-discuss] Re: Aborted connection 47625 to db | Read Replica

Hello Abhishek,

There was an infrastructure issue reported on March 30, 2020 and on March 26, 2020 which might affect your Cloud SQL instance. However, "Aborted connection nnnn to db:" error usually indicates that your application is not terminating connections properly. If the issue is still occurring, you may take a look at the best practices for connection management; and If you have already taken the best practices and it hasn't alleviated the issue, you may report it to the Google Cloud Platform Issue Tracker so that we would be able to further investigate it.

Note that GCP groups are reserved for general discussions on Google Cloud Platform-end products. For reporting issues and feature requests, you should create a ticket via the GCP Issue Tracker. 

--
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/7110d07e-4414-4cc1-9636-63bfcfb9ad4a%40googlegroups.com.

Re: [google-cloud-sql-discuss] Re: Not able to export database

I didn't use any commands as I am using export option from gcloud sql web where I can select cloud storage location export type(SQL) and database.

-Mayank

On Tue, Mar 31, 2020, 10:48 PM 'noverlyjoseph' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

Hi Mayank,

Could you provide the full command you've used for that while keeping PII redacted? It will help to understand what might have gone wrong here.

Could also review this document[1] for guidance on exporting.

[1] https://cloud.google.com/sql/docs/postgres/import-export/exporting#gcloud

On Tuesday, March 31, 2020 at 8:56:14 AM UTC-4, Mayank Rupareliya wrote:

In gcloud SQL, I am getting error on exporting one particular postgres database using sql type export.
Error I see in notification is "Unknown error."
If I retry from notification it shows "The server has encountered a problem. Please try again."
How to fix 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/b706d298-637c-4279-b5c0-b4fbda5cf25d%40googlegroups.com.

--
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/CAGeZtJCi4H8dNuADVh820X9GsyoxUCEiYhx8n40ALn4q6d-b0w%40mail.gmail.com.

[google-cloud-sql-discuss] Re: Not able to export database

Hi Mayank,

Could you provide the full command you've used for that while keeping PII redacted? It will help to understand what might have gone wrong here.

Could also review this document[1] for guidance on exporting.

[1] https://cloud.google.com/sql/docs/postgres/import-export/exporting#gcloud

On Tuesday, March 31, 2020 at 8:56:14 AM UTC-4, Mayank Rupareliya wrote:

In gcloud SQL, I am getting error on exporting one particular postgres database using sql type export.
Error I see in notification is "Unknown error."
If I retry from notification it shows "The server has encountered a problem. Please try again."
How to fix 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/b706d298-637c-4279-b5c0-b4fbda5cf25d%40googlegroups.com.

[google-cloud-sql-discuss] Not able to export database

In gcloud SQL, I am getting error on exporting one particular postgres database using sql type export.
Error I see in notification is "Unknown error."
If I retry from notification it shows "The server has encountered a problem. Please try again."
How to fix 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/5c9663b6-bd1f-48a2-b1f0-0d55c9bbda08%40googlegroups.com.

[google-cloud-sql-discuss] Re: Create SQL Server 2017 through jinja template

Hi,

I could not find any supporting GCP documents that supports the creation of SQL Server 2017 through jinja template, however, when creating Cloud SQL for SQL Server instance, the "Database version " by default is 'SQL Server 2017 Standard'. Other options are SQL Server 2017 Enterprise, SQL Server 2017 Express, SQL Server 2017 Web.

--
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/b7bcb19f-67c4-4e8d-8462-5639b3d9ee9a%40googlegroups.com.

[google-cloud-sql-discuss] Aborted connection 47625 to db | Read Replica

For my CloudSQL DB, Read-Replica of PROD, i am getting frequent aborted connections error. We use Read-Replica for reporting purpose, We use SQL proxy to connect from MS-SQL server ( hosted in Azure) along with C-data in between for fetching data from CloudSQL to MS-SQL server. 

SQL quires executes for 30-180 mins and are running for last 1 year. In last 4-5 days , our reporting SQL's start hanging after running for 20-30 mins and did not respond. 

Read-Replica logs show are is a increase in aborted connect error.

Logs:

====

{

 insertId: "xxxxxxxx"  

 logName: "projects/xxx-xxx-db/logs/cloudsql.googleapis.com%2Fmysql.err"  

 receiveTimestamp: "2020-03-30T13:07:53.626203743Z"  

 resource: {…}  

 severity: "INFO"  

 textPayload: "2020-03-30T13:07:52.901100Z 47625 [Note] Aborted connection 47625 to db: 'XXXXDB' user: 'readonlyusr' host: 'cloudsqlproxy~xx.xx.xx.xxx' (Got an error writing communication packets)"  

 timestamp: "2020-03-30T13:07:52.901563Z"  

}

--
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/d1884ab8-a710-4bb3-9702-05eae89ee532%40googlegroups.com.

[google-cloud-sql-discuss] Re: Wordpress Remote Connect to Cloud SQL - Error establishing a database connection

Hi Jun, 

Glad to see you have fixed your issue. You are welcome opening separate issues in the Public Issue Tracker, if you are faced with other Cloud Platform related problems, or questions in stackoverflow for strictly programming-related matter. 

--
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/c8326015-7a70-4bd5-b562-f1d088b8baef%40googlegroups.com.

[google-cloud-sql-discuss] Is it feasible to connect modern Java webapps (e.g. Vert.x) from Cloud Run to Cloud SQL?

I have a Java /Vert.x web application that I've deployed to Cloud Run. I wanted to connect it to a database, so Cloud SQL seemed the obvious choice. But after trying, I'm wondering if it's really feasible to connect a modern Java web application from Cloud Run to Cloud SQL.

By "modern Java web application", I mean one leveraging the event-loop paradigm as opposed to the traditional thread-per-request model. This means that we want to leverage non-blocking APIs for IO operations such as database access.

However, Cloud SQL requires connections from Cloud Run using a UNIX socket, rather than via a standard JDBC address. Unfortunately, there are very few JDBC drivers/connection pools that support connectivity via UNIX sockets (to my knowledge, Hikari CP is the only option). Importantly, there are no non-blocking drivers that support socket connection (that I've found).

So as far as I can tell, my options are:

• Use Hikari and block the main thread (not an option)
• Use Hikari and create a ham-handed approach whereby the entire data access layer takes place in another thread
• Use Hikari, and spend a lot of time creating an entirely new non-blocking driver to use with it

Am I missing something? It seems odd that GCP would preclude such a large swath of applications, so I'm guessing that I might be.

--
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/84a6ba20-7677-4dcb-98b3-9f2a9bfb9411%40googlegroups.com.

[google-cloud-sql-discuss] TOOLS to use to TUNE SLOW QUERIES in Postgresql CLOUD SQL ?

Hi guys,

Apart from using "EXPLAIN ANALYZE". Is there another tool that can be used to ANALYZE slow queries in postgres cloud sql and the provides RECOMMENDATIONS on where to create indexes, partitioning table, modifying query etc

Thank you for your suggestions 

Thanks

Harry

--
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/aa3bc63c-c342-4d55-85db-6dbd11b7d128%40googlegroups.com.

[google-cloud-sql-discuss] AUTOMATING Export and Import Of tables For CLOUD SQL postgresql database

Hi guys,

I hope everyone staying home and save during these difficult times. I am NEW to clould sql. I recently migrated our ON-PREM postgres databases in to Google CLOUD SQL (postgres)

Every week I have to MANUALLY export 15 tables From one postgres cloud sql instance to another. First within the Same project and then across to 6 other Projects /Environments.

This takes too long and I do not know how I can automate this.

I use pgAdmin or CLOUD Shell command line to perform these exports and imports.

STEPS

           - create the exports (DATA ONLY) of all 15 tables in SOURCE

           - Connect to psql client to truncate these 15 table at the TARGET

           - Import tables (data only) in to TARGET 

I am used to using CRONTAB and bash/SQL scripting to achieve this task on my ON-PREM databases.

HOW DO I script and automate this task in Google Cloud???

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/49226808-c486-42dd-be66-2407c14fa07b%40googlegroups.com.

[google-cloud-sql-discuss] Create SQL Server 2017 through jinja template

Hi,

Can we create SQL Server 2017 instance through jinja template? If yes please let me know what should be value of "databaseVersion:"

--
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/25d847ff-cdd6-4888-9408-fad9c7441c78%40googlegroups.com.

[google-cloud-sql-discuss] Re: Failover failed instance failed

Hello Samuel, 

There could be various reasons for the Cloud SQL instance failover process to fail with message "status: failed" which you have shared. 

It is difficult to determine the root cause and provide work around to resolve the issue without inspecting your Google Cloud Platform project, Stackdriver Logging Logs and internal monitoring tools. 

I have tried to look for Project which might be associated with your email address associated with this post internally where I have seen so many projects that are associated with the email. Due to that it was not possible to identify the project in question. 

I would recommend you to create a Cloud SQL Public Issue under "Storage and Databases" section by going here as the issue may be required to refer to the Cloud SQL Engineering team to resolve it. Please select the private component as probably you will have to share project specific information, so that it is not visible to the public. One of the Google Cloud Platform Support Agents will assist you to resolve your issue.

Please note that Google Groups is only meant for general discussion related to Google Cloud Platform products which are not technical in nature, service status updates and release notes, and ranging from book recommendations to creative shortcuts.

On Friday, March 27, 2020 at 3:38:24 PM UTC-4, Samuel Logan wrote:

We attempted to failover, now the instance says "status: failed" with no option to do anything other than delete the instance 

--
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/f254bc24-8043-46cf-8844-98089089af00%40googlegroups.com.

[google-cloud-sql-discuss] Re: Error establishing a database connection

https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!topic/google-cloud-sql-discuss/9CxXepaLziI

Hi,

Thanks for quick respond. It has nothing to do without that incident.

After adding CIDR notation /32 into my ip and restarted my instance, it finally works now.

Thanks a lot.

Have a great day.

On Friday, March 27, 2020 at 11:41:46 PM UTC+8, Pierre-Yves (Google Cloud Support) wrote:

Hi Jun,

There was an incident that affected Cloud SQL instances between 2020-03-26 18:17 and ended at 2020-03-27 06:57 UTC-7.

Since the issue is now resolved, please try the migration again. If you still experience errors, please provided the full console output for the error, while obfuscating sensitive information.

On Friday, March 27, 2020 at 9:21:20 AM UTC-4, Jun Leong Wong wrote:

Hi,

I have successfully imported my sql into Google Cloud SQL (MySQL).

I migrated the database to Google Cloud SQL but the whole Wordpress files still remain on my own server.

I have edited the wp-config.php as follow:

/** MySQL database username */

define('DB_USER', 'myuser');  // this is the username under master instance > username

/** MySQL database password */

define('DB_PASSWORD', 'mypass');  // this is the password under master instance > username

/** MySQL hostname */

define('DB_HOST', '35.227.86.242'); // under Connect to this instance > Public IP address > 35.227.86.242

/** Database Charset to use in creating database tables. */

define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */

define('DB_COLLATE', 'utf8_general_ci');

I follow the tutorial at https://geekflare.com/google-cloud-sql-wordpress/

But it doesn't work.

I got Error establishing a database connection message.

Helps needed.

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/5e988e6a-225b-4d3a-b345-2c9321b12103%40googlegroups.com.

[google-cloud-sql-discuss] Re: Wordpress Remote Connect to Cloud SQL - Error establishing a database connection

Hi,

Thanks for quick respond.

After adding CIDR notation /32 into my ip and restarted my instance, it finally works now.

Thanks a lot.

Have a great day.

On Saturday, March 28, 2020 at 3:16:48 AM UTC+8, George (Cloud Platform Support) wrote:

Did you independently verify that your Cloud SQL instance accepts connections? You may refer to the "Connecting to Cloud SQL from external applications" documentation page for details. Have you followed the steps on this page for your setup? Is there any instruction that still has to be executed? 

You can grant any application access to a Cloud SQL instance by authorizing the public IP addresses that the application uses to connect. Have you executed this step, in your Cloud SQL setup? 

You may have been affected by a general Cloud SQL issue, just recently solved, as indicated on Google Cloud Status Dashboard. This issue is fixed now, so you should try connecting again, to determine if this was in fact your problem. 

--
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/0fd5d096-2cc8-49c9-929a-27c0a80b8955%40googlegroups.com.

[google-cloud-sql-discuss] Re: Wordpress Remote Connect to Cloud SQL - Error establishing a database connection

Did you independently verify that your Cloud SQL instance accepts connections? You may refer to the "Connecting to Cloud SQL from external applications" documentation page for details. Have you followed the steps on this page for your setup? Is there any instruction that still has to be executed? 

You can grant any application access to a Cloud SQL instance by authorizing the public IP addresses that the application uses to connect. Have you executed this step, in your Cloud SQL setup? 

You may have been affected by a general Cloud SQL issue, just recently solved, as indicated on Google Cloud Status Dashboard. This issue is fixed now, so you should try connecting again, to determine if this was in fact your problem. 

--
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/02af18cb-1ada-454b-9079-b3bdf75df21c%40googlegroups.com.

[google-cloud-sql-discuss] Failover failed instance failed

We attempted to failover, now the instance says "status: failed" with no option to do anything other than delete the instance 

--
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/8cda2cee-68d3-4508-a972-8ea7344becda%40googlegroups.com.

[google-cloud-sql-discuss] Re: Error establishing a database connection

Hi Jun,

There was an incident that affected Cloud SQL instances between 2020-03-26 18:17 and ended at 2020-03-27 06:57 UTC-7.

Since the issue is now resolved, please try the migration again. If you still experience errors, please provided the full console output for the error, while obfuscating sensitive information.

On Friday, March 27, 2020 at 9:21:20 AM UTC-4, Jun Leong Wong wrote:

Hi,

I have successfully imported my sql into Google Cloud SQL (MySQL).

I migrated the database to Google Cloud SQL but the whole Wordpress files still remain on my own server.

I have edited the wp-config.php as follow:

/** MySQL database username */

define('DB_USER', 'myuser');  // this is the username under master instance > username

/** MySQL database password */

define('DB_PASSWORD', 'mypass');  // this is the password under master instance > username

/** MySQL hostname */

define('DB_HOST', '35.227.86.242'); // under Connect to this instance > Public IP address > 35.227.86.242

/** Database Charset to use in creating database tables. */

define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */

define('DB_COLLATE', 'utf8_general_ci');

I follow the tutorial at https://geekflare.com/google-cloud-sql-wordpress/

But it doesn't work.

I got Error establishing a database connection message.

Helps needed.

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/f6848a5a-73c8-429c-aa3f-e5d4171993b2%40googlegroups.com.

[google-cloud-sql-discuss] Re: Error establishing a database connection

Hi,

Have you tried to connect using a tool such as MySQLWorkBench and test the connection.

Also, check whether or not the the port setting is set to 3306.

Have you also set DB_NAME?

Thanks

On Friday, 27 March 2020 15:21:20 UTC+2, Jun Leong Wong wrote:

Hi,

I have successfully imported my sql into Google Cloud SQL (MySQL).

I migrated the database to Google Cloud SQL but the whole Wordpress files still remain on my own server.

I have edited the wp-config.php as follow:

/** MySQL database username */

define('DB_USER', 'myuser');  // this is the username under master instance > username

/** MySQL database password */

define('DB_PASSWORD', 'mypass');  // this is the password under master instance > username

/** MySQL hostname */

define('DB_HOST', '35.227.86.242'); // under Connect to this instance > Public IP address > 35.227.86.242

/** Database Charset to use in creating database tables. */

define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */

define('DB_COLLATE', 'utf8_general_ci');

I follow the tutorial at https://geekflare.com/google-cloud-sql-wordpress/

But it doesn't work.

I got Error establishing a database connection message.

Helps needed.

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/30ac5c34-9fd3-4037-b7e3-f2cc307bf79c%40googlegroups.com.

[google-cloud-sql-discuss] Wordpress Remote Connect to Cloud SQL - Error establishing a database connection

Hi,

I have an existing wordpress running on my own server and now I want to migrate my database to Google Cloud SQL 

I follow this tutorial https://geekflare.com/google-cloud-sql-wordpress/

The following I have set in my wp-config.php

I have added my server outgoing, incoming, and cloudflare ip into public ip

define('DB_NAME', 'myblog'); //under MySQL databases

/** MySQL database username */

define('DB_USER', 'myusername');  //under username created under MySQL user accounts

/** MySQL database password */

define('DB_PASSWORD', 'mypass');   //under password created under MySQL user accounts

/** MySQL hostname */

define('DB_HOST', '35.227.86.242');  //under Connect to this instance > Public IP address

/** Database Charset to use in creating database tables. */

define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */

define('DB_COLLATE', 'utf8_general_ci');

However, I got Error establishing a database connection error.

Helps needed.

Thank 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/d340341c-d5a6-4420-a475-c5803b21a0df%40googlegroups.com.

[google-cloud-sql-discuss] Error establishing a database connection

Hi,

I have successfully imported my sql into Google Cloud SQL (MySQL).

I migrated the database to Google Cloud SQL but the whole Wordpress files still remain on my own server.

I have edited the wp-config.php as follow:

/** MySQL database username */

define('DB_USER', 'myuser');  // this is the username under master instance > username

/** MySQL database password */

define('DB_PASSWORD', 'mypass');  // this is the password under master instance > username

/** MySQL hostname */

define('DB_HOST', '35.227.86.242'); // under Connect to this instance > Public IP address > 35.227.86.242

/** Database Charset to use in creating database tables. */

define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */

define('DB_COLLATE', 'utf8_general_ci');

I follow the tutorial at https://geekflare.com/google-cloud-sql-wordpress/

But it doesn't work.

I got Error establishing a database connection message.

Helps needed.

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/1f3144be-6d98-42b8-9fb7-a21bae265430%40googlegroups.com.

[google-cloud-sql-discuss] Re: How to connect Azure Web App to Google Cloud SQL

Hello Kats, 

It is possible to connect to Cloud SQL instances from external applications which includes Microsoft Azure as described in this document. 

This is possible to connect to the Cloud SQL instances from external applications by using a proxy, by configuring access for one or more public IP addresses, by using the JDBC Socket Factory which is applicable to Java Programming language and MySQL Second Generation instances only and by using the Cloud SQL Proxy library which is applicable for the Go programming language and Second Generation instances only. 

Please also note that if you have not created a Cloud SQL instance already you may encounter issues during creation as there is a Global issue currently ongoing which you can monitor here. Once the issue is resolved you can attempt to create the Cloud SQL instance and connect with the Microsoft Azure App Service application. 

On Thursday, March 26, 2020 at 11:26:00 AM UTC-4, kats mike wrote:

Due to what is happening to the world right now, azure seems to be out of capacity, so no new sql databases can be made. 

Does anyone have experience or knowledge on how to connect the an Azure App Service App to a Google SQLServer Database?

Thank you 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/4ab01f96-6df5-4c97-bb5b-36e85448dcf9%40googlegroups.com.

[google-cloud-sql-discuss] Re: How to connect Azure Web App to Google Cloud SQL

not  familiar with app service  on  azure  but connecting  to  Cloud SQL on GCP can be done outside  of GCP using IP whitelisting.

so  if your  app have a static ip you can  defined that on the whitelisted IP and connect as usual.

On Thursday, March 26, 2020 at 5:26:00 PM UTC+2, kats mike wrote:

Due to what is happening to the world right now, azure seems to be out of capacity, so no new sql databases can be made. 

Does anyone have experience or knowledge on how to connect the an Azure App Service App to a Google SQLServer Database?

Thank you 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/b4477a14-3baf-482a-a52c-4c2497a99d9b%40googlegroups.com.

[google-cloud-sql-discuss] How to connect Azure Web App to Google Cloud SQL

Due to what is happening to the world right now, azure seems to be out of capacity, so no new sql databases can be made. 

Does anyone have experience or knowledge on how to connect the an Azure App Service App to a Google SQLServer Database?

Thank you 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/cffe3ec8-9e3e-48a6-a2fb-1ea8e9736e65%40googlegroups.com.

Re: [google-cloud-sql-discuss] Restoring Managed backup across different Project - CloudSQL

Here[1] is the link to the doc in case you would like to know more about the other parameters available for this API

[1] https://cloud.google.com/sql/docs/mysql/admin-api/rest/v1beta4/instances/restoreBackup



On Wednesday, March 25, 2020 at 8:22:26 AM UTC-4, chen levi wrote:

yes you can , we do that and its way faster.

its possible through Rest API.

for example:

curl  -o /dev/null -w'%{http_code}'  -X POST https://www.googleapis.com/sql/v1beta4/projects/${TARGET_PROJECT}/instances/${SQL_TARGET_INSTANCE}/restoreBackup -H "Authorization: Bearer ${TOKEN}"

-H 'Content-Type: application/json'  -d   '{"restoreBackupContext": {"backupRunId":"${SOURCE_BACKUP_ID}","project":"${SOURCE_PROJECT}","instanceId":  "${SQL_SOURCE_INSTANCE}"}}'

where:

TARGET_PROJECT = the project you want to  restore backup to

SQL_TARGET_INSTANCE = the sql instance you want to do restore on

TOKEN = authentication token 

SOURCE_BACKUP_ID=the backup id from the source instance you want  to use for the restore

SOURCE_PROJECT=the project  of the sql instance which were  backed  up

SQL_SOURCE_INSTANCE=the sql instance which were backed up

hope that's  clear enough.

Chen

On Wed, Mar 25, 2020 at 5:08 AM abhishek singh <abhishek.singhdba@gmail.com> wrote:

Hi,

Our Production Db is approx 1.3 TB and we do restore PROD to lower env using export/import. This is takes approx 22-26 hrs. 

Is there a way if i can restore a cloudsql managed backup across different projects ? 

Thanks

Abhi

--
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/08330703-74e9-4bcf-80cc-8060893fa998%40googlegroups.com.

--
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/ff0fafa7-c490-4896-847c-5ba5222a9451%40googlegroups.com.

Re: [google-cloud-sql-discuss] Restoring Managed backup across different Project - CloudSQL

yes you can , we do that and its way faster.

its possible through Rest API.

for example:

curl  -o /dev/null -w'%{http_code}'  -X POST https://www.googleapis.com/sql/v1beta4/projects/${TARGET_PROJECT}/instances/${SQL_TARGET_INSTANCE}/restoreBackup -H "Authorization: Bearer ${TOKEN}"

-H 'Content-Type: application/json'  -d   '{"restoreBackupContext": {"backupRunId":"${SOURCE_BACKUP_ID}","project":"${SOURCE_PROJECT}","instanceId":  "${SQL_SOURCE_INSTANCE}"}}'

where:

TARGET_PROJECT = the project you want to  restore backup to

SQL_TARGET_INSTANCE = the sql instance you want to do restore on

TOKEN = authentication token 

SOURCE_BACKUP_ID=the backup id from the source instance you want  to use for the restore

SOURCE_PROJECT=the project  of the sql instance which were  backed  up

SQL_SOURCE_INSTANCE=the sql instance which were backed up

hope that's  clear enough.

Chen

On Wed, Mar 25, 2020 at 5:08 AM abhishek singh <abhishek.singhdba@gmail.com> wrote:

Hi,

Our Production Db is approx 1.3 TB and we do restore PROD to lower env using export/import. This is takes approx 22-26 hrs. 

Is there a way if i can restore a cloudsql managed backup across different projects ? 

Thanks

Abhi

--
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/08330703-74e9-4bcf-80cc-8060893fa998%40googlegroups.com.

--
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/CAA63%3De6N6f2TNWSS_rTxYawKBH8LYLVHa_nfcswV9-Y0GwO%2Bkg%40mail.gmail.com.

[google-cloud-sql-discuss] Re: [SQLServer] Adding database stuck since 3 days

Thanks

Issue resolved by Google staff after opening a private issue tracker

On Monday, 23 March 2020 19:04:10 UTC+1, David (Cloud Platform Support) wrote:

Cloud SQL instances are constantly being monitored so issues like this one should be resolved within a few hours. However, if your Cloud SQL instance is still stuck:

File a support ticket if you have or are able to get a Google Cloud Platform Support package (this would be the fastest way to get this issue resolved).

If you do not have a support package, try opening a private Issue Tracker describing the problem, remembering to include all the relevant details such as project ID and instance name.

--
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/3e4970c7-b00a-4e6a-8a5e-cbc386951403%40googlegroups.com.

[google-cloud-sql-discuss] Restoring Managed backup across different Project - CloudSQL

Hi,

Our Production Db is approx 1.3 TB and we do restore PROD to lower env using export/import. This is takes approx 22-26 hrs. 

Is there a way if i can restore a cloudsql managed backup across different projects ? 

Thanks

Abhi

--
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/08330703-74e9-4bcf-80cc-8060893fa998%40googlegroups.com.

[google-cloud-sql-discuss] Re: [SQLServer] Adding database stuck since 3 days

Cloud SQL instances are constantly being monitored so issues like this one should be resolved within a few hours. However, if your Cloud SQL instance is still stuck:

File a support ticket if you have or are able to get a Google Cloud Platform Support package (this would be the fastest way to get this issue resolved).

If you do not have a support package, try opening a private Issue Tracker describing the problem, remembering to include all the relevant details such as project ID and instance name.

--
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/c3cedc04-d6d7-4bb0-ab46-15e0e6abc5a8%40googlegroups.com.

[google-cloud-sql-discuss] Re: [SQLServer] Adding database stuck since 3 days

Here is the message for GCloud SDK CLI :

HTTPError 409: Operation failed because another operation was already in progress

--
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/979ca16e-6964-4973-b98c-2ed17ed992a9%40googlegroups.com.

[google-cloud-sql-discuss] [SQLServer] Adding database stuck since 3 days

Hello all,

I am experiencing an issue with creating a new database : i have a CI pipeline which delete and create a database on my sqlserver instance every day.

Since 3 days, a task is running, and when i go to my instance summary, i can read this : "Adding database. This may take a few minutes. While this operation is running, you may continue to view information about the instance. "

I can't stop the task, and i can't do anything on the instance either with the console or with the SDK CLI.

I would like to stop the task, and be able to create a new one. Can anyone help me ?

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/960a3eb5-b0b7-4863-8c89-477961c3a7f6%40googlegroups.com.

[google-cloud-sql-discuss] Re: Connecting google CloudSQL (SQL server instance) to BigQuery

Hello,

Your statement about federated queries not supporting Cloud SQL Server is correct as the documentation states that it only supports MySQL 2nd generation and PostgreSQL instances.

If you refer to this StackOverflow post, the accepted answer mentions using some third party products to connect your Cloud SQL Server instance to BigQuery, or make use of Cloud Dataflow. The suggestions made there might interest you.

If you are specifically interested in using federated queries, then you may also open a Feature Request asking for federated queries to support Cloud SQL Server by following the instructions here; I currently do not see any requests of that nature yet, so opening a request may push the addition of that feature forward.

--
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/5f13ac6b-15cd-4671-bb5d-7f34f5696ce4%40googlegroups.com.

[google-cloud-sql-discuss] Connecting google CloudSQL (SQL server instance) to BigQuery

Hello folks,

I have been looking around the internet and reading Google Cloud SQL documentation , trying to figure out a way to connect CloudSQL (SQL server instance) to Google BigQuery. I ended up with the federated queries, but this resource is not available for SQL Server instance. 

Does someone have faced the same problem or similar and have any tip to a feasible solution?

Best,

Eduardo

--
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/f88ac4ff-a790-40cd-944a-9d9ab830fbf7%40googlegroups.com.

[google-cloud-sql-discuss] Re: Postgres 11 issue: "SSL error: DATA_LENGTH_TOO_LONG"

That's great. I'm glad that your issue has been resolved. Please feel free to reach out if you have any other issues, questions or concerns.

Enjoy!

-Manpreet

On Monday, March 16, 2020 at 12:06:19 PM UTC-4, Hans Ravnaas wrote:

FYI a fix for this was deployed today. The JVMs for Cloud Functions are now using 11.06 (upgraded from 11.04).

On Thursday, March 5, 2020 at 6:41:53 PM UTC-8, Hans Ravnaas wrote:

Hi, Manpreet.

I think you are misunderstanding. This has already been through a private Issue Tracker, a support case and I'm now providing info about the solution to others.

Hans

On Thursday, March 5, 2020 at 6:38:18 PM UTC-8, Manpreet Sidhu (Google Cloud Support) wrote:

Hans,

As suggested by the previous Cloud Support Agent, it would be best if you can create a Private Issue Tracker where you can provide your Instance name along with your Project name. With this information, we will be able to further investigate this issue.

This issue seems to be isolated to your use case as we have not had any other reports.

--
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/451ac70b-d4ee-4d8a-9674-0032036e6d0b%40googlegroups.com.

[google-cloud-sql-discuss] Re: Postgres 11 issue: "SSL error: DATA_LENGTH_TOO_LONG"

FYI a fix for this was deployed today. The JVMs for Cloud Functions are now using 11.06 (upgraded from 11.04).

On Thursday, March 5, 2020 at 6:41:53 PM UTC-8, Hans Ravnaas wrote:

Hi, Manpreet.

I think you are misunderstanding. This has already been through a private Issue Tracker, a support case and I'm now providing info about the solution to others.

Hans

On Thursday, March 5, 2020 at 6:38:18 PM UTC-8, Manpreet Sidhu (Google Cloud Support) wrote:

Hans,

As suggested by the previous Cloud Support Agent, it would be best if you can create a Private Issue Tracker where you can provide your Instance name along with your Project name. With this information, we will be able to further investigate this issue.

This issue seems to be isolated to your use case as we have not had any other reports.

--
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/84a202ae-0f6b-4820-9735-817c90bf7e7f%40googlegroups.com.

[google-cloud-sql-discuss] Re: Replicated database on a different maintenance schedule?

As mentioned previously, the purpose of having different maintenance windows is for still having access to the read replica while the Master is in maintenance. This behavior should be expected behavior, and according to this doc, maintenance windows are not supported by read replicas, and maintenance can happen at any time.

If you would like to have the option to select a maintenance window for read replicas, you can always submit a feature request to possibly get this implemented.

--
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/da7f0d63-c2ae-4e8d-b590-fc13c1e300f6%40googlegroups.com.

[google-cloud-sql-discuss] Re: Incorrect Region Reported by service URL and Metric URL

Hello, Siva

I was able to reproduce this issue using the monitoring API interface available on this documentation[1]. The region reported in the Response header for my CloudSQL Instance seem to be a broad region category, rather than specifically the region of the Instance. I would've recommended that the issue be reported on the issue tracker link[2] however, I observed a similar issue has already been reported on this link[3] and I can confirm that the issue has been forwarded to the API Engineers. They are reviewing the issue and you can be sure that updates would be posted on the issue link as soon as a fix or an update is available for the issue. 

[1]https://cloud.google.com/monitoring/api/ref_v3/rest/v3/projects.timeSeries/list

[2]https://cloud.google.com/support/docs/issue-trackers#trackers-list

[3]https://issuetracker.google.com/151102914

--
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/ed6ab146-82a8-45c7-9e5b-dc9ca83a85b2%40googlegroups.com.