Re: Connection string parameter "sslrootcert" does not work

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ed Hutchinson <edhutch1963(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Connection string parameter "sslrootcert" does not work
Date: 2014-11-12 00:59:14
Message-ID: 5462B0E2.5060508@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On 11/11/2014 09:52 AM, Ed Hutchinson wrote:
> Thanks, Adrian.
>
>
> Sorry, I should have provided more details.
>

> I get back:
> root certificate file \"/Users/edhutch/.postgresql/root.crt\" does not
> exist\nEither provide the file or change sslmode to disable server
> certificate verification.

Have you tried doing a psql connection using a redirected sslrootcert to
determine if this a more general problem?

Have you tried to quote the path names?

>
> When I rename the pem file to root.crt and place it in the default
> location that the driver expects, the connection goes through fine.
>

> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2014-11-12 03:36:10 Re: Connection string parameter "sslrootcert" does not work
Previous Message Ed Hutchinson 2014-11-11 17:52:42 Re: Connection string parameter "sslrootcert" does not work