Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-4829

MySQL driver update

Details

    • Task
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • None
    • 15.2
    • Framework
    • None

    Description

      We need to update the JDBC driver for MySQL, especially for security reasons.
      Administrators need to check if the time zone is set on their databases. The new driver will not accept an undefined timezone and make an exception about CEST timezone. This can be done with:

      SET GLOBAL time_zone = 'Europe/Zurich';

      The following parameter in olat.local.properties needs to checked:

      db.url.options.mysql=?characterEncoding=UTF-8&connectionCollation=utf8_unicode_ci
      

      The connection collation attribute is mandatory for some rare queries in OpenOlat. Set this attribute with the same collation you use in your database.

      Attachments

        Activity

          People

            srosse Stéphane Rossé
            srosse Stéphane Rossé
            Mandy Menzel Mandy Menzel
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: