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

                [CRM-6098] Having trigger privilege is not enough in mysql 5.1 if binary logging is enabled
                Piotr Szotkowski added a comment -

                Thanks for catching this! Fixed in r27582.

                  People

                  • Assignee:
                    Piotr Szotkowski
                    Reporter:
                    Dave D

                    Dates

                    • Created:
                      Updated:
                      Resolved: