Important update to Open-Xchange configdb database

[Carsten Hoeger]

Important update to Open-Xchange configdb database

In versions < 6.20 one table in the database used by the OX backend was
created with the configured default ENGINE of MySQL. This may, in certain
corner cases, trigger a bug in the OX backend which can lead to
data loss.

New installations of version 6.20 and greater will not be affected by this
problem. It is, however, not possible to change the database in existing
installations automatically.

To ensure the stability and correct functioning of your Open-Xchange
installation, we would like to ask you to make the following change to
the database:

1. Connect to your MySQL database with the following command:

mysql -h <master-db-host> -u <db-login> -p<db-password> configdb

The values to replace are configured e.g. in /opt/open-
xchange/etc/groupware/configdb.properties if you do not remember
them.

2. When connected to the MySQL ConfigDB Scheme, execute the following
SQL statement to correct the definition of table configdb_sequence:

ALTER TABLE configdb_sequence ENGINE=InnoDB DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;

Alternatively, you can download a shell script which executes these commands
and changes the database at:

wget http://software.open-xchange.com/checkandfixconfigdb.sh
bash checkandfixconfigdb.sh