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

MySQL driver cannot resolve daylight time zone setting on linux- Remote Staging

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: No Longer Reproducible
    • Affects Version/s: Master
    • Fix Version/s: None
    • Labels:
      None

      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. Run Remote_Live database and Remote_staged database. 

      3) Open incognito window for local live and and remote live portals.

      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. 
      • Bug: I still see this error show up on my console (remote-staging running remote_live and remote_staged databases. This is after adding the &servertimezone=PST to fix the properties. 019-03-11 23:53:52.048 ERROR [Framework Event Dispatcher: Equinox Container: dd50b55e-3d8b-4869-a319-5967d0fe8d8d][com_liferay_portal_vulcan_impl:97] FrameworkEvent ERROR graphql.AssertException: Duplicated definition for field 'postUserAccount' in type 'Mutation'

       

      Environment:

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

      1. Bug gist: 

      https://gist.githubusercontent.com/lindacaldera/416a41197920147778fcc5281c96d0ca/raw/7dd3fd6e990e1aa196955aed60bf12439b88fd6e/master_staged2_state

       

      2. Resolved Bug gist: https://gist.githubusercontent.com/lindacaldera/f2c9ca45422b5d8957863cb1774c375f/raw/936990ecdc0699dadebea606700227f16ea8d644/3-12-19_new%2520bundle_master_staged

       

      Environment (Bug Fixed):

      Ubuntu 18.04.1 LTS+Tomcat 9.0.10+MySQL5.7
      Git ID:  8cb6976ca63bc713af736bcf1f398eacb54d32ab

       

       

      Related bugs: https://issues.liferay.com/browse/LPS-91921 

        Attachments

          Activity

            People

            • Assignee:
              victor.ware Victor Ware
              Reporter:
              linda.caldera Linda Caldera (Inactive)
              Participants of an Issue:
              Recent user:
              Victor Ware
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

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

                Packages

                Version Package