Re: ssl database connection problems...

On Jan 21, 2009, at 4:24 PM, Ray Stell wrote:

> On Wed, Jan 21, 2009 at 12:50:23PM -0500, Carol Walter wrote:
>> -bash-3.00$ /usr/local/ssl/bin/openssl verify -CAfile ./root.crt
>> testcert.pem
>> Error loading file ./root.crt
>> 24149:error:02001002:system library:fopen:No such file or
>> directory:bss_file.c:126:fopen('./root.crt','r')
>
>
> root.crt is just my self signed root authority cert. It is just a
> file
> I created/named with openssl for testing. You place whatever file is
> the public side of the chain (you got it from the signing authority)
> somewhere and tell the command where to look with the -CAfile flag.
> The file testcert.pem was signed by that auth and so is paired with
> root.crt.
>
I do understand that. I just wasn't sure that was causing all my
errors. Also, in the second part of my message there are lines
relating to the encryption. I'm not sure what needs to be in my
postgresql.conf file to handle this. I'm using the MD5 method.

Carol

> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin