Author Topic: 3.3.1: Logging throws permissions error (Read 1270 times)

bmw · December 14, 2010, 05:07:40 pm

Seems I am getting a permissions error when I try to set Administer/Global Settings/Miscellaneous/Logging.
Please advise. Thank you.

Code: [Select]

   Sorry. A non-recoverable error has occurred.
      DB Error: insufficient permissions
      Error Details
      Database Error Code: TRIGGER command denied to user 'joomla'@'localhost' for table 'civicrm_acl', 1142
      Additional Details:

      Array
      (
          [callback] => Array
              (
                  [0] => CRM_Core_Error
                  [1] => handle
              )

          [code] => -26
          [message] => DB Error: insufficient permissions
          [mode] => 16
          [debug_info] => CREATE TRIGGER civicrm_acl_after_insert AFTER Insert ON civicrm_acl FOR EACH ROW INSERT INTO joomla.log_civicrm_acl (id, name, deny, entity_table, entity_id, operation, object_table, object_id, acl_table, acl_id, is_active, log_conn_id, log_user_id, log_action) VALUES (NEW.id, NEW.name, NEW.deny, NEW.entity_table, NEW.entity_id, NEW.operation, NEW.object_table, NEW.object_id, NEW.acl_table, NEW.acl_id, NEW.is_active, CONNECTION_ID(), @civicrm_user_id, 'Insert') [nativecode=1142 ** TRIGGER command denied to user 'joomla'@'localhost' for table 'civicrm_acl']
          [type] => DB_Error
          [user_info] => CREATE TRIGGER civicrm_acl_after_insert AFTER Insert ON civicrm_acl FOR EACH ROW INSERT INTO joomla.log_civicrm_acl (id, name, deny, entity_table, entity_id, operation, object_table, object_id, acl_table, acl_id, is_active, log_conn_id, log_user_id, log_action) VALUES (NEW.id, NEW.name, NEW.deny, NEW.entity_table, NEW.entity_id, NEW.operation, NEW.object_table, NEW.object_id, NEW.acl_table, NEW.acl_id, NEW.is_active, CONNECTION_ID(), @civicrm_user_id, 'Insert') [nativecode=1142 ** TRIGGER command denied to user 'joomla'@'localhost' for table 'civicrm_acl']
          [to_string] => [db_error: message="DB Error: insufficient permissions" code=-26 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TRIGGER civicrm_acl_after_insert AFTER Insert ON civicrm_acl FOR EACH ROW INSERT INTO joomla.log_civicrm_acl (id, name, deny, entity_table, entity_id, operation, object_table, object_id, acl_table, acl_id, is_active, log_conn_id, log_user_id, log_action) VALUES (NEW.id, NEW.name, NEW.deny, NEW.entity_table, NEW.entity_id, NEW.operation, NEW.object_table, NEW.object_id, NEW.acl_table, NEW.acl_id, NEW.is_active, CONNECTION_ID(), @civicrm_user_id, 'Insert') [nativecode=1142 ** TRIGGER command denied to user 'joomla'@'localhost' for table 'civicrm_acl']"]
      )

      Return to home page.

[/code]

Donald Lobo · December 14, 2010, 06:09:06 pm

There is an issue for this.

http://issues.civicrm.org/jira/browse/CRM-7205

We need to trap the error and give a more pleasant error message. Your mysql user needs TRIGGER privileges to enable logging

lobo

bmw · December 14, 2010, 06:42:09 pm

Thanks! Will look into it. Will report back later. Hands hurt too much to continue tonite.

CiviCRM Community Forums (archive)

News:

Author Topic: 3.3.1: Logging throws permissions error (Read 1270 times)

bmw

3.3.1: Logging throws permissions error

Donald Lobo

Re: 3.3.1: Logging throws permissions error

bmw

Re: 3.3.1: Logging throws permissions error