| 140 | | |
| 141 | | |
| 142 | | |
| 143 | | |
| 144 | | |
| | 140 | == Upgrade |
| | 141 | |
| | 142 | 1. Download the Redcap upgrade from https://community.projectredcap.org/page/download.html |
| | 143 | |
| | 144 | 2. Backup you database and create a new database with an incremental version number. Import this new database and assign roles an privileges. |
| | 145 | |
| | 146 | 3. Connect to your docker redcap container |
| | 147 | |
| | 148 | {{{sudo docker exec -i -t <CONTAINERID> /bin/bash}}} |
| | 149 | |
| | 150 | 4. Unzip the contents of redcap7.X.X_upgrade.zip into /var/www/site/redcap |
| | 151 | |
| | 152 | 5. Change database.php with details of new database. |
| | 153 | |
| | 154 | 6. Open URL |
| | 155 | |
| | 156 | {{{http://<HOST>.xuhl-tr.nhs.uk/redcap/redcap_v7.X.X/upgrade.php}}} |
| | 157 | |
| | 158 | 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 : |
| | 159 | |
| | 160 | {{{mysql -u root -p redcap6168 < redcap_upgrade_XXXXX.sql}}} |
| | 161 | |
| | 162 | 8. Now modify lcbruit/redcap_fresh docker image. This is very important as it will replace you current docker image. |
| | 163 | |
| | 164 | Download the fresh install package from redcap and modify the Dockerfile in redcap_fresh to use it. |
| | 165 | |
| | 166 | 9. Build and run the redcap_fresh container : |
| | 167 | |
| | 168 | {{{sudo docker build -t lcbruit/redcap_fresh:v6.16.6 .}}} |
| | 169 | |
| | 170 | {{{sudo docker run -itd -p 80:80 lcbruit/redcap_fresh:v6.16.6}}} |
| | 171 | |
| | 172 | 10.Ensure you have set the container to start on reboot with the correct version number |
| | 173 | |
| | 174 | [[Docker HowTo Auto Start Containers On Reboot]] |
| 174 | | OPTION B: Download the SQL upgrade script as a file |
| 175 | | |
| 176 | | mysql -u root -p redcap6168 < redcap_upgrade_61608.sql |
| 177 | | |
| 178 | | INSERT INTO `redcap_config` VALUES ('redcap_base_url','https://briccs.xuhl-tr.nhs.uk/redcap/'); |
| 179 | | |
| 180 | | update redcap_config set value = 'http://10.28.88.37/redcap/' where field_name = 'redcap_base_url'; |
| 181 | | |
| 182 | | |
| 183 | | |
| 184 | | |
| 185 | | |
| 186 | | |
| 187 | | |
| 188 | | |
| 189 | | |
| 190 | | |
| 191 | | |
| 192 | | |
| 193 | | |
| 194 | | |
| 195 | | |
| 196 | | |
| 197 | | There are 3 docker scripts available from github : |
| 198 | | |
| 199 | | git clone https://github.com/LCBRU/docker_redcap_upgrade |
| 200 | | |
| 201 | | Amend database.php |
| 202 | | |
| 203 | | sudo docker build -t lcbruit/redcap_fresh:v6.16.6 . |
| 204 | | |
| 205 | | sudo docker run -itd -p 80:80 lcbruit/redcap_fresh:v6.16.6 |
| 206 | | |
| 207 | | |
| 208 | | git clone https://github.com/LCBRU/docker_redcap_v5.7.0 |
| 209 | | |
| 210 | | git clone https://github.com/LCBRU/docker_redcap_fresh |
| 211 | | |
| 212 | | |
| 213 | | REDCap 6.16.6 |
| 214 | | |
| 215 | | http://uhlbriccsapp02.xuhl-tr.nhs.uk/redcap/index.php |
| 216 | | |
| 217 | | REDCap Software - Version 5.7.0 |
| 218 | | |
| 219 | | http://uhlbriccsapp02.xuhl-tr.nhs.uk:81/redcap/index.php |
| 220 | | |
| 221 | | Installation script |
| 222 | | * Image |
| 223 | | * CRON |
| 224 | | * php upgrade |
| 225 | | |
| 226 | | |
| 227 | | sudo apt-get update && sudo apt-get dist-upgrade |
| 228 | | sudo init 6 |
| 229 | | sudo apt-get install update-manager-core |
| 230 | | sudo vi /etc/update-manager/release-upgrades |
| 231 | | sudo do-release-upgrade -d |
| 232 | | |
| 233 | | |
| 234 | | |
| 235 | | |
| 236 | | sudo apt-get update |
| 237 | | sudo apt-get upgrade |
| 238 | | |
| 239 | | do-release-upgrade |
| 240 | | 91 sudo apt-get update && sudo apt-get dist-upgrade |
| 241 | | 92 sudo init 6 |
| 242 | | 93 sudo apt-get install update-manager-core |
| 243 | | 94 sudo vi /etc/update-manager/release-upgrades |
| 244 | | 95 sudo do-release-upgrade -d |
| 245 | | 96 ls |
| 246 | | 97 lsb_release -a |
| 247 | | 98 exit |
| 248 | | 99 sudo apt-get update |
| 249 | | 100 sudo apt-get upgrade |
| 250 | | 101 sudo apt-get install update-manager-core |
| 251 | | 102 sudo do-release-upgrade |
| 252 | | |
| 253 | | |
| 254 | | |
| 255 | | |
| 256 | | == Fresh Redcap using Docker |
| 257 | | |
| 258 | | |
| 259 | | == Further info |
| 260 | | |
| 261 | | Redcap is run on port 82 |
| 262 | | |
| 263 | | |
| 264 | | |
| 265 | | |
| 266 | | |
| | 204 | |
| | 205 | |
| | 206 | |
| | 207 | |
| | 208 | |
| | 209 | |
| | 210 | |
| | 211 | |
| | 212 | |
| | 213 | |
| | 214 | |
| | 215 | |
| | 216 | |