Project

General

Profile

Actions

Feature #2038

closed

Update OpenAtlas software to Debian bookworm

Added by Alexander Watzinger 11 months ago. Updated 5 months ago.

Status:
Closed
Priority:
Normal
Category:
Backend
Target version:
Start date:
2023-07-23
Estimated time:

Description

After Debian, the standard installation system for OpenAtlas, released the new version 12 bookworm we will look into, test and adapt OpenAtlas to the new available software packages.

  • Python from 3.9 to 3.11.2 (changelog 3.10, 3.11)
  • Flask from 1.1.2 to 2.2.2 (changelog 2.0.0)
  • PostgreSQL from 13.11 to 15 (changelog: 14.0, 15)
  • PostGIS from 3.1 to 3.3
  • Jinja2 from 2.11 to 3.1 (changelog)
  • Node.js from 12.22.12 to 18.13.0

Notes
Removable packages: python3-rdflib-jsonld (python3-rdflib 6.1.1 should include this package)
New packages: python3-email-validator, and if developing with Mypy: python3-typeshed
Make sure to backup databases and other data information before.
This link might be useful when upgrading: howto upgrade to bookworm, in short:

sudo apt update
sudo apt upgrade
sudo vim /etc/apt/sources.list (replace bullseye with bookworm, add non-free-firmware, see example below)
sudo apt update
sudo apt upgrade
* When asked if to enable app-armor for msmtp I choose "yes" and it worked out ok
sudo apt full-upgrade
sudo apt autoremove
sudo reboot

/etc/apt/sources.list example

deb http://deb.debian.org/debian bookworm main contrib
deb http://deb.debian.org/debian bookworm-updates main contrib
deb http://deb.debian.org/debian-security/ bookworm-security main contrib

Upgrade PostgreSQL and PostGIS

sudo apt install postgresql-postgis
sudo systemctl stop postgresql
sudo pg_dropcluster 15 main
sudo pg_upgradecluster 13 main
sudo pg_dropcluster 13 main
sudo systemctl start postgresql

Add new packages

sudo apt install python3-email-validator

Clean up

sudo apt purge python3-rdflib-jsonld

Actions #1

Updated by Bernhard Koschiček-Krombholz 10 months ago

  • Description updated (diff)
Actions #2

Updated by Alexander Watzinger 10 months ago

  • Description updated (diff)
Actions #3

Updated by Alexander Watzinger 10 months ago

  • Description updated (diff)
  • Status changed from Acknowledged to In Progress
Actions #4

Updated by Alexander Watzinger 10 months ago

  • Description updated (diff)
Actions #5

Updated by Alexander Watzinger 10 months ago

  • Description updated (diff)
Actions #6

Updated by Alexander Watzinger 10 months ago

  • Description updated (diff)
Actions #7

Updated by Alexander Watzinger 9 months ago

  • Description updated (diff)
Actions #8

Updated by Alexander Watzinger 9 months ago

  • Description updated (diff)
Actions #9

Updated by Alexander Watzinger 9 months ago

  • Description updated (diff)
Actions #10

Updated by Alexander Watzinger 8 months ago

  • Description updated (diff)
Actions #11

Updated by Alexander Watzinger 8 months ago

  • Description updated (diff)
Actions #12

Updated by Alexander Watzinger 8 months ago

  • Description updated (diff)
Actions #13

Updated by Alexander Watzinger 8 months ago

Just an update about the Debian Bookworm upgrade: like already anticipated software adaptions will be necessary too.
At least the new version of Jinja2 doesn't seem to be backwards compatible to the old one (e.g.: cannot import name contextfilter) but of course we might encounter breaking changes in other underlying software upgrades too.
Good news is that the PostgreSQL cluster upgrade to version 15 seems to work out fine.

Actions #14

Updated by Alexander Watzinger 7 months ago

  • Subject changed from Update OpenAtlas software to Debian-bookworm to Update OpenAtlas software to Debian bookworm
  • Description updated (diff)
Actions #15

Updated by Alexander Watzinger 7 months ago

  • Description updated (diff)
Actions #16

Updated by Alexander Watzinger 7 months ago

  • Description updated (diff)
Actions #17

Updated by Alexander Watzinger 7 months ago

  • Description updated (diff)
Actions #18

Updated by Alexander Watzinger 7 months ago

  • Description updated (diff)
Actions #19

Updated by Bernhard Koschiček-Krombholz 7 months ago

  • Description updated (diff)
Actions #20

Updated by Bernhard Koschiček-Krombholz 7 months ago

  • Description updated (diff)
Actions #21

Updated by Bernhard Koschiček-Krombholz 7 months ago

  • Description updated (diff)
Actions #22

Updated by Alexander Watzinger 7 months ago

  • Description updated (diff)
Actions #23

Updated by Alexander Watzinger 7 months ago

  • Description updated (diff)
Actions #24

Updated by Alexander Watzinger 7 months ago

  • Description updated (diff)
Actions #25

Updated by Alexander Watzinger 6 months ago

  • Description updated (diff)
Actions #26

Updated by Alexander Watzinger 6 months ago

  • Description updated (diff)
Actions #27

Updated by Alexander Watzinger 6 months ago

  • Description updated (diff)
Actions #28

Updated by Alexander Watzinger 6 months ago

  • Description updated (diff)
Actions #29

Updated by Alexander Watzinger 6 months ago

  • Description updated (diff)
Actions #30

Updated by Alexander Watzinger 6 months ago

  • Description updated (diff)
Actions #31

Updated by Alexander Watzinger 6 months ago

  • Target version changed from 312 to 8.0.0
Actions #32

Updated by Alexander Watzinger 6 months ago

  • Status changed from In Progress to Closed
Actions #33

Updated by Bernhard Koschiček-Krombholz 5 months ago

  • Description updated (diff)
Actions

Also available in: Atom PDF