Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-6098

Having trigger privilege is not enough in mysql 5.1 if binary logging is enabled

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.2
    • Fix Version/s: 3.2
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      On, for example the Localization settings page, it gives you a warning about your installation:

      "In order to use this functionality, the installation's database user must have privileges to create triggers (in MySQL 5.0 this means the SUPER privilege). This install does not seem to have the required privilege enabled."

      In MySQL 5.1 you need the SUPER privilege if binary logging is enabled. Suggest adding this info to the warning, e.g.

      "In order to use this functionality, the installation's database user must have privileges to create triggers (in MySQL 5.0 this means the SUPER privilege, and also in MySQL 5.1 if binary logging is enabled). This install does not seem to have the required privilege enabled."

        Attachments

          Activity

            People

            • Assignee:
              shot Piotr Szotkowski
              Reporter:
              demeritcowboy Dave D
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: