Re: ssl

From: "pg" <pg(at)newhonest(dot)com>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: ssl
Date: 2003-03-20 01:46:12
Message-ID: 00a201c2ee82$7d6dc420$2101a8c0@newhonest.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oh, my problem is My server doesn't even start, and there's no log about
this start failure. Screen dump as below :

============
[root(at)local init.d]# ./postgresql start
Starting postgresql service: [ FAILED ]
============

Does the postgresql contained in standard (from postgresql.org) compiled
with ssl enabled?

-Jason

----- Original Message -----
From: "Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: "pg" <pg(at)newhonest(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, March 19, 2003 4:51 PM
Subject: Re: [GENERAL] ssl

> 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
>

In response to

  • Re: ssl at 2003-03-19 08:51:41 from Nigel J. Andrews

Responses

  • Re: ssl at 2003-03-22 17:45:18 from Oliver Elphick

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-03-20 02:12:18 Re: MySQL at .NET conference
Previous Message Mike Castle 2003-03-20 01:06:00 FIPS 127-2