Details

    • Type: Sub-task
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.7.3
    • Fix Version/s: 4.7.7
    • Component/s: None
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code

      Description

      CiviCRM makes heavy use of triggers. In some circumstances allowing the mysql user to have CREATE TRIGGER permission or SUPER permission (if replication is enabled) is problematic.

      Even if you create the triggers offline CiviCRM attempts to check triggers are turned on before displaying the log tab on a contact record - which may not be possible.

      My proposal is to add a new setting 'logging_no_trigger_permission' and when it is enabled

      1) log trigger create statements
      2) treat logging is on even if triggers can not be seen by the mysql user

      I don't feel this setting needs to be available through the UI but I might add it as a commented out setting in the civicrm.settings.php template

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                eileen Eileen McNaughton
                Reporter:
                eileen Eileen McNaughton
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: