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

MySQL driver update

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 15.2
    • Component/s: Framework
    • Labels:
      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

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

              Dates

              Created:
              Updated:
              Resolved: