Database Info/wiki creation

From Informatics

• ssh <username>@mgmt1.c2b2.columbia.edu
• sudo su -
• cd /ifs/www/vhosts/wiki.c2b2.columbia.edu/html

mkdir <wiki-site>/
chown –R wikiuser:webgrp <wiki-site>
chmod R g+w <wiki-site>/

• wget http://download.wikimedia.org/mediawiki/<version>/mediawiki-<version>.tar.gz .
• tar xzvf mediawiki-<version>.tar.gz
• open browser and go to http://wiki.c2b2.columbia.edu/<wiki-site>/mw-config/index.php

database host: <something>.c2b2.columbia.edu
database name: <whatever>
database username: <whatever>
storage engine: InnoDB
database character set: utf-8
database password: ********
superuser name: <mysql user>

download generated LocalSettings.php file from completed web installation and copy to <wiki-site>/mw-config

• [mhonig@mgmt1 ~]$ cp LocalSettings.php /tmp/
• [mhonig@mgmt1 ~]$ chmod a+r /tmp/LocalSettings.php
• [mhonig@mgmt1 ~]$ sudo -u wikiuser –i
• [wikiuser@mgmt1]$ cp /tmp/LocalSettings.php /ifs/www/vhosts/wiki.c2b2.columbia.edu/html/<directory>/

• [wikiuser@mgmt1]$ vi LocalSettings.php

$wgEnableUploads = true;

# Prevent new user registration
$wgGroupPermissions['*']['createaccount'] = false;
$wgVerifyMimeType = false;

# Define the list of extensions for upload-able files
$wgFileExtensions = array('gif','xml','owl','mp3','png','jpg','jpeg','xls','doc','docx','txt','pdf','jar','zip','ppt','pptx','wmv','WMA','wma','csv');
$wgWhitelistRead = array( "Home","Special:Userlogin");

# Disable anonymous reads and edits
$wgGroupPermissions['*']['read'] = false;
$wgGroupPermissions['*']['edit'] = false;