Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id EF473650138
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed, 29 Oct 2008 14:13:16 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 44358-09 for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed, 29 Oct 2008 14:13:12 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by postgresql.org (Postfix) with ESMTP id 7B6DA650123
	for <pgsql-admin@postgresql.org>; Wed, 29 Oct 2008 14:13:11 -0300 (ADT)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Wed, 29 Oct 2008 12:13:09 -0500
Message-Id: <49085346.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.3 
Date: Wed, 29 Oct 2008 12:12:54 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Peter Koczan" <pjkoczan@gmail.com>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: SSL and md5 password?
References: <4544e0330810291007p5b68fba2o4ee782b4d4f92878@mail.gmail.com>
In-Reply-To: <4544e0330810291007p5b68fba2o4ee782b4d4f92878@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200810/171
X-Sequence-Number: 30627

>>> "Peter Koczan" <pjkoczan@gmail.com> wrote: 
> psql: FATAL:  no pg_hba.conf entry for host "128.105.162.36", user
> "test_md5", database "koczan_test", SSL off
 
> hostssl all         postgres    128.105.0.0/16     reject
> hostssl all         postgres    198.133.224.0/24   reject
> 
> # Testing out md5 users
> hostssl all         test_md5      128.105.0.0/16     md5
> hostssl all         test_md5      198.133.224.0/24   md5
 
I think it uses the first matching entry in pg_hba.conf.
What happens with the matching "reject" line?
 
-Kevin