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 B5E2152988 for ; Mon, 8 Aug 2005 14:03:13 -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 15373-05 for ; Mon, 8 Aug 2005 17:03:05 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.201]) by svr1.postgresql.org (Postfix) with ESMTP id 1CD9352904 for ; Mon, 8 Aug 2005 14:03:03 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id n29so35459nzf for ; Mon, 08 Aug 2005 10:03:03 -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=qu16+qDrtjW7WuiHYoHZ9rBiJtuvqNxFXTs8q3W1zbWffX2MNGH9RdJFIYHchWeJ29GT9lqr82MzMgzlxuceOLzz4FTohH1qjQ7yrr2B/oQ7x2CE6ubPEcj03pt8NZKtHHQAdcaiPr7wAwVCZoOM7zSR7LsXTknnyeNze0qP0yY= Received: by 10.37.15.71 with SMTP id s71mr197721nzi; Mon, 08 Aug 2005 10:03:03 -0700 (PDT) Received: by 10.36.60.19 with HTTP; Mon, 8 Aug 2005 10:03:03 -0700 (PDT) Message-ID: Date: Mon, 8 Aug 2005 13:03:03 -0400 From: Mario Soto Cordones - Venezuela To: pgsql-admin@postgresql.org, Alvaro Herrera Subject: Re: [GENERAL] postgresql Secure Mode In-Reply-To: <20050808164024.GC2177@alvh.no-ip.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20050808143851.GA26979@alvh.no-ip.org> <20050808151811.GA28073@alvh.no-ip.org> <20050808160844.GA2177@alvh.no-ip.org> <20050808164024.GC2177@alvh.no-ip.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.215 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200508/90 X-Sequence-Number: 18409 2005/8/8, Alvaro Herrera : > On Mon, Aug 08, 2005 at 12:24:14PM -0400, Mario Soto Cordones - Venezuela= wrote: > > 2005/8/8, Alvaro Herrera : > > > On Mon, Aug 08, 2005 at 11:41:24AM -0400, Mario Soto Cordones - Venez= uela wrote: > > > > 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.1= 00=C2=BB, > > > > usuario =C2=ABvasa=C2=BB, base de datos =C2=ABvasa=C2=BB, SSL inact= ivo > > > > 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.1= 00=C2=BB, > > > > usuario =C2=ABvasa=C2=BB, base de datos =C2=ABvasa=C2=BB, SSL inact= iv > > > > > > > > but SSl its active > > > > > > Yeah, the server thinks it's active, but the client doesn't know it. > > > Did you try connecting with psql? Maybe your EMS client does not > > > support SSL (it'd surprise me.) > > > > Yes EMS suport this but say unable to autenticate user >=20 > Maybe you have to enable it explicitly? Maybe it's not supported in the > free (lite) version? Again, did you try with psql? >=20 the EMS it's professional edition licenced from the server I connect with psql and makes it bash-3.00$ psql -U vasa -h 192.168.0.2 vasa Contrase=C3=B1a: Bienvenido a psql 8.0.3, el terminal interactivo de PostgreSQL. Digite: \copyright para ver los t=C3(c)rminos de distribuci=C3=B3n \h para obtener ayuda sobre comandos SQL \? para obtener ayuda sobre comandos internos \g o punto y coma (;) para ejecutar consulta \q para salir conexi=C3=B3n SSL (cifrado: DHE-RSA-AES256-SHA, bits: 256) this is correct but I am working direct in the server, not from an application client like visual basic for example. > -- > Alvaro Herrera () > "La felicidad no es ma=F1ana. La felicidad es ahora" >=20 --=20 cordialmente, Ing. Mario Soto Cordones