Re: OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql - Mailing list pgsql-general

From Dan Davis
Subject Re: OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql
Date
Msg-id CAFzonYbDVmtznsuepvOepLiKPDsYhw5E9QVL354ftYohCjKZ3w@mail.gmail.com
Whole thread Raw
In response to OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql  (cecile rougnaux <cecile_rougnaux@hotmail.com>)
List pgsql-general
The reason that openssl is not linked is that MacOS already has LibreSSL. It would be good to build PostgreSQL with LibreSSL on OS X, as LibreSSL is really more secure, but then again, PostgreSQL on OS X should be only for development purposes.  You may have heard about the heartbleed attack - LibreSSL is a fork of OpenSSL with older ciphers removed.

One thing you can do is to place openssl in your  LD_LIBRARY_PATH and DYLD_LIBRARY_PATH:

export LD_LIBRARY_PATH=/usr/local/opt/openssl@3/lib
export DYLD_LIBRARY_PATH=/usr/local/opt/openssl@3/lib

If you need it beyond Terminal, then this should force it:

brew link openssl

On Tue, Apr 12, 2022 at 6:34 AM cecile rougnaux <cecile_rougnaux@hotmail.com> wrote:
My system is OS Mojave 10.14.6, I got homebrew from this command :


when I try to install postgresql with the command 
brew install postgresql

I have this error:

    Error: An exception occurred within a child process:
      RuntimeError: /usr/local/opt/openssl@1.1 not present or broken
    Please reinstall openssl@1.1. Sorry :(

When I try to install openssl@1.1 I have this message:

    brew install openssl@1.1
    Running `brew update --preinstall`...
    ==> Auto-updated Homebrew!
    Updated 1 tap (homebrew/cask).
    ==> Updated Casks
    Updated 8 casks.
   
    Warning: openssl@1.1 1.1.1n is already installed, it's just not linked.
    To link this version, run:
      brew link openssl@1.1
    ➜  / brew link openssl@1.1
    Warning: Refusing to link macOS provided/shadowed software: openssl@1.1
    If you need to have openssl@1.1 first in your PATH, run:
      echo 'export PATH="/usr/local/opt/openssl@1.1/bin:$PATH"' >> ~/.zshrc
   
    For compilers to find openssl@1.1 you may need to set:
      export LDFLAGS="-L/usr/local/opt/openssl@1.1/lib"
      export CPPFLAGS="-I/usr/local/opt/openssl@1.1/include"
   
    For pkg-config to find openssl@1.1 you may need to set:
      export PKG_CONFIG_PATH="/usr/local/opt/openssl@1.1/lib/pkgconfig"

And then when I try to force hombrew link openssl, I get this message

    Warning: Refusing to link macOS provided/shadowed software: openssl@1.1
    If you need to have openssl@1.1 first in your PATH, run:
      echo 'export PATH="/usr/local/opt/openssl@1.1/bin:$PATH"' >> ~/.zshrc
   
    For compilers to find openssl@1.1 you may need to set:
      export LDFLAGS="-L/usr/local/opt/openssl@1.1/lib"
      export CPPFLAGS="-I/usr/local/opt/openssl@1.1/include"
   
    For pkg-config to find openssl@1.1 you may need to set:
      export PKG_CONFIG_PATH="/usr/local/opt/openssl@1.1/lib/pkgconfig"

I added the lines to .zshrc file as suggested:

    export PATH="/usr/local/opt/openssl@1.1/bin:$PATH"
    export LDFLAGS="-L/usr/local/opt/openssl@1.1/lib"
    export CPPFLAGS="-I/usr/local/opt/openssl@1.1/include"
    export PKG_CONFIG_PATH="/usr/local/opt/openssl@1.1/lib/pkgconfig"

But I kept on having the message when retrying to intall postgresql

    Error: An exception occurred within a child process:
      RuntimeError: /usr/local/opt/openssl@1.1 not present or broken

I also tried this command:

    brew reinstall openssl

openssl@3 is installed and I get this message:

    openssl@3 is keg-only, which means it was not symlinked into /usr/local,
    because macOS provides LibreSSL.
and then when I try to

    brew install postgresql

I have the same error:
Error: An exception occurred within a child process:
 RuntimeError: /usr/local/opt/openssl@1.1 not present or broken
Please reinstall openssl@1.1.

and The pg version in my rails gemfile is
gem "pg", "1.3.5"
but I just tried brew install pg,
and bundle install fails also.
If anyone could help, I am totally stuck here, thanks!
Cécile


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql
Next
From: Adrian Klaver
Date:
Subject: Re: OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql