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
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 |
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? |