Skip site navigation (1) Skip section navigation (2)

Re: SSL Connection Issue

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: Flip Mulder <fmulder(at)xs4all(dot)nl>,pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: SSL Connection Issue
Date: 2004-07-28 15:27:04
Message-ID: 4107C5C8.7070907@pse-consulting.de (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
Magnus Hagander wrote:
>  
> 
>>I am connecting to the server from the same computer as where 
>>the server is running. Just local... The log of the server 
>>gives this (with
>>log_error_verbosity=verbose):
>>
>>------------------------------------------------------
>>C:\Documents and Settings\postgresql>postmaster
>>LOG:  could not recognize system timezone, defaulting to "Etc/GMT-1"
>>HINT:  You can specify the correct timezone in postgresql.conf.
>>LOG:  could not load root certificate file
>>"C:/postgres/data/root.crt": No such
>>file or directory
> 
> 
> ^^^
> This here is your problem. There is no root certificate for it to load.
> You need to either adjust the path to wherever you have your root
> certificate, or move the root certificate to the specified location.
> 

No, AFAIR root.crt is necessary for client certificates only. My Linux 
installation works perfectly without.
server.req, server.key and server.crt are in my PGDATA dir.

Regards,
Andreas

In response to

pgsql-hackers-win32 by date

Next:From: Richard Sydney-SmithDate: 2004-07-28 15:29:32
Subject: Re: win32 pgsql not installable
Previous:From: Bruce MomjianDate: 2004-07-28 14:43:43
Subject: Re: win32 pgsql not installable

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group