4.1.6

4.1.16

Update Instructions

Update: Docker Compose Stack Version Bump for MariaDB

This update includes a version bump for MariaDB within our Docker Compose stack to incorporate the latest improvements and fixes.

Issue:
Docker Compose does not cleanly stop MySQL by default, which can lead to errors when restarting the database after an update. Reference: MariaDB Docker Issue #185.

Solution:
To cleanly stop MariaDB with Docker Compose, use the following command:

dc exec db /usr/bin/mysqladmin -uroot -p shutdown

Recommendation:
Performing a database backup is recommended before starting the update procedure. Utilize the db-backup profile included in the docker-compose.tools.yml file for this purpose.

New Feature:
An environment variable MARIADB_AUTO_UPGRADE is now set to 1 (activated) by default to automate the upgrade of the MariaDB system tables. This upgrade process, executed via mariadb-upgrade, updates system tables to enable new features but may restrict some downgrade options. Unless the environment variable MARIADB_DISABLE_UPGRADE_BACKUP is set, a backup of the system tables will be created as system_mysql_backup_*.sql.zst in the top level of the data directory to assist in any required downgrades.

Caution:
The provided MariaDB container in the Docker Compose stack is not ready for production as-is and requires adjustments. It is recommended to use an external, redundant service for the primary datastore.

Steps to Follow for Updating Docker Compose Stack:

1. Perform a backup of the application box and all databases published on your MariaDB server.
2. Stop the MariaDB server using the command (adapt it with your credentials):

   dc exec db /usr/bin/mysqladmin -uroot -p shutdown

3. Take down the Docker stack with:

   dc down

4. Deploy the new Docker stack version.
5. Start your stack with:

   dc up -d

Note: dc is a bash function aliasing docker compose with .env and .env.local values merged. See the README.md for more details.

Phraseanet Upgrade

• Phraseanet Migration Patch:
  • A migration script for the configuration file is available. Run the following command in the setup container with Docker if the environment variable PHRASEANET_UPGRADE=1 is set:

    bin/setup system:upgrade
    

Stack (Docker Compose and Helm)

• MariaDB: Bumped to 10.11.4

Version Summary

• Bump MariaDB
• Fix issue on CSRF
• Fix issue on export title choice in pusher case

What's Changed

• PHRAS-4129 : account page - collections request - CSRF error by @aynsix in #4585
• PHRAS-4130 : upgrade mariadb to 5.11.11 by @moctardiouf in #4586
• PHRAS-4115 Export window - Save File name choice case download_async by @aynsix in #4583
• PHRAS-4127 add mysql timeout env by @aynsix in #4584

Full Changelog: 4.1.15...4.1.16