`psql` fails to connect to maincloud via PGWire with `sslmode=require`

[dalton-oliveira]

Description

When connecting to a SpacetimeDB Cloud instance (maincloud.spacetimedb.com) using a PostgreSQL client, the connection fails if SSL is enforced, throwing an error indicating that the server does not support SSL. This contradicts the official documentation which states sslmode=require is supported for Cloud deployments.

Reproduction Steps

Attempt to connect to a maincloud database using psql (v17) with SSL explicitly required:

psql-17 "host=maincloud.spacetimedb.com port=5432 user=any dbname=quickstart-chat sslmode=require"
psql-17: error: connection to server at "maincloud.spacetimedb.com" (131.153.201.171), port 5432 failed: server does not support SSL, but SSL was required

[bfops]

Thank you for reporting this! We'll work on getting it triaged and investigated.

[dalton-oliveira]

@bfops I tried the same command and the error persists

[bfops]

@dalton-oliveira are you getting the same "server does not support SSL" error? (we're observing a slightly different one in our test, so want to confirm)

[dalton-oliveira]

@bfops sorry it's not the same. Here's exact error:

psql-17: error: connection to server at "maincloud.spacetimedb.com" (125.253.87.9), port 5432 failed: FATAL:  Invalid Authorization Specification. SSL connection is required```

[bfops]

okay that looks like what we're seeing now. Thank you! We're investigating.

[jdetter]

This will likely be fixed this week when we roll the release.

[bfops]

This is still not working as expected

[bfops]

it seems to be working properly now after hitting some machines with a wrench!

@dalton-oliveira please let us know if you're still having this issue.

[dalton-oliveira]

works fine! Thanks @bfops