2023.10.24 qwc-base-db rework¶
As of 2023.10.24 the QWC base DB image has been reworked as follows:
- Migrations were moved to the
qwc-config-dbrepository is now obsolete.
- A new
qwc-base-db-migrateimage helps migrating dockerized or external config DBs.
- Demo data will be initialized by an optional setup script in
qwc-demo-dbrepository is now obsolete.
To use the new images, replace
qwc-postgis: image: docker.io/sourcepole/qwc-demo-db:<version> ...
qwc-postgis: image: sourcepole/qwc-base-db:<pg_version> environment: POSTGRES_PASSWORD: '' # TODO: Set your postgres password here! volumes: - ./volumes/db:/var/lib/postgresql/docker # If you don't want/need the demo data, you can remove this line - ./volumes/demo-data/setup-demo-data.sh:/docker-entrypoint-initdb.d/2_setup-demo-data.sh ports: - "127.0.0.1:5439:5432" healthcheck: test: ["CMD-SHELL", "pg_isready -U postgres"] interval: 10s qwc-config-db-migrate: image: sourcepole/qwc-base-db-migrate:<version> volumes: - ./pg_service.conf:/tmp/pg_service.conf:ro depends_on: qwc-postgis: condition: service_healthy
- It is now mandatory to set your own
- You can keep your previous
volumes/dbpostgres data folder, but it is recommended to make a backup.
sourcepole/qwc-base-dbimages are versioned according to the Postgres major version (i.e. 13, 14, 15, ...).
sourcepole/qwc-base-db-migrateimages are versioned by date (
- See the
qwc-base-dbREADME for more information.
- As of
2023.10.24the name of the database was changed to the more generic
Upgrading to qwc service images v2022.01.26¶
qwc-uwsgi-base images have been changed to allow for configurable UID/GID of the
uwsgi process. The default is
GID=33, you can override it by setting the
SERVICE_GID environment variables in
As a consequence,
/var/www is not necessarily anymore the home directory of the user wich runs
uwsgi, and therefore the
qwc-uwsgi-base images now set
ENV PGSERVICEFILE="/srv/pg_service.conf". You'll therefore need to adapt your
pg_service.conf volume mounts in your
docker-compose.yml to point to that location, i.e.
[...] - ./pg_service.conf:/srv/pg_service.conf:ro [...]
Upgrading to qwc-config-generator-v2022.01.12¶
scanned_projects_path_prefixhas been dropped as a config setting. Instead,
qgis_projects_scan_base_dirmust be a directory below
qgis_projects_base_dir, and the prefix is automatically computed internally.
scanned_projects_path_prefixhas been added as a config setting as the output path for preprocessed qgis projects. It must be a directory below
qgis_projects_base_dirto which the config service is allowed to write.
Upgrading from qwc service images v2021.x to v2022.01.08 or later¶
Starting with v2022.01.08, the requirements of all services where updated to use Flask-JWT-Extended 4.3.1.
Flask-JWT-4.x changes the JWT format (see 4.0.0 Breaking Changes), which can result in QWC Services returning a
Missing claim: identity error message.
To avoid this:
* Change your JWT secret key in
* Ensure all services are upgraded to v2022.01.12 or later (if such a version exists). Please omit v2022.01.08 and v2022.01.11.