IMPORT/EXPORT using Azure Blob Storage may not work by default
Details
| Detail name | Value |
|---|---|
| Changelog Number | 25363 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 8.29.0 |
| Fix Versions | Exasol 8.32.0 |
| Resolution Date | 2024-11-08 |
Description
IMPORT/EXPORT using AZURE BLOBSTORAGE may not work by default. This is because the default value of the -etlCAPath parameter is set to /etc/ssl/certs/ca-bundle.crt. While this path is correct for some systems (e.g. CentOS) used as the base of Exasol container, it is incorrect for other systems, for example Ubuntu, which use /etc/ssl/certs/ca-certificates.crt.
Example error message
SQL Error [42636]: ETL-5500: An error occurred with Azure Blob storage: load_verify_file: No such file or directory (system library, fopen) [asio.ssl:33558530]
Workaround
The -etlCAPath parameter can be changed to an appropriate path for the system.
Fix
The -etlCAPath parameter will not have a default value, and if the parameter is not set explicitly, Exasol will dynamically search for the CA file on the system and set the parameter accordingly.
