Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0A23A9FC13B for ; Wed, 8 Aug 2007 12:33:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 68180-02 for ; Wed, 8 Aug 2007 12:32:59 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from bay0-omc3-s30.bay0.hotmail.com (bay0-omc3-s30.bay0.hotmail.com [65.54.246.230]) by postgresql.org (Postfix) with ESMTP id 807EC9FC169 for ; Wed, 8 Aug 2007 12:32:59 -0300 (ADT) Received: from hotmail.com ([65.54.250.22]) by bay0-omc3-s30.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 8 Aug 2007 08:32:58 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 8 Aug 2007 08:32:58 -0700 Message-ID: Received: from 65.54.250.200 by by115fd.bay115.hotmail.msn.com with HTTP; Wed, 08 Aug 2007 15:32:57 GMT X-Originating-IP: [201.147.232.179] X-Originating-Email: [fabrixio1@hotmail.com] X-Sender: fabrixio1@hotmail.com From: =?iso-8859-1?B?RmFicmljaW8gUGXxdWVsYXM=?= To: maps.on@gmx.net Cc: pgsql-admin@postgresql.org Subject: Re: ssl and odbc standar driver Date: Wed, 08 Aug 2007 15:32:57 +0000 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed X-OriginalArrivalTime: 08 Aug 2007 15:32:58.0338 (UTC) FILETIME=[65D7C420:01C7D9D1] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/75 X-Sequence-Number: 26406 I did this (16.7. Secure TCP/IP Connections with SSL) (postgresql documentation) i build postgresql with option --with-openssl then i created the certificate and put then into data dirtory openssl req -new -text -out server.req openssl rsa -in privkey.pem -out server.key rm privkey.pem openssl req -x509 -in server.req -text -key server.key -out server.crt chmod og-rwx server.key pg_hba.conf hostssl all all 0.0.0.0 0.0.0.0 md5 I can to conect from pg_admin and this say in properties page: Encryption SSL encrypted Now the problem is the client. i use this conecction string (http://www.connectionstrings.com/?carrier=postgresql) ODBC - PostgreSQL driver Standard Driver={PostgreSQL};Server=IP address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword; I can add SSL=true;SslMode=Require; to this string? I add the ssl option in the client but not function. The cliente say: FATAL: no pg_hba.conf entry for host "xx.xx.xx.xx", user "yyyyy", database "asdfasdf", SSL off I need to install something in the client? >The certificate has to be named postgresql.crt >and the key postgresql.key. this is for the client? sorry for my bad english... :) >From: Andreas >To: Fabricio Peñuelas >CC: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] ssl and odbc standar driver >Date: Wed, 08 Aug 2007 02:47:54 +0200 > > >In deed it is possible. >You'll need a ssl certificate and a private key and put it on c: in your >users ....\application data\postgresql directory. >You'll have to create the postgresql-directory first. > >The certificate has to be named postgresql.crt >and the key postgresql.key. > >Now you can chose ssl in your dsn-settings or set the parameter in your >connection string. > > > >Fabricio Peñuelas schrieb: >>It is possible to connect to postgres with odbc standar driver and ssl >>enabled ?? >>Es posible conectarme a postgresql con odbc standar driver y ssl activado? > > >---------------------------(end of broadcast)--------------------------- >TIP 6: explain analyze is your friend _________________________________________________________________ Live Search en Prodigy/MSN. Todo lo que buscas ahora más rapido http://live.com