Drupal 7 - CiviCRM 4.3.4 - Error - Could not create a trigger.

[osxxso]

After clicking the 'Check Requirements and Install CiviCRM' button I get one RED highlighted error under 'CiviCRM Database Details'

Can I create triggers in the database --> Could not create a trigger.

Everything else is OK green.

I tried a Google search and tried searching this forum.  Unable to find a clear solution.

Can anyone help?  Thanks in advance.   Stefan

[Hershel]

CiviCRM requires (see http://civicrm.org/aboutcivicrm ) MySQL 5.1.x+ with InnoDB support the DB user needs the privilege of creating triggers. Ask your host about this.

[osxxso]

Contacted my host and InnoDB is supported and should be working just fine.  Attached a screenshot ( maybe it will help? ).

Performed another test and I still get the same single error. 

Could it be something else?

Thanks.

[Hershel]

Please read my post again. I wrote you need the privilege of creating triggers. Ask your host about that.

[Carlo Landmeter]

I just bumped into this issue and found the following to be helpful:

When binary logging is enabled the server must be running with the --log-bin-trust-function-creators option turned on in order to allow trigger creation without super (i.e. trigger permission).

Or you can add it to my.cnf:

log-bin-trust-function-creators = 1

This is of course when you are running your own mysql server.

[senyak]

Same issue here. I've used a local shared web host (Laughing Squid) for many nonprofit clients who have modest needs. Relatively good service, price, reliability. Drupal 7.2.4 installs perfectly.

Today I tried to install CiviCRM (4.4) as a Drupal module on that host, and was sandbagged by the need for permission for triggers. My host can't/won't allow GRANT TRIGGER permission to my mySQL database user. Thus, far as I can tell, I just can't host Civi there.

So I'm trying to find another shared host (i.e., < $100/mo) that might be suitable for small nonprofits, and so far the only real choice I've seen is civihosting.com. Am I missing something? A2 and SiteGround boast Civi hosting, but it looks like there's serious user dissatisfaction with their performance.

It's a genuine hardship for small nonprofits if Civi really can't be installed on the average shared host. This is not just a cost issue! Though civihosting's minimum $25/month is more than we've come to expect to pay for basic Drupal hosting, I agree that it's a reasonable price. However, most small nonprofits are already using some cheap shared web host (usually including a CMS for their website). If they have to migrate those functions to a new host just to use Civi, that's not always a trivial job. And if there's only one or two hosts that they can afford, it's a real counter-incentive. (Why? Because if there's a problem with the host, the organization must either abandon Civi or else go to some kind of unaffordable VPS solution.)

So I would love to know if:
   a) there's any way to install CiviCRM 4.4 on Drupal 7 *without* trigger permissions,
   b) future versions of CiviCRM might allow installation without trigger permissions (with logging disabled, perhaps),
   c) there are moderately-priced shared hosts (besides civihosting.com) that are known to run CiviCRM 4.4 on Drupal 7 with acceptable performance.

Many thanks!

[Donald Lobo]

a. No

b. Dont know of anyone working on it currently

c. check: https://civicrm.org/providers/hosting

note that you should be able to run civi on a VPS from any of the hosting providers.

lobo

[Hershel]

Though civihosting's minimum $25/month is more than we've come to expect to pay for basic Drupal hosting, I agree that it's a reasonable price.

To clarify, CiviHosting offers two shared hosting packages. The larger is $25 per month but the smaller one is $15 a month, and the resources provided for that package are sufficient for many/most small NPOs.

However, most small nonprofits are already using some cheap shared web host (usually including a CMS for their website). If they have to migrate those functions to a new host just to use Civi, that's not always a trivial job.

To note, some hosts, such as CiviHosting, do offer migration services, some for a small fee. Thus, it can actually be trivial.

[ehowland]

Carlo's solution:

log-bin-trust-function-creators = 1
Placed in the [mysqld] section of my.cnf

Worked for me.