Re: ssl

On Wed, 19 Mar 2003, Tom Lane wrote:

> "Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> > 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
>
> I believe it would act that way if the incoming connection is non-SSL
> (which suggests that your libpq isn't compiled with SSL support).

Interesting you should say that because I know remember what happened, slap me
with a wet fish later for the noise.

I'm convinced I rebuilt on the workstation in order to get a libpq with ssl. I
am equally convinced I tested it and it worked. Then a couple of days later
trying to get the developers using Windows to be able to connect I looked at it
again and I found my psql was no longer linked against the ssl library. Was
very wierd.

However, I never was able to get the developers connected. I may need to
revisit that later.

Sorry for the noise, my memory is going.

--
Nigel Andrews