[postgis-tickets] [PostGIS] #5199: Cannot access remote raster files when querying raster

[PostGIS]

#5199: Cannot access remote raster files when querying raster
-------------------------+---------------------------
  Reporter:  tuannguyen  |      Owner:  pramsey
      Type:  defect      |     Status:  new
  Priority:  medium      |  Milestone:  PostGIS 3.2.3
 Component:  postgis     |    Version:  3.2.x
Resolution:              |   Keywords:
-------------------------+---------------------------
Comment (by tuannguyen):

 For more information, I was running database container with docker image
 postgis/postgis:14-3.2. It turns out that the image is not shipped with
 `ca-certificates` as the container logs show

 {{{
 ERROR 11: CURL error: server certificate verification failed. CAfile: none
 CRLfile: none
 2022-08-05 11:43:47.299 UTC [243] ERROR:  rt_band_load_offline_data:
 Cannot open offline raster: /vsigs/<bucket>/pop12.tif
 2022-08-05 11:43:47.299 UTC [243] CONTEXT:  SQL function
 "st_pixelaspolygons" statement 1
         SQL statement "SELECT public.ST_Buffer(public.ST_Collect(t.geom),
 0)            FROM public.ST_PixelAsPolygons(rast, nband) AS t"
         PL/pgSQL function _st_intersects(geometry,raster,integer) line 21
 at SQL statement
         PL/pgSQL function st_intersection(geometry,raster,integer) line 11
 at assignment
         SQL function "st_intersection" statement 1
 }}}

 Install that package into the container and the database succeeded to
 return the result.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5199#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.