Uploaded image for project: 'PUBLIC - Liferay Documentation'
  1. PUBLIC - Liferay Documentation
  2. LRDOCS-7360

Flagged: Change MySQL examples for an error-free start-up

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Fix Version/s: 7.2.x
    • Component/s: Core Infrastructure
    • Labels:
      None

      Description

      Flagged by Isaac Wilson via tickets: 1342413425

      Article link: https://help.liferay.com/hc/en-us/articles/360028712292

      • jdbc.default.driverClassName=com.mysql.jdbc.Driver jdbc.default.url=jdbc:mysql://localhost/myportal?characterEncoding=UTF-8&dontTrackOpenResources=true&holdResultsOpenOverStatementClose=true&useFastDateParsing=false&useUnicode=true jdbc.default.username=jbloggs jdbc.default.password=pass123
      • Comment: "Using this driver and default.url no longer works in 7.2 (causes startup errors), so I think we should change this example to match the ones in the portal.properties (in particular – a new driver listing, and the addition of serverTimezone=GMT). For example (with sample details added): jdbc.default.driverClassName=com.mysql.cj.jdbc.Driver jdbc.default.url=jdbc:mysql://localhost/myportal?characterEncoding=UTF-8&dontTrackOpenResources=true&holdResultsOpenOverStatementClose=true&serverTimezone=GMT&useFastDateParsing=false&useUnicode=true jdbc.default.username=jbloggs jdbc.default.password=pass123"

       

      Article Link: https://help.liferay.com/hc/en-us/articles/360028712332

      •  jdbc.default.driverClassName=com.mysql.cj.jdbc.Driver jdbc.default.url=jdbc:mysql://localhost/lportal?characterEncoding=UTF-8&dontTrackOpenResources=true&holdResultsOpenOverStatementClose=true&useFastDateParsing=false&useUnicode=true jdbc.default.username= jdbc.default.password=

        {{}}

      • *Comment: "*Similar to the Portal Properties page, I think we should change this MySQL example to allow for an error-free startup. (See https://issues.liferay.com/browse/LPS-91921 for reference). The jdbc.default.url would then look like: jdbc.default.url=jdbc:mysql://localhost/lportal?characterEncoding=UTF-8&dontTrackOpenResources=true&holdResultsOpenOverStatementClose=true&serverTimezone=GMT&useFastDateParsing=false&useUnicode=true{{"}}

       

       

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                7.2.x