TEHCC Wiki:Maintenance

Note! Any site specified use of php on the command line should replace php with /opt/cpanel/ea-php72/root/usr/bin/php.

System Maintenance

Upgrade/Reinstall

Use to upgrade across major versions or to reinstall a borked install

1. Get MediaWiki (per MediaWiki site)
   1. Download desired version MediaWiki Site using wget to the home directory
   2. Unpack using tar -xvzf (e.g., tar -xvzf mediawiki stable release number.tar.gz)
   3. Delete zipped tarball (e.g., rm mediawiki stable release number.tar.gz)
2. Copy customized files to new install (per MediaWiki site)
   1. Copy Localsettings.php (e.g., cp public_html/clubwiki/LocalSettings.php ~/mediawiki stable release number/)
   2. Copy Images folder (e.g., cp -R public_html/clubwiki/images/ ~/mediawiki stable release number/)
   3. Copy kml folder (e.g., cp -R public_html/clubwiki/kml/ ~/mediawiki stable release number/)
3. Move over to new install (per MediaWiki site)
   1. Move the existing installation to a temporary backup folder mv ~/public_html/clubwiki/ ~/OLD.yyyymmdd.clubwiki
   2. Move the new installation to the public folder mv ~/mediawiki stable release number ~/public_html/clubwiki
4. Install extensions/handlers
   1. Composer - per Mediawiki site download to clubwiki folder (e.g. wget https://getcomposer.org/composer.phar)
   2. Semantic MediaWiki using Composer except syntax to use php v7.0 - Ensure to specify the most recent/desired version of software!
   3. NumberFormat - Download extension and extract into the extension directory tar -xzf extension.tar.gz -C ~/public_html/clubwiki/extensions/
   4. Maps using Composer except syntax to use php v7.0. Start at step 2.
   5. Page Forms - Download extension and extract into the extension directory tar -xzf extension.tar.gz -C ~/public_html/clubwiki/extensions/
   6. Semantic result formats using Composer except syntax to use php v7.0. Ensure you specify most recent/desired version!
   7. Semantic Compound Queries I tried to use Composer but it wasn't loading so manually installed at v1.1.0. Used for auto map of trails and parks
   8. Arrays - Simple extension download. Used for array manipulation in templates
   9. Header Tabs - Allows turning form pages (or really any page) into tabbed pages
   10. MyVariables - Allows referencing logged in user for form automation
5. Run Mediawiki upgrade or command line update (per MediaWiki site)
6. Done! (May need to ctrl-shift-R to force reload pages to avoid seeing errors)

Update MediaWiki

Patch - Available for point releases. Details on the MediaWiki site

1. Download patch from the dumps site
2. cd to cd ~/public_html/clubwiki/ directory (the one with LocalSettings.php).
3. Download (wget) the patch file from the dumps site and gunzip it gunzip mediawiki stable release number.patch.gz.
4. Use patch -p1 --dry-run to check what will be changed (e.g., patch -p1 --dry-run -i mediawiki stable release number.patch)
5. If all is well, run patch again without --dry-run.
6. Check Special:Version and you should see the new version number in place.
7. Delete patch files rm mediawiki stable release number.patch*

Update extensions

1. Composer based (Semantic MediaWiki, Maps, and Semantic Result Formats)
   1. cd to cd ~/public_html/clubwiki/ directory (the one with LocalSettings.php).
   2. Update composer /opt/cpanel/ea-php72/root/usr/bin/php composer.phar self-update
   3. Update using composer /opt/cpanel/ea-php72/root/usr/bin/php composer.phar update --no-dev
2. Composer extensions that need version number updated in composer.json vi composer.json
   1. Semantic MediaWiki
   2. Maps - Note! v6 and above requires php v7.1 which is not on this host yet
   3. Semantic Result Formats
   4. Semantic Compound Queries
   5. Rerun composer update if there were any updates to perform /opt/cpanel/ea-php72/root/usr/bin/php composer.phar update --no-dev
3. Manual extensions - Go to Special:Version and compare what's shown on extension page
   1. NumberFormat - Download needed updates and extract into the extension directory tar -xzf extension.tar.gz -C public_html/clubwiki/extensions/
   2. Page Forms - Download extension and extract into the extension directory tar -xzf extension.tar.gz -C public_html/clubwiki/extensions/
   3. Arrays - Upload new version into extension folder
   4. Header Tabs - Upload new version into extension folder
   5. MyVariables - Upload new version into extension folder
   6. SimpleTable - Upload new version into extension folder
4. Remaining extensions are part of MediaWiki and upgraded with it
5. Update completion - run maintenance routine from cd ~/public_html/clubwiki/ directory: /opt/cpanel/ea-php72/root/usr/bin/php maintenance/update.php
6. Finish any residual jobs - run manual maintenance runJobs from cd ~/public_html/clubwiki/ directory: /opt/cpanel/ea-php72/root/usr/bin/php maintenance/runJobs.php --maxjobs 1000

Site Maintenance

Cleanup after a spam/vandalism battle

1. cd to cd ~/public_html/clubwiki/ directory (the one with LocalSettings.php)
2. Delete archived revisions (deleted page revisions) /opt/cpanel/ea-php72/root/usr/bin/php maintenance/deleteArchivedRevisions.php for dry run, then execute /opt/cpanel/ea-php72/root/usr/bin/php maintenance/deleteArchivedRevisions.php --delete
3. Delete users older than 7 days with no edits /opt/cpanel/ea-php72/root/usr/bin/php maintenance/removeUnusedAccounts.php --ignore-touched 7 for dry run, then execute /opt/cpanel/ea-php72/root/usr/bin/php maintenance/removeUnusedAccounts.php --ignore-touched 7 --delete