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

(edited)

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.

https://community.vercel.com/t/debugging-404-errors/437

Vercel Community

Debugging 404 Errors

Sometimes things don’t go as expected when deploying a website. If you see a 404 on your site, that means the page or resource couldn’t be found. There are...

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

Vercel Alum

Hey, ! Welcome to Vercel Community

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.

https://vercel.com/docs/connectivity/static-ips

Does that help?

This topic is closed. It no longer accepts new replies.