Re: enable SSL on server

Hello!

Please tell - how to enable SSL on PostgreSQL 8.1 server. When
setting option "ssl = on" in postgresql.conf - server even doesn't want
to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from
.msi, downloaded from www.posgtresql.org.

Best regards,

Kovalevski Andrei,
soft(at)andrei(dot)in(dot)ua

Андрей wrote:
> Hello!
>
> Please tell - how to enable SSL on PostgreSQL 8.1 server. When
> setting option "ssl = on" in postgresql.conf - server even doesn't want
> to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from
> .msi, downloaded from www.posgtresql.org.

If the server isn't starting up, it will say why in the logs.

What does it say in the logs?

--
Richard Huxton
Archonet Ltd

Richard Huxton wrote:

> Andrei wrote:
>
>> Hello!
>>
>> Please tell - how to enable SSL on PostgreSQL 8.1 server. When
>> setting option "ssl = on" in postgresql.conf - server even doesn't
>> want to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed
>> from .msi, downloaded from www.posgtresql.org.
>
>
> If the server isn't starting up, it will say why in the logs.
>
> What does it say in the logs?

No logs appear, just got MessageBox with 'PostgreSQL Tray' - 'Service
command failed'. :(

Best Regards,

Kovalevski Andrei

Андрей wrote:
> Richard Huxton wrote:
>
>> Andrei wrote:
>>
>>> Hello!
>>>
>>> Please tell - how to enable SSL on PostgreSQL 8.1 server. When
>>> setting option "ssl = on" in postgresql.conf - server even doesn't
>>> want to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed
>>> from .msi, downloaded from www.posgtresql.org.
>>
>>
>> If the server isn't starting up, it will say why in the logs.
>>
>> What does it say in the logs?
>
> No logs appear, just got MessageBox with 'PostgreSQL Tray' - 'Service
> command failed'. :(

It seems unlikely that *nothing* is being logged - PG is usually good at
that. Check your logging configuration settings, and see what you get
with ssl = false, then try again with ssl = true.

If you genuinely have nothing being logged, the failure must be very
early in the startup sequence. Try starting it from a command-prompt -
you should see an error message then.

--
Richard Huxton
Archonet Ltd

=?UTF-8?B?0JDQvdC00YDQtdC5?= <andyk(at)softwarium(dot)net> writes:
> Please tell - how to enable SSL on PostgreSQL 8.1 server. When
> setting option "ssl = on" in postgresql.conf - server even doesn't want
> to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from
> .msi, downloaded from www.posgtresql.org.

Did you set up the key and certificate files required by an SSL server?
See the documentation:
http://www.postgresql.org/docs/8.1/static/ssl-tcp.html

regards, tom lane

******************************************************************
* Do not Cc: me, because I am on THIS list, if I write here *
* Keine Cc: am mich, bin auf DIESER Liste wenn ich hier schreibe *
******************************************************************

Hello,

are the certificates on teh right place?
If not, pgsql will not show any errors about it.
I think, this should be done in the default loglevel.

I had the same problem some weeks ago.

Greetings
Michelle

Am 2005-12-15 14:03:15, schrieb ????????????:
> Hello!
>
> Please tell - how to enable SSL on PostgreSQL 8.1 server. When
> setting option "ssl = on" in postgresql.conf - server even doesn't want
> to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from
> .msi, downloaded from www.posgtresql.org.
>
> Best regards,
>
> Kovalevski Andrei,
> soft(at)andrei(dot)in(dot)ua
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
------------------------- END OF REPLYED MESSAGE -------------------------

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)