dimitri / pgloader

Migrate to PostgreSQL in a single command!
http://pgloader.io
Other
5.45k stars 548 forks source link

Ubuntu 22: Fatal LOAD-FOREIGN-LIBRARY-ERROR: Unable to load any of the alternatives: ("libcrypto.so.1.1" "libcrypto.so.1.0.0" "libcrypto.so") [workaround] #1507

Open blzzua opened 1 year ago

blzzua commented 1 year ago

I am trying to build pgloader 3.6. 9 on ubuntu 22.04 (current LTS): download bundle https://github.com/dimitri/pgloader/releases/tag/v3.6.9, unpack, compiling.

# /tmp/aaa/pgloader-bundle-3.6.9 # make 
bin/buildapp      --logfile /tmp/pgloader-bundle-build.log     \
                         --require sb-posix --require sb-bsd-sockets --require sb-rotate-byte                             \
                         --sbcl sbcl                                 \
                         --asdf-tree .                                \
                         --load-system cffi                           \
                         --load-system cl+ssl                         \
                         --load-system mssql                          \
                         --load local-projects/pgloader-3.6.9/src/hooks.lisp              \
                         --load-system pgloader                    \
                         --eval '(setf pgloader.params::*version-string* "3.6.9")' \
                         --entry pgloader:main                        \
                         --dynamic-space-size 16384              \
                         --compress-core                         \
                         --output bin/pgloader.tmp
;; loading system "cffi"
;; loading system "cl+ssl"
Fatal LOAD-FOREIGN-LIBRARY-ERROR:
  Unable to load any of the alternatives:
   ("libcrypto.so.1.1" "libcrypto.so.1.0.0" "libcrypto.so")
make: *** [Makefile:47: bin/pgloader] Error 1

clear mistake - ubuntu no longer has the required version of this library.

Internet have lot of cases of this error.

Example workaround: https://gist.github.com/joulgs/c8a85bb462f48ffc2044dd878ecaa786

wget http://archive.ubuntu.com/ubuntu/pool/main/o/openssl/libssl1.1_1.1.0g-2ubuntu4_amd64.deb
sudo dpkg -i libssl1.1_1.1.0g-2ubuntu4_amd64.deb

Its work. But.

I'm not familiar with LISP, but is it possible to make a workaround at the pgloader compilation level?