Does anyone have any experience with setting up Pr...
# orm-help
k
Does anyone have any experience with setting up Prisma/ PostgreSQL on a local machine and then connecting to it through your external IPv4? I can connect to it through my LAN no problem (using internal IPv4), but when I try and use my external IPv4 (after port forwarding and allowing inbound & outbound traffic on the machine through ufw) it just won't connect.
Copy code
Message: Error in Prisma Client request: 


Invalid `prisma.entry.findMany()` invocation:


Can't reach database server at `external_ipv4_redacted`:`5000`

Please make sure your database server is running at `external_ipv4_redacted`:`5000`.
  
Query:
{
  "modelName": "Entry",
  "operation": "findMany",
  "args": {
    "take": 100,
    "skip": 0,
    "select": {
      "id": true
    }
  }
}
1
t
not an expert but have u tried to see whether you can access anything through your ipv4?
maybe spin up a web server and see whether you can access through ip just to confirm that it’s not sth else blocking your connection
k
Yeah I've accessed things before with my external IPv4 plenty of times, I did just wipe the PC that I'm running the PSQL server on so I can check to see if that's still the case
n
I haven't tried connecting through an external ipv4 before, but I was wondering if you would need to add some configuration in the PostgreSQL database to allow connecting it remotely through an ipv4 address, something like what this article describes.