Mediawiki installation
Todo SemanticFormsInputs
An overview and record of strategies to install mediawiki the first time, and maintain and upgrade it. See also:
- Debian installation for the underlying server,
- Mediawiki on biowikifarm for a brief introduction to the present configuration/installation
- Mediawiki maintenance
- Mediawiki Development for links to software documentation etc.
Contents |
First time MediaWiki installation
1.18 Stable Version:
sudo mkdir /usr/share/mediawiki; cd /usr/share/mediawiki sudo apt-get install imagemagick librsvg2-2 librsvg2-bin # Checking out head revision for main and extensions sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/branches/REL1_18/phase3 sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/branches/REL1_18/extensions sudo chgrp www-data /usr/share/mediawiki/extensions/Widgets/compiled_templates; sudo chmod g+w /usr/share/mediawiki/extensions/Widgets/compiled_templates; sudo mkdir extensions-is-from-stable-release # A second checkout for extensions usable only in newest versions: sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/trunk/extensions ext-trunk sudo chgrp www-data /usr/share/mediawiki/ext-trunk/Widgets/compiled_templates; sudo chmod g+w /usr/share/mediawiki/ext-trunk/Widgets/compiled_templates; sudo mkdir ext-trunk-is-from-trunk-head # make the local biowikifarm checkout into ext-LOCAL-svn #### COMMAND missing here sudo mkdir ext-LOCAL-svn-is-in-biowikifarm-SVN--DO-NOT-EDIT-HERE sudo ln -s ./phase3/maintenance maintenance sudo mkdir maintenance-is-extra-link-for-ext-scripts # Some extensions have stable versions, do not integrate stable versions into the # the stable MW releases however. These handled separately: sudo mkdir ext-tagged-release cd /usr/share/mediawiki/ext-tagged-release sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/AdminLinks/REL_0_1_4 AdminLinks sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/ExternalData/REL_1_3_2 ExternalData sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/HeaderTabs/REL_0_8_3 HeaderTabs sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/Maps/REL_1_0_4 Maps sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/OpenID/REL_0_9 OpenID sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/PageObjectModel/REL_0_1_3 PageObjectModel sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/ReplaceText/REL_0_9_1 ReplaceText ## NOT SemanticCalendar - this is obsolete!!! sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/SemanticCompoundQueries/REL_0_3 SemanticCompoundQueries sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/SemanticDrilldown/REL_0_8_3 SemanticDrilldown sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/SemanticForms/REL_2_2_1 SemanticForms sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/SemanticFormsInputs/REL_0_4_1 SemanticFormsInputs sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/SemanticInternalObjects/REL_0_6_6 SemanticInternalObjects sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/SemanticMaps/REL_1_0_4 SemanticMaps sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/SemanticMediaWiki/REL_1_6_2 SemanticMediaWiki sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/SemanticResultFormats/REL_1_6_2 SemanticResultFormats sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/SemanticSignup/REL_0_3 SemanticSignup sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/SocialProfile/REL_1_3 SocialProfile sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/Validator/REL_0_4_9 Validator sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/tags/extensions/Widgets/REL_0_9_2 Widgets sudo chgrp www-data /usr/share/mediawiki/ext-tagged-release/Widgets/compiled_templates; sudo chmod g+w /usr/share/mediawiki/ext-tagged-release/Widgets/compiled_templates; # make symbolic links - STATUS: fully updated (removing obsolete, adding new) 2011-08 cd /usr/share/mediawiki/phase3/extensions sudo ln -s ../../extensions/APC sudo ln -s ../../extensions/ArticleFeedback sudo ln -s ../../extensions/AssertEdit sudo ln -s ../../extensions/CategoryTree sudo ln -s ../../extensions/CentralAuth sudo ln -s ../../extensions/CentralNotice sudo ln -s ../../extensions/CharInsert sudo ln -s ../../extensions/Cite sudo ln -s ../../extensions/ClickTracking # required for ArticleFeedback sudo ln -s ../../extensions/Collection sudo ln -s ../../extensions/ConditionalShowSection sudo ln -s ../../extensions/Configure sudo ln -s ../../extensions/ConfirmAccount sudo ln -s ../../extensions/ConfirmEdit sudo ln -s ../../extensions/ContactPage sudo ln -s ../../extensions/CrossNamespaceLinks sudo ln -s ../../extensions/DoubleWiki sudo ln -s ../../extensions/DumpHTML sudo ln -s ../../extensions/DynamicPageList sudo ln -s ../../extensions/EmailCapture # required for ArticleFeedback sudo ln -s ../../extensions/ExpandTemplates sudo ln -s ../../extensions/FCKeditor sudo ln -s ../../extensions/FlaggedRevs sudo ln -s ../../extensions/Gadgets sudo ln -s ../../extensions/GlobalUsage sudo ln -s ../../extensions/googleAnalytics sudo ln -s ../../extensions/GoogleMaps sudo ln -s ../../extensions/GraphViz sudo ln -s ../../extensions/ImageMap sudo ln -s ../../extensions/InputBox sudo ln -s ../../extensions/intersection sudo ln -s ../../extensions/Interwiki sudo ln -s ../../extensions/Lockdown sudo ln -s ../../extensions/MassEditRegex sudo ln -s ../../extensions/MathStatFunctions sudo ln -s ../../extensions/MediaFunctions sudo ln -s ../../extensions/MoodBar sudo ln -s ../../extensions/MultiUpload sudo ln -s ../../extensions/Nuke sudo ln -s ../../extensions/OggHandler sudo ln -s ../../extensions/OpenSearchXml sudo ln -s ../../extensions/Oversight sudo ln -s ../../extensions/PagedTiffHandler sudo ln -s ../../extensions/ParserFunctions sudo ln -s ../../extensions/PasswordReset sudo ln -s ../../extensions/PdfHandler sudo ln -s ../../extensions/PrefSwitch # required for ArticleFeedback sudo ln -s ../../extensions/ProofreadPage sudo ln -s ../../extensions/Quiz sudo ln -s ../../extensions/Renameuser sudo ln -s ../../extensions/RSS sudo ln -s ../../extensions/SimpleSurvey # required for ArticleFeedback sudo ln -s ../../extensions/ScanSet sudo ln -s ../../extensions/SharedUserRights sudo ln -s ../../extensions/SMWWriter sudo ln -s ../../extensions/SyntaxHighlight_GeSHi sudo ln -s ../../extensions/TitleKey sudo ln -s ../../extensions/TreeAndMenu sudo ln -s ../../extensions/Vector ## future: NO LONGER IN TRUNK? sudo ln -s ../../extensions/WikiEditor ## future: NO LONGER IN TRUNK? sudo ln -s ../../extensions/WikimediaMessages # Extensions that provide tagged releases, see sudo ln -s ../../ext-tagged-release/AdminLinks sudo ln -s ../../ext-tagged-release/ExternalData sudo ln -s ../../ext-tagged-release/HeaderTabs sudo ln -s ../../ext-tagged-release/Maps sudo ln -s ../../ext-tagged-release/OpenID sudo ln -s ../../ext-tagged-release/PageObjectModel sudo ln -s ../../ext-tagged-release/ReplaceText sudo ln -s ../../ext-tagged-release/SemanticCompoundQueries sudo ln -s ../../ext-tagged-release/SemanticDrilldown sudo ln -s ../../ext-tagged-release/SemanticForms sudo ln -s ../../ext-tagged-release/SemanticFormsInputs sudo ln -s ../../ext-tagged-release/SemanticInternalObjects sudo ln -s ../../ext-tagged-release/SemanticMaps sudo ln -s ../../ext-tagged-release/SemanticMediaWiki sudo ln -s ../../ext-tagged-release/SemanticResultFormats sudo ln -s ../../ext-tagged-release/SemanticSignup # SMWWriter does not exist tagged! sudo ln -s ../../ext-tagged-release/SocialProfile sudo ln -s ../../ext-tagged-release/Validator sudo ln -s ../../ext-tagged-release/Widgets # Extensions best used from trunk: sudo ln -s ../../ext-trunk/ArrayExtension sudo ln -s ../../ext-trunk/LiquidThreads sudo ln -s ../../ext-trunk/MobileFrontend sudo ln -s ../../ext-trunk/ReaderFeedback sudo ln -s ../../ext-trunk/UploadWizard sudo ln -s ../../ext-trunk/WikiLove # Extensions not available from mediawiki subversion, managed through local subversion sudo ln -s ../../ext-LOCAL-svn/CommonsMediaCaching ## used only through cron+sh, not embedded sudo ln -s ../../ext-LOCAL-svn/ContributorList sudo ln -s ../../ext-LOCAL-svn/IdentificationTool sudo ln -s ../../ext-LOCAL-svn/JSHTMLWidget sudo ln -s ../../ext-LOCAL-svn/Loops sudo ln -s ../../ext-LOCAL-svn/MobileKeyV1 sudo ln -s ../../ext-LOCAL-svn/MobileKeyV2 sudo ln -s ../../ext-LOCAL-svn/NotificationMailer sudo ln -s ../../ext-LOCAL-svn/SemanticQueries sudo ln -s ../../ext-LOCAL-svn/TemplateParameterIndex sudo ln -s ../../ext-LOCAL-svn/Variables sudo ln -s ../../ext-LOCAL-svn/VideoFlash
Notes: "phase3" contains the main application, "extensions" the extension code. ImageMagick was later update to a newer version than available in Debian, see Upgrading Imagemagick to a current version.
STAGING/TEST Version:
Also, for testing subversion updates, we checkout the wiki a second time into a staging folder:
sudo mkdir /usr/share/mediawikistaging; cd /usr/share/mediawikistaging sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/trunk/phase3 sudo svn checkout http://svn.wikimedia.org/svnroot/mediawiki/trunk/extensions sudo mkdir extensions-is-here-trunk sudo ln -s ./extensions ext-trunk sudo mkdir ext-trunk-is-only-link-to-extensions sudo ln -s ./extensions ext-tagged-release sudo mkdir ext-tagged-release-is-only-link-to-extensions ## do the symlinks in phase3/extensions as above ...
We want to run multiple mediawiki instances on one server. We created a special, "mixed" form of linking, where the LocalSettings.php, the config and image folder are local, and the rest is linked, following instructions here (an alternative method would probably create problems with the maintenance scripts). Later we detected a page probably equivalent to our method (its source?) which may be helpful if problems should arise (but we did not use it yet). We created this mixed linked/local for a "/var/www/wiki-template" folder:
md /var/www/wiki-template; cd /var/www/wiki-template/ # it is important not to add any further "/" anywhere: sudo ln -s /usr/share/mediawiki/phase3/* . sudo rm -rf config sudo cp -vpRP /usr/share/mediawiki/phase3/config . sudo rm -rf images ## may have changed since, check sudo cp -vpRP /usr/share/mediawiki/phase3/images .
For installation, we need to make the config folder writable by the webserver, for media files some folders within images need to be writable. Also we renamed "images" to "media"
cd /var/www/wiki-template/; sudo chmod 755 config sudo mv images media; sudo chmod 777 media cd /var/www/wiki-template/media/; sudo mkdir archive; mkdir thumb; sudo mkdir temp sudo chmod 755 archive; sudo chmod 755 thumb; sudo chmod 755 temp
To enable the display of svn revision numbers on Special:Version pages (as can be seen on the Wikimedia foundation wikis), one also must create a .svn link in each wiki folder from pointing to .svn in phase3!
Email: Setting up the email functions requires either a local server, or for external server setting $wgSMTP. It also first requires to install the Mail.php functionality:
sudo apt-get install php-mail php-net-smtp
then add to LocalSettings.php:
ini_set("include_path", ".:$IP:$IP/includes:$IP/languages:/usr/share/php/:/usr/share/php/PEAR/"); $wgSMTP = array( 'host' => "160.45.63.40", 'IDHost' => "bgbm.org", 'port' => 25, 'auth' => true, 'username' => "xxx123", 'password' => "xxx123xxx123xxx123" );
Cloning a new wiki
Any code above needs to be run only the first time. From then on, the template can be reused to clone instances (where "NEW-WIKI" is replaced with the name for your wiki):
cd /var/www/; sudo cp -r wiki-template NEW-Wiki cd /var/www/NEW-Wiki; sudo chmod a+w config; sudo chmod a+w cache; sudo chmod a+w media
followed by the install process in a web browser (http://..../NEW-Wiki/config/index.php)
Current template may require: (check whether wiki folder is in /*/ or /*/*/)
sudo chgrp www-data /var/www/v-xxx/*/*/media -R sudo chown www-data /var/www/v-xxx/*/*/media -R sudo chmod 775 /var/www/v-xxx/*/*/media -R
Short note for later installs:
- Set license first (setting it will void other entries)
- set localhost:8088
- set database name and UTF-8 character set.
- For db creation do not use root, but personal mysql admin account.
Full notes for settings made on the web forms of the MediaWiki installation: For the DPG (society of phytopathologists in Germany): Name=DPG, contact email gh, language de, License: Creative Commons, choose non-commercial, share-alike, Admin name: WikiSysop, (password noted separate), caching memcached 127.0.0.1:11211, email options left default (or user-to-user disabled), DB config: MySQL, localhost:8088 (the port on which we operate mysql), databasename: pmedwiki, user name wikiuser, (password noted separate). adding root credentials so that wikiuser and tables can be created (wikiuser has insufficient rights). No database table prefix (originally we DID use prefixes and a single db, however, that prevents to ever use the single-sign-on mechanism...), engine=InnoDB, character set changed to UTF-8. Click Install, move LocalSettings.php to the parent directory, remove the config folder:
cd /var/www/NEW-Wiki/; sudo mv config/LocalSettings.php .; sudo rm -rf config
For each wiki add to the virtual host configuration (e.g. to /etc/apache2/sites-available/default):
Alias /NEW-Wiki-VIRTUAL /var/www/NEW-WIKI/index.phpand restart Apache2 gracefully:
sudo /usr/sbin/apache2ctl -k graceful # or not graceful: sudo /usr/sbin/apache2ctl -k restart
For each wiki using ShortURLs, the robot.txt must be updated!
Some extensions need execution of a sql command for each db (where "DBNAME" and "DBUSER" are replaced with actual db name and user) (ls /var/www/NEW-Wiki/extensions/*.sql):
mysql -u USER -p --database=xwiki < /usr/share/mediawiki/extensions/OpenID/openid_table.sql mysql -u USER -p --database=xwiki < /usr/share/mediawiki/extensions/TitleKey/titlekey.sql
ConfirmAccount from /usr/share/mediawiki/extensions/ConfirmAccount/ConfirmAccount.sql would create 2 tables: "account_requests", "account_credentials". It is necessary only in the shared sign-on wiki (for us this is metawiki). OpenID creates single table "user_openid". Titlekey creates single table "titlekey". Note: We no longer add the DPL views.
To simplify the setup, we have extracted the common settings from LocalSettings.php into a file called MediaWikiCommonSettings.php directly in the www-root. Usually, because of the manual change to MediaWikiCommonSettings.php, we manually modify a template LocalSettings.php from any wiki and use it instead of the one created by the install process.
Note: virtual wiki path is preferable in lower case because it helps to highlight the page title (having Title-Case)!
Configuration after setup
- Logo changed in each LocalSettings
- Short_URL see: http://www.mediawiki.org/wiki/Manual:Short_URL
- Timezone settings added: ( #Set Default Timezone: // $wgLocaltimezone="Europe/Berlin"; // $wgLocalTZoffset = +120; // putenv("TZ=$wgLocaltimezone");)
- Security information on preventing editing by anonymous users and user-creation options under Preventing_Access; we added following to MediaWikiCommonSettings.php:
$wgEnableUploads = true; # (Make sure the php.ini settings are correct, see above) $wgMaxImageArea = 5e7; # Default is 1.25e7. # (support thumb generation for large line drawings which may only be 1.4 MB but larger 5000 px) # Disable anonymous editing $wgGroupPermissions['*']['edit'] = false; # Prevent new user registrations except by sysops $wgGroupPermissions['*']['createaccount'] = false;
(Perhaps see also a blog describing this method). A better method than limiting creation to sysops it the ConfirmAccount extension, which we installed (see extensions below).
Enabling extensions
The first part, establishing the symbolic links, must be done only once for the subversion-managed mediawiki installation, since all further wiki installations symlink to the same phase3/extensions folder. Normally further actions are necessary (LocalSettings.php) for each wiki, but we perform them centrally in MediaWikiCommonSettings.php. Yet some db-specific actions are necessary for some extensions, see at the end. Most extensions are already available through the subversion download. Symbolic links are created to enable selected extensions, initially for:
The CentralAuth extension is difficult to install, although seemingly the only extension supporting single-sign one (users can be shared through shared tables, but sign-ons in browers must be repeated). The initial attempts to use CentralAuth failed. New help is available since, and http://noc.wikimedia.org/conf/highlight.php?file=CommonSettings.php would be an important resource.
In LocalSettings/CommonSettings, add the information for the extensions. The following example may be outdated, check against current file:
# NEEDS UPDATING - OUT OF DATE VERSIONS PRESENTLY REMOVED!Additional actions for some extensions:
- CharInsert requires after standard installation to create/edit MediaWiki:Edittools
- Good templates are found (but respect the license!) at en.wikipedia or de.wikipedia.
- The english WP uses a mixture of direct use and Javascript; it requires also MediaWiki:Edittools.js
- The place where MediaWiki:Edittools.js is being activated needs still to be found! TODO!
- ConfirmAccount needs sql commands for each db; details under cloning wikis above.
- OpenID requires the openidenabled.com 2.x libraries. Debian 4 support those only as backports, so make sure the repository has been added (see above). Then issue
apt-get install python-openid. Additional sql code is needed; details under cloning wikis above. - (Cite may also need additional action, although the mentioned cite layout file is already present. Nothing done so far, needs testing)
- (Sitenotice: It is possible to set one in LocalSettings.php, but better method is MediaWiki:Sitenotice)
- Todo:
- FlaggedRevs has a number of things to do, not yet done
- install lucene (links on MWSearch page), add and install MWSearch extension
Note: according to testing by Evolaris, the CentralNotice extension is slowing down the Wiki functionality significantly, by loading <script type="text/javascript" src="http://smorgasbord.local/trunk/index.php/Special:NoticeLoader"></script> from external sites. We may want to disable this function again. the function occurs on both KeyToNature and the JKI installations. Note that, although the en and de Wikipedias themselves use the extension, the script does not appear there!!!
GlobalUsage init scripts
Add to common settings:
- $wgGlobalUsageDatabase = "openmedia";
- require_once( "$IP/extensions/GlobalUsage/GlobalUsage.php" );
THIS EXTENSION ONLY WORKS WITH setting up a dummy form of http://www.mediawiki.org/wiki/Manual:$wgLBFactoryConf - even if Loadbalancing is acutally not used!
Initialize with:
# create central table in image repository (only first time; alternatively update.php will also do this): cd /var/www/v-species/o; sudo php ./maintenance/sql.php ./extensions/GlobalUsage/GlobalUsage.sql --conf ./LocalSettings.php # record file usage on all other wikis: cd /var/www/metawiki; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/studienstiftungswiki; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/testwiki; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/testwiki2; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-floramalesiana/w; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-ispi/w; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-k2n/w; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-k2n/h; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-k2n/it; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-k2n/sl; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-lias/w; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-nnvm/w; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-on/w; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-orowiki/w;sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-phytomed/w; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-phytopathology/w; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-plantnet/terms/e; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-plantnet/terms/f; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-plantnet/uses/e; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-plantnet/uses/f; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-rosaceae/w; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-species/f; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-species/o; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-species/s; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-species/w; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-workbench/w; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php cd /var/www/v-zsm/w; sudo php ./extensions/GlobalUsage/refreshGlobalimagelinks.php --conf ./LocalSettings.php
Removing tables for Cleanup (check for new wikis that need to be added!): DROP TABLE enwiki.globalimagelinks; DROP TABLE ispiwiki.globalimagelinks; DROP TABLE k2n_handbook.globalimagelinks; DROP TABLE k2n_it.globalimagelinks; DROP TABLE k2n_sl.globalimagelinks; DROP TABLE k2n_wiki.globalimagelinks; DROP TABLE liaswiki.globalimagelinks; DROP TABLE malesiana_wiki.globalimagelinks; DROP TABLE metawiki.globalimagelinks; DROP TABLE nnvmwiki.globalimagelinks; DROP TABLE onwiki.globalimagelinks; DROP TABLE openmedia.globalimagelinks; DROP TABLE orowiki.globalimagelinks; DROP TABLE plantnet_terms_en.globalimagelinks; DROP TABLE plantnet_terms_fr.globalimagelinks; DROP TABLE plantnet_uses_en.globalimagelinks; DROP TABLE plantnet_uses_fr.globalimagelinks; DROP TABLE plazi_wiki.globalimagelinks; DROP TABLE pmedwiki.globalimagelinks; DROP TABLE rosawiki.globalimagelinks; DROP TABLE specialmedia.globalimagelinks; DROP TABLE specieswiki.globalimagelinks; DROP TABLE species_fr.globalimagelinks; DROP TABLE studienstiftungswiki.globalimagelinks; DROP TABLE testwiki.globalimagelinks; DROP TABLE testwiki2.globalimagelinks; DROP TABLE wbwiki.globalimagelinks; DROP TABLE zsm_entomology.globalimagelinks;
2011: mwlib extension for open document support
Source: http://code.pediapress.com/wiki/wiki/mwlib-install - the easy-install variant seems more feasable, the git/re2c variant requires code later than debian lenny
sudo apt-get install g++ perl python python-dev python-setuptools python-imaging sudo easy_install -U setuptools sudo easy_install mwlib && rehash
The last command resulted in a number of error, however.
Open Questions
- TODO: Install and test Extension:CentralAuth. The special tables are created in wikidb, and a variant for CommonSettings2.php exists in the root. However, configuring the wgConfig variable remained unclear for a config with with prefixed tables for multiple wikis in a single database. Could not get it to work...
- CentralAuth is confirmed not to work at present when multiple wikis are kept in a single DB, separated by table prefixes. (Originally, we used such a setup, but have changed to separate databases by now.)
- Instead we configured one Wiki-database to manage the users from all Wikis (using the localsettings variable $wgSharedDB). This provides single identity, although not single sign-on.
- If we fail to get this running, drop the tables again: DROP TABLE globalnames; DROP TABLE localnames; DROP TABLE globaluser; DROP TABLE localuser; DROP TABLE global_user_groups; DROP TABLE global_group_permissions;
Securing MediaWiki
Further information can be found under Mediawiki maintenance (maintenance/backup/upgrading)