Changes between Version 40 and Version 41 of REDCap HowTo Install Using Docker

Timestamp:

08/05/17 09:14:46 (7 years ago)

Author:

Richard Bramley

Comment:

--

REDCap HowTo Install Using Docker

@@ -139 +139 @@
 1. Download the Redcap upgrade from https://community.projectredcap.org/page/download.html
 
-2. Backup you database and create a new database with an incremental version number. Import to this new database and assign roles and privileges.
-
-3. Connect to your docker redcap container
+2. Backup your database or copy the most recent database from {{{/var/MySqlBackerUpper/data/latest}}}.
+
+3. Amend the backup file to change the database name using the following command:
+{{{
+sed -i.bak 's/redcap{old_version}_briccs/redcap{new_version}_briccs/g' {copy of backup file}
+}}}
+
+4. Create the database:
+{{{
+mysql < {copy of backup file}
+}}}
+
+5. Grant redcap user permission to the new database:
+{{{
+GRANT SELECT ON redcap{version}.* TO  'redcap'@'%';
+}}}
+
+6. Connect to your docker redcap container
 
    {{{sudo docker exec -i -t <CONTAINERID> /bin/bash}}}
 
-4. Unzip the contents of redcap7.X.X_upgrade.zip into /var/www/site/redcap
-
-5. Change database.php with details of new database.
-
-6. Open URL
+7. Unzip the contents of redcap7.X.X_upgrade.zip into /var/www/site/redcap
+
+8. Change database.php with details of new database.
+
+9. Open URL
 
    {{{http://<HOST>.xuhl-tr.nhs.uk/redcap/redcap_v7.X.X/upgrade.php}}}
 
-7. This url will give you a sql script that you run against the database. Download the sql file and place it on the mysql host. Run as follows :
+10. This url will give you a sql script that you run against the database. Download the sql file and place it on the mysql host. Run as follows :
 
    {{{mysql -u root -p redcap6168 < redcap_upgrade_XXXXX.sql}}} 
 
-8. Now modify lcbruit/redcap_fresh docker image. This is very important as it will replace you current docker image.
+11. Now modify lcbruit/redcap_fresh docker image. This is very important as it will replace you current docker image.
 
    Download the fresh install package from redcap and modify the Dockerfile in redcap_fresh to use it.
 
-9. Build and run the redcap_fresh container :
+12. Build and run the redcap_fresh container :
 
    {{{sudo docker build -t lcbruit/redcap_fresh:v6.16.6 .}}}
@@ -167 +182 @@
    {{{sudo docker run -itd -p 80:80 lcbruit/redcap_fresh:v6.16.6}}}  
 
-10. Ensure you have set the container to start on reboot with the correct version number
+13. Ensure you have set the container to start on reboot with the correct version number
 
    [[Docker HowTo Auto Start Containers On Reboot]]