Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-91921

MySQL driver cannot resolve daylight time zone setting on linux

    Details

      Description

      Steps to reproduce:

      1) Configure portal for mysql 5.7 with a linux (tested on Ubuntu) system on Pacific Daylight Time zone (MySQL defaults to SYSTEM time which is PDT)

      2) Go to console run> ./catalina.sh run

      3) Open browser and enter a URL as localhost:8080. 

      Expected Result: Liferay Portal window should load up and display a git id.

      Actual Result: Liferay Portal window displayed and error. Also, Console error showed up concerning server time zone configuration property. Bundle worked properly with hsql, but could not start up on Mysql 5.7.25. 

      Environment:

      Ubuntu 18.04.1 LTS+Tomcat 9.0.10+MySQL5.7
      Git ID: 1ba469112e11f5225c99ed38bed45b23c3a20ea8

      Console Gist: https://gist.githubusercontent.com/lindacaldera/39ed8259c881e3ca695c429ddfc5ffc2/raw/7addec2e164007974bc23d37aacc1bf2ce724861/3-11-19%2520-%2520Bundle%2520Console%2520Error

      Mysql variables: https://gist.githubusercontent.com/lindacaldera/a631434f2a94c8e598e39bada3ca04d2/raw/3090bf9aef7c05a8bda4e668dfb296d154b2aca7/3-11-19-%2520mysqladmin%2520variables

      Not Reproducible on:
      MacOS 10.12 (MySQL time set to "PST")
      Windows 10 (MySQL time set to "Pacific Daylight Time")

      Notes: 
      Entered command in console. Returned: system.

       mysql -e select@@global.time_zone; 

      https://knowledgebase.progress.com/articles/Article/MySQL-8-JDBC-drivers-affecting-date-time-field-data

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  38 weeks, 3 days ago

                  Packages

                  Version Package
                  Master