[google-cloud-sql-discuss] Re: Cloud SQL Admin API - Sudden and ongoing spike

The serviceName, cloudsql.googleapis.com filters logs associated with the CloudSQL Instance, rather than the CloudSQL admin API. More specifically, the service name for the Cloud SQL Admin API is "sqladmin.googleapis.com". 

If no results are returned from using your Advanced Filter with serviceName= "sqladmin.googleapis.com", I recommend reporting this issue about the spike on Cloud SQL Admin API's queries by creating an issue on the Issue tracker. An engineer should be able to work with you reviewing the details of your Stackdriver logs to understand the Spikes in your usage of the API. 

--
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/f6ff0bc1-46a5-43a0-8a98-c7f25b5861d1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Postgres refuses connection when trying to use Proxy with Kubernetes

I changed the ports per Harmit's instructions. I also found that for some reason the credential files were not getting loaded into the proxy properly. So if you're running into those issues it is a good idea to check those issues.

After fixing both of those issues, it worked!! 

Thank you Harmit for your detailed answer!

On Thursday, October 25, 2018 at 2:07:58 PM UTC-7, Harmit Rishi (Cloud Platform Support) wrote:

Hello,

Considering the type of error you are receiving, it would be my recommendation to follow the troubleshooting steps on the GKE troubleshooting in here.

If the issue persists we can attempt the following as well:

-Verify scopes/permissions for your cluster by navigating from GCP>KE> Cluster>permissions> Cloud SQL should be "Enabled".

(Note: if you see Cloud SQL: Disabled then you can enable the API permission here.)

-You had mentioned that a docker image was built exposing port:5432. I would like to inform you that only your proxy port should be set to 5432.

(Note: When a cluster is created the default port for the proxy is 5432. Connection errors can occur if the same port is used for both the cluster and your proxy within the pod.)

Also, this forum is not intended for troubleshooting customer issues, so I'll recommend posting your issue on Stackoverflow forum

On Thursday, October 25, 2018 at 8:22:00 AM UTC-4, Nathan Berkowitz wrote:

Hi All,

I have an application written in python that streams tweets from Twitter into a PostGres database in Google Cloud Platform using SqlAlchemy. 

I built the docker image (exposing port 5432) and uploaded it to the container registry, and followed all of the steps to connect GKE to SQL in the "Connecting from GKE" guide. 

However, after following all of the steps and setting up the proxy, I keep getting the "connection refused" error from the database. 

Here are the things that I have checked:

• Tested the script locally. If I use the public IP I set up for local connections, it works fine.
• Re-built the docker image using the --no-cache flag to make sure my changes were actually implemented
• Made sure that the Kubernetes Engine Service Agent had Admin access to Cloud SQL.
• Changed the Host IP in my application from the DBs public IP to localhost, per the instructions.
• Checked to make sure that the username/password were correct.

Any help you could offer would be greatly appreciated!

Best,

Nathan

--
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/214b9021-d065-4bcd-b3b5-069037890be7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Connectivity section not load, unable to manage authorized networks

As log returned 403 error which means the client is not permitted access to the resource for some reason besides authentication. This other reason needs to be acted upon before re-requesting access to the resource. You can find more information on HTTP 403 here.

It looks like you possibly don't have permission to get host project information. A potential workaround to this issue would be to upgrade your permissions to make sure you have project viewing permission. In addition to that please make sure there are no connectivity issues.

I can see that you also created a Public Issue Tracker (118342206) and you have been advised the same there as well and instruct you how to get details about project and Cloud SQL permissions[1][2] and how to grant permission to the project member[3].

If you have still has any other questions and concerns you can ask it at the Public Issue Tracker (118342206).

[1] https://cloud.google.com/sql/docs/mysql/project-access-control#permissions-gcloud

[2] https://cloud.google.com/iam/docs/

[3] https://cloud.google.com/iam/docs/quickstart

On Wednesday, October 24, 2018 at 8:24:54 AM UTC-4, Oleg Stefaniuk wrote:

Connectivity section not load from web ui

got 403 status at the moment when loader stops.

--
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/607aa227-445c-4d96-8bca-a3beee519aed%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Postgres refuses connection when trying to use Proxy with Kubernetes

Hello,

Considering the type of error you are receiving, it would be my recommendation to follow the troubleshooting steps on the GKE troubleshooting in here.

If the issue persists we can attempt the following as well:

-Verify scopes/permissions for your cluster by navigating from GCP>KE> Cluster>permissions> Cloud SQL should be "Enabled".

(Note: if you see Cloud SQL: Disabled then you can enable the API permission here.)

-You had mentioned that a docker image was built exposing port:5432. I would like to inform you that only your proxy port should be set to 5432.

(Note: When a cluster is created the default port for the proxy is 5432. Connection errors can occur if the same port is used for both the cluster and your proxy within the pod.)

Also, this forum is not intended for troubleshooting customer issues, so I'll recommend posting your issue on Stackoverflow forum

On Thursday, October 25, 2018 at 8:22:00 AM UTC-4, Nathan Berkowitz wrote:

Hi All,

I have an application written in python that streams tweets from Twitter into a PostGres database in Google Cloud Platform using SqlAlchemy. 

I built the docker image (exposing port 5432) and uploaded it to the container registry, and followed all of the steps to connect GKE to SQL in the "Connecting from GKE" guide. 

However, after following all of the steps and setting up the proxy, I keep getting the "connection refused" error from the database. 

Here are the things that I have checked:

• Tested the script locally. If I use the public IP I set up for local connections, it works fine.
• Re-built the docker image using the --no-cache flag to make sure my changes were actually implemented
• Made sure that the Kubernetes Engine Service Agent had Admin access to Cloud SQL.
• Changed the Host IP in my application from the DBs public IP to localhost, per the instructions.
• Checked to make sure that the username/password were correct.

Any help you could offer would be greatly appreciated!

Best,

Nathan

--
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/875837e8-a144-4ecb-b69a-3e58f32c736f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Cloud SQL Admin API - Sudden and ongoing spike

Thank you Katayoon,

I'm trying to filter logs, but I'm just finding register from [ protoPayload.serviceName= "cloudsql.googleapis.com"].

Filtering by [ protoPayload.serviceName= "sqladmin.googleapis.com"] it gives me no logs, even on days showing those spike on charts.

Em quarta-feira, 24 de outubro de 2018 17:36:48 UTC-3, Katayoon (Cloud Platform Support) escreveu:

Hi Hudson,

I should note that Cloud SQL Admin API is for administering your instances programmatically, and you can make Advanced Logs Filters to get more information on the request sent to this API. As you can find in Cloud SQL Admin API console, the service name is "sqladmin.googleapis.com". So you may use this service name as a filter in your Logs Viewer. 

--
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/8f2ae253-8015-452b-9548-8dac048ddc6a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Cloud SQL Admin API - Sudden and ongoing spike

Thank you Katayoon,

I'm trying to filter logs, but I'm justing finding register from [ protoPayload.serviceName= "cloudsql.googleapis.com"].

Filtering by [ protoPayload.serviceName= "sqladmin.googleapis.com"] it gives me no logs, even on days showing those spike on charts.

Em quarta-feira, 24 de outubro de 2018 17:36:48 UTC-3, Katayoon (Cloud Platform Support) escreveu:

Hi Hudson,

I should note that Cloud SQL Admin API is for administering your instances programmatically, and you can make Advanced Logs Filters to get more information on the request sent to this API. As you can find in Cloud SQL Admin API console, the service name is "sqladmin.googleapis.com". So you may use this service name as a filter in your Logs Viewer. 

--
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/32bda981-ef84-40b1-bf50-c8278e9d16df%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Postgres refuses connection when trying to use Proxy with Kubernetes

Hi All,

I have an application written in python that streams tweets from Twitter into a PostGres database in Google Cloud Platform using SqlAlchemy. 

I built the docker image (exposing port 5432) and uploaded it to the container registry, and followed all of the steps to connect GKE to SQL in the "Connecting from GKE" guide. 

However, after following all of the steps and setting up the proxy, I keep getting the "connection refused" error from the database. 

Here are the things that I have checked:

• Tested the script locally. If I use the public IP I set up for local connections, it works fine.
• Re-built the docker image using the --no-cache flag to make sure my changes were actually implemented
• Made sure that the Kubernetes Engine Service Agent had Admin access to Cloud SQL.
• Changed the Host IP in my application from the DBs public IP to localhost, per the instructions.
• Checked to make sure that the username/password were correct.

Any help you could offer would be greatly appreciated!

Best,

Nathan

--
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/05b9756c-e282-4bba-a319-ee2ce1f99f5c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Cloud SQL Admin API - Sudden and ongoing spike

Hi Hudson,

I should note that Cloud SQL Admin API is for administering your instances programmatically, and you can make Advanced Logs Filters to get more information on the request sent to this API. As you can find in Cloud SQL Admin API console, the service name is "sqladmin.googleapis.com". So you may use this service name as a filter in your Logs Viewer. 

--
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/8b262981-05bb-4ea0-920b-e300b3e7d0d4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: How do I find out what's taking up most of the space on my SQL CLOUD GCP?

Hello,

The issue that you are reporting is related to the operations performed within the specified time frame. You can check that by clicking "OPERATIONS" tab from the same console from where you were view the "OVERVIEW" of the "Storage usage".

To view the mentioned logs STACKDRIVER -> Logging -> Logs in the Navigation menu (the hamburger icon in the top left section of the Cloud Console page) under STACKDRIVER. Please select 'Cloud SQL Database' from the drop down menu of the component three of the basic filter interface as outlined in this document. Select 'No limit' from the drop down menu of the component four.  You can modify or filter the log according to your requirements. However it is impossible to tell without more detailed inspection.  

What's needed for anybody who would want to report an issue, is to use the issue tracker rather than google groups. This forum is meant for general discussion of the platform, not specific technical issues. If the issue requires to share any private or project specific information please choose the "Private" component so that the information are not visible to the public.

If you believe that what you've encountered is not a platform issue but rather a problem with how you've configured your code, although you're not sure what it may be specifically, you should post to stackoverflow.

If the above suggestions does not help you to resolve the issue, I wish you the best of luck in proceeding to either open a proper issue report in the public issue tracker, or posting to stackoverflow so that you can get support from the community of developers.

On Tuesday, October 23, 2018 at 1:38:50 PM UTC-4, Michel Zúñiga wrote:

I could identify what is taking up most of my SQL Cloud Storage, in the last 24 hours something wrote almost 1 GiB on the storage, according to the GCP dashboards.

If a use MySQL client to determine the size of my tables, the values didn't match with my storage use.

+--------------------+-----------+
| Database | Size (MB) |
+--------------------+-----------+
| information_schema | 0.01 |
| mysql | 6.92 |
| performance_schema | 0.00 |
| XXX_db2014 | 480.25 |
| XXX_db2015 | 282.86 |
| XXX_db2017 | 208.14 |
| XXX_db2018 | 215.44 |
+--------------------+-----------+

Any idea on how to determine what is taking up most of the space?

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/bd6509b6-276a-44b6-bb58-b52fe915527b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] ETL approaches to bulk load data in Cloud SQL

I'm not really sure where I should ask these types of questions, but this one is a duplicate of a question that I posted on StackOverflow: https://stackoverflow.com/questions/52973508/etl-approaches-to-bulk-load-data-in-cloud-sql. 

Since this is a discussion forum, maybe someone could help me.

I need to ETL data into my Cloud SQL instance. This data comes from API calls. Currently, I'm running a custom Java ETL code in Kubernetes with Cronjobs that makes request to collect this data and load it on Cloud SQL. The problem comes with managing the ETL code and monitoring the ETL jobs. The current solution may not scale well when more ETL processes are incorporated. In this context, I need to use an ETL tool.

My Cloud SQL instance contains two types of tables: common transactional tables and tables that contains data that comes from the API. The second type is mostly read-only in a "operational database perspective" and a huge part of the tables are bulk updated every hour (in batch) to discard the old data and refresh the values.

Considering this context, I noticed that Cloud Dataflow is the ETL tool provided by GCP. However, it seems that this tool is more suitable for big data applications that needs to do complex transformations and ingest data in multiple formats. Also, in Dataflow, the data is parallel processed and worker nodes are escalated as needed. Since Dataflow is a distributed system, maybe the ETL process would have an overhead when allocating resources to do a simple bulk load. In addition to that, I noticed that Dataflow doesn't have a particular sink for Cloud SQL. This probably means that Dataflow isn't the correct tool for simple bulk load operations in a Cloud SQL database.

In my current needs, I only need to do simple transformations and bulk load the data. However, in the future, we might want to handle other sources of data (pngs, json, csv files) and sinks (Cloud Storage and maybe BigQuery). Also, in the future, we might want to ingest streaming data and store it on Cloud SQL. In this sense, the underlying Apache Beam model is really interesting, since it offers an unified model for batch and streaming.

Giving all this context, I can see two approaches:

1) Use an ETL tool like Talend in the Cloud to help monitoring ETL jobs and maintenance.

2) Use Cloud Dataflow, since we may need streaming capabilities and integration with all kinds of sources and sinks.

The problem with the first approach is that I may end up using Cloud Dataflow anyway when future requeriments arrives and that would be bad for my project in terms of infrastructure costs, since I would be paying for two tools.

The problem with the second approach is that Dataflow doesn't seem to be suitable for simply bulk loading operations in a Cloud SQL Database.

Is there something I am getting wrong here? Can someone enlighten me?

--
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/703173ed-40a3-45c8-9993-14cf9e3426d2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Understanding the behaviour of gcloud sql export

Any news on that?

Il giorno giovedì 18 ottobre 2018 15:08:45 UTC+2, Matteo Di Sabatino ha scritto:

Hello all,

I've got a Google Cloud SQL instance of second generation; for a purpose of mine, I decided to create a sort of replica machine by exporting data from it and importing to another instance.

Before begin I controlled the used disk space, that was 125GB and after I exported the database by running the command:

gcloud sql export sql MY_INSTANCE gs://MY_BACKET/2018-10-18/mysql/MY_DB.mysql.sql.gz --database=MY_DB

When it finished I imported that backup into the replica machine, and... surprise! The used disk space was 180GB!

How is it possibile? Why was the second instance 55GB bigger?

Thanks in advance for the response.

--
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/f808a5f8-a72e-4ffd-b6dc-273f5d257812%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Latency executing SQLs from GAE

This has been reported as resolved in October 23 https://status.cloud.google.com/incident/cloud-sql/18004 but the issue remains

Anyone else has this 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/05f5c3ba-a1a8-410f-8c8b-40d54f6c737f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Connectivity section not load, unable to manage authorized networks

Connectivity section not load from web ui

got 403 status at the moment when loader stops.

--
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/308c988a-61e7-4d9a-825d-0e393a180d99%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Cloud SQL Admin API - Sudden and ongoing spike

Since last monday (15/10) a notice a sudden spike on Cloud SQL Admin API's queries, but we didn't make any changes in our application or in our environment recently. 

Is there any place where I can see which queries are these?

I'm looking everywhere but I can't find the origin of this spike.

--
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/ff9c990f-90d5-4b6b-871f-983cd65ff669%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] How do I find out what's taking up most of the space on my SQL CLOUD GCP?

I could identify what is taking up most of my SQL Cloud Storage, in the last 24 hours something wrote almost 1 GiB on the storage, according to the GCP dashboards.

If a use MySQL client to determine the size of my tables, the values didn't match with my storage use.

+--------------------+-----------+
| Database | Size (MB) |
+--------------------+-----------+
| information_schema | 0.01 |
| mysql | 6.92 |
| performance_schema | 0.00 |
| XXX_db2014 | 480.25 |
| XXX_db2015 | 282.86 |
| XXX_db2017 | 208.14 |
| XXX_db2018 | 215.44 |
+--------------------+-----------+

Any idea on how to determine what is taking up most of the space?

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/02d1e26a-5836-47a9-b7c3-1220a4d57b2e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Connect SQL Cloud with Java and Hibernate error

Take a look at the Cloud SQL Socket Factory for JDBC drivers.

In case you need assistance using it, I suggest posting a question on Stack Overflow so people that are more familiar with Hibernate can help you.

On Monday, October 22, 2018 at 10:40:45 AM UTC-4, Misael Astorga wrote:

I want to connect my java application with hibernate to my mysql db in the cloud.

i start with the Hibernate Configuration Wizard and everything goes well but when i try to make the Hibernate Reverse Engineering it says this: 

Do you guys have any recommendation or some done examples that i can see?

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/297867e2-af6c-4cb4-9fb3-f47d8a8e76cb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Google Cloud SQL and Google Earth Engine

Hello Andrea, 

You can use the Asset Manager or command line interface (CLI) to upload datasets in the Shapefile format. Related details are accessible on the "Importing Table Data" page. 

You can also export images, map tiles, tables and video from Earth Engine. The exports can be sent to your Google Drive account, to Google Cloud Storage or to a new Earth Engine asset. You can read more on this subject from the "Exporting Data" online document. More on Asset Manager here. 

--
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/848740e2-11d0-4c7e-abdb-55bf775769fb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Google Cloud SQL and Google Earth Engine

Hi, 

I would like to know if there is a way to import geometries hosted in Google Cloud SQL in Google Earth Engine, or should I use Google Cloud Storage to do so?

Thank You,

Andrea

--
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/86a35778-22be-40c2-8979-051f22823304%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Connect SQL Cloud with Java and Hibernate error

I want to connect my java application with hibernate to my mysql db in the cloud.

i start with the Hibernate Configuration Wizard and everything goes well but when i try to make the Hibernate Reverse Engineering it says this: 

Do you guys have any recommendation or some done examples that i can see?

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/6c7f613c-ccc5-4dc5-8c0c-8d5be86b9ef3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Understanding the behaviour of gcloud sql export

Hello Parth, 

The message option you see in the drop-down menu is inherently private, as the message is directed to the addressee and not visible to anyone else.

--
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/9587d5a6-ac04-4b72-8c42-fa32cf36545d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: SQLSTATE[HY000] [2002] No such file or directory, google cloud app engine flexible

Hello Parth, 

The recommended way to connect to Cloud SQL is detailed in the "Using Cloud SQL for MySQL" online document. The env_variables entry in your app.yaml should look analogous to: 

env_variables:

  SQL_USER: YOUR_SQL_USER

  SQL_PASSWORD: YOUR_SQL_PASSWORD

  SQL_DATABASE: YOUR_SQL_DATABASE

  # e.g. my-awesome-project:us-central1:my-cloud-sql-instance

  INSTANCE_CONNECTION_NAME: YOUR_INSTANCE_CONNECTION_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/4b413e61-c59f-4219-9f69-0395e37ac174%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Understanding the behaviour of gcloud sql export

There is no private option on reply drop-down menu. How can i send private message?

On Fri, Oct 19, 2018 at 8:05 PM 'George (Cloud Platform Support)' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

Hi Matteo, 

At this stage, we need your project ID and the name of the two instances in question, to have a deeper look at this out-of-common situation. This is confidential information, and should not be published directly in forums with public visibility. You should rather send me a private message from the drop-down menu of the "reply" button at the top right of the window. You are encouraged to open a new issue in Public Issue Tracker, including all the information above. In PIT things will get investigated thoroughly, and you'll be able to follow developments with ease. 

--
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/71c7c786-4128-46af-8f58-f19bd9ddcb51%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Parth Gohil

Rockers Technology.

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

[google-cloud-sql-discuss] Re: Understanding the behaviour of gcloud sql export

Hi Matteo, 

At this stage, we need your project ID and the name of the two instances in question, to have a deeper look at this out-of-common situation. This is confidential information, and should not be published directly in forums with public visibility. You should rather send me a private message from the drop-down menu of the "reply" button at the top right of the window. You are encouraged to open a new issue in Public Issue Tracker, including all the information above. In PIT things will get investigated thoroughly, and you'll be able to follow developments with ease. 

--
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/71c7c786-4128-46af-8f58-f19bd9ddcb51%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] SQLSTATE[HY000] [2002] No such file or directory, google cloud app engine flexible

I am trying to connect cloud sql socket with google cloud app engine flexible.

My code is as bellow:

$dsn = getenv('MYSQL_DSN');  $user = getenv('MYSQL_USER');  $password = getenv('MYSQL_PASSWORD');  try {      $db = new PDO($dsn, $user, $password);      $statement = $db->prepare("SELECT * from user");      $statement->execute();      $users = $statement->fetchAll();  } catch (Exception $e) {      echo 'Caught exception: ',  $e->getMessage(), "\n";  }

app.yaml

runtime: php
env: flex

runtime_config:
    document_root: .

env_variables:
    MYSQL_DSN: mysql:dbname=DATABASE;unix_socket=/cloudsql/CONNECTION_NAME
    MYSQL_USER: username
    MYSQL_PASSWORD: password

Getting bellow error

SQLSTATE[HY000] [2002] No such file or directory

--
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/110133e6-de24-4ede-88d5-ee25e8990be6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] SQLSTATE[HY000] [2002] No such file or directory, google app engine flexible

Using cloud sql with app engine flexible. Trying to connect sql with socket as bellow:

   

   $dsn = getenv('MYSQL_DSN');

   $user = getenv('MYSQL_USER');

   $password = getenv('MYSQL_PASSWORD');

   try {

       $db = new PDO($dsn, $user, $password);

       $statement = $db->prepare("SELECT * from user");

       $statement->execute();

       $users = $statement->fetchAll();

   } catch (Exception $e) {

       echo 'Caught exception: ',  $e->getMessage(), "\n";

   }

My app.yaml file

    runtime: php

    env: flex

    runtime_config:

        document_root: .

    env_variables:

        MYSQL_DSN: mysql:dbname=DATABASE;unix_socket=/cloudsql/INSTANCE_CONNECTION_NAME

        MYSQL_USER: username

        MYSQL_PASSWORD: password

I am getting bellow error:

Caught exception: SQLSTATE[HY000] [2002] No such file or directory

--
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/5316d2c5-6983-46f7-aa35-356735b8ccfa%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.