Ch at 10:22, 29 November 2019

2019-11-29T10:22:00Z

New page

[[Raspberry Pi|⇐ Raspberry Pi]]

''27 November 2019, BradnorRP1''

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

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

==Install new version==
::[[https://www.mediawiki.org/wiki/Manual:Upgrading https://www.mediawiki.org/wiki/Manual:Upgrading]]
:Download and extract latest version of mediawiki
::::<tt>$ 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</tt>
:Copy some files, such as images, config and logos
::::<tt>$ 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/</tt>
:::::and some security stuff
::::<tt>$ sudo find ./images -type d -exec chmod 755 {} \;
::::$ sudo chgrp -R www-data /var/lib//mediawiki-1.33.1/images</tt>
:download and install latest versions of extensions
::namely PDFEmbed, UserMerge, Elastica, Cirrussearch (''note: not got working yet'')
:make the new folder the distribution
::::<tt>$ sudo ln -sfn /var/lib/mediawiki-1.33.1 /var/lib/mediawiki</tt>

==Configure new version==
:Modify LocalSettings to deprecate
::::<tt>$ sudo emacs /etc/mediawiki/LocalSettings.php</tt>
::::*comment out the line <tt>require_once "$IP/includes/PlatformSettings.php";</tt>
::::*and change <tt>$wgScriptPath</tt> to be <tt>bradnorwiki-new</tt>
::::* change <tt>require_once "/var/security/db.1.31.4.php";</tt> to <tt>require_once "/var/security/db.php";</tt>
:Run update script
::::<tt>$ sudo cd /var/lib/mediawiki
::::$ sudo php maintenance/update.php</tt>
:::::note that might have to all privileges to database for mediawiki
:update symlink in web directory
::::<tt>$ sudo ln -sfn /var/lib/mediawiki.1.33.1 /var/www/html/bradnorwiki-new</tt>
:Edit apache config
::::<tt>$ sudo emacs /etc/apache2/conf-enabled/mediawiki.conf</tt>
:::::and update or add <tt>setenv MW_INSTALL_PATH /var/lib/mediawiki.1.33.1</tt>
::restart apache
::::<tt>$ sudo systemctl restart apache2</tt>
: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
::<tt>$ sudo ln -sfn /var/lib/mediawiki /var/www/html/bradnorwiki</tt>

Upgrade Mediawiki to v1.33.1 - Revision history

Ch at 10:22, 29 November 2019