Re: solaris and openssl

Yes, it's a remote client. The server is running on a linux machine.

Example connection string:
DRIVER=PostgreSQL;SERVER=<hostname>;UID=<user>;PWD=<password>;DATABASE=postgres;PORT=5432;SSLMODE=allow

-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Sent: Wednesday, September 17, 2014 11:40 AM
To: Keith Handlon; pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] solaris and openssl

On 09/17/2014 08:27 AM, Keith Handlon wrote:
> Yes, the server is running on port 5432.

Not sure that it matters, but what machine is the server running on?

In other words is solaris a remote client?

>
> The server is setup using self-signed certificate. Any option for sslmode but disabled returns that error. Allow, prefer, require, etc...
>
> The servers hba_pg.conf is set up like so:
>
> # "local" is for Unix domain socket connections only
> local all all md5
> # IPv4 local connections:
> host all all 127.0.0.1/32 md5
> # IPv6 local connections:
> #host all all ::1/128 md5
> # Allow replication connections from localhost, by a user with the #
> replication privilege.
> #local replication dbmsowner md5
> #host replication dbmsowner 127.0.0.1/32 md5
> #host replication dbmsowner ::1/128 md5
> #
> host all all all md5
> hostssl all all ::1/128 trust
>

Not seeing anything obvious.
What is the rest of your connection string?
>
>

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