Re: ssl - Mailing list pgsql-general

From Nigel J. Andrews
Subject Re: ssl
Date
Msg-id Pine.LNX.4.21.0303190845020.10824-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to ssl  ("pg" <pg@newhonest.com>)
Responses Re: ssl  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: ssl  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
On Wed, 19 Mar 2003, pg wrote:

> I'm using redhat 8.0 and postgresql 7.2.4 (rpm from postgresql.org). I want
> to enable ssl.
>
> I have edited postgresql.conf to ssl = true. I also follow the 7.3 manual
> (from postgresql.org) to create certificates and placed them in
> /var/lib/pgsql/data/. Then restart the server with /etc/init.d/postgresql
> restart. The result is [Failed]. What else should I do? Or procedure for 7.3
> is different from 7.2.4? Or the rpm does not have ssl enabled when compile?

How does it fail? Just with a '[Failed]' message in the logs?

I must say my non rpm installation doesn't seem to pick up the hostssl line in
pg_hba. Or at least it doesn't match it when a connection comes in. I didn't
get very far into looking into that so it's probably something I'm doing wrong.

FWIW, my pg_hba entry is:

hostssl    all        all      xx.xx.xx.xx     255.255.255.240     md5

and the error I get is:

 FATAL:  No pg_hba.conf entry for host xx.xx.xx.xx, user vtc, database vtc


--
Nigel J. Andrews


pgsql-general by date:

Previous
From: Joel Rees
Date:
Subject: Re: access primitives in php
Next
From: Bruno Wolff III
Date:
Subject: Re: Division of intervals.