Bradnor

Upgrade Mediawiki to v1.33.1

⇐ Raspberry Pi

27 November 2019, BradnorRP1

Current situation

Current version was v1.31.4 as installed by apt-get install mediawiki.
This version is mainly installed under /usr/share/mediawiki with symlinks from $IP (set from MW_INSTALL_PATH, default /var/lib/mediawiki) except the cache, config, extensions and images directories, which are directly under $IP
Latest version, v1.33.x not available by this means
so downloaded from mediawiki.org.
v1.33.1 is directly installed under $IP, i.e. /var/lib/mediawiki

Backup and modify current version

Put up warning that wiki is old version
In wiki modify 'Main_Page' with warning at start of the form
==<span style="color:red">Warning!! :: this is 192.168.192.201 Mediawiki <small>v</small>1.31.4</span>==
and maybe alter logo at /var/lib/mediawiki/resources/assets/bradnor-logo.png
Backup and restore wiki database
$ sudo automysqlbackup
and copy locally and extract
$ sudo cp /var/lib/automysqlbackup/daily/bradnor/bradnor_2019-11-27_16h55m.Wednesday.sql.gz .
$ sudo chown ch:ch ./bradnor_2019-11-27_16h55m.Wednesday.sql.gz
$ gunzip ./bradnor_2019-11-27_16h55m.Wednesday.sql.gz
edit the sql file to change the hardcoded database reference
$ emacs ./bradnor_2019-11-27_16h55m.Wednesday.sql
and change the CREATE DATABASE and USE statements to reference a different database 'bradnor1314'
restore database to new database
$ cat bradnor_2019-11-27_16h55m.Wednesday.sql | sudo mysql
and set privileges
$ sudo mysql
GRANT SELECT,CREATE,UPDATE,DELETE ON bradnor1314.* TO 'mediawiki'@'localhost';
Advertise Bradnorwiki as being under maintenance by redirecting symlink in web directory to holding page
$ sudo ln -sf /var/www/html/bradnorwiki-maintenence /var/www/html/bradnorwiki
Ensure current version can run from 'non-standard' directory name, i.e. .../mediawiki.1.31.4
Move installation directory to new name
$ sudo mv /var/lib/mediawiki /var/lib/mediawiki.1.31.4
edit soft link from web directory
$ sudo ln -sfn /var/lib/mediawiki.1.31.4 /var/www/html/bradnorwiki-old
edit LocalSettings
rename LocalSettings file and update symlink
$ sudo mv /etc/mediawiki/LocalSettings.php /etc/mediawiki/LocalSettings.1.31.4.php
$ sudo ln -sf /etc/mediawiki/LocalSettings.1.31.4.php /var/lib/mediawiki.1.31.4/LocalSettings.php
$ sudo emacs /etc/mediawiki/LocalSettings.1.31.4.php
and change $wgScriptPath to be /bradnorwiki-old
change database login in LocalSettings
$ sudo cp -a /var/security/db.php /var/security/db.1.31.4.php
$ sudo emacs /var/security/db.1.31.4.php
and change $wgDBname = "bradnor"; to $wgDBname = "bradnor1314";
and edit
$ sudo emacs /etc/mediawiki/LocalSettings.1.31.4.php
and change require_once "/var/security/db.php"; to require_once "/var/security/db.1.31.4.php";
Edit apache config
$ sudo emacs /etc/apache2/conf-enabled/mediawiki.conf
and update or add setenv MW_INSTALL_PATH /var/lib/mediawiki.1.31.4
restart apache
$ sudo systemctl restart apache2

Install new version

[https://www.mediawiki.org/wiki/Manual:Upgrading]
Download and extract latest version of mediawiki
$ cd tmp
$ wget https://releases.wikimedia.org/mediawiki/1.33/mediawiki-1.33.1.tar.gz
$ tar -xvzf ./mediawiki-1.33.1.tar.gz
$ rm ./mediawiki-1.33.1.tar.gz
$ mv ./mediawiki-1.33.1 ./mediawiki-1.33.1
Copy some files, such as images, config and logos
$ sudo cp -a /etc/mediawiki/LocalSettings.1.31.4.php /etc/mediawiki/LocalSettings.1.33.1.php
$ sudo ln -s /etc/mediawiki/LocalSettings.1.33.1.php /etc/mediawiki/LocalSettings.php
$ sudo ln -s /etc/mediawiki/LocalSettings.php var/lib/mediawiki-1.33.1/LocalSettings.php
$ sudo cp -a /var/lib/mediawiki.1.31.4/resources/assets/bradnor-logo.png /var/lib/mediawiki-1.33.1/resources/assets/
$ sudo cp /var/lib/mediawiki.1.31.4/robots.txt /var/lib/mediawiki-1.33.1/
$ sudo cp -a /var/lib/mediawiki.1.31.4/images/. /var/lib/mediawiki-1.33.1/images/
and some security stuff
$ sudo find ./images -type d -exec chmod 755 {} \;
$ sudo chgrp -R www-data /var/lib//mediawiki-1.33.1/images
download and install latest versions of extensions
namely PDFEmbed, UserMerge, Elastica, Cirrussearch (note: not got working yet)
make the new folder the distribution
$ sudo ln -sfn /var/lib/mediawiki-1.33.1 /var/lib/mediawiki

Configure new version

Modify LocalSettings to deprecate
$ sudo emacs /etc/mediawiki/LocalSettings.php
  • comment out the line require_once "$IP/includes/PlatformSettings.php";
  • and change $wgScriptPath to be bradnorwiki-new
  • change require_once "/var/security/db.1.31.4.php"; to require_once "/var/security/db.php";
Run update script
$ sudo cd /var/lib/mediawiki
$ sudo php maintenance/update.php
note that might have to all privileges to database for mediawiki
update symlink in web directory
$ sudo ln -sfn /var/lib/mediawiki.1.33.1 /var/www/html/bradnorwiki-new
Edit apache config
$ sudo emacs /etc/apache2/conf-enabled/mediawiki.conf
and update or add setenv MW_INSTALL_PATH /var/lib/mediawiki.1.33.1
restart apache
$ sudo systemctl restart apache2
Test
Browse to 192.168.192.201/bradnorwiki-new
Check Version page for version and installed extensions
Browse to check if everything is OK
Edit Main_Page to remove warning

Finish

Bring Bradnorwiki online by redirecting symlink in web directory
$ sudo ln -sfn /var/lib/mediawiki /var/www/html/bradnorwiki
Retrieved from "https://bradnor.ddns.net/bradnorwiki/index.php?title=Upgrade_Mediawiki_to_v1.33.1&oldid=1208"