From: | Andrew M <andrew(at)jibeya(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: SSL confirmation |
Date: | 2004-12-05 17:36:49 |
Message-ID: | 3E054141-46E4-11D9-8B7A-0003938366A4@jibeya.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc |
Andreas,
this what I get when I issue the openssl command:
6521:error:140790E5:SSL routines:SSL23_WRITE:ssl handshake
failure:s23_lib.c:226:
could you explain what this means if you know?
When I do:
/usr/local/pgsql/bin/postmaster -l -i -D /usr/local/pgsql/data
I get:
LOG: checkpoint record is at 0/DAB280
LOG: redo record is at 0/DAB280; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 1216; next OID: 17668
LOG: database system is ready
LOG: invalid length of startup packet
There is no mention of SSL at all
regards
Andrew
On 5 Dec 2004, at 17:03, Andreas Seltenreich wrote:
> Andrew M. writes:
>
>> To answer my own question I included the -l flag:
>>
>> /usr/local/pgsql/bin/postmaster -l -i -D /usr/local/pgsql/data
>>
>> No errors were reported, which I guess there would be if:
>>
>> 1. postgreSQL had not ben built with SSL support? or
>> 2. the certificate has not been properly setup?
>
> You could also use openssl's utilities to diagnose the SSL part of the
> connection. For example:
>
> $ openssl s_client -host localhost -port <port>
>
> will show you details about the authentication and encryption in use.
>
> HTH
> Andreas
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jake Stride | 2004-12-05 17:48:32 | Re: Constaints |
Previous Message | Bruno Wolff III | 2004-12-05 17:33:00 | Re: Constaints |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Seltenreich | 2004-12-05 17:59:41 | Re: SSL confirmation |
Previous Message | Michael Fuhr | 2004-12-05 17:03:59 | Re: SSL confirmation |