Need guidance: Vercel → MySQL on FreeBSD (Hetzner), no static IPs + Prisma on FreeBSD

Hi all — I’m hosting a Next.js app on Vercel with Prisma + MySQL.

My MySQL is on a FreeBSD server in Hetzner. Vercel doesn’t provide fixed outbound IPs on my plan, and Hetzner/MySQL can’t safely allowlist dynamic IPs. I tried running Prisma on FreeBSD, but Prisma engines aren’t available for FreeBSD 14, so prisma generate fails with a 404 for the engine binaries.

What’s the recommended/cleanest setup for this kind of deployment? Any gotchas or alternative approaches?

There’s another community post with 404 debugging tips that might be helpful. Please give these solutions a try and let us know how it goes.

A human should be around soon to offer more advice. But you can also get helpful information quickly by asking v0.

Hey, @abilykev-5849! Welcome to Vercel Community :waving_hand:

I’d recommend going down the Static IPs route as it’s the cleanest setup, they provide consistent, fixed IP addresses for all outbound traffic from your Vercel deployment. This solves the IP whitelisting challenge since Vercel normally uses dynamic IPs.

Does that help?

1 Like