X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 017D95299C for ; Mon, 8 Aug 2005 12:41:38 -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 97430-01 for ; Mon, 8 Aug 2005 15:41:30 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.193]) by svr1.postgresql.org (Postfix) with ESMTP id 7993052967 for ; Mon, 8 Aug 2005 12:41:24 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 4so28520nzn for ; Mon, 08 Aug 2005 08:41:24 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=q4iLc9UNk52k0PBsLv0eq9WWD9JhMhZEiZZuct/N4PIFMvILCw/Q082WNvTZsJlb9VMVWymHHa4r/QhnDl4rDMKv5RFeayeL5C3HkmidSfH49/UUPJX8kwKiyiKyOmFKoPJlbJLh9AFJD1f+6JDhZrtYDxgqRak1Svs/9cG7PrE= Received: by 10.36.222.17 with SMTP id u17mr133869nzg; Mon, 08 Aug 2005 08:41:24 -0700 (PDT) Received: by 10.36.60.19 with HTTP; Mon, 8 Aug 2005 08:41:24 -0700 (PDT) Message-ID: Date: Mon, 8 Aug 2005 11:41:24 -0400 From: Mario Soto Cordones - Venezuela To: alvherre@alvh.no-ip.org, pgsql-admin@postgresql.org Subject: Re: [GENERAL] postgresql Secure Mode In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20050808135640.GB26568@alvh.no-ip.org> <20050808143851.GA26979@alvh.no-ip.org> <20050808151811.GA28073@alvh.no-ip.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.22 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200508/85 X-Sequence-Number: 18404 LOG Say: LOG: conexi=C3=B3n recibida: host=3D192.168.0.100 port=3D1175 FATAL: no hay una l=C3=ADnea en pg_hba.conf para =C2=AB192.168.0.100=C2=BB= , usuario =C2=ABvasa=C2=BB, base de datos =C2=ABvasa=C2=BB, SSL inactivo LOG: conexi=C3=B3n recibida: host=3D192.168.0.100 port=3D1226 FATAL: no hay una l=C3=ADnea en pg_hba.conf para =C2=AB192.168.0.100=C2=BB= , usuario =C2=ABvasa=C2=BB, base de datos =C2=ABvasa=C2=BB, SSL inactiv but SSl its active select * from pg_settings where name =3D 'ssl'=20 ssl =09on =09Connections and Authentication / Security and Authentication =09Enables SSL connections. =09postmaster =09bool =09configuration file =09 thank you 2005/8/8, Mario Soto Cordones - Venezuela : > Hola Alvaro no po lostee en espanol porque pense que este problema > correspondia a la lista de admin, o me equivoco >=20 > Saludos >=20 >=20 > 2005/8/8, Alvaro Herrera : > > On Mon, Aug 08, 2005 at 11:06:22AM -0400, Mario Soto Cordones - Venezue= la wrote: > > > 2005/8/8, Alvaro Herrera : > > > > On Mon, Aug 08, 2005 at 10:24:54AM -0400, Mario Soto Cordones - Ven= ezuela wrote: > > > > > > > but when I try to connect myself for example from an application = EMS > > > > > postgresql manager by means of SSL, says that it cannot authenti= cate > > > > > in user > > > > > > > > Ok, so do you have the user created in Postgres by means of CREATE = USER > > > > or createuser? Try changing the password. Also, please show us th= e > > > > relevant extract of the server log file. > > > > > > yes expample the user is vasa > > > > > > the log say > > > > > > LOG: no se pudo cargar el archivo del certificado raiz > > > /var/lib/pgsql/data/bd/root.crt > > > DETALLE: Los certificados de clientes no se verificaran > > > > This isn't the problem. Here it's only telling you that were the clien= t > > to hand a certificate, they wouldn't be checked. There must be other > > message. > > > > > but I don't understand because it leaves that message > > > > It's because you don't have the root.crt file, or the file doesn't have > > the proper permissions. > > > > > > I don't understand why didn't you post this problem to pgsql-es-ayuda > > first ... > > > > -- > > Alvaro Herrera () > > Y dijo Dios: "Que sea Satan=E1s, para que la gente no me culpe de todo = a m=ED." > > "Y que hayan abogados, para que la gente no culpe de todo a Satan=E1s" > > >=20 >=20 > -- > cordialmente, >=20 > Ing. Mario Soto Cordones >=20 --=20 cordialmente, Ing. Mario Soto Cordones