Author Topic: Problems being granted all MySQL permissions required for CiviCRM 4.5 upgrade (Read 382 times)

brianedmundblood · September 19, 2014, 09:18:41 am

I currently use Civicrm 4.4.5; Drupal 7.23; PHP 5.3.28 (but this could be switched to 5.4.24) and mySQL 5.5.37 with InnoDB support

I emailed my provider, ICDSoft, as follows:

"I want to upgrade my CiviCRM to version 4.5 which has just been launched.

The requirements are:
CiviCRM 2.2.x+ : You must be running CiviCRM 2.2.x or higher to use this upgrade. Running a version prior to 2.2? First upgrade to 2.2 using these instructions
Drupal 7.x : CiviCRM 4.5 has been built to run under Drupal 7. It may run on Drupal 6, however it is not compatible with Drupal 5 sites.
PHP 5.3.3+ : CiviCRM will NOT run on PHP4 servers. (more info...).
MySQL 5.0.x or higher with InnoDB support : CiviCRM is compatible the current generally available MySQL release. Note that MySQL 5.1 is recommended for new installations and for sites during upgrades as CiviCRM is beginning to use Triggers more (eg to support multi-lingual installations), which require SUPER privileges in MySQL 5.0.
Permissions needed for CiviCRM 4.5 upgrade on MySQL 5.1: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, TRIGGER, CREATE ROUTINE, ALTER ROUTINE. (CREATE VIEW, TRIGGER, CREATE ROUTINE, ALTER ROUTINE are new requirements for update to CiviCRM 4.5, the others were needed before on 4.2.x.)
PCRE with Unicode properties support (more info).

I have checked my MySQL permissions and note that I do not have either CREATE ROUTINE or ALTER ROUTINE currently available.

Can you advise how I can switch these permissions on.

Many thanks."

They replied:

"Hello,

Most of the requirements are met, but SUPER privileges, CREATE ROUTINE, ALTER ROUTINE cannot be made available for security reasons. Our recommendation is to contact the CiviCRM developers and ask how crucial would their lack be. Let us know how they respond.
Thank you.

Best regards,
Support"

Would anyone on the forum have an answer about this?

Do you think I will have to move to another host in order to carry out this upgrade?

Any thoughts gratefully received.

Dan C · September 19, 2014, 12:38:58 pm

I don't know about the Create Routine or Alter Routine, but the Triggers are a crucial part of Civi. I have had a lot of trouble with installs that were forced onto databases without SUPER user rights. Unfortunately many shared server environments the hosts don't want to grant those privileges because of security concerns (I can't exactly disagree). So I would not suggest trying to do the upgrade with out SUPER user privileges and that may require moving to a host that is more willing to grant those rights. You could also talk to your host about upgrading your package if you want, sometimes if you move to a VPS (or similar) they will let you have those access rights.

brianedmundblood · September 19, 2014, 01:06:54 pm

Sadly the same host informed me that they don't grant those rights even on their upgraded VPS service so it looks like a new host

Thanks for your comments through.

Brian

CiviCRM Community Forums (archive)

News:

Author Topic: Problems being granted all MySQL permissions required for CiviCRM 4.5 upgrade (Read 382 times)

brianedmundblood

Problems being granted all MySQL permissions required for CiviCRM 4.5 upgrade

Dan C

Re: Problems being granted all MySQL permissions required for CiviCRM 4.5 upgrade

brianedmundblood

Re: Problems being granted all MySQL permissions required for CiviCRM 4.5 upgrade