0

Im trying to deploy my NodeJS app to Google cloud functions connected to a Cloud SQL instance (MySQL) and using Prisma ORM.

The deployment was successful, but whenever I access an API route with a connection to the database, I get the following error as a response:

PrismaClientInitializationError: Can't reach database server at `my.cloudsql.ip`:`3306`. Please make sure your database server is running at `my.cloudsql.ip`:`3306`.

My database string looks like this: "mysql://user:password@cloud-sql-ip/database?host=/cloudsql/instance-connection-name"

I alread try adding ?connect_timeout=300 to the connection string of the database as mentioned here. But I didn't succeed.

Exlley Santos
  • 21
  • 4

2 Answers2

3

It also took me a while to figure this out, here's the URL that worked for me:

DATABASE_URL=mysql://{USER}:{PASSWORD}@{INSTANCE_PUBLIC_IP}:3306/{DB_NAME}?socket={INSTANCE_CONNECTION_NAME}

Then, in your schema.prisma:

datasource db {
  provider = "MySQL"
  url = env("DATABASE_URL")
}

ALSO, remember to update the IAM permissions in your Cloud Function/Cloud SQL instance to authorize the Cloud function to read from DB: https://cloud.google.com/sql/docs/mysql/connect-functions

Diego Olalde
  • 56
  • 5
  • Thanks for your answer. Updating my IAM permissions in my Cloud Function instance to authorize the Cloud function to read from DB worked for me. – Exlley Santos Jul 01 '22 at 13:54
1

In my case, It is because I use the generated password from cloud SQL .Thus, I encode it and my connection string is like

DATABASE_URL=mysql://{USER:{PASSWORD}@{INSTANCE_PUBLIC_IP}:3306/{DB_NAME}

ninoorta
  • 662
  • 1
  • 5
  • 13