pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andreas <maps.on@gmx.net>
To: Fabricio Peñuelas <fabrixio1@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: ssl and odbc standar driver
Date: Wed, 08 Aug 2007 20:00:34 +0200
Message-ID: <46BA04C2.8010701@gmx.net> (raw)
In-Reply-To: <BAY115-F12367FE951B79DCA0BF3D9FEE70@phx.gbl>
References: <BAY115-F12367FE951B79DCA0BF3D9FEE70@phx.gbl>

Fabricio Peñuelas schrieb:
> I need to install something in the client?
Well, you obviously need the ODBC driver on the client


>> The certificate has to be named    postgresql.crt
>> and the key   postgresql.key.
>
> this is for the client?
Yes. You need a key+cert pair for your client, too.
And it should not be the same as the server's   ;)
The hairy part is that the documentation does explain the creation of 
the SSL stuff for the server but it fails to tell how to get the 
credentials for the clients.

Every user who is supposed to connect from this client-pc needs to have 
at least those 2 files present in his/her "postgresql" folder. It needs 
to be created in the user's personal data subtree above   c:\documents 
and settings\username\application data
We are talking about Windows as client, are we?
I haven't tried this with a Linux client but there it should be the 
folder   /home/username/postgresql

You wrote that you could connect with pgAdmin.
pgAdmin needs the same two files with ssl-credentials so if this worked 
on your client, then there is something wrong with your connection string.
On the other hand since the server complains that you try to connect 
without ssl, I'd rather think there is something wrong with your 
ssl-credentials. I'd guess the driver cant find them.


> sorry for my bad english... :) 
no problem. It isn't my first language either.



view thread (5+ messages)  latest in thread

Message-ID: <46BA04C2.8010701@gmx.net>
Permalink:  ../46BA04C2.8010701@gmx.net/
Also on:    postgresql.org/message-id/46BA04C2.8010701@gmx.net

 · 

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: maps.on@gmx.net, fabrixio1@hotmail.com
  Subject: Re: ssl and odbc standar driver
  In-Reply-To: <46BA04C2.8010701@gmx.net>

* 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