GDAL driver-prefixed URLs : error adding trust anchors

[mtreguer]

While using DuckDB version 1.5.2, I encountered the following error:

memory D SELECT * FROM st_read('WFS:https://ahocevar.com/geoserver/wfs', layer='topp:states');
IO Error:
error adding trust anchors from file: /etc/pki/tls/certs/ca-bundle.crt

LINE 1: SELECT * FROM st_read('WFS:https://ahocevar.com/geoserver/wfs', layer...

cf #779

[mtreguer]

Hi,

It works with :

setenv GDAL_HTTP_UNSAFESSL YES
setenv CPL_CURL_IGNORE_ERROR YES
duckdb

DuckDB v1.5.2 (Variegata)
Enter ".help" for usage hints.
memory D
memory D
memory D LOAD spatial;
memory D SELECT * FROM st_read('WFS:https://sextant.ifremer.fr/services/wfs/biologie', layer='ms:IFR_AAMP_HAB_EUNIS_1M_ATL_P');
┌─────────┬─────────┬──────────────────────────────────────────────────────────────────────┬───────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ OGC_FID │ gml_id  │                                EUNIS                                 │                                                  msGeometry                                                   │
│  int64  │ varchar │                               varchar                                │                                             geometry('epsg:4326')                                             │
├─────────┼─────────┼──────────────────────────────────────────────────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────────┤
│       0 │         │ A5.14 : Circalittoral coarse sediment                                │ POLYGON ((51.141594 1.383757, 51.145655 1.383757, 51.145655 1.390212, 51.143625 1.390212, 51.143625 1.386985… │
│       1 │         │ A5.14 : Circalittoral coarse sediment                                │ POLYGON ((51.121288 1.341802, 51.123319 1.341802, 51.123319 1.345029, 51.121288 1.345029, 51.121288 1.341802… │
│       2 │         │ A5.26 : Circalittoral muddy sand                                     │ POLYGON ((51.113163 1.319211, 51.115194 1.319211, 51.115194 1.322438, 51.113163 1.322438, 51.113163 1.319211… │