pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Stephan <rstepha1@nycap.rr.com>
To: pgsql-admin@postgresql.org
Subject: SSL Connections from Windows Clients
Date: Tue, 03 Mar 2009 20:33:01 -0500
Message-ID: <49ADDA4D.5020700@nycap.rr.com> (raw)

I am having a problem getting the Windows client to work with my Solaris 
database using SSL connections.

In the postgresql\8.3\bin directory there are the libpq.dll 
andssleay32.dll libraries. I am fairly certain by the tests I have 
conducted that the client is trying to use SSL but the error in the 
server log is "could not accept SSL connection: cipher or hash unavailable"

What do I need to do on the server to get the client to use a valid cipher?

My psql client on the Solaris box using localhost as my connection works 
with:
Cipher: EDH-RSA-DES-CBC3-SHA, bits: 168

And my Java clients connect successfully as well.

http://www.postgresql.org/docs/8.3/static/ssl-tcp.html
http://www.postgresql.org/docs/8.3/stat ... q-ssl.html 
<http://www.postgresql.org/docs/8.3/static/libpq-ssl.html;
http://jdbc.postgresql.org/documentatio ... lient.html 
<http://jdbc.postgresql.org/documentation/83/ssl-client.html;

Message-ID: <49ADDA4D.5020700@nycap.rr.com>
Permalink:  ../49ADDA4D.5020700@nycap.rr.com/
Also on:    postgresql.org/message-id/49ADDA4D.5020700@nycap.rr.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: rstepha1@nycap.rr.com
  Subject: Re: SSL Connections from Windows Clients
  In-Reply-To: <49ADDA4D.5020700@nycap.rr.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox