Connecting via SSL not working (except from psql)

From: Paul Legato <plegato(at)nks(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Connecting via SSL not working (except from psql)
Date: 2002-08-06 15:46:42
Message-ID: 3D4FEF62.2000206@nks.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

Hi,

I'm trying to connect to SSL-enabled Postgres (started with -i -l) using
both the openssl command line utility and with a modified JDBC driver
using the built in JSSE API from Java 1.4.

If I attempt to connect from a shell with the openssl test utility, I get:

$ openssl s_client -connect localhost:5432
CONNECTED(00000003)
25870:error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown
protocol:s23_clnt.c:460:

With the JDBC driver, at connection I get:

javax.net.ssl.SSLException: Unrecognized SSL message, plaintext connection?

In both cases, the server logs the message "FATAL 1: invalid length of
startup packet".

A connection to the server with psql works fine, and prints "SSL
connection (cipher: DES-CBC3-SHA, bits: 168)" at startup. I've tried
manually specifying this cipher to openssl, which does not change the
result.

I'm stuck. Any suggestions or pointers will be greatly appreciated. :)

Thanks,
-Paul

Browse pgsql-admin by date

  From Date Subject
Next Message Riyaz 2002-08-06 16:47:58 need plain pg_hba.conf file
Previous Message =?ISO-8859-1?Q?St=E9phane?= 2002-08-06 10:33:24 Ouverture d'une session base de données

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mark Proctor 2002-08-06 17:08:28 Clob Blob Status
Previous Message Jacob Vennervald Madsen 2002-08-06 15:10:03 Can I check if a db connection is working?