could you describe or mak a video on how you got mysql with app engine using nodejs as the server side language to connect? i been struggling for weeks to get it to work and so far no good here what i have done below, i have tried other things like try going the compute engine way but the fact that i can't get the compute engine to have a https is getting in the way. but if i can just get my app engine to connect with mysql using nodejs than i would be good. if you can help.. like using a video to show case how you did it that would be great.
here are screen shoots of doing what was ask of me in this instruction: https://cloud.google.com/sql/docs/mysql/connect-app-engine?hl=en_US Setting up a Cloud SQL instance no screen shoot of that but i did create it Find the INSTANCE_CONNECTION_NAME for the instance on the *Instance details* page. It uses the format PROJECT_ID:REGION:INSTANCE_ID, and is used to identify the Cloud SQL instance you are connecting to. [image: Screenshot_2020-03-19 db1 Overview - My First Project - Google Cloud Platform.png] Enable the Cloud SQL Admin API, if you haven't already done so: i click it for both projects This service account must have the correct IAM permissions to successfully connect. Unless otherwise configured, the default service account is in the format service-PROJECT_NUMBER@ gae-api-prod.google.com.iam.gserviceaccount.com When connecting resources in two different projects, make sure that both projects have enabled the correct IAM roles and have given the service account the correct permissions. Ensure that the service account for your service has one of the following IAM roles <https://cloud.google.com/iam/docs/understanding-roles#cloud-sql-roles>: [image: Screenshot_2020-03-19 IAM – IAM Admin – My First Project – Google Cloud Platform.png] [image: Screenshot_2020-03-19 Cloud Shell(1).png] and here the error message: [image: Screenshot_2020-03-19 Cloud Shell.png] i been stuck on this project for weeks and i hate that it's this complicated or even worst it's not complicated at all but it just not conveying to me correctly of what i might be doing wrong. The frustration is real, i never blame a tool for not knowing how to use it correctly but this is making me hate google. you would think i could find a lot of resource on google cloud dealing with this issues on youtube but i don't and it suck and no other where can i find any help or how to but that same link that i been going over and over. if anyone see what i'm doing wrong or if there is a google emlpoyee that i can give access to my account to show me how to do it. i will high appreciate it. On Friday, January 10, 2020 at 8:33:17 AM UTC-5, Ferry Ariawan wrote: > > Hi, > > I use Google App Engine (nodeJs) and Google Cloud SQL (Mysql 5.7). > Yesterday (about 24 hours ago) I did a gcloud deploy and it deployed > perfectly, and when i did gcloud deploy this afternoon the app keep failing > to start. > It keeps giving this error message > 2020/01/10 13:08:54 Reading data from local connection on > /cloudsql/my-app-name:asia-south1:my-instance-name had error: read unix > /cloudsql/my-app-name:asia-south1:my-instance-name->@: read: connection > reset by peer > > > > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/613e00b1-5bd1-474c-b4b8-3c1e10670f56%40googlegroups.com.
