1

Topic: Correct database schema upgrade script

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):  1.4.0 MARIADB edition.
- Deployed with iRedMail Easy or the downloadable installer? https://www.linuxbabe.com/mail-server/u … ail-server
- Linux/BSD distribution name and version: Ubuntu 20.04.3 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Whenever I update sogo I get the following message:

======= Important SOGo post-installation note =======

SOGo database schemas are _not_ automatically upgraded by
the packaging system.

Please check the list of database schema upgrade scripts
inside /usr/share/doc/sogo/ and apply them if needed.

The contents of /usr/share/doc/sogo/ are:

changelog.Debian.gz
changelog.gz
CHANGELOG.md.gz
copyright
SOGo-apple-ab.conf
sogo-backup.sh
sql-update-101_to_102.sh
sql-update-1.2.2_to_1.3.0-mysql.sh
sql-update-1.2.2_to_1.3.0.sh
sql-update-1.3.11_to_1.3.12-mysql.sh
sql-update-1.3.11_to_1.3.12.sh
sql-update-1.3.16_to_1.3.17-mysql.sh
sql-update-1.3.16_to_1.3.17.sh
sql-update-1.3.3_to_1.3.4-mysql.sh
sql-update-1.3.3_to_1.3.4.sh
sql-update-20070724.sh
sql-update-20070822.sh
sql-update-20080303.sh
sql-update-2.0.4b_to_2.0.5-mysql.sh
sql-update-2.2.17_to_2.3.0-mysql.sh
sql-update-2.2.17_to_2.3.0.sh
sql-update-3.0.0-to-combined-mysql.sh
sql-update-3.0.0-to-combined.sh
sql-update-3.2.10_to_4.0.0-mysql.sh
sql-update-3.2.10_to_4.0.0.sh
updates.php

How can I know which of these scripts is the correct one to run?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Correct database schema upgrade script

Jedi wrote:

Whenever I update sogo I get the following message:

This is a general note message, as sysadmin, you should know which version of SOGo you were running before update. Please read SOGo upgrade tutorial here:
https://www.sogo.nu/files/docs/SOGoInst … _upgrading