Problem with SSL

From: Peter Dockweiler <pdo(at)wikon(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem with SSL
Date: 2001-07-02 07:52:22
Message-ID: 01070209522200.00848@pdo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Am Donnerstag, 28. Juni 2001 16:50 schrieb Peter Dockweiler:
Hello,

I am trying to connect to PostregSQL with SSL.
I need a SSL conection with a windoze client. The client uses psqlodbc and
stunnel for the SSL encryption.
I have compiled the PostgresSQL 7.1.2 and openssl 0.9.6a.
It starts with -i -l.
The SSL connection will not work. I tryed
# openssl s_client -connect localhost:5432 -debug
and get the following output:

CONNECTED(00000003)
write to 08149618 [08149660] (124 bytes => 124 (0x7C))
0000 - 80 7a 01 03 01 00 51 00-00 00 20 00 00 16 00 00 .z....Q... .....
0010 - 13 00 00 0a 07 00 c0 00-00 66 00 00 05 00 00 04 .........f......
0020 - 03 00 80 01 00 80 08 00-80 00 00 65 00 00 64 00 ...........e..d.
0030 - 00 63 00 00 62 00 00 61-00 00 60 00 00 15 00 00 .c..b..a..`.....
0040 - 12 00 00 09 06 00 40 00-00 14 00 00 11 00 00 08 (dot)(dot)(dot)(dot)(dot)(dot)(at)(dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)
0050 - 00 00 06 00 00 03 04 00-80 02 00 80 6e f6 c8 d7 ............n...
0060 - 55 a4 75 be fd 43 16 be-00 1f cf a8 40 a5 26 60 U(dot)u(dot)(dot)C(dot)(dot)(dot)(dot)(dot)(dot)(at)(dot)&`
0070 - da f5 1a c7 e2 b1 d2 fa-d3 02 9c d8 ............
read from 08149618 [0814EBC0] (7 bytes => 7 (0x7))
0000 - 45 49 6e 76 61 6c 69 EInvali
2780:error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown
protocol:s23_clnt.c:460:

I think PostgreSQL does not use the SSL encryption. Does anybody know where
the problem ist?
I can use stunnel on the server, because I need hba.

Thanks in advance.
Peter Dockweiler

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew W. Nosenko 2001-07-02 10:54:52 Re: Data Conversion
Previous Message Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= 2001-07-01 14:19:03 Re: A small question about Red Hat