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
-
Labels:
-
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
- is supplemented by
-
CRM-19051 Logging - setting to allow offline triggers not respected in all cases
- Done/Fixed
- links to