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.klaver@aklaver.com]
Sent: Wednesday, September 17, 2014 11:40 AM
To: Keith Handlon; pgsql-odbc@postgresql.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.klaver@aklaver.com