BUG #4405: Valid certificate reported as expired - Mailing list pgsql-bugs

From Andrej Podzimek
Subject BUG #4405: Valid certificate reported as expired
Date
Msg-id 200809061243.m86ChLKm092741@wwwmaster.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4405
Logged by:          Andrej Podzimek
Email address:      andrej@podzimek.org
PostgreSQL version: 8.3.3
Operating system:   Linux
Description:        Valid certificate reported as expired
Details:

Hello,

I thought this was a PgAdmin III issue and reported it on the PgAdmin
mailing list. Only now did I realize that psql has exactly the same
problem.

I have been using psql (and PgAdmin III) with SSL for a couple of months. I
set up certificates for both the server and the client, valid until March
2009. Everything worked fine.

Now the bad news: Both psql and PgAdmin refuse to connect since yesterday,
with this error message:

    Error connecting to the server: SSL error: sslv3 alert certificate
expired

This is obviously a nonsense, as both certificates are valid and system
clocks on both computers show correct date and time. I even restarted the
PostgreSQL server, which did not help.

There haven't been any such problems up to now, so what could be wrong? Is
there anything I should try?

Best regards,

Andrej Podzimek

pgsql-bugs by date:

Previous
From: "Ross Toole"
Date:
Subject: BUG #4404: Installation Appears to work service fails
Next
From: "Mike Gagnon"
Date:
Subject: BUG #4406: silent install error