Thread: Re: Steps to enable SSL Enable

Re: Steps to enable SSL Enable

From
Daulat
Date:
Thanks Tom,
If I do the "openssl version" , it looks like it is already installed. 

$ openssl version
OpenSSL 1.0.2k-fips  26 Jan 2017



On Tue, Dec 21, 2021 at 9:14 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Daulat <daulat.dba@gmail.com> writes:
> I am getting error "waiting for server to start....2021-12-21 15:40:17.076
> UTC [5040] LOG:  SSL is not supported by this build"

In that case you need to recompile with --with-openssl.

                        regards, tom lane

Re: Steps to enable SSL Enable

From
Bruce Momjian
Date:
On Mon, Mar  7, 2022 at 03:55:41PM +0530, Daulat wrote:
> Thanks Tom,
> If I do the "openssl version" , it looks like it is already installed. 
> 
> $ openssl version
> OpenSSL 1.0.2k-fips  26 Jan 2017

Uh, that means you have OpenSSL installed on the server, not that
Postgres is built to support SSL.

---------------------------------------------------------------------------

> 
> 
> 
> On Tue, Dec 21, 2021 at 9:14 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
>     Daulat <daulat.dba@gmail.com> writes:
>     > I am getting error "waiting for server to start....2021-12-21
>     15:40:17.076
>     > UTC [5040] LOG:  SSL is not supported by this build"
> 
>     In that case you need to recompile with --with-openssl.
> 
>                             regards, tom lane
> 

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.




Re: Steps to enable SSL Enable

From
Daulat
Date:
Ok, thanks. Then what is the solution please.

On Mon, Mar 7, 2022 at 8:22 PM Bruce Momjian <bruce@momjian.us> wrote:
On Mon, Mar  7, 2022 at 03:55:41PM +0530, Daulat wrote:
> Thanks Tom,
> If I do the "openssl version" , it looks like it is already installed. 
>
> $ openssl version
> OpenSSL 1.0.2k-fips  26 Jan 2017

Uh, that means you have OpenSSL installed on the server, not that
Postgres is built to support SSL.

---------------------------------------------------------------------------

>
>
>
> On Tue, Dec 21, 2021 at 9:14 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>     Daulat <daulat.dba@gmail.com> writes:
>     > I am getting error "waiting for server to start....2021-12-21
>     15:40:17.076
>     > UTC [5040] LOG:  SSL is not supported by this build"
>
>     In that case you need to recompile with --with-openssl.
>
>                             regards, tom lane
>

--
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.

Re: Steps to enable SSL Enable

From
Ganesh Korde
Date:
Compile PostgreSQL source with openssl option.

Regards,
Ganesh Korde.

On Mon, 7 Mar 2022, 11:52 pm Daulat, <daulat.dba@gmail.com> wrote:
Ok, thanks. Then what is the solution please.

On Mon, Mar 7, 2022 at 8:22 PM Bruce Momjian <bruce@momjian.us> wrote:
On Mon, Mar  7, 2022 at 03:55:41PM +0530, Daulat wrote:
> Thanks Tom,
> If I do the "openssl version" , it looks like it is already installed. 
>
> $ openssl version
> OpenSSL 1.0.2k-fips  26 Jan 2017

Uh, that means you have OpenSSL installed on the server, not that
Postgres is built to support SSL.

---------------------------------------------------------------------------

>
>
>
> On Tue, Dec 21, 2021 at 9:14 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>     Daulat <daulat.dba@gmail.com> writes:
>     > I am getting error "waiting for server to start....2021-12-21
>     15:40:17.076
>     > UTC [5040] LOG:  SSL is not supported by this build"
>
>     In that case you need to recompile with --with-openssl.
>
>                             regards, tom lane
>

--
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.

Re: Steps to enable SSL Enable

From
Daulat
Date:
Hi Ganesh,

I have tried to compile it but no success. 

sudo ./configure --prefix= /opt/PostgreSQL-10/bin --with-openssl --with-includes=/opt/PostgreSQL-10/include/openssl --with-libraries=/opt/PostgreSQL-10/lib

Could you please suggest how we can achieve it.

On Wed, Mar 9, 2022 at 1:11 PM Ganesh Korde <ganeshakorde@gmail.com> wrote:
Compile PostgreSQL source with openssl option.

Regards,
Ganesh Korde.

On Mon, 7 Mar 2022, 11:52 pm Daulat, <daulat.dba@gmail.com> wrote:
Ok, thanks. Then what is the solution please.

On Mon, Mar 7, 2022 at 8:22 PM Bruce Momjian <bruce@momjian.us> wrote:
On Mon, Mar  7, 2022 at 03:55:41PM +0530, Daulat wrote:
> Thanks Tom,
> If I do the "openssl version" , it looks like it is already installed. 
>
> $ openssl version
> OpenSSL 1.0.2k-fips  26 Jan 2017

Uh, that means you have OpenSSL installed on the server, not that
Postgres is built to support SSL.

---------------------------------------------------------------------------

>
>
>
> On Tue, Dec 21, 2021 at 9:14 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>     Daulat <daulat.dba@gmail.com> writes:
>     > I am getting error "waiting for server to start....2021-12-21
>     15:40:17.076
>     > UTC [5040] LOG:  SSL is not supported by this build"
>
>     In that case you need to recompile with --with-openssl.
>
>                             regards, tom lane
>

--
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.