I'm trying to use Prisma to connect to an AWS RDS instance with no public IP (only available on the VPC) and requires SSL. When we do a

prisma db pull --schema <our schema file with connection string>

it connects and sees the database tables and works. When we try to start up the app (which runs fine against local copies of the database) with the same connection string we get error logs of

UnhandledPromiseRejectionWarning: Error: Can't reach database server at `<our.rds.instance>.<http://rds.amazonaws.com|rds.amazonaws.com>`:`3600`

This is the format of our connection string.

mysql://<user>:<pass>@<our.rds.instance>.<http://rds.amazonaws.com:3306/<database>?pool_timeout=10&connect_timeout=10&sslcert=<ourcert.pem|rds.amazonaws.com:3306/<database>?pool_timeout=10&connect_timeout=10&sslcert=<ourcert.pem>>

Could not having a public IP be causing a connection issue in the Rust code? It's not even getting to the "Authentication failed" which is what happens if I leave off the sslcert when doing a db pull.

An extra detail, we are creating our client passing the connection string to the constructor like so:

const prisma = new PrismaClient({
  datasources: {
    db: { url: CONNECTION_STRING }
  }
})

Could you create a Bug Report for this so that our engineering team could further diagnose it?

Will do. I looked through the client code, and I couldn’t find an issue.

Ah, that’s good to know! Sounds good! 👍