On Fri, 24 Jul 2009, nmset@netcourrier.com wrote:
> I am having problems making SSL connection to PostgreSQL 8.3.7 with the
> jdbc driver, when using the NonValidatingFactory. The server constantly
> rejects the connection saying there is no certificate presented.
>
> There is no problem when NonValidatingFactory is not in use, and a
> keystore + truststore are used by the usual mechanism (-Djavax.ssl...).
>
> According to the PostgreSQl server documentation, if a root.crt
> cerfificate is present in the data directory of the database cluster,
> the server requires that a client certificate must be verified.
>
> The NonValidatingFactory is supposed to bypass any credentials
> presentation to the server.
The NonValidatingFactory does not verify the information presented by the
server. It cannot convince the server to avoid verifying the client
certificate. If the server is configured to require a client cert,
it wouldn't make a lot of sense to allow a client to turn off that
verification. The documentation was written at a time when we didn't
think client certificate presentation worked, so it didn't really consider
that possibility. So if you really want encryption only and no
validation, you need to turn off the client certificate requirement on the
server end.
Kris Jurka