Civicrm Drupal

Ensure that your system meets the following requirements before installing or upgrading CiviCRM.

Poking the Drupal 8 bear: 'If you've been holding back from using Backdrop because your site requires the popular and powerful CiviCRM, hold back no longer. You can now easily install CiviCRM on Backdrop, or migrate it from your Drupal 7/CiviCRM setup.' And, unfortunately, you couldn't just make a special CiviCRM bundle that's 'optimized' for a particular version of Drupal 8, because each Drupal 8 site is potentially unique: you can update the PHP libraries used by a Drupal 8 site (for example, upgrading Symfony to a newer version) or add new PHP libraries that could conflict. Welcome to CiviCRM Sandbox on Drupal. CiviCRM is a community-based open source project to build constituent relationship management functionality for the nonprofit, advocacy and nongovernmental sectors. You can use this demo site to try out most of the features of CiviCRM including online donation processing, event management, memberships, case.

If you are curious what technologies other organizations are using to run CiviCRM, you can look at the CiviCRM Stats.

Summary¶

A recommended server environment should typically meet these guidelines:

  • Operating system: Linux
  • CMS: Backdrop, Drupal 7, Drupal 8/9, Joomla, or WordPress
  • PHP: 7.2 or 7.3 -- with configuration and extension requirements
  • MySQL: MySQL 5.7+ or MariaDB 10.0+ -- with configuration requirements

Other environments may also meet the system requirements. The following sections present requirements more precisely.

Server Environment¶

Operating System¶

If your server meets all of the requirements described on this page, CiviCRM should function correctly. There are no explicit operating system requirements. However, it's worth noting that CiviCRM is far more widely deployed and tested on UNIX-based operating systems, in particular Linux (e.g. Ubuntu, Debian, etc.), than with Microsoft Windows. You can still use CiviCRM fine from Windows desktops when the hosting environment runs Linux.

Hosting¶

In general, CiviCRM is a demanding web application which requires substantial server resources. It may not perform well on all hosting platforms. Learn more about choosing your hosting platform.

CMS¶

A CMS, or Content Management System, is a type of application which controls and manages the content of a website. CiviCRM must be installed within one of these compatible CMS platforms.

Civicrm Drupal Upgrade

See the page on choosing a CMS for more information about the advantages and disadvantages of each compatible CMS platform.

Civicrm drupal 7

Backdrop¶

  • Backdrop 1.0 or newer is required.

Drupal¶

Joomla¶

  • Joomla 3.x.x is required.

WordPress¶

  • WordPress 4.9 or newer is required.

PHP¶

PHP Version on the Command Line¶

The PHP version used on the command line is important and should match the version used by the web server. Using PHP 7.1 (or lower) on the command line and using PHP 7.2 (or higher) on the web server can cause issues.

It is also important to ensure that the same PHP extensions/modules are loaded on the command line and the web server.

PHP Version¶

CiviCRM 5.33 ESRCiviCRM 5.x.x stable
PHP 7.4incompatiblecompatible and recommended from CiviCRM 5.37 onwards. There are still a couple of issues with regards to PHP7.4 being tracked in this lab issue
PHP 7.3compatible and recommendedcompatible and recommended
PHP 7.2compatible and recommended - but see note below about resaving the SMTP passwordcompatible and recommended but see note below about resaving the SMTP password
PHP 7.1compatible but not recommended due to to PHP end-of life in Dec 2019incompatible as of 5.35.0
PHP 7.0incompatibleincompatible as of 5.25.0
PHP 5.6incompatibleincompatible
Historical PHP Versions

The table below gives information on PHP minimum and recommended version compatibility for old versions of CiviCRM:

CiviCRM VersionPHP Minimum VersionPHP Recommended Version
5.1 - 5.55.57.0
5.6 - 5.95.57.1
5.10 - 5.135.67.2
5.14 - 5.237.07.2
5.247.07.3
5.25 - 5.347.17.3
5.35 - Current7.27.3

PHP Extensions¶

To install these extensions, you will typically install a separate package within your server's package manager (e.g. apt-get on Ubuntu).

Required for CiviCRM Core¶

  • PHP BCMath - required for calculating financial values in CiviCRM Core.
  • PHP Curl - required for many payment processors, the extension manager, and the CiviCRM News dashlet.
  • PHP DOM XML - required by CiviCase.
  • PHP Multibyte - required for internationalisation and proper encoding of fields.
  • PHP Zip - required for unzipping auto-downloaded extensions so they can be installed from the browser.
  • PHP INTL - required for outputting localized formatted number strings from CiviCRM 5.28 onwards

Required for Third-Party Functionality or CiviCRM Extensions¶

  • PHP SOAP - required to use the SOAP processor (required for the CiviSMTP service)

PHP 7.1 and the MCrypt library¶

  • PHP MCrypt - the MCrypt extension is no longer recommended for new installations. From CiviCRM 5.34 onwards MCrypt is no longer needed.

    PHP 7.2 Compatibility

    1password chrome autofill

    7.2 upgrade warning - 7.2 does not support MCrypt and if MCrypt is not installed the SMTP password (if entered) will need to be re-saved once you update your PHP version to 7.2.

    PHP 7.1 cannot access SMTP credentials

    CiviCRM will incorrectly attempt to decrypt the SMTP password using the MCrypt library when executed using PHP 7.1. If PHP 7.2 or higher was used to save the SMTP password. This can occur if the PHP version on the command line does not match the web server version.

PHP Configuration¶

The following PHP directives is the recommended minimum. These are defined in the php.ini file.

  • memory_limit 256M
  • max_execution_time 240
  • max_input_time 120
  • post_max_size and upload_max_filesize 50M

    Don't use MAMP XCache

    Several people have reported 'white screen of death' trying to run CiviCRM with MAMP's XCache enabled (check MAMP > Preferences > PHP > Cache).

MySQL¶

CiviCRM requires MySQL (or compatible) database software.

MariaDB and Percona are forks of the MySQL project and can be used as drop-in replacements for MySQL.

Other database servers (such as PostgreSQL) are not compatible with CiviCRM.

MySQL Version¶

Your MySQL version should be 5.7.5 or greater or MariaDB 10.0.2 or greater. As of version 5.28 the minimum install version for CiviCRM is 5.6 users on versions before that are advised to upgrade their MySQL instance to a recommended version. CiviCRM may not run correctly on MySQL 5.6 as these versions don't support some of the functionality CiviCRM uses to ensure that database actions don't compete for the same resources.

Historical MySQL Versions

The table below gives information on MySQL minimum and recommended version compatibility for old versions of CiviCRM:

CiviCRM VersionMySQL Minimum VersionMySQL Recommended VersionMariaDB Minimum VersionMariaDB Recommended Version
5.26 - 5.275.55.7
5.28 - 5.335.6.55.710.4
5.34 - Current5.75.710.0.210.4

MySQL 8¶

As of version 5.24 CiviCRM has been shown to be able to run on MySQL 8 through the execution of our test matrix. All of the Content Management Systems support MySQL 8, CiviCRM MySQL 8 support was being tracked in this issue for MySQL 8 support. Backdrop supports MySQL 8 as of 1.17.2, Drupal 7 as of 7.76 Supports MySQL 8, Drupal 8supports MySQL 8 as of version 8.6, All versions of Drupal 9 support MySQL 8, Current versions of WordPress and Joomla appear to be compatible with MySQL 8.

MySQL Connection¶

By default, new installations of CiviCRM will copy the MySQL connection details from the CMS, creating a shared database. It is also possible toinstall CiviCRM on a separate database. As a rule of thumb:

  • A shared database works well for small deployments (eg a few thousand records and a single administrator or developer).
  • Separate databases work well for large deployments (eg a million records and multiple administrators/developers).

If you are unsure which style fits better, consider some trade-offs:

  • Initial setup: The shared database can be setup automatically. To use a separate database, you must create the second one.
  • 'Views' integration: On Drupal 7 / Backdrop, the 'Views' integration can query MySQL data from both CMS and Civi. This works easily with a shared database, but it requires effort with separate databases.
  • Backups: If you have a smalls SQL queries that were written with the assumption that this mode would be disabled.
  • Administrators are advised to turn off this SQL mode by removing the string ONLY_FULL_GROUP_BY from the sql_mode variable. The following SQL query will do the trick.

  • See also:

    • A popular Stack Exchange question discussing this issue
  • If you plan to have multiple languages used in your CiviCRM installation it is strongly recommended that you ensure that locale is set to a UTF8 locale and also ensure that you set utf8 as the standard encoding for MySQL. To alter locale you can configure as per Ubuntu instructions, Debian, CentOS. To set the default encoding for MySQL you should follow the steps provided in this Stack Overflow post
  • In order to support a future data migration from utf8 to the utf8mb4 character set, it is recommended, though not yet required, to add the following configuration directives on MySQL 5.5 or 5.6 (these are the default values on MySQL 5.7):

In MySQL 8 the default authentication plugin changes from mysql_native_password to caching_sha2_password. This may cause issues with your PHP layer. Fortunately you can revert this change by specifying your chosen authentication plugin in your MySQL configuration:

Civicrm Drupal 8

Also in MySQL 8 the following variables, used fairly extensively in CiviCRM installs, have been removed innodb_large_prefix and innodb_file_format. In MySQL 8 binary logging is also turned on by default which many users may want to turn off, this can be achieved by adding to your MySQL configuration file:

MySQL Time¶

CiviCRM performs various operations based on dates and times – for example, deactivating expired records or triggering scheduled reminders. To perform these operations correctly, the dates and times reported by PHP and MySQL should match. If the dates or times are mismatched, then one or more of the following may be the problem:

  • PHP and MySQL may be running on different servers, and the clocks may be out-of-sync. Configuring automatic clock synchronization is the best solution.
  • PHP, MySQL, and/or the operating system may be configured to use different default timezones. Verify the configuration of each.
  • The content management system (Drupal, Joomla, or WordPress) or one of its plugins may manipulate the timezone settings without informing CiviCRM's. You may wish to post to Stack Exchange or Mattermost about your problem. Please include any available details about the timezone settings in the operating system, PHP, MySQL, and the CMS; if you have any special CMS plugins or configuration options which may affect timezones, please report them.

MySQL/PHP Time Mismatch Warning - WordPress¶

If you get a MySQL/PHP mismatch warning, under Settings > General set the timezone to a City, not UTC offset. For example, use London not UTC+0.

Civicrm Wordpress

MySQL Permissions¶

The permissions you'll need to assign to the MySQL user that CiviCRM uses will depend on your version of MySQL. The following example assumes you have a database called civicrm and a MySQL user called civicrm_user.

Binary Logging¶

Civicrm Drupal 8

If you want to enable binary logging you will need to choose one of the following. Either:

  • Add the following line to your configuration file. The location of the configuration file depends on your operating system and database server you can find more information for MySQL here and for MariaDB here.

    (See the MySQL manual reference for more information.)

  • Or give the SUPER permission (even if your MySQL version is greater than 5.1.6).

    (More information on triggers is available in the MySQL documentation about Binary Logging of Stored Programs.)

Installing on certain Cloud Providers¶

Civicrm Drupal

When installing on certain cloud providers (AWS, Azure) where you are using database as a service, you will not have access to the my.cnf but you can generally use Database Parameter Groups or in Azure to set the parameters such as the log_bin_trust_function_creators as appropriate. On Azure running with DB as a service there needs to be a change made to the installation code as per the answer on Stack Exchange here. This is due to Azure not permitting connections to databases without credentials.