I nominate adding the database schema upgrade script to the deb and rpm
install/upgrade scripts. It would need to detect the current db schema
version and apply the appropriate db updates. Which it surely does
already...
That automation alone would probably reduce friction by 5%.
It is not that easy.
It first would have to scan your config, in order to find which DBMS you
use.
Some are even using multiple DBs.
I think it would be relatively straight-forward and avoid lots of
upgrade confusion for SOGo to store in the db the db schema version.
Then when SOGo starts up and connects to the db, it checks that the db
schema version matches the version it is expecting. If it isn't, it
throws an error and stops. This forces the admin to read the
instructions and do the db backup, run the upgrade script, etc. But it
prevents someone from doing a quick upgrade and running a new version
SOGo against an old db schema and having weird problems, etc.
Ben
--
[email protected]
https://inverse.ca/sogo/lists