[oxhe-announce] Important update to Open-Xchange configdb database

Open-Xchange Hosting Edition Maintenance Announcements oxhe-announce at open-xchange.com
Mon Apr 11 08:54:16 CEST 2011


Dear Customers of Open-Xchange,


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


Best regards,
Your Open-Xchange Team 

--
Open-Xchange AG,  Maxfeldstr. 9, 90409 Nürnberg
Amtsgericht Nürnberg HRB 24738
Vorstand: Rafael Laguna de la Vera, 
Aufsichtsratsvorsitzender: Richard Seibt



More information about the oxhe-announce mailing list