I'm trying to get an hyperdrive created through a cloudflare tunnel with wrangler. We can confirm the tunnel is working if I run cloudflared locally and connect to my postgres database with pgadmin while cloudflared is running. I can also create an hyperdrive pointing directly to the postgres database if I open it up to the public and don't use the tunnel.
When I use the tunnel though, I get the error
A request to the Cloudflare API (/accounts/f6a6c66448e6ec04bcb60f35a3205b86/hyperdrive/configs) failed. DNS lookup failed. Please make sure the hostname is valid and is a publicly routable address or IP [code: 2008]
A request to the Cloudflare API (/accounts/f6a6c66448e6ec04bcb60f35a3205b86/hyperdrive/configs) failed. DNS lookup failed. Please make sure the hostname is valid and is a publicly routable address or IP [code: 2008]
(creating it through wrangler) with npx wrangler hyperdrive create my-cool-tunnel --host=tunnel.mycompany.com:5432 --user=myuser --password=mydbpassword --database=mydb --access-client-id=myid --access-client-secret=mysecret