Re: solaris and openssl

On 09/17/2014 08:09 AM, Keith Handlon wrote:
> I’m trying to get the 9.03.0300 odbc driver to work with ssl on
> solaris.  I get it to build fine.  But as soon as I add the sslmode
> connection option I’m getting rejected on the client end with the
> generic error.  I don’t see anything in the server logs (log_connections
> is turned on).
>
> could not connect to server:
>
> No such file or directory        Is the server running on host "<hostname>"
>
>         (<ip_address>) and accepting       TCP/IP connections on port 5432?

Is your server running on port 5432?

>
> I know the server is up and running and accepting ssl connections
> because I can connect to it from windows and linux both with and without
> ssl.  And the connection works fine without the sslmode option from solaris.

What is the sslmode you are using?

What are your pg_hba.conf settings that cover the solaris client?

>
> ldd doesn’t report any missing shared objects.  Nor does truss, though
> it appears from the truss log it may be searching the odbcinst for
> something.  I can’t seem to locate any unixodbc or postgresql doc that
> indicates any ssl odbcinst settings.
>
> Any ideas?
>


--
Adrian Klaver
adrian.klaver@aklaver.com