Mediawiki/MultipleInstances

Installing | Multiple Instances

Overview

If you've followed the previous instructions for a single instance, adding multiple instances of mediawiki should be a snap.

setup mysql

login to db

~$ mysql -u root -p

Create next mysql wiki user

~$ mysql> CREATE USER 'wiki2'@'localhost' IDENTIFIED BY 'THISpasswordSHOULDbeCHANGED';
~$ mysql> exit

login as new user to verify account works

~$ mysql -u wiki2 -p
~$ mysql> exit

create DB

~$ mysql -u root -p
~$ mysql> CREATE DATABASE wikidatabase2;

verify DB creation

~$ mysql> SHOW DATABASES;

assign rights to wiki user for new database created

~$ mysql> GRANT ALL PRIVILEGES ON wikidatabase2.* TO 'wiki2'@'localhost' IDENTIFIED BY 'wikiuserpassword' WITH GRANT OPTION;
~$ mysql> exit

verify permissions have been granted

~$ mysql -u wiki2 -p
~$ mysql> SHOW GRANTS;
+---------------------------------------------------------------------------------------------------------------+
| Grants for wiki2@localhost                                                                                   |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'wiki2'@'localhost' IDENTIFIED BY PASSWORD '*2K21458K438UYE85A38B9Y7Y78DAEBF4T8689YK4' |
| GRANT ALL PRIVILEGES ON `wikidatabase2`.* TO 'wiki2'@'localhost' WITH GRANT OPTION                          |
+---------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

create dir/export tar contents

~$ sudo mkdir /var/www/html/sitename2.com
~$ tar -C /var/www/html/sitename2.com -zxf mediawiki-1.22.6.tar.gz

configure apache

Make a new conf file just for this site under /etc/httpd/conf.d/
edit domain2.conf

~$ sudo vi /etc/httpd/conf.d/domain2.conf
add:
<VirtualHost *:80>
       ServerName servername2.com
       ServerAdmin [email protected]
       DocumentRoot /var/www/html/servername2/mediawiki-1.22.6/
       TransferLog logs/servername2-access_log
       ErrorLog logs/servername2-error_log
</VirtualHost>

give folder rights to apache user

~$ sudo chown -R apache:apache /var/www/html/servername2/mediawiki-1.22.6/

verify

~$ ls -la /var/www/html/servername2/
total 12
drwxr-xr-x.  3 root   root   4096 Apr 28 14:52 .
drwxr-xr-x.  3 root   root   4096 Apr 28 15:16 ..
drwxr-xr-x. 13 apache apache 4096 Apr 24 17:24 mediawiki-1.22.6