Trying to deploy a remix.run project to Fly.io with fly postgress - Getting Error: P1011: Error opening a TLS connection: unexpected EOF

1

Hello.

Im trying to deploy a remix.run project to fly.io using fly postgress, but getting the following error:

Error: P1011: Error opening a TLS connection: unexpected EOF

when connecting from local it works fine.
The db is already attached to the app.

Any clues?

Thanks in advance

2

I’m having exactly the same issue with renewly deployed Remix app.
is there any insight into this ?

3

For what it is worth, I’m able to follow the remix blues stack instructions and deploy.

I don’t know how you are set up, but with fly postgres you do NOT want SSL/TLS.

My prisma/schema.prisma:

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

generator client {
  provider = "prisma-client-js"
}

model User {
. . .
4

OK, figured it out. I tried adding ?sslmode=disable to the connection string in DATABASE_URL, and that solved it. thanks!!

1 Like
5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.