Help:Wiki Administration

Upgrading & Testing after upgrade

YWAMKnowledgeBase:MediaWikiUpgradeTestPlan

Check databases
mysqlcheck -uroot -p --optimize --all-databases Optimise and check databases. --repair to repair.

Backup wikidatabase
Assuming your mysql is set up with a root user and assuming your wikidb is called wikidb then

mysqldump -u root -p --opt -v --databases wikidb > wikidb.sql

Will dump the wiki to a file ready for importing. (Wiki sql file is 6 mb as of 6/3/2007)

Importing is done with

mysql wikidb -u root -p -v < wikidb.sql

Upgrading from MW 1.19 to 1.23
in Progress ...

Done:

 * Database backup (to home dir)
 * Extract new version
 * Run php maintenance/update.php
 * Update extensions
 * CreateBox
 * ConfirmEdit (yes, captcha works)
 * UserMerge
 * Minor Skin changes
 * wikibits.js: Uncaught ReferenceError: mediaWiki is not defined
 * EmbedVideo (new version needs PHP 5.4!)

ToDo:

 * Update extensions
 * Try Maps (can't find a page that is using it)
 * NewestPagesBlog.php (now disabled, doesn't work Call to undefined method SpecialPage::SpecialPage and doesn't seem to be used.)
 * Skin changes
 * Style login page
 * Style Outline ol
 * ? Recent Changes: Collapse legend by default

Migrating to another server and upgrading to MW1.9.1
Upgrading was painless and migrating the sql was not too hard either

STOP! UPGRADE notes in WM 1.9.1 tar ball say this: * May need to upgrade to utf-8 Among other changes, note that Latin-1 encoding (ISO-8859-1) is no longer supported. Latin-1 wikis will need to be upgraded to UTF-8; an experimental command-line upgrade helper script, 'upgrade1_5.php', can do this -- run it prior to 'update.php' or the web upgrader. Also see below Configuration changes

This explained why user white lists was not working! Also $wgNavigationLinks seems not to be working like before! Plus where did the logo go?! This answers it all:

Packages needed:
 * 1) mysql, php5, apache mod php5, php5 cli, imagemagick, xpdf (for pdf2text)
 * 2) squid

Process: $wgAllowExternalImages = true; $wgGroupPermissions['*']['edit'] = false; $wgShowIPinHeader = false; # don't want to see IP when not logged in
 * 1) stop webserver on old host
 * 2) backup db and transfer sql to new host and import
 * 3) copy old sskcwiki to new host (could change and change $wgScript to change the prefix as we are going live soon)
 * 4) back up Localsettings.php
 * 5) copy Adminsettings and add db root and pass
 * 6) cp MW 1.9.1 over sskcwiki dir
 * 7) permissions 777 over all files
 * 8) in maintainance run php update.php and php refreshLinks.php and rebuildImages.php (solves inline images not showing up problem
 * 9) remove Adminsettings?
 * 10) add to Localsettings.php
 * 1) test! and then set up Squid
 * 2) Navigation settings: Edit Mediawiki:Sidebar
 * 3) Finally change firewall so server points to new server not old
 * 4) decomission apache and mysql on old server
 * 5) Make sure apache knows it is serving pages to mail.ywambrussels.be or wiki.ywambrussels.be or new domain...

Notes:
 * 1) template images are odd - needed to enable $wg images from other sites thingy. It will be all confused until I know exactly what the server name is - but it is not hard to correct
 * 2) squid will need setting up again - its refresh needs reducing as users increase to ensure pages reflect current state
 * 3) Stats are looking odd! But this corrected itself later...!

Configuration changes from 1.4.x:
$wgDisableUploads has been replaced with $wgEnableUploads.

$wgWhitelistAccount has been replaced by the 'createaccount' permission key in $wgGroupPermissions. To emulate the old effect of setting: $wgWhitelistAccount['user'] = 0; set: $wgGroupPermissions['*']['createaccount'] = false;

$wgWhitelistEdit has been replaced by the 'edit' permission key. To emulate the old effect of setting: $wgWhitelistEdit = true; set: $wgGroupPermissions['*']['edit'] = false;

If $wgWhitelistRead is set, you must also disable the 'read' permission for it to take affect on anonymous users: $wgWhitelistRead = array( "Main Page", "Special:Userlogin" ); $wgGroupPermissions['*']['read'] = false;

Note that you can disable/enable several other permissions by modifying this configuration array in your LocalSettings.php; see DefaultSettings.php for the complete default permission set.

If using Memcached, you must enabled it differently now: $wgUseMemCached = true; should be replaced with: $wgMainCacheType = CACHE_MEMCACHED;

Customisations made

 * All the help files
 * All the wiki.png logo
 * Brown back ground
 * Templates
 * wikitable pretty table printing added to the Mediawiki:Common.css page.

To Add:
 * 1) Bible extension to replace the template (done)
 * 2) Citation extension
 * 3) page to pdf extension (done)