Announcement

Collapse
No announcement yet.

Important update to Open-Xchange configdb database

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Important update to Open-Xchange configdb database

    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:

    Code:
    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:

    Code:
    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:

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