Re: Postgesql and SSL - Mailing list pgsql-admin

From Thomas Pundt
Subject Re: Postgesql and SSL
Date
Msg-id 49AA845D.7040500@rp-online.de
Whole thread Raw
In response to Re: Postgesql and SSL  ("Lukas" <Lukas@fmf.vtu.lt>)
Responses Re: Postgesql and SSL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Lukas schrieb:
>  nope, no use of it.. Situation stays the same.. Does any one have more
> ideas?
[...]
>>>  I am trying to run PostgreSQL with SSL, so I compiled and
>>> linked with
>>> options:
>>>
>>> ./configure --prefix=/DB --with-openssl
>>>
>>> Configured and installed successfully.
>>> In postgresql.conf I have option "ssl = on"
>>> When starting Postgres I get error:
>>> LOG:  SSL is not supported by this build
>>> FATAL:  invalid value for parameter "ssl": 1
>>> DEBUG:  proc_exit(1)
>>> DEBUG:  shmem_exit(1)
>>> DEBUG:  exit(1)
>>>
>>> Where is the problem? Is here versions which does not
>>> support SSL, it
>>> would be strange..
>>>
>>> Versions used:
>>> PostgreSQL 8.3.4
>>> OpenSSL 0.9.8j


well, probably; in a situation like this I'd first check for any errors
from the configure step. Did it by any chance complain about not
finding the SSL library?

Next thing to check: is the postmaster linked against the SSL library?
   cd /your/postgres/install/path/bin
   ldd postgres|grep ssl

should output something like
   libssl.so.0.9.7 => /usr/lib64/libssl.so.0.9.7 (0x0000002a95775000)

if not, SSL is likely not compiled in; go back to checking the
configure part.

If you have positively confirmed, that SSL support is compiled in,
you likely simply don't use your newly built postgres. Check paths
and start scripts and make sure, it uses your new built binaries.

If that's not it, I think you have to provide more information about
your platform.

Ciao,
Thomas

pgsql-admin by date:

Previous
From: Glyn Astill
Date:
Subject: Re: Postgesql and SSL
Next
From: "Bryan Keith"
Date:
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade