Please read [[Docker HowTo Install]] before installing CiviCRM

== Prerequisites if required

'''Step 1 - Install Docker'''

[[Docker HowTo Install]]

'''Step 2 - Install Git''' 

    {{{$ sudo apt-get update }}}

    {{{$ sudo apt-get install git }}}

'''Step 3 - Backup CiviCRM and Drupal Databases'''

Log on to the mysql database machine. Backup Druplal and CiviCRM as follows :

    {{{/usr/local/mysql/bin/mysqldump --single-transaction -u root -p --ignore-table=civicrm_db_name.civicrm_domain \ }}}

    {{{--ignore-table=civicrm_db_name.civicrm_acl_cache \ }}}

    {{{--ignore-table=civicrm_db_name.civicrm_acl_contact_cache \ }}}

    {{{--ignore-table=civicrm_db_name.civicrm_cache  \ }}}

    {{{--ignore-table=civicrm_db_name.civicrm_group_contact_cache \ }}}

    {{{civicrmtest > civicrmtest.sql  }}}

    {{{   }}}

    {{{/usr/local/mysql/bin/mysqldump --single-transaction -u root -p drupaltest > drupaltest.sql  }}} 

This creates 2 sql dump files.

Connect to your destination mysql server where you wish to install the new databases.

    {{{mysql -u root -p}}}

Create a database, make sure you postfix with CiviCRM version number. Please stick to this naming convention. 

    {{{mysql > create database civicrmtest_docker4715}}}

    {{{mysql > create database drupaltest_docker4715}}}

Import the lastest database.

    {{{mysql -u root -p drupaltest_docker4715 < drupaltest.sql}}}

    {{{mysql -u root -p civicrmtest_docker4715 < civicrmtest.sql}}}

'''Step 4 - Create / Grant Mysql permissions'''

If a new user is needed run the following, replace necessary details

    {{{CREATE USER 'docker'@'localhost' IDENTIFIED BY 'docker'; }}}
  
    {{{CREATE USER 'docker'@'%' IDENTIFIED BY 'docker'; }}}

Grant necessary privileges to user.
 
    {{{GRANT ALL PRIVILEGES ON drupaltest_docker4715.* TO 'docker'@'localhost' WITH GRANT OPTION;}}}

    {{{GRANT ALL PRIVILEGES ON civicrmtest_docker4715.* TO 'docker'@'localhost' WITH GRANT OPTION;}}}

    {{{GRANT ALL PRIVILEGES ON drupaltest_docker4715.* TO 'docker'@'%' WITH GRANT OPTION;}}}

    {{{GRANT ALL PRIVILEGES ON civicrmtest_docker4715.* TO 'docker'@'%' WITH GRANT OPTION;}}}

'''Step 5 - Perform necessary sql if required'''

Run the following commands and take note of the sql for the views :

    {{{SHOW CREATE VIEW civicrm_view_case_activity_upcoming;}}}

    {{{SHOW CREATE VIEW civicrm_view_case_activity_recent;}}}

Make the modification 'CREATE SQL SECURITY invoker' and recreate the view :

    {{{DROP VIEW civicrm_view_case_activity_upcoming;}}}

    {{{CREATE SQL SECURITY invoker VIEW `civicrm_view_case_activity_upcoming` AS select `ca`.`case_id` AS `case_id`,`a`.`id` AS `id`,`a`.`activity_date_time` AS `activity_date_time`,`a`.`status_id` AS `status_id`,`a`.`activity_type_id` AS `activity_type_id` from (`civicrm_case_activity` `ca` join `civicrm_activity` `a` on((`ca`.`activity_id` = `a`.`id`))) where ((`a`.`activity_date_time` <= (now() + interval 14 day)) and (`a`.`is_current_revision` = 1) and (`a`.`is_deleted` = 0) and (`a`.`status_id` = 1));}}}

    {{{DROP VIEW civicrm_view_case_activity_recent;}}}

    {{{CREATE SQL SECURITY invoker VIEW `civicrm_view_case_activity_recent` AS select `ca`.`case_id` AS `case_id`,`a`.`id` AS `id`,`a`.`activity_date_time` AS `activity_date_time`,`a`.`status_id` AS `status_id`,`a`.`activity_type_id` AS `activity_type_id` from (`civicrm_case_activity` `ca` join `civicrm_activity` `a` on((`ca`.`activity_id` = `a`.`id`))) where ((`a`.`activity_date_time` <= now()) and (`a`.`activity_date_time` >= (now() - interval 14 day)) and (`a`.`is_current_revision` = 1) and (`a`.`is_deleted` = 0) and (`a`.`status_id` <> 1));}}}

== Upgrade CiviCRM using Docker

Step 1. On the host machine go to directory

    {{{/local/docker/<USER>/}}}

Step 2. Go to this directory and checkout from git docker_civicrm_upgrade

    {{{sudo git clone https://github.com/LCBRU/docker_civicrm_upgrade.git}}}

    {{{sudo chmod -R 777 docker_civicrm_upgrade/}}}

This will create a directory /local/docker/<USER>/docker_civicrm_upgrade

This docker script upgrades an existing CiviCRM installation. 

Step 3. The main configuration file is Dockerfile

Modify the following lines in Dockerfile :

    {{{ENV DRUPALVERSION 7.53}}}

    {{{ENV CIVICRMVERSION 4.7.15}}}

    {{{#####################}}}

    {{{# select only one}}}

    {{{ENV ENVIRONMENT test }}}

    {{{#ENV ENVIRONMENT live}}}

    {{{#####################}}}

Note the database config are in the live and test folders.

Modify as necessary the files :

    {{{civicrm.settings.php}}}

    {{{settings.php}}}

Step 4. Build Docker container

    {{{sudo docker build -t lcbruit/civicrm:v4.7.15 .}}}

    {{{sudo docker build --no-cache=true -t lcbruit/civicrm:v4.7.15 .}}}

Ensure that the **version number** matches the actual CiviCRM version you are upgrading to.

Run container

   {{{sudo docker run -v /share:/share -itd -p 80:80 lcbruit/civicrm:v4.7.15}}}

To connect to container :

   {{{sudo docker ps -a}}}
   {{{sudo docker exec -i -t [CONTAINER ID] /bin/bash}}}

Step 5. Upgrade Drupal and CiviCRM

To upgrade Drupal point your browser to :

   {{{http://XXXXXXXXXXXXXX.xuhl-tr.nhs.uk/update.php?op=info}}}

To upgrade CiviCRM point your browser to :

   {{{http://XXXXXXXXXXXXXX.xuhl-tr.nhs.uk/civicrm/upgrade?reset=1}}}
  
Go to Drupal -> Modules and enable the module 'Module Missing Message Fixer'

Go to Drupal -> Configuration -> Missing Module Message Fixer to remove any missing modules.

Go to the url :  

   {{{http://XXXXXXXXXXXXXX.xuhl-tr.nhs.uk/civicrm/admin/setting/path?reset=1}}}

ensure that the following are set to :

   {{{Temporary Files Directory = /var/local/civicrm/drupal/sites/default/files/civicrm/upload/}}}

   {{{Image Directory = /var/local/civicrm/drupal/sites/default/files/civicrm/persist/contribute/}}}

   {{{Custom Files Directory = /var/local/civicrm/drupal/sites/default/files/civicrm/custom/}}}

   {{{Custom Template Directory = /var/local/civicrm/drupal/sites/all/lcbru_custom/civicrm_templates/}}}

   {{{Custom PHP Directory = /var/local/civicrm/drupal/sites/all/lcbru_custom/civicrm_php/}}}

   {{{Extensions Directory = /var/local/civicrm/drupal/sites/all/lcbru_custom/civicrm_extensions/}}}

Go to the url :

   {{{http://XXXXXXXXXXXXXX.xuhl-tr.nhs.uk/civicrm/admin/setting/url?reset=1}}} 

ensure that the following are set to :

   {{{CiviCRM Resource URL = http://XXXXXXXXXXXXXX.xuhl-tr.nhs.uk/sites/all/modules/civicrm}}}

   {{{Image Upload URL = http://XXXXXXXXXXXXXX.xuhl-tr.nhs.uk/sites/default/files/civicrm/persist/contribute/}}}

   {{{Extension Resource URL = http://XXXXXXXXXXXXXX.xuhl-tr.nhs.uk/sites/all/civicrm_extensions}}}
  
Go to the url : 

   {{{http://XXXXXXXXXXXXXX.xuhl-tr.nhs.uk/civicrm/admin/setting/misc?reset=1}}}  

ensure that the following are set to :

   {{{Path to wkhtmltopdf executable = /usr/local/bin/wkhtmltopdf}}}

Go to the url : 

   {{{http://uhlbriccsapp07.xuhl-tr.nhs.uk/civicrm/admin/extensions?reset=1}}}  

Remove any extensions not required.

Stop the container :

   {{{sudo docker ps -a}}}
   {{{sudo docker stop [CONTAINER ID] }}}

Step 6. Set location of theme directory.

Connect to your drupal database and run the following 

   {{{select * from variable where name = 'color_antonelli_files'; }}}

This give the following output  

   {{{a:2:{i:0;s:42:"public://color/antonelli-d1bee6f5/logo.png";i:1;s:44:"public://color/antonelli-d1bee6f5/colors.css";} }}}

Modify the Dockerfile as follows

   {{{################### }}}

   {{{#css location. first line is test, 2nd line is live }}}

   {{{ENV CSS antonelli-d1bee6f5/ }}}

   {{{#ENV CSS antonelli-75b84edd  }}}

   {{{#################### }}}

Rebuild you image :

    {{{sudo docker build -t lcbruit/civicrm:v4.7.15 .}}}

    {{{sudo docker build --no-cache=true -t lcbruit/civicrm:v4.7.15 .}}}

Run container 

   {{{sudo docker run -v /share:/share -itd -p 80:80 lcbruit/civicrm:v4.7.15}}}

Step 7. Ensure you have set the container to start on reboot.

[[Docker HowTo Auto Start Containers On Reboot]]