CiviCRM Community Forums (archive)

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.

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

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!

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.