Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 8C12A9FB67F for ; Wed, 8 Aug 2007 15:00:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 12839-02-4 for ; Wed, 8 Aug 2007 15:00:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 146589FBA21 for ; Wed, 8 Aug 2007 15:00:36 -0300 (ADT) Received: (qmail invoked by alias); 08 Aug 2007 18:00:34 -0000 Received: from i3ED6CCCD.versanet.de (EHLO [192.168.0.112]) [62.214.204.205] by mail.gmx.net (mp045) with SMTP; 08 Aug 2007 20:00:34 +0200 X-Authenticated: #14269776 X-Provags-ID: V01U2FsdGVkX1/BIj8rCf3Blggq7v0CYjKISKX4VFe0RzThjnN6W0 eyRIWz58j4jSA8 Message-ID: <46BA04C2.8010701@gmx.net> Date: Wed, 08 Aug 2007 20:00:34 +0200 From: Andreas User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8.1.6) Gecko/20070802 SeaMonkey/1.1.4 MIME-Version: 1.0 To: =?ISO-8859-1?Q?Fabricio_Pe=F1uelas?= CC: pgsql-admin@postgresql.org Subject: Re: ssl and odbc standar driver References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/82 X-Sequence-Number: 26413 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.