CRIN Trac: Ticket #5: Migrate MediaWiki from GreenQloud

hours changed; totalhours set

chris — Sat, 02 May 2015 14:02:19 GMT

hours changed from 0 to 2.51
totalhours set to 2.51

The ssh public key from Crin1 was added to the ~/.ssh/authorized_keys file on the server at wiki.crin.org and this was prefixed with the servers IP address to only allow it to be used from Crin1:

from="93.95.228.179" ssh-rsa AAAA...

The site is in /var/www/html/mw/mediawiki, so create a directory on Crin1 and rsync it:

sudo -i
mkdir /var/ww/mediawiki/w
rsync -av wiki:/var/www/html/mw/mediawiki/ /var/www/mediawiki/w/

Create a system account for mediawiki and chown the files that need to be writable:

adduser --system --disabled-password --disabled-login --group --home=/var/www/mediawiki mediawiki
  Warning: The home dir /var/www/mediawiki you specified already exists.
  Adding system user `mediawiki' (UID 114) ...
  Adding new group `mediawiki' (GID 119) ...
  Adding new user `mediawiki' (UID 114) with group `mediawiki' ...
  The home directory `/var/www/mediawiki' already exists.  Not copying from `/etc/skel'.
  adduser: Warning: The home directory `/var/www/mediawiki' does not belong to the user you are currently creating.
chown -R mediawiki:mediawiki /var/www/mediawiki/w/cache
chown -R mediawiki:mediawiki /var/www/mediawiki/w/images

Dump the MySQL database:

mysqldump -ucontent -pXXX mw > /root/mediawiki.sql

SCP it and create a new one to import it into:

scp wiki:mediawiki.sql /root/
mysql mysql
 mysql> CREATE DATABASE mediawiki;
 mysql> GRANT ALL ON mediawiki.* to 'mediawiki'@'localhost' identified by 'XXX';
 mysql> FLUSH PRIVILEGES;
cat /root/mediawiki.sql | mysql mediawiki

A script for syncing the site was created /root/bin/mediawiki-sync, it is set to omit the config file:

#!/bin/bash
# sync and chown the data
rsync -av --exclude "LocalSettings.php" wiki:/var/www/html/mw/mediawiki/ /var/www/mediawiki/w/
chown -R root:root /var/www/mediawiki/
chown -R mediawiki:mediawiki /var/www/mediawiki/w/cache
chown -R mediawiki:mediawiki /var/www/mediawiki/w/images
# dump and copy the database
ssh wiki "mysqldump -ucontent -pXXX mw > /root/mediawiki.sql"
scp wiki:mediawiki.sql /root/
# import the database
cat /root/mediawiki.sql | mysql mediawiki

The following things were changed in the LocalSettings.php config file:

## The protocol and server name to use in fully-qualified URLs
$wgServer = "https://wiki.crin1.crin.org";
/* $wgScriptPath       = "/mediawiki"; */
$wgScriptPath       = "/w";
$wgArticlePath      = "/wiki/$1";
/* $wgLogo             = "$wgStylePath/common/images/wiki.png"; */
$wgLogo             = "";
/* $wgDBserver         = "localhost";
 * $wgDBname           = "mw";
 * $wgDBuser           = "content";
 * $wgDBpassword       = "XXX";
**/
$wgDBserver         = "localhost";
$wgDBname           = "mediawiki";
$wgDBuser           = "mediawiki";
$wgDBpassword       = "XXX";
/* $wgCacheDirectory='D:/Html/LocalUser/userweb505/Html/mediawiki/cache/'; */
$wgCacheDirectory = "$IP/cache";
/* $wgRightsUrl = "http://wiki.crin.org/mediawiki/index.php?title=MediaWiki:Copyright"; */
$wgRightsUrl = "/wiki/MediaWiki:Copyright";

The following Apache config file was created at /etc/apache2/sites-available/mediawiki.conf:

<VirtualHost *:80>
        <IfModule mpm_itk_module>
                AssignUserID mediawiki mediawiki
                MaxClientsVHost 60
        </IfModule>
        ServerName wiki.crin.org
        ServerAlias www.wiki.crin.org
        ServerAlias wiki.crin1.crin.org
        <If "%{HTTP_HOST} == 'wiki.crin.org'">
                Redirect / https://wiki.crin.org/
        </If>
        <If "%{HTTP_HOST} == 'www.wiki.crin.org'">
                Redirect / https://wiki.crin.org/
        </If>
        <If "%{HTTP_HOST} == 'wiki.crin1.crin.org'">
                Redirect / https://wiki.crin1.crin.org/
        </If>
</VirtualHost>
<IfModule mod_ssl.c>
<VirtualHost *:443>
        <IfModule mpm_itk_module>
                AssignUserID mediawiki mediawiki
                MaxClientsVHost 60
        </IfModule>
        ServerName wiki.crin.org
        ServerAlias www.wiki.crin.org
        ServerAlias wiki.crin1.crin.org
        SSLEngine on
        SSLCertificateFile    /etc/ssl/gandi/wiki.crt.pem
        SSLCertificateKeyFile /etc/ssl/gandi/wiki.key.pem
        SSLCACertificateFile  /etc/ssl/gandi/root.pem
        SetEnv TMPDIR /var/www/mediawiki/tmp
        <Directory />
                Options FollowSymLinks
                AllowOverride None
                Require all denied
        </Directory>
        DocumentRoot /var/www/mediawiki
        <Directory /var/www/mediawiki>
                Options Indexes FollowSymLinks
                AllowOverride All
                Require all granted
		# http://www.mediawiki.org/wiki/Manual:Short_URL/Apache
                <IfModule mod_rewrite.c>
                        # Enable the rewrite engine
                        RewriteEngine On
                        # Short url for wiki pages
                        RewriteRule ^/?wiki(/.*)?$ /var/www/mediawiki/w/index.php [L]
                        # Ensure that old URL's still work
                        RewriteRule ^/?mediawiki(/.*)?$ /var/www/mediawiki/w/index.php [L]
                        # Redirect / to Main Page
                        RewriteRule ^/*$ /var/www/mediawiki/w/index.php [L]
                </IfModule>
        </Directory>
        <IfModule mod_php5.c>
                php_admin_value open_basedir /var/www/mediawiki
                php_admin_value upload_tmp_dir /var/www/mediawiki/tmp
                php_admin_value session.save_path /var/www/mediawiki/tmp
                php_admin_value file_uploads 1
        </IfModule>
        ErrorLog ${APACHE_LOG_DIR}/mediawiki.error.log
        # Possible values include: debug, info, notice, warn, error, crit,
        # alert, emerg.
        LogLevel warn
        CustomLog ${APACHE_LOG_DIR}/mediawiki.ssl_access.log combined
        <IfModule headers_module>
                # Use HTTP Strict Transport Security to force client to use secure connections only
                #Header always set Strict-Transport-Security "max-age=31536000; includeSubDomains"
                Header always set Strict-Transport-Security "max-age=31536000"
                # mitigate TIME attack
                Header always append X-Frame-Options "sameorigin"
        </IfModule>
        <FilesMatch "\.(cgi|shtml|phtml|php)$">
                SSLOptions +StdEnvVars
        </FilesMatch>
        <Directory /usr/lib/cgi-bin>
                SSLOptions +StdEnvVars
        </Directory>
        BrowserMatch "MSIE [2-6]" \
                nokeepalive ssl-unclean-shutdown \
                downgrade-1.0 force-response-1.0
        # MSIE 7 and newer should be able to use keepalive
        BrowserMatch "MSIE [17-9]" ssl-unclean-shutdown
</VirtualHost>
</IfModule>

Create and chown the TMPDIR:

mkdir /var/www/mediawiki/w/tmp
chown -R mediawiki:mediawiki /var/www/mediawiki/w/tmp

Generate a certificate CSR:

cd /etc/ssl/gandi
openssl req -nodes -newkey rsa:2048 -sha256 -keyout wiki.key.pem -out wiki.csr.pem

For testing the cert was set to the Trac one and then the Apache config was symlinked and tested:

cd /etc/apache2/sites-enabled
ln -s ../sites-available/mediawiki.conf 30-mediawiki.conf
apache2ctl configtest
  Syntax OK
service apache2 restart

The site was tested at https://wiki.crin1.crin.org/ and there was this error:

Children's Rights Wiki error

Set $wgShowExceptionDetails = true; at the bottom of LocalSettings.php to show detailed debugging information.

The errors in the Apache logs:

[Sat May 02 12:59:09.982784 2015] [:error] [pid 10281] [client X.X.X.X:36860] PHP Warning:  include(/var/www/mediawiki/w/extensions/MyExtension/MyExtension.i18n.php): failed to open stream: No such file or directory in /var/www/mediawiki/w/includes/LocalisationCache.php on line 405
[Sat May 02 12:59:09.982869 2015] [:error] [pid 10281] [client X.X.X.X:36860] PHP Warning:  include(): Failed opening '/var/www/mediawiki/w/extensions/MyExtension/MyExtension.i18n.php' for inclusion (include_path='/var/www/mediawiki/w:/var/www/mediawiki/w/includes:/var/www/mediawiki/w/languages:.:/usr/share/php:/usr/share/pear') in /var/www/mediawiki/w/includes/LocalisationCache.php on line 405
[Sat May 02 12:59:09.986350 2015] [:error] [pid 10281] [client X.X.X.X:36860] PHP Warning:  dba_open(/var/www/mediawiki/w/cache/l10n_cache-en.cdb.tmp.132944312): failed to open stream: Permission denied in /var/www/mediawiki/w/includes/Cdb.php on line 121

So, enabled debugging and got an error regarding the cache not being writable, so:

chown -R mediawiki:mediawiki /var/www/mediawiki/w/cache

Get the logo and favicon:

cd /var/www/mediawiki
wget https://www.crin.org/favicon.ico
wget https://www.crin.org/sites/default/themes/crin/images/logo.gif
chown mediawiki:mediawiki favicon.ico
chown mediawiki:mediawiki logo.gif

And the site was tested at https://wiki.crin1.crin.org/wiki/Main_Page

And images and page content was missing...

However if you view source the content is there, for example: https://wiki.crin1.crin.org/w/index.php?title=Main_Page&action=edit

The Gandi SSL/TLS cert was installed.

The config files was changed from DOS format:

aptitude install dos2unix
dos2unix LocalSettings.php
  dos2unix: converting file LocalSettings.php to Unix format ...

Trying the run the database upgrade script:

su - mediawiki -s /bin/bash
cd ~/w/maintenance
php update.php

Generated these errors:

PHP Notice:  Undefined index: HTTP_USER_AGENT in /var/www/mediawiki/w/extensions/FCKeditor/fckeditor/fckeditor_php5.php on line 37
PHP Notice:  Undefined index: REMOTE_ADDR in /var/www/mediawiki/w/extensions/FormMailer.php on line 53
PHP Warning:  include(/var/www/mediawiki/w/extensions/MyExtension/MyExtension.i18n.php): failed to open stream: No such file or directory in /var/www/mediawiki/w/includes/LocalisationCache.php on line 405
PHP Warning:  include(): Failed opening '/var/www/mediawiki/w/extensions/MyExtension/MyExtension.i18n.php' for inclusion (include_path='/var/www/mediawiki/w:/var/www/mediawiki/w/includes:/var/www/mediawiki/w/languages:.:/usr/share/php:/usr/share/pear') in /var/www/mediawiki/w/includes/LocalisationCache.php on line 405

Also this link was suggested via the ircs://irc.freenode.net/mediawiki channel:

https://www.mediawiki.org/wiki/Manual:Errors_and_symptoms#All_pages_have_no_content.2C_but_when_editing_a_page_the_wiki_text_is_there

Which says:

This is caused by a change in PCRE 8.34. You need to downgrade PCRE, or update MediaWiki to version 1.22.1 or newer (see Task T60640).

So I think we might be forced to upgrade MediaWiki, the current versions are 1.24.2 (LTS) and 1.23.9 and we are on 1.16.0...

hours, totalhours changed

chris — Sat, 02 May 2015 15:36:35 GMT

hours changed from 0 to 1
totalhours changed from 2.51 to 3.51

Regarding this error:

PHP Warning:  include(/var/www/mediawiki/w/extensions/MyExtension/MyExtension.i18n.php): failed to open stream: No such file or directory in /var/www/mediawiki/w/includes/LocalisationCache.php on line 405
PHP Warning:  include(): Failed opening '/var/www/mediawiki/w/extensions/MyExtension/MyExtension.i18n.php' for inclusion (include_path='/var/www/mediawiki/w:/var/www/mediawiki/w/includes:/var/www/mediawiki/w/languages:.:/usr/share/php:/usr/share/pear') in /var/www/mediawiki/w/includes/LocalisationCache.php on line 405

That directory contains:

-rwxr-xr-x  1 root root  222 Aug 28  2014 MyExtension.il8n.php
-rwxr-xr-x  1 root root 1.1K Aug 28  2014 MyExtension.php
-rwxr-xr-x  1 root root 2.4K Aug 28  2014 SpecialMyExtension.php

So perhaps a symlink will solve this (it looks like a typo confusing a lowercase l with a 1):

ln -s MyExtension.il8n.php MyExtension.i18n.php

And that did solve this issue.

Trying an upgrade to the LTS version:

cd /var/www/
wget https://releases.wikimedia.org/mediawiki/1.23/mediawiki-1.23.9.tar.gz
wget https://releases.wikimedia.org/mediawiki/1.23/mediawiki-1.23.9.tar.gz.sig
gpg --verify mediawiki-1.23.9.tar.gz.sig
  gpg: assuming signed data in `mediawiki-1.23.9.tar.gz'
  gpg: Signature made Tue 31 Mar 2015 05:57:22 PM GMT using DSA key ID 62D84F01
  gpg: Can't check signature: public key not found
gpg --search-key 62D84F01
  gpg: searching for "62D84F01" from hkp server keys.gnupg.net
  (1)     Chris Steipp <csteipp@wikimedia.org>
            2048 bit DSA key 62D84F01, created: 2012-08-30, expires: 2016-08-29
  Keys 1-1 of 1 for "62D84F01".  Enter number(s), N)ext, or Q)uit > 1
  gpg: requesting key 62D84F01 from hkp server keys.gnupg.net
  gpg: key 62D84F01: public key "Chris Steipp <csteipp@wikimedia.org>" imported
  gpg: no ultimately trusted keys found
  gpg: Total number processed: 1
  gpg:               imported: 1
gpg --verify mediawiki-1.23.9.tar.gz.sig
  gpg: assuming signed data in `mediawiki-1.23.9.tar.gz'
  gpg: Signature made Tue 31 Mar 2015 05:57:22 PM GMT using DSA key ID 62D84F01
  gpg: Good signature from "Chris Steipp <csteipp@wikimedia.org>"
  gpg: WARNING: This key is not certified with a trusted signature!
  gpg:          There is no indication that the signature belongs to the owner.
  Primary key fingerprint: 1624 32D9 E81C 1C61 8B30  1EEC EE1F 6634 62D8 4F01
tar -zxvf mediawiki-1.23.9.tar.gz
rsync -av mediawiki-1.23.9/ mediawiki/w/
su - mediawiki -s /bin/bash
cd ~/w/maintenance
php update.php
  PHP Notice:  Undefined index: HTTP_USER_AGENT in /var/www/mediawiki/w/extensions/FCKeditor/fckeditor/fckeditor_php5.php on line 37
  PHP Fatal error:  Call to undefined function wfLoadExtensionMessages() in /var/www/mediawiki/w/extensions/DiscussionThreading/DiscussionThreading.php on line 54

So disabling the DiscussionThreading extension by commenting this from LocalSettings.php:

/* require_once("$IP/extensions/DiscussionThreading/DiscussionThreading.php"); */

And now the updater runs OK, but the site generates an error and with debugging on the message is:

[8c81b080] / Exception from line 1318 of /var/www/mediawiki/w/includes/cache/LocalisationCache.php: Unable to open CDB file for write "/var/www/mediawiki/w/cache/l10n_cache-en.cdb"

So:

rm -rf /var/www/mediawiki/w/cache/*.*
chown mediawiki:mediawiki /var/www/mediawiki/w/cache -R

And now we get a 500 error and this in the logs:

[Sat May 02 14:48:39.337197 2015] [:error] [pid 11930] [client X.X.X.X:37442] PHP Fatal error:  Call to undefined method Parser::strip() in /var/www/mediawiki/w/extensions/FCKeditor/FCKeditor.body.php on line 130

So, disable that old and un-supported extension (the new VisualEditor would be a better one to use) by commenting out these lines:

/* require_once("$IP/extensions/FCKeditor/FCKeditor.php"); */

Reload and another 500 error, with this in the Apache logs:

[Sat May 02 14:51:40.772447 2015] [:error] [pid 11970] [client X.X.X.X:37444] PHP Warning:  A skin using autodiscovery mechanism, Standard, was found in your skins/ directory. The mechanism will be removed in MediaWiki 1.25 and the skin will no longer be recognized. See https://www.mediawiki.org/wiki/Manual:Skin_autodiscovery for information how to fix this. [Called from Skin::getSkinNames in /var/www/mediawiki/w/includes/Skin.php at line 74] in /var/www/mediawiki/w/includes/debug/Debug.php on line 303
[Sat May 02 14:51:40.780890 2015] [:error] [pid 11970] [client X.X.X.X:37444] PHP Fatal error:  Call to undefined function wfLoadExtensionMessages() in /var/www/mediawiki/w/extensions/UsabilityInitiative/Vector/Vector.hooks.php on line 98

So, following the https://www.mediawiki.org/wiki/Manual:Skin_autodiscovery#Migration_guide and noting that the LocalSettings.php specifies vector:

$wgDefaultSkin = 'vector';

I think deleting the skins directory and using the new one might solve this.

rm -rf /var/www/mediawiki/w/skins/
cp -a /var/www/mediawiki-1.23.9/skins/ /var/www/mediawiki/w/

We still have:

==> /var/log/apache2/mediawiki.error.log <==
[Sat May 02 14:58:35.087352 2015] [:error] [pid 12051] [client X.X.X.X:37470] PHP Fatal error:  Call to undefined function wfLoadExtensionMessages() in /var/www/mediawiki/w/extensions/UsabilityInitiative/Vector/Vector.hooks.php on line 98

So commenting that extension from the LocalSettings.php file as it isn't a current extension, see https://www.mediawiki.org/wiki/Extension:UsabilityInitiative :

/* require_once( "$IP/extensions/UsabilityInitiative/Vector/Vector.php" ); */

And the site is working but now with the default Vector skin.

The copyright and main logo were sorted out.

And the site is usable, but I'd strongly suggest an update of the extensions and installation of parsoid so the new VisualEditor can be used.

hours, totalhours changed

chris — Sat, 02 May 2015 16:24:58 GMT

hours changed from 0 to 0.25
totalhours changed from 3.51 to 3.76

Checking that old URL's such as these:

Will all still work:

And they do thanks to these rules:

        # Ensure that old URL's still work
        <If "%{HTTP_HOST} == 'wiki.crin.org'">
                RedirectMatch "/mediawiki/index.php(.*)" "https://wiki.crin.org/wiki$1"
                RedirectMatch "/mediawiki/api.php(.*)"   "https://wiki.crin.org/w/api.php$1"
                RedirectMatch "/mediawiki/load.php(.*)"  "https://wiki.crin.org/w/load.php$1"
                Redirect "/mediawiki/" "https://wiki.crin.org/w/"
        </If>
        <If "%{HTTP_HOST} == 'www.wiki.crin.org'">
                RedirectMatch "/mediawiki/index.php(.*)" "https://www.wiki.crin.org/wiki$1"
                RedirectMatch "/mediawiki/api.php(.*)"   "https://www.wiki.crin.org/w/api.php$1"
                RedirectMatch "/mediawiki/load.php(.*)"  "https://www.wiki.crin.org/w/load.php$1"
                Redirect "/mediawiki/" "https://www.wiki.crin.org/w/"
        </If>
        <If "%{HTTP_HOST} == 'wiki.crin1.crin.org'">
                RedirectMatch "/mediawiki/index.php(.*)" "https://wiki.crin1.crin.org/wiki$1"
                RedirectMatch "/mediawiki/api.php(.*)"   "https://wiki.crin1.crin.org/w/api.php$1"
                RedirectMatch "/mediawiki/load.php(.*)"  "https://wiki.crin1.crin.org/w/load.php$1"
                Redirect "/mediawiki/" "https://wiki.crin1.crin.org/w/"
        </If>

hours, totalhours changed

chris — Sun, 03 May 2015 11:06:53 GMT

hours changed from 0 to 1
totalhours changed from 3.76 to 4.76

Issues with the migrated MediaWiki site

In addition to the customisation to the theme being lost (is this an issue, the only key difference I can see is that the "Q&A", "Contact Us" and "Home" tabs have been lost and I expect these could be restored if needs be) there are the following plugins which should be updated, removed or replaced.

You can get a list of the plugins on the live site at http://wiki.crin.org/mediawiki/index.php/Special:Version and for the new site at https://wiki.crin1.crin.org/wiki/Special:Version

ConfirmAccount

The site is running an unknown version, it should probably be upgraded as there are different config option for MediaWiki > 1.19, see: https://www.mediawiki.org/wiki/Extension:ConfirmAccount

ContactPage

The site is running an unknown version:

Upgrading from versions < 2.x (MediaWiki ≤ 1.22) to versions ≥ 2.x (MediaWiki ≥ 1.23) requires a complete reconfiguration of this extension in "LocalSetting.php" to avoid breakage.

https://www.mediawiki.org/wiki/Extension:ContactPage

This should be upgraded if it is still needed.

MyExtension

This looks like a MediaWiki plugin which has been written especially for CRIN?

Password Reset

We have version 1.7.

In MW 1.18 and above, a special page "PasswordReset" exists which overrides the special page of this extension. This means this extension no longer works from 1.18 on.

https://www.mediawiki.org/wiki/Extension:Password_Reset

This extension should be removed and replaced with something else if it provided functionality that MediaWiki doesn't already provide (there is now a password reset feature available).

Cite

Starting with MediaWiki 1.25 the "Special:Cite" extension that used to be documented on this page too is no longer part of the "Cite" extension. When upgrading from MediaWiki 1.24 the following line will have to be removed from your "LocalSettings.php" file:

require_once "$IP/extensions/Cite/SpecialCite.php";

The "Special:Cite" extension is now know as the CiteThisPage extension and may be installed separately.

We are running the LTS version, 1.23.9 so the above will have an impact when upgrading to the next LTS version, in the meantime this extension should probably upgraded -- we have an unknown version.

EmailForm

We have version 0.8a, latest version is 0.81, it has been unmaintained since 2009, I'd suggest removing this extension and replacing it with something else if needs be:

This extension stores its source code on a wiki page. Please be aware that this code may be unreviewed or maliciously altered. They may contain security holes, outdated interfaces that are no longer compatible etc.

https://www.mediawiki.org/wiki/Extension:EmailForm

Google Calender

We have an unknown version and the URL for the extension no longer resolves:

http://wiki.couchsurfing.com/en/Google_Calendar_MediaWiki_plugin

We should invistigate what this plugin was used for and if it is needed and if so what can replace it, or simply remove it.

RSS Reader

We have version 0.2.5, latest version from 2012 is 0.2.6:

This extension stores its source code on a wiki page. Please be aware that this code may be unreviewed or maliciously altered. They may contain security holes, outdated interfaces that are no longer compatible etc.

https://www.mediawiki.org/wiki/Extension:RSS_Reader

We should find which pages, if any, are pulling in RSS feeds and decide if this functionality is still needed and if a maintained extension can be used to replace it.

SelectCategory

We are running version 0.7dev, the latest version is 0.8.2, this extension should be upgraded, see https://www.mediawiki.org/wiki/Extension:SelectCategory

TreeAndMenu

We are running version 1.1.1, 2009-07-29, the latest version is 4.1.1 (2015-04-28), this extension should be upgraded, see https://www.mediawiki.org/wiki/Extension:TreeAndMenu

Boilerplate

We are running an unknown version, the latest version is from 2007:

This extension is currently not actively maintained!

This extension stores its source code on a wiki page. Please be aware that this code may be unreviewed or maliciously altered.

Several users have reported bugs with this extension related to unmodifiable headers, please see the discussion tab for details.

https://www.mediawiki.org/wiki/User:RouslanZenetl/Extension:Boilerplate

We should decide if this is needed and if it is if another extension can be used instead.

BoilerPlateSelection

We are running an unknown version, this extension hasn't been updated since 2007.

This extension stores its source code on a wiki page. Please be aware that this code may be unreviewed or maliciously altered. https://www.mediawiki.org/wiki/Extension:BoilerplateSelection

We should decide if this is needed and what could replace it, if it is needed.

FormMailer

We are running version 1.0.3, 2011-01-02, which is the latest version, note that the author of the extsnsion said in 2009:

Personally I don't use SimpleForms anymore, it has too many problems and is too difficult to maintain

https://www.mediawiki.org/wiki/Extension_talk:FormMailer#I_need_help_with_this

We should find where this extension is used and decide if it's still needed and if it is what can replace it.

MultiBoilerplate

We are running 1.8.0, the latest version is 2.0.0 but this is only for > 1.24 and we are on 1.23 so this should only be upgraded when we upgrade MediaWiki to the next LTS version.

DiscussionThreading

This was disabled due to problems, we were running Version 1.3, the latest version is 1.5.0, we should decide if this is needed and install it, if it is needed (I don't see any evidence of the discussion pages being used at all, never mind needing threading).

FCKeditor

This was disabled due to problems, it was Version 1.0.1, if a WYSIWYG editor is needed we should install Parsiod and the new VisualEditor, see:

Preloader

We are running Version 1.1.1, the latest version, from 2011, is 1.2.0:

This extension is currently not actively maintained!

https://www.mediawiki.org/wiki/Extension:Preloader

We should decide if this extension in still needed.

UsabilityInitiative

We are running Version 0.1.1:

This extension has been archived.

The components of this extension have all now been moved out to their own extensions.

ClickTracking
PrefSwitch
PrefStats
UserDailyContribs
Vector
WikiEditor
https://www.mediawiki.org/wiki/Extension:UsabilityInitiative

This extension should probably be removed and the extensions above installed if any functionality from it is still needed.

Vector

We had Version 0.2.0, this appears to have been superceeded when the Vector skin became the default some years ago.

WikiEditor

We have Version 0.2.0:

This extension is bundled with MediaWiki 1.18 and above. Thus you do not have to download it again.

https://www.mediawiki.org/wiki/Extension:WikiEditor

hours, estimatedhours, totalhours changed

chris — Thu, 07 May 2015 11:20:00 GMT

hours changed from 0 to 0.05
estimatedhours changed from 0 to 8
totalhours changed from 4.76 to 4.81

So far 4h 45m has been spent on this ticket, resolving the issues with extensions documented at ticket:5#comment:4 and potentially installing a Parsoid server for the new VisualEditor (assuming we want WYSIWYG editing) could take quite a few more hours, setting the estimated time to 8 hours in total.

cc changed

chris — Mon, 11 May 2015 08:55:09 GMT

cc graham added

Adding Graham as a CC for this ticket.

cc changed

chris — Thu, 04 Jun 2015 12:47:41 GMT

cc adam jenny gillian added; graham removed

I have removed graham as a Cc for this ticket, see ticket:16 and added adam, gillian and jenny .

cc changed

chris — Fri, 12 Jun 2015 09:10:44 GMT

cc jonas adam removed

adam and jonas removed as CCs.

hours, totalhours changed

chris — Fri, 03 Jul 2015 11:00:29 GMT

hours changed from 0 to 0.25
totalhours changed from 4.81 to 5.06

I have just spent some time looking at the relationship between Drupal pages and MediaWiki pages, for example:

The Drupal page has a "Wiki link" field:

wiki link

The link will try and format itself but if this fails then you can overwrite the default here

http://wiki.crin.org/mediawiki/index.php?title=Burundi

And it looks like the quick facts might be pulled in from the Wiki site as this data isn't present when editing this page using Drupal.

jenny — Fri, 03 Jul 2015 11:30:05 GMT

Hi Chris,
the Quick facts and the persistent violations are not editable in Drupal
and are drawn from the Wiki as well as the text for the introduction. Can
you confirm that this will not be lost?
Thanks
On 3 July 2015 at 12:00, CRIN Trac <trac@trac.crin.org> wrote:
> #5: Migrate MediaWiki from GreenQloud
> -------------------------------------+-------------------------------------
>                  Reporter:  chris    |                Owner:  chris
>                      Type:  task     |               Status:  new
>                  Priority:  major    |            Milestone:  Install and
>                 Component:           |  configure crin1
>   mediawiki                          |              Version:
>                Resolution:           |             Keywords:
> Estimated Number of Hours:  8        |  Add Hours to Ticket:  0.25
>                 Billable?:  1        |          Total Hours:  4.81
> -------------------------------------+-------------------------------------
> Changes (by chris):
>
>  * hours:  0 => 0.25
>  * totalhours:  4.81 => 5.06
>
>
> Comment:
>
>  I have just spent some time looking at the relationship between [[Drupal]]
>  pages and MediaWiki pages, for example:
>
>  * https://www.crin.org/en/library/countries/burundi
>  * http://wiki.crin.org/mediawiki/index.php?title=Burundi
>
>  The Drupal page has a "Wiki link" field:
>
>  > wiki link
>  >
>  > The link will try and format itself but if this fails then you can
>  overwrite the default here
>  >
>  > http://wiki.crin.org/mediawiki/index.php?title=Burundi
>  And it looks like the
>  [https://www.crin.org/en/library/countries/burundi#barbox quick facts]
>  might be pulled in from the Wiki site as this data isn't present when
>  editing this page using Drupal.
>
> --
> Ticket URL: <https://trac.crin.org/trac/ticket/5#comment:9>
> CRIN Trac <https://trac.crin.org/trac>
> Trac project for CRIN website and servers.
>

hours, totalhours changed

chris — Fri, 03 Jul 2015 12:06:44 GMT

hours changed from 0 to 0.55
totalhours changed from 5.06 to 5.61

Replying to jenny:

the Quick facts and the persistent violations are not editable in Drupal and are drawn from the Wiki as well as the text for the introduction. Can you confirm that this will not be lost?

Looking at how this works, there is a module:

CRIN wiki pull

Module for populating county from wiki

This module is in /var/www/drupal/sites/default/modules/crinqp and these files contain the wiki URL:

crinqp.module:  $link = "http://wiki.crin.org/mediawiki/index.php?title=".$counrty;
crinqp.php:  $link = "http://wiki.crin.org/mediawiki/index.php?title=".$counrty;

So I would suggest that if the DNS was updated and above were changed to the following:

crinqp.module:  $link = "https://wiki.crin.org/wiki?title=".$counrty;
crinqp.php:  $link = "https://wiki.crin.org/wiki?title=".$counrty;

Then importing content should still work, assuming the import supports HTTPS, if it doesn't then the wiki could be changed so that content can be read over HTTP and HTTPS is only needed for editing.

However I'm not clear when the data is pulled in, is it when the Drupal country page is created, or edited or on a regular basis (so if the wiki is updated the Drupal site is automatically updated), looking at the dump of the Drupal database and searching for the string 8749400 (the population of Burundi) this value is present in the field_revision_field_population table and the field_data_field_population table.

The unknown issues above could be clarified through testing (for example change some values on the wiki to see if they update automatically) and / or you could ask Code Positive how exactly this works.

If I were you I'd keep the copy of the wiki on Crin1 and ask me to:

Make the copy of the wiki at https://wiki.crin1.crin.org/ available via HTTP for reading and HTTPS only for editing.
Update the DNS for wiki.crin.org so it points to Crin1 rather than the GreenQloud server.
Update the wiki URLs in crinqp.module and crinqp.php.
Update the wiki URLs in the Drupal database, perhaps using the Drush Search & Replace module.

After the above had been done the GreenQloud wiki server could be shutdown.

If however you want to get rid of the wiki site then if I were you I'd ask Code Positive:

Does the CRIN wiki pull module pull in content from the wiki at any time other when a new country is added to the Drupal site?
If the answer to 1, is no then how would we add a new country or update data for a country if the wiki site is shutdown?
If the answer to 1. is on a regular basis or when there are changes I think you might need to keep the wiki if you are not going to make changes to the way the Drupal country pages work.
If the answer to 2. is not simple then you would either need to update the Drupal code to remove the dependancy on the wiki or keep the wiki.

chris — Fri, 03 Jul 2015 12:34:58 GMT

Ideally the following would be first done on a dev server, so sorting out ticket:23 and then testing the relationship with the wiki and Drupal there would be the safest way to do things -- keep the GreenQloud wiki server running till these things have been tested and proven to work on dev before deploying to live.

Replying to chris:

If I were you I'd keep the copy of the wiki on Crin1 and ask me to:

Make the copy of the wiki at https://wiki.crin1.crin.org/ available via HTTP for reading and HTTPS only for editing.
Update the DNS for wiki.crin.org so it points to Crin1 rather than the GreenQloud server.
Update the wiki URLs in crinqp.module and crinqp.php.
Update the wiki URLs in the Drupal database, perhaps using the Drush Search & Replace module.
After the above had been done the GreenQloud wiki server could be shutdown.

jenny — Fri, 03 Jul 2015 14:40:03 GMT

Hi Chris,
Can we have a chat about this on Monday please?
Thanks,
Jenny
On 3 July 2015 at 13:06, CRIN Trac <trac@trac.crin.org> wrote:
> #5: Migrate MediaWiki from GreenQloud
> -------------------------------------+-------------------------------------
>                  Reporter:  chris    |                Owner:  chris
>                      Type:  task     |               Status:  new
>                  Priority:  major    |            Milestone:  Install and
>                 Component:           |  configure crin1
>   mediawiki                          |              Version:
>                Resolution:           |             Keywords:
> Estimated Number of Hours:  8        |  Add Hours to Ticket:  0.55
>                 Billable?:  1        |          Total Hours:  5.06
> -------------------------------------+-------------------------------------
> Changes (by chris):
>
>  * hours:  0 => 0.55
>  * totalhours:  5.06 => 5.61
>
>
> Comment:
>
>  Replying to [comment:10 jenny]:
>  >
>  > the Quick facts and the persistent violations are not editable in Drupal
>  > and are drawn from the Wiki as well as the text for the introduction.
>  Can
>  > you confirm that this will not be lost?
>
>  Looking at how this works, there is a
>  [https://www.crin.org/en/admin/modules module]:
>
>  > CRIN wiki pull
>  >
>  > Module for populating county from wiki
>
>  This module is in `/var/www/drupal/sites/default/modules/crinqp` and these
>  files contain the wiki URL:
>
>  {{{
>  crinqp.module:  $link =
>  "http://wiki.crin.org/mediawiki/index.php?title=".$counrty;
>  crinqp.php:  $link =
>  "http://wiki.crin.org/mediawiki/index.php?title=".$counrty;
>  }}}
>
>  So I would suggest that if the DNS was updated and above were changed to
>  the following:
>
>  {{{
>  crinqp.module:  $link = "https://wiki.crin.org/wiki?title=".$counrty;
>  crinqp.php:  $link = "https://wiki.crin.org/wiki?title=".$counrty;
>  }}}
>
>  Then importing content should still work, assuming the import supports
>  HTTPS, if it doesn't then the wiki could be changed so that content can be
>  read over HTTP and HTTPS is only needed for editing.
>
>  However I'm not clear when the data is pulled in, is it when the Drupal
>  country page is created, or edited or on a regular basis (so if the wiki
>  is updated the Drupal site is automatically updated), looking at the dump
>  of the Drupal database and searching for the string 8749400 (the
>  [https://www.crin.org/en/library/countries/burundi#barbox population of
>  Burundi]) this value is present in the `field_revision_field_population`
>  table and the `field_data_field_population` table.
>
>  The unknown issues above could be clarified through testing (for example
>  change some values on the wiki to see if they update automatically) and /
>  or you could ask Code Positive how exactly this works.
>
>  If I were you I'd keep the copy of the wiki on [[Crin1]] and ask me to:
>
>  1. Make the copy of the wiki at https://wiki.crin1.crin.org/ available
> via
>  HTTP for reading and HTTPS only for editing.
>  2. Update the DNS for `wiki.crin.org` so it points to [[Crin1]] rather
>  than the !GreenQloud server.
>  3. Update the wiki URLs in `crinqp.module` and `crinqp.php`.
>  4. Update the wiki URLs in the Drupal database, perhaps using the
>  [https://www.drupal.org/project/sar Drush Search & Replace module].
>
>  After the above had been done the !GreenQloud wiki server could be
>  shutdown.
>
>  If however you want to get rid of the wiki site then if I were you I'd ask
>  Code Positive:
>
>  1. Does the CRIN wiki pull module pull in content from the wiki at any
>  time other when a new country is added to the Drupal site?
>  2. If the answer to 1, is no then how would we add a new country or update
>  data for a country if the wiki site is shutdown?
>  3. If the answer to 1. is on a regular basis or when there are changes I
>  think you might need to keep the wiki if you are not going to make changes
>  to the way the Drupal country pages work.
>  4. If the answer to 2. is not simple then you would either need to update
>  the Drupal code to remove the dependancy on the wiki or keep the wiki.
>
> --
> Ticket URL: <https://trac.crin.org/trac/ticket/5#comment:11>
> CRIN Trac <https://trac.crin.org/trac>
> Trac project for CRIN website and servers.
>

chris — Fri, 03 Jul 2015 14:50:03 GMT

Hi
Sure, I should be in our office from 9:30am to 3pm
All the best
Chris
On Fri 03-Jul-2015 at 02:40:03PM -0000, CRIN Trac wrote:
>
> Comment (by jenny):
>
>  Can we have a chat about this on Monday please?

jenny — Fri, 03 Jul 2015 16:25:03 GMT

Hi Chris,
Can we say 10.30?
Have a good weekend,
Jenny
On 3 July 2015 at 15:47, Chris Croome <chris@webarchitects.co.uk> wrote:
> Hi
>
> Sure, I should be in our office from 9:30am to 3pm
>
> All the best
>
> Chris
>
> On Fri 03-Jul-2015 at 02:40:03PM -0000, CRIN Trac wrote:
> >
> > Comment (by jenny):
> >
> >  Can we have a chat about this on Monday please?
>

hours, totalhours changed

chris — Mon, 06 Jul 2015 13:20:47 GMT

hours changed from 0 to 1.15
totalhours changed from 5.61 to 6.76

TICKET SUMMURY: The https://wiki.crin.org/ site is now at 1984.is and the GreenQloud server can be shutdown (you could wait till tomorrow since the DNS will take some time to update, but this isn't critical).

Following a phone call with Jenny I have done the followiong to make the copy of the wiki at 1984.is available at wiki.crin.org.

Replying to chris:

Make the copy of the wiki at https://wiki.crin1.crin.org/ available via HTTP for reading and HTTPS only for editing.

I found that the login page was generating a 500 error due to the ConfirmAccount plugin not working so I commented that out in /var/www/mediawiki/w/LocalSettings.php and also disabled the public creation of accounts to stop spammers signing up for accounts:

//require_once("$IP/extensions/ConfirmAccount/SpecialConfirmAccount.php");
$wgGroupPermissions['*']['createaccount'] = false;

I updated the Apache config to:

<VirtualHost *:80>
        <IfModule mpm_itk_module>
                AssignUserID mediawiki mediawiki
                MaxClientsVHost 60
        </IfModule>
        ServerName  www.wiki.crin.org
        ServerAlias wiki.crin1.crin.org
        Redirect / http://wiki.crin.org/
</VirtualHost>
<VirtualHost *:80>
        <IfModule mpm_itk_module>
                AssignUserID mediawiki mediawiki
                MaxClientsVHost 60
        </IfModule>
        ServerName wiki.crin.org
        SetEnv TMPDIR /var/www/mediawiki/tmp
        <Directory />
                Options FollowSymLinks
                AllowOverride None
                Require all denied
        </Directory>
        DocumentRoot /var/www/mediawiki
        # Ensure that old URL's still work
        RedirectMatch "/mediawiki/index.php(.*)" "http://wiki.crin.org/wiki$1"
        RedirectMatch "/mediawiki/api.php(.*)"   "http://wiki.crin.org/w/api.php$1"
        RedirectMatch "/mediawiki/load.php(.*)"  "http://wiki.crin.org/w/load.php$1"
        Redirect "/mediawiki/" "http://wiki.crin.org/w/"
        <Directory /var/www/mediawiki>
                Options Indexes FollowSymLinks
                AllowOverride All
                Require all granted
                # http://www.mediawiki.org/wiki/Manual:Short_URL/Apache
                <IfModule mod_rewrite.c>
                        # Enable the rewrite engine
                        RewriteEngine On
                        # Short url for wiki pages
                        RewriteRule ^/?wiki(/.*)?$ /var/www/mediawiki/w/index.php [L]
                        # Redirect / to Main Page
                        RewriteRule ^/*$ /var/www/mediawiki/w/index.php [L]
                </IfModule>
        </Directory>
        <IfModule mod_php5.c>
                php_admin_value open_basedir /var/www/mediawiki
                php_admin_value upload_tmp_dir /var/www/mediawiki/tmp
                php_admin_value session.save_path /var/www/mediawiki/tmp
                php_admin_value file_uploads 1
        </IfModule>
        ErrorLog ${APACHE_LOG_DIR}/mediawiki.error.log
        # Possible values include: debug, info, notice, warn, error, crit,
        # alert, emerg.
        LogLevel warn
        CustomLog ${APACHE_LOG_DIR}/mediawiki.access.log combined
</VirtualHost>
<IfModule mod_ssl.c>
<VirtualHost *:443>
        <IfModule mpm_itk_module>
                AssignUserID mediawiki mediawiki
                MaxClientsVHost 60
        </IfModule>
        ServerName  www.wiki.crin.org
        ServerAlias wiki.crin1.crin.org
        SSLEngine on
        SSLCertificateFile    /etc/ssl/gandi/wiki.crt.pem
        SSLCertificateKeyFile /etc/ssl/gandi/wiki.key.pem
        SSLCACertificateFile  /etc/ssl/gandi/root.pem
        Redirect / https://wiki.crin.org/
</VirtualHost>
</IfModule>
<IfModule mod_ssl.c>
<VirtualHost *:443>
        <IfModule mpm_itk_module>
                AssignUserID mediawiki mediawiki
                MaxClientsVHost 60
        </IfModule>
        ServerName wiki.crin.org
        SSLEngine on
        SSLCertificateFile    /etc/ssl/gandi/wiki.crt.pem
        SSLCertificateKeyFile /etc/ssl/gandi/wiki.key.pem
        SSLCACertificateFile  /etc/ssl/gandi/root.pem
        SetEnv TMPDIR /var/www/mediawiki/tmp
        <Directory />
                Options FollowSymLinks
                AllowOverride None
                Require all denied
        </Directory>
        DocumentRoot /var/www/mediawiki
        # Ensure that old URL's still work
        <If "%{HTTP_HOST} == 'wiki.crin.org'">
                RedirectMatch "/mediawiki/index.php(.*)" "https://wiki.crin.org/wiki$1"
                RedirectMatch "/mediawiki/api.php(.*)"   "https://wiki.crin.org/w/api.php$1"
                RedirectMatch "/mediawiki/load.php(.*)"  "https://wiki.crin.org/w/load.php$1"
                Redirect "/mediawiki/" "https://wiki.crin.org/w/"
        </If>
        <If "%{HTTP_HOST} == 'www.wiki.crin.org'">
                RedirectMatch "/mediawiki/index.php(.*)" "https://www.wiki.crin.org/wiki$1"
                RedirectMatch "/mediawiki/api.php(.*)"   "https://www.wiki.crin.org/w/api.php$1"
                RedirectMatch "/mediawiki/load.php(.*)"  "https://www.wiki.crin.org/w/load.php$1"
                Redirect "/mediawiki/" "https://www.wiki.crin.org/w/"
        </If>
        <If "%{HTTP_HOST} == 'wiki.crin1.crin.org'">
                RedirectMatch "/mediawiki/index.php(.*)" "https://wiki.crin1.crin.org/wiki$1"
                RedirectMatch "/mediawiki/api.php(.*)"   "https://wiki.crin1.crin.org/w/api.php$1"
                RedirectMatch "/mediawiki/load.php(.*)"  "https://wiki.crin1.crin.org/w/load.php$1"
                Redirect "/mediawiki/" "https://wiki.crin1.crin.org/w/"
        </If>
        <Directory /var/www/mediawiki>
                Options Indexes FollowSymLinks
                AllowOverride All
                Require all granted
                # http://www.mediawiki.org/wiki/Manual:Short_URL/Apache
                <IfModule mod_rewrite.c>
                        # Enable the rewrite engine
                        RewriteEngine On
                        # Short url for wiki pages
                        RewriteRule ^/?wiki(/.*)?$ /var/www/mediawiki/w/index.php [L]
                        # Redirect / to Main Page
                        RewriteRule ^/*$ /var/www/mediawiki/w/index.php [L]
                </IfModule>
        </Directory>
        <IfModule mod_php5.c>
                php_admin_value open_basedir /var/www/mediawiki
                php_admin_value upload_tmp_dir /var/www/mediawiki/tmp
                php_admin_value session.save_path /var/www/mediawiki/tmp
                php_admin_value file_uploads 1
        </IfModule>
        ErrorLog ${APACHE_LOG_DIR}/mediawiki.error.log
        # Possible values include: debug, info, notice, warn, error, crit,
        # alert, emerg.
        LogLevel warn
        CustomLog ${APACHE_LOG_DIR}/mediawiki.ssl_access.log combined
        <IfModule headers_module>
                # Use HTTP Strict Transport Security to force client to use secure connections only
                #Header always set Strict-Transport-Security "max-age=31536000; includeSubDomains"
                Header always set Strict-Transport-Security "max-age=31536000"
                # mitigate TIME attack
                Header always append X-Frame-Options "sameorigin"
        </IfModule>
        <FilesMatch "\.(cgi|shtml|phtml|php)$">
                SSLOptions +StdEnvVars
        </FilesMatch>
        <Directory /usr/lib/cgi-bin>
                SSLOptions +StdEnvVars
        </Directory>
        BrowserMatch "MSIE [2-6]" \
                nokeepalive ssl-unclean-shutdown \
                downgrade-1.0 force-response-1.0
        # MSIE 7 and newer should be able to use keepalive
        BrowserMatch "MSIE [17-9]" ssl-unclean-shutdown
</VirtualHost>
</IfModule>

So now the site is available via HTTP.

Update the DNS for wiki.crin.org so it points to Crin1 rather than the GreenQloud server.

This has been done and and it should update soon.

Update the wiki URLs in crinqp.module and crinqp.php.

This has been done for /var/www/drupal/sites/default/modules/crinqp/crinqp.module:

  // updated by chris on 2015-07-06 see https://trac.crin.org/trac/ticket/5
  //$link = "http://wiki.crin.org/mediawiki/index.php?title=".$counrty;
  $link = "http://wiki.crin.org/wiki/".$counrty;

And for /var/www/drupal/sites/default/modules/crinqp/crinqp.php:

  // updated by chris on 2015-07-06 see https://trac.crin.org/trac/ticket/5
  //$link = "http://wiki.crin.org/mediawiki/index.php?title=".$counrty;
  $link = "http://wiki.crin.org/wiki/".$counrty;

Update the wiki URLs in the Drupal database, perhaps using the Drush Search & Replace module.

Install the Drupal module on Crin2:

cd /usr/local/src
wget https://ftp.drupal.org/files/projects/sar-7.x-1.0.tar.gz
tar -zxvf sar-7.x-1.0.tar.gz
mkdir -p /var/www/.drush/commands
cp -a sar /var/www/.drush/commands/

Backup the database on Crin1:

/usr/local/bin/backup-mysql

However the Dtupal search and replace module doesn't work:

su - www-data -s /bin/bash
cd drupal/
drush help sar
  Invalid command sar.                                                                             [error]
drush sql-cli
  ERROR 1045 (28000): Access denied for user 'drupal'@'crin2' (using password: YES)
drush sql-query "show tables"
  Query failed.                                                                                    [error]

See ticket:18 for the above problem.

So looking at doing this at a MySQL level, frirst fine which tables contain this data:

cd /var/backups/mysql/databases/drupal
grep "wiki.crin.org" -rli
field_data_field_wiki_link.sql
field_revision_body.sql
field_data_body.sql
field_revision_field_wiki_link.sql
field_revision_field_attachment_link.sql
field_data_field_attachment_link.sql
cache_entity_node.sql

The field_data_field_wiki_link and field_revision_field_wiki_link tables contains the links, so the dumps of these tables were edited and imported:

cd /var/backups/mysql/databases/drupal
cp field_data_field_wiki_link.sql field_data_field_wiki_link.sql.bak
cp field_revision_field_wiki_link.sql field_revision_field_wiki_link.sql.bak
vim field_data_field_wiki_link.sql field_revision_field_wiki_link.sql
  :1,$s;http://wiki.crin.org/mediawiki/index.php?title=;http://wiki.crin.org/wiki/;g
cat field_data_field_wiki_link.sql | mysql drupal
cat field_revision_field_wiki_link.sql | mysql drupal

I think that will do -- the links on the Drupal site haven't been updated, for example this link:

http://wiki.crin.org/mediawiki/index.php?title=Algeria

Exists on this page:

https://www.crin.org/en/library/countries/algeria

But a redirect is in place, eg:

lynx -dump -head "http://wiki.crin.org/mediawiki/index.php?title=Algeria" | grep Location
Location: http://wiki.crin.org/wiki?title=Algeria

So nobody should get a 404.

hours, totalhours changed

chris — Mon, 06 Jul 2015 17:01:12 GMT

hours changed from 0 to 0.05
totalhours changed from 6.76 to 6.81

I forgot to update /var/www/mediawiki/w/LocalSettings.php with the new server URL, this has now been done:

#$wgServer = "https://wiki.crin1.crin.org";
$wgServer = "https://wiki.crin.org";

hours, status, totalhours changed; resolution set

chris — Tue, 07 Jul 2015 09:21:05 GMT

hours changed from 0 to 0.1
status changed from new to closed
resolution set to fixed
totalhours changed from 6.81 to 6.91

The DNS for wiki.crin.org should have updated now, so the old server at GreenQloud can be shutdown / deleted, so closing this ticket because none of the MediaWiki plugin issues listed at ticket:5#comment:4 are to be fixed as the plan is to delete the wiki as soon as the Drupal dependencies have been removed by Code Positive.

Note that all the migration tickets are now closed, however, there might be a need to re-open the backup ticket.

status changed; resolution deleted

jenny — Tue, 07 Jul 2015 09:50:05 GMT

status changed from closed to reopened
resolution fixed deleted

Thanks Chris, we just need to download our MyGreenQloud files which we will do ourselves and then we can shut down.
J
Sent from my iPhone
> On 7 Jul 2015, at 10:21, CRIN Trac <trac@trac.crin.org> wrote:
>
> #5: Migrate MediaWiki from GreenQloud
> -------------------------------------+-------------------------------------
>                 Reporter:  chris    |                Owner:  chris
>                     Type:  task     |               Status:  closed
>                 Priority:  major    |            Milestone:  Install and
>                Component:           |  configure crin1
>  mediawiki                          |              Version:
>               Resolution:  fixed    |             Keywords:
> Estimated Number of Hours:  8        |  Add Hours to Ticket:  0.1
>                Billable?:  1        |          Total Hours:  6.81
> -------------------------------------+-------------------------------------
> Changes (by chris):
>
> * hours:  0 => 0.1
> * status:  new => closed
> * resolution:   => fixed
> * totalhours:  6.81 => 6.91
>
>
> Comment:
>
> The DNS for `wiki.crin.org` should have updated now, so the old server at
> !GreenQloud can be shutdown / deleted, so closing this ticket because none
> of the MediaWiki plugin issues listed at ticket:5#comment:4 are to be
> fixed as the plan is to delete the wiki as soon as the Drupal dependencies
> have been removed by Code Positive.
>
> Note that [https://trac.crin.org/trac/report/6 all the migration tickets
> are now closed], however, there might be a need to re-open
> [https://trac.crin.org/trac/ticket/11 the backup ticket].
>
> --
> Ticket URL: <https://trac.crin.org/trac/ticket/5#comment:18>
> CRIN Trac <https://trac.crin.org/trac>
> Trac project for CRIN website and servers.

hours, status, totalhours changed; resolution set

chris — Tue, 07 Jul 2015 09:54:50 GMT

hours changed from 0 to 0.02
status changed from reopened to closed
resolution set to fixed
totalhours changed from 6.91 to 6.93

The email from Jenny, ticket:5#comment:19, reopened this ticket, closing it again.