Ubuntu
roundcube package

  1. Bug #1970428
  2. Comment #4

Comment 4 for bug 1970428

Revision history for this message
halfgaar (wiebe-halfgaar) wrote :

Upstream having released a fix doesn't actually help until the migration scripts in 'usr/share/dbconfig-common/data/roundcube/upgrade/mysql' inside the deb are fixed. Here's a workaround.

I performed an upgrade to Ubuntu 22.04, for which there are two migration scripts. They will fail half way, at which point you need to say 'ignore' and run them by hand:

* upgrade to Ubuntu 20.04
* say 'ignore' on the dbconfig error
* Finish the upgrade
* run 'mysql roundcube < 1.4.1-1__starting_from_first_failed_statement.sql'
* Upgrade to Ubuntu 22.04
* say 'ignore' on the dbconfig error
* Finish the upgrade
* run 'mysql roundcube < 1.5~beta-1__starting_from_first_failed_statement.sql'

On both my test virtual machines and real server the upgrade from MySQL 5.7 to 8.0.33 actually failed for various reason (invalid config file and redo log corruption), but that's outside the scope of this bug report.

The question then is for the next upgrade, whether the .deb will contain migration scripts that properly escape the 'system' keyword.