Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-2624

Installer: Check MySQL max_allowed_packet and possibly other MySQL vars during install

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.2.2
    • Fix Version/s: Short Term
    • Component/s: None
    • Labels:
      None

      Description

      Some people have been reporting issues with installing Blesta, and the issue has been related to 2 MySQL config values:

      max_allowed_packet and wait_timeout

      In limited testing, max_allowed_packet value of 16M or less resulted in a failed installation while running migrations, prior to writing the config. wait_timeout was set in this case also, to a value of 10. Increasing it to a value of 3600 and increasing max_allowed_packet to 128M resolved the issues and installation completed successfully.

      Not sure what the minimum values should be, may require more testing to determine.

        Issue Links

          Activity

          admin Paul Phillips created issue -
          tyson Tyson Phillips (Inactive) made changes -
          Field Original Value New Value
          Link This issue is duplicated by CORE-2625 [ CORE-2625 ]
          Hide
          tyson Tyson Phillips (Inactive) added a comment -

          The issue with max_allowed_packet and wait_timeout configuration settings are currently described in the docs @ https://docs.blesta.com/display/user/Installing+Blesta#InstallingBlesta-CommonInstallationIssues

          Show
          tyson Tyson Phillips (Inactive) added a comment - The issue with max_allowed_packet and wait_timeout configuration settings are currently described in the docs @ https://docs.blesta.com/display/user/Installing+Blesta#InstallingBlesta-CommonInstallationIssues
          tyson Tyson Phillips (Inactive) made changes -
          Story Points 3
          tyson Tyson Phillips (Inactive) made changes -
          Rank Ranked higher
          tyson Tyson Phillips (Inactive) made changes -
          Rank Ranked higher

            People

            • Assignee:
              Unassigned
              Reporter:
              admin Paul Phillips
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: