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 ......@.........
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.u..C......@.&`
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