CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 3.4 and 4.0 Releases Testing »
  • Is SUPER privilege required only when enabling logging?
Pages: [1]

Author Topic: Is SUPER privilege required only when enabling logging?  (Read 3826 times)

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Is SUPER privilege required only when enabling logging?
March 28, 2011, 02:28:23 am
Is SUPER privilege required only when enabling logging? I prefer to only give my MySQL user to minimum privileges it needs to do it's job. I'd like to remove the SUPER privilege once logging has been enabled,

Thanks,
Ken

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Is SUPER privilege required only when enabling logging?
March 28, 2011, 06:28:05 am

when u add/delete new custom fields / groups, we need the trigger privilege again. might be worth keeping it for now

note that in mysql 5.1 trigger is yet another privilege. so no need for super :)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

davej

  • Ask me questions
  • ****
  • Posts: 404
  • Karma: 21
Re: Is SUPER privilege required only when enabling logging?
May 31, 2011, 10:59:04 am
Testing with Civi 3.4.1 and MySQL 5.0.51, I tried granting SUPER privilege, enabling logging, revoking SUPER, then editing a contact. The log_ tables got created OK but when I tried editing a contact, I got this error:

UPDATE  civicrm_contact  SET contact_type = 'Individual' , contact_sub_type = NULL , do_not_email = 1 , do_not_phone = 0 , do_not_mail = 0 , do_not_sms = 0 , do_not_trade = 0 , is_opt_out = 1 , external_identifier = NULL , sort_name = 'Technical, Circle' , display_name = 'Circle Technical' , nick_name = NULL , preferred_communication_method = '' , preferred_language = 'en_GB' , preferred_mail_format = 'Both' , source = NULL , first_name = 'Circle' , middle_name = NULL , last_name = 'Technical' , suffix_id = NULL , email_greeting_id = 1 , email_greeting_custom = NULL , postal_greeting_id = 1 , postal_greeting_custom = NULL , addressee_id = 1 , addressee_custom = NULL , job_title = NULL , gender_id = NULL , birth_date = NULL , is_deceased = 0   WHERE (  civicrm_contact.id = 2 )   [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation]

Not good news for those on 5.0 .

Dave J
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 3.4 and 4.0 Releases Testing »
  • Is SUPER privilege required only when enabling logging?

This forum was archived on 2017-11-26.