Ubuntu 22.04 DuckDb CLI using Azure Extensions - Problem with the SSL CA cert (path? access rights?) - 0.9.1 and 0.9.2 both version

[sulejmaninaim]

I am running DuckDB CLI on Ubuntu 22.04 and I receive this error when I try to query Azure blob storage using Azure extensions

`
INSTALL azure;
LOAD azure;
SET azure_storage_connection_string = 'CONNECTION_SRING OF AZURE BLOB STORAGE';

SELECT * FROM 'azure://container_name/filename.parquet';

`

It shows an error:
Error: Invalid Error: Fail to get a new connection for: https://[domain].blob.core.windows.net. Problem with the SSL CA cert (path? access rights?)

[jaihind213]

quick fix mentioned in duckdb/duckdb_azure#7

mkdir -p /etc/pki/tls/certs ln -s /etc/ssl/certs/ca-certificates.crt /etc/pki/tls/certs/ca-bundle.crt

[rubinboban]

SET azure_transport_option_type = 'curl'; worked for me