Database connection error with Postgres & Movable Type

Question

I'm trying to set up MovableType 4.34 using a Postgres database, and I'm getting the following (unhelpful) error message:

Connection error: authentication method 7 not supported

The database server doesn't support SSL connections, so I suspect that's to blame -- but I can't be sure (what is "authentication method 7" ?), and at any rate it's not clear to me how to see if MT is trying to use SSL connections for the database or not. Any ideas?

Answer 1

Did you turn on SSL in postgresql.conf? Just check it using this query:

SHOW ssl;

You have to check pg_hba.conf as well, hostssl needs a proper setting.