MediaWiki Setup Procedure

From MyWiki

Jump to: navigation, search

Contents

Linux

  • Select existing VM image to clone
  • Clone existing VM (copy VM files)
  • Launch new VM


  • Edit /etc/sysconfig/network
  • Edit /etc/hosts
  • Reboot (to pick up hostname changes)


  • Register new VM with DSN
  • Reboot (to pick up permanent IP address)


  • Change root password
  • Update passwords.gpg (see MikeF or PatrickD)
  • Review, add, delete user accounts
  • Review sudoers list (command visudo to edit)

MySQL

  • Change MySQL root password and update passwords.gpg file 
mysqladmin -u root -p password newpassword
  • Verify full text search minimum work length setting
Edit /etc/my.cnf 
[mysqld]
ft_min_word_len=3
Restart and reload MySQL if necessary 
service mysqld restart
mysql> use wikidb;
mysql> repair table searchindex quick;

HTTPD

  • Create a server certificate 
ncsa-cert-request -host ittf.ncsa.uiuc.edu -dir .
tar cvf keys.tar *.pem
  • Copy server certificate files to /etc/httpd/conf 
tar xvf keys.tar
chown root:root host*.pem
chmod 640 hostcert.pem
chmod 600 hostkey.pem
  • Verify /etc/httpd/conf/httpd.conf 
ServerName xxxx.ncsa.uiuc.edu
...
..Redirect / https://xxxx.ncsa.uiuc.edu/
  • Verify /etc/httpd/conf.d/ssl.conf 
SSLCertificateFile /etc/httpd/conf/hostcert.pem
SSLCertificateKeyFile /etc/httpd/conf/hostkey.pem
  • Verify /etc/httpd/conf.d/mediawiki.conf
  • Start web server 
service httpd start

MediaWiki Reset Database

  • Save copy of current config & hide it 
cd /var/www/mediawiki
cp LocalSettings.php LocalSettings.php.save
mv LocalSettings.php LocalSettings.php.hide
  • Delete MediaWiki database 
>mysql -u root -p

mysql> show databases;
mysql> drop database wikidb;
mysql> exit;
  • Prepare for reconfiguration 
mv config_old config
chmod a+w config
  • Configure MediaWiki 
http://ittf.ncsa.uiuc.edu/mediawiki/config/index.php

and use settings 

Wiki name: ITTFWiki
Admin username: WikiSysop
Admin password: <set to something and remember>
Database type: MySQL
Database host: localhost
Database name: wikidb
Database username: wikiuser
Database password: <set to something and remember>
Superuser password: <set to MySQL root password>
  • Rename the generated config file in config/LocalSettings.php to something else to "get rid" of it 
cd /var/www/mediawiki/config
mv LocalSettings.php LocalSettings.php.generated
  • Rename the config directory to "get rid" of it (for better security) 
cd /var/www/mediawiki
mv config config_hide
  • "Restore" the original config file 
cd /var/www/mediawiki
mv LocalSettings.php.hide LocalSettings.php

MediaWiki Configuration

  • Edit /var/www/mediawiki/LocalSettings.php 
$wgSitename = "xxxxWiki";
$wgServer = "http://yyyyyy.ncsa.uiuc.edu";
$wgDBpassword = "zzzzzz";  <-use password for wikiuser
$wgProxyKey = "...............";
  • Restart the web server 
service httpd restart
  • Create users and grant admin rights (Bureaucrat, Sysop)

Backups

  • Crontab entry (for account root) 
[root@nwiki ~]# crontab -l
MAILTO=root
#minute0-59 hour0-23 dayofmonth1-31 month1-12 dayofweek0-7
30 1 * * * $HOME/wikidb_backups/database_backup.sh
  • Contents of /root/wikidb_backups/database_backup.sh 
#!/bin/bash
date=`date +D%Y%m%dT%H%M%S`
echo Processing wikidb backup for `date`
outfile=/root/wikidb_backups/backup$date.sql
mysqldump -u wikiuser --password=xxxxxxx --opt wikidb >$outfile
Retrieved from "http://mywiki.ncsa.uiuc.edu/wiki/MediaWiki_Setup_Procedure"
Personal tools