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) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Setup triggers for logging on Hostgator
Pages: [1]

Author Topic: Setup triggers for logging on Hostgator  (Read 1923 times)

malks

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 7
  • CiviCRM version: 3.4.x 4.x
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Setup triggers for logging on Hostgator
February 04, 2011, 12:21:14 am
Hi,
I want to set up triggers for the logging in Civi but Hostgator don't give permissions to create triggers but will create them for you.  Is there an sql script that I can give them to run that will create all the required triggers for me?

Thanks,
Malks.

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: Setup triggers for logging on Hostgator
February 04, 2011, 08:09:32 am

no. the sql is dynamically generated by "introspection" of the db schema

note that you do need trigger support as you add custom groups and for upgrades as the schema changes. So doing it via a script will not work in the medium/long term

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

malks

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 7
  • CiviCRM version: 3.4.x 4.x
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: Setup triggers for logging on Hostgator
February 05, 2011, 02:11:37 pm
Just for the record, that means that logging won't work on any shared hosting atm.  Because creating triggers (before MySql 5.1.6 at any rate) requires the SUPER permission, cPanel doesn't allow it.  I think this has changed at the MySql level but is not yet supported by cPanel.

malks

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 7
  • CiviCRM version: 3.4.x 4.x
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: Setup triggers for logging on Hostgator
February 06, 2011, 12:58:01 pm
Just to add to this again... Hostgator, if you ask them through a support ticket, will grant the TRIGGER privilege to a particular user on a database.  I've been quite happy with Hostgator and this is another reason why.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Setup triggers for logging on Hostgator

This forum was archived on 2017-11-26.