Re: PG12.2 Configure cannot enalble SSL

On 14 May 2020, at 23:26, Tom Lane wrote:

> "Gavan Schneider" <gavan-pg-list(at)pendari(dot)net> writes:
>> -bash-3.2$ ./configure --with-openssl \
>> > --with-includes=/usr/local/opt/openssl/include/openssl \
>> > --with-libraries=/usr/local/opt/openssl/lib
>> ...
>> checking openssl/ssl.h usability... no
>> checking openssl/ssl.h presence... no
>> checking for openssl/ssl.h... no
>> configure: error: header file <openssl/ssl.h> is required for
>> OpenSSL
>
> Offhand, I'll guess that you need to shorten the --with-includes
> path to
>
> --with-includes=/usr/local/opt/openssl/include
>
> What you are showing here would only work if the header file's full
> path
> is
>
> /usr/local/opt/openssl/include/openssl/openssl/ssl.h
>
> which doesn't seem likely.
>
My bad. I made an error in cobbling together a reduced example which
achieved the same error for the wrong reasons.
I’ll share the larger version but the problem remains. It does not
seem to be as simple as a bad path.

-bash-3.2$
-bash-3.2$ ./_Build_PostgeSQL.sh > build.log 2>&1
-bash-3.2$ ls -las
/usr/local/Cellar/openssl(at)1(dot)1/1.1.1g/include/openssl/ssl.h
224 -rw-r--r-- 1 pendari staff 111253 21 Apr 22:22
/usr/local/Cellar/openssl(at)1(dot)1/1.1.1g/include/openssl/ssl.h
-bash-3.2$

Where _Build_PostgeSQL.sh looks like:

echo ===================================================
echo ================= `date "+%Y-%m-%d %H:%M"` ================
echo ===================================================

PORT=65432

##### Working Base
BASE="/usr/local/pgsql/v12"

##### Define basic tools == Homebrew versions (updated on a regular
basis)
MAKE="/usr/local/bin/gmake"
CC="/usr/bin/gcc" # alternate? "/usr/local/bin/gcc-9"

LIBS=""
HDRS=""
##### OPENSSL
LIBS=${LIBS}:"/usr/local/Cellar/openssl(at)1(dot)1/1.1.1g/lib"
HDRS=${HDRS}:"/usr/local/Cellar/openssl(at)1(dot)1/1.1.1g/include"
#LIBS=${LIBS}:"/usr/local/Cellar/libressl/3.1.1/lib"
#HDRS=${HDRS}:"/usr/local/Cellar/libressl/3.1.1/include"
##### OPENLDAP
LIBS=${LIBS}:"/usr/local/opt/openldap/lib"
HDRS=${HDRS}:"/usr/local/opt/openldap/include"
##### GENERIC
LIBS=${LIBS}:"/usr/local/lib:/Library/Developer/CommandLineTools/usr/lib"
HDRS=${HDRS}:"/usr/local/include:/Library/Developer/CommandLineTools/usr/include"

cd postgresql-12.2

./configure \
CC=${CC} \
--with-includes=${HRDS} \
--with-libraries=${LIBS} \
--prefix=${BASE} \
--with-pgport=${PORT} \
--with-python \
--with-libxml --with-libxslt \
--with-wal-blocksize=8 \
--with-system-tzdata=/usr/share/zoneinfo \
--with-pam \
--with-ldap \
--with-uuid=e2fs \
--with-bonjour \
--with-openssl \

echo ===================================================
echo ===================================================
echo --with-includes =${HDRS}
echo --with-libraries=${LIBS}
echo CC is: $CC
echo MAKE is: $MAKE
echo ===================================================
echo ===================================================

exit ####DEBUG

and generated

===================================================
================= 2020-05-15 21:43 ================
===================================================
checking build system type... x86_64-apple-darwin19.4.0
checking host system type... x86_64-apple-darwin19.4.0
. . .
checking zlib.h usability... yes
checking zlib.h presence... yes
checking for zlib.h... yes
checking openssl/ssl.h usability... no
checking openssl/ssl.h presence... no
checking for openssl/ssl.h... no
configure: error: header file <openssl/ssl.h> is required for OpenSSL
===================================================
===================================================
--with-includes
=:/usr/local/Cellar/openssl(at)1(dot)1/1.1.1g/include:/usr/local/opt/openldap/include:/usr/local/include:/Library/Developer/CommandLineTools/usr/include
--with-libraries=:/usr/local/Cellar/openssl(at)1(dot)1/1.1.1g/lib:/usr/local/opt/openldap/lib:/usr/local/lib:/Library/Developer/CommandLineTools/usr/lib
CC is: /usr/bin/gcc
MAKE is: /usr/local/bin/gmake
===================================================
===================================================

so, once again, I get the error but this time the paths appear to be
correct

Thoughts?

Gavan Schneider
——
Gavan Schneider, Sodwalls, NSW, Australia
Explanations exist; they have existed for all time; there is always a
well-known solution to every human problem — neat, plausible, and
wrong. The ancients, in the case at bar, laid the blame upon the gods:
sometimes they were remote and surly, and sometimes they were kind. In
the Middle Ages lesser powers took a hand in the matter, and so one
reads of works of art inspired by Our Lady, by the Blessed Saints, by
the souls of the departed, and even by the devil. H. L. Mencken, 1920