🐛 BUG: hyperdrive localConnectionString changed to sslmode=prefer after updated to 3.86.1

[j4tmr]

Which Cloudflare product(s) does this pertain to?

Wrangler

What version(s) of the tool(s) are you using?

3.86.1

What version of Node are you using?

20.10.0

What operating system and version are you using?

Mac Sonoma 14.6.1

Describe the Bug

Observed behavior

hyperdrive localConnectionString not working
sslmode=disable in 3.85.0

Please provide a link to a minimal reproduction

No response

Please provide any relevant error logs

No response

[edmundhung]

Hi @j4tmr ! Yes, we’ve updated localConnectionString to use sslmode=prefer recently. This change should allow connections to use SSL if available while still supporting unencrypted connections for local test databases.

If you run into any issues because of this change, could you share more details, such as any error messages you’re seeing? That would help us investigate further. Thanks!

[j4tmr]

@edmundhung The server does not support SSL connections. While i'm using supabase locally, with configuration

[[hyperdrive]]
binding = "xxx"
id = "xxx"
localConnectionString = "postgresql://postgres:[email protected]:54322/postgres"

And at the same time, localConnectionString = "postgresql://postgres:[email protected]:54322/postgres?sslmode=disable" not works.

[sambarnes]

seeing similar as j4tmr -- appears we're both using supabase, judging from the 54322 port number there

this worked previously but no longer does

local workaround is doing this for dev environment:
c.env.HYPERDRIVE_SUPABASE.connectionString.replace('sslmode=prefer', 'sslmode=disable')

not great but unblocks for now

---

edit: oh and to be clear, error i was seeing was CONNECT_TIMEOUT

[ivanfgm]

Same here with a remote timescale instance (CONNECT_TIMEOUT), could only get it working replacing prefer with disable same as @sambarnes