Timescaledb: Timescale installer is not finding openssl

[arifainchtein]

Hello,
For the past few months i have been installing timescaledb from code without a problem.
I am running on a raspberry pi 3 using raspian stretch.
I have an install procedure that installs openssl.

For postgresql, I install Postgresql 9.6 using:

apt-get -y install postgresql postgresql-server-dev-9.6

i then do

cd /home/pi
sudo rm -r timescaledb
git clone https://github.com/timescale/timescaledb.git
cd timescaledb
git checkout
./bootstrap
cd build && make
sudo make install

and normally is not a problem. Today however, I get this:

Cloning into 'timescaledb'...
remote: Enumerating objects: 4, done.
remote: Counting objects: 100% (4/4), done.
remote: Compressing objects: 100% (4/4), done.
remote: Total 14589 (delta 0), reused 0 (delta 0), pack-reused 14585
Receiving objects: 100% (14589/14589), 5.00 MiB | 382.00 KiB/s, done.
Resolving deltas: 100% (11388/11388), done.
Your branch is up-to-date with 'origin/master'.
-- The C compiler identification is GNU 6.3.0
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Detecting C compile features
-- Detecting C compile features - done
-- TimescaleDB version 1.3.0-dev. Can be updated from version 1.2.1
-- Build type is Release
-- Install method is 'source'
-- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN
-- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN - Success
-- Using compiler GNU
-- Found Git: /usr/bin/git (found version "2.11.0")
-- Using pg_config /usr/bin/pg_config
-- Compiling against PostgreSQL version 9.6.10
CMake Warning at CMakeLists.txt:267 (message):
  clang-format is disabled (can't find clang-format or docker)


-- Could NOT find OpenSSL, try to set the path to OpenSSL root folder in the system variable OPENSSL_ROOT_DIR (missing:  OPENSSL_LIBRARIES OPENSSL_INCLUDE_DIR)
CMake Error at CMakeLists.txt:302 (message):
  TimescaleDB requires OpenSSL but it wasn't found.  If you want to continue
  without OpenSSL, re-run bootstrap with `-DUSE_OPENSSL=0`


-- Configuring incomplete, errors occurred!
See also "/home/pi/timescaledb/build/CMakeFiles/CMakeOutput.log".
make: *** No targets specified and no makefile found.  Stop.
make: *** No rule to make target 'install'.  Stop.

i definetely have openssl installed. I checked this by doing:

pi@Cleo2:~ $ whereis openssl
openssl: /usr/bin/openssl /usr/share/man/man1/openssl.1ssl.gz

Just now while researching the problem i also added:

export OPENSSL_ROOT_DIR=/usr/bin/openssl

And is still does not work. The last step above was never necessary before.

Any suggestions as to why timescale can not find openssl?

[pmwkaa]

Hey, I might suggest that you could be missing -dev version of the package. Try this

apt-get install libssl-dev

[mfreed]

Hi @arifainchtein did @pmwkaa 's suggestion fix your problem?

[spitzenidee]

Hi @mfreed! Just as a heads-up: @pmwkaa 's suggestion did it for me (compiling TimescaleDB into a PG11 Docker image - builds correctly now with TimescaleDB 1.2.1).

[binakot]

For Alpine use apk add openssl-dev.