rdagumampan / yuniql

Free and open source schema versioning and database migration made natively with .NET/6. NEW THIS MAY 2022! v1.3.15 released!
https://yuniql.io
Apache License 2.0
417 stars 63 forks source link

SOLVED: yuniql run - No usable version of libssl was found - Aborted (core dumped) #322

Closed giotachristodoulou98 closed 1 week ago

giotachristodoulou98 commented 2 weeks ago

I have a testing empty database and a test sql script on an EC2 instance. I am trying to execute the script that is under /tmp/devops/downloads/postgresdb/v0.00/UAT using yuniql run command.

EC2 instance OS information: NAME="Amazon Linux" VERSION="2023" ID="amzn" ID_LIKE="fedora" VERSION_ID="2023" PLATFORM_ID="platform:al2023" PRETTY_NAME="Amazon Linux 2023" ANSI_COLOR="0;33" CPE_NAME="cpe:2.3:o:amazon:amazon_linux:2023"

Command: yuniql run -p /tmp/devops/downloads/postgresdb/ -c 'Host=localhost;Port=5432;Username=<username>;Password=<password>;Database=<dbname>' -a true --platform postgresql -t v0.00 --environment UAT

Output:

Running yuniql v1.1.55 for linux-x64
Copyright 2019 (C) Rodel E. Dagumampan. Apache License v2.0
Visit https://yuniql.io for documentation & more samples

INF   2024-08-30 08:41:14Z   Run configuration:
{
  "isInitialized": true,
  "workspace": "/tmp/devops/downloads/postgresdb/",
  "platform": "postgresql",
  "connectionString": "<sensitive-data-redacted>",
  "isAutoCreateDatabase": true,
  "targetVersion": "v0.00",
  "tokens": [],
  "isVerifyOnly": false,
  "bulkSeparator": ",",
  "bulkBatchSize": 0,
  "commandTimeout": 30,
  "isDebug": false,
  "appliedByTool": "yuniql-cli",
  "appliedByToolVersion": "1.1.55.0",
  "environment": "UAT",
  "metaSchemaName": null,
  "metaTableName": null,
  "isContinueAfterFailure": false,
  "transactionMode": "session",
  "isRequiredClearedDraft": false,
  "isForced": false
}
No usable version of libssl was found
Aborted (core dumped)

I have also installed openssl-devel package but the issue remains.

giotachristodoulou98 commented 1 week ago

SOLVED

Steps:

  1. wget https://www.openssl.org/source/openssl-1.1.1t.tar.gz
  2. tar -xzf openssl-1.1.1t.tar.gz
  3. sudo dnf install perl-core
  4. sudo cpan install FindBin
  5. ./openssl-1.1.1t/config --prefix=/usr/local/openssl-1.1.1
  6. make
  7. sudo make install
  8. export LD_LIBRARY_PATH=/usr/local/openssl-1.1.1/lib:$LD_LIBRARY_PATH