X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 12CFA52988 for ; Mon, 8 Aug 2005 09:44:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18502-10 for ; Mon, 8 Aug 2005 12:44:42 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.199]) by svr1.postgresql.org (Postfix) with ESMTP id 55D8052904 for ; Mon, 8 Aug 2005 09:44:41 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so563559nzo for ; Mon, 08 Aug 2005 05:44:44 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=lnPKZjuqSh8UgHUho6de8Yjvze+3pYRnaEeyeQUM/70e8hjxjXXCVQhUgwy97UEuO7c7/xUIr9wT1WNmuFtugmhvhRz8gflEh8vg/kbUKnabSXXo0AKxAb4kCFxubU0nqfJ6cIGVQayIt0DB/3tOvYjD8wJcrhGH9SQPbVGbbnc= Received: by 10.36.222.25 with SMTP id u25mr1630760nzg; Mon, 08 Aug 2005 05:44:44 -0700 (PDT) Received: by 10.36.60.20 with HTTP; Mon, 8 Aug 2005 05:44:44 -0700 (PDT) Message-ID: Date: Mon, 8 Aug 2005 08:44:44 -0400 From: Mario Soto Cordones - Venezuela To: Christopher Browne Subject: Re: postgresql Secure Mode Cc: pgsql-general@postgresql.org In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.241 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200508/370 X-Sequence-Number: 81778 Hi ,=20 not in fact I don't have a password file, I wanted to use autentificacion PAM, I have attempted it but I have not gotten it, on the other hand I don't understand that of the passwords file. =20 Greetings and thank you Mario Soto=20 2005/8/7, Christopher Browne : > > Hi, > > > > i have a probem,. > > > > I am trying to configure postgresql in sure way, I have made the > > following thing: > > > > 1. - I have created the certificate and put this in the directory it da= ta > > 2. - given him privileges to the user postgresql for the certificate > > 3. - in the file postgresql.conf, modify the parameters ssl =3D true to > > use md5 =3D true > > 4. - in the file pg_hba.conf adds one it lines this way hostssl all > > all 192.168.0.0/255.255.255.0 md5 > > 5. - stsrt postresql > > > > But when trying to connect me says that the user cannot authenticate > > > > some idea >=20 > Hmm. Are you certain you had the password for the user stored > somewhere? >=20 > e.g... >=20 > 1. Stored in the file $HOME/.pgpass? > 2. Stored in some relevant environment variable ($PGPASS)? > 3. Included into the DSN (e.g. - 'dbname=3Dthis password=3Dsomething') >=20 > Having the cert doesn't automatically authenticate anything... > -- > let name=3D"cbbrowne" and tld=3D"acm.org" in String.concat "@" [name;tld]= ;; > http://cbbrowne.com/info/rdbms.html > Rules of the Evil Overlord #153. "My Legions of Terror will be an > equal-opportunity employer. Conversely, when it is prophesied that no > man can defeat me, I will keep in mind the increasing number of > non-traditional gender roles." >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >=20 --=20 cordialmente, Ing. Mario Soto Cordones