Reproducible integration tests

[khklau]

To catch problems sooner automation is needed for reproducible integration tests. The components needed for the integration tests are:

• A container running Postgresql + PostGIS extension
• Setting up Postgresql with an OpenStreetMap database instance and roles
• Ingesting the map data into Postgresql
• A container running renderd that has a shared disk partition
• A container running Apache2 webserver + mod_tile module which also mounts the shared disk partition. This webserver also needs to serve leaflet.js for the front end

The shared disk partition is needed because legacy renderd and mod_tile use the file system as an RPC mechanism.

[khklau]

Initial development was done on Debian 11 Bullseye so we'll stick with this version for now. We can upgrade the components later.

So the versions of the tech stack are:

• Debian 11 Bullseye
• Postgresql 13
• PostGIS 3.4
• Apache2 Webserver 2.4.57
• Osm2pgsql 1.4.1
• Openstreetmap-carto 5.3.1
• Mapnik 3.1.0
• Renderd 0.5
• Mod_tile 0.5
• Leaflet.js 1.7.1

[khklau]

Here's the container image for Debian 11 + PostGIS 3.4 + Postgresql 13:

https://hub.docker.com/layers/postgis/postgis/13-3.4/images/sha256-d3b01809008b8de9d89310433722caf8001c539b59d00b2d61374d7f057a1a3a?context=explore

which is defined by these Dockerfiles:

https://github.com/docker-library/postgres/blob/master/13/bullseye/Dockerfile

https://github.com/postgis/docker-postgis/blob/master/13-3.4/Dockerfile

[khklau]

Unfortunately there no up to date container images on Docker hub of mod_tile and renderd so we'll have to define our own. It should be based on the container image for Debian 11 + Apache2 Webserver 2.4.57 here:

https://hub.docker.com/layers/library/httpd/2.4.57-bullseye/images/sha256-a6522910f36f4f6d1dde6bd3a605ef11f7ffd6fc6d37df7067c40faaeb236319?context=explore

which is defined by this Dockerfile:

https://github.com/docker-library/httpd/blob/7d6139b45f2e9a3146c2062894aca949cba91bba/2.4/Dockerfile