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