WebTop 1.5 with Tomcat and Postgresql Version Upgrade

[lucagasparini]

It is necessary to upgrade the current versions of tomcat 8.5 and postgresql 9.2 for the webtop module on NS8 to switch to stable versions with longest life (see https://endoflife.date/tomcat and https://endoflife.date/postgresql)

Proposed solution
I propose to switch at least to tomcat 9 and postgresql 17

• For postgres 17 it is necessary to add this variable in the systemd unit with which the container is started:

--env POSTGRES_PASSWORD=<password>

See PostgreSQL documentation about "trust": https://www.postgresql.org/docs/current/auth-trust.html
It will be necessary to evaluate and verify if it is enough to use pg_upgrade to convert a DB already installed with postgres 9.2

• For tomcat 9 it should be enough to just install and configure the new version to replace the current 8.5

[stephdl]

QA

target is webtop:1.4.3-testing.3

• case1: direct install
  install an account provider, mail server and webtop from 1.4.3-testing.3
  create some entries in the database (events, contacts, tasks)
  no issue expected

• case2 upgrade
  install an account provider, mail server and webtop from stable
  create some entries in the database (events, contacts, tasks)
  upgrade to webtop:1.4.3-testing.3
  no issue expected

[lucagasparini]

Test case 1 (Install): OK
Test case 2 (Upgrade): OK

postgres=# SELECT version();
                                                       version
---------------------------------------------------------------------------------------------------------------------
 PostgreSQL 17.5 (Debian 17.5-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

root@webtop:/usr/local/tomcat/lib# java -cp catalina.jar org.apache.catalina.util.ServerInfo
Server version: Apache Tomcat/9.0.106
Server built:   Jun 5 2025 19:02:30 UTC
Server number:  9.0.106.0
OS Name:        Linux
OS Version:     5.14.0-284.11.1.el9_2.x86_64
Architecture:   amd64
JVM Version:    1.8.0_452-b09
JVM Vendor:     Temurin