MediaWiki

Initial installation

Concerns

• Media Wiki 1.6.6
• Mysql 4.0.15
• SuSE 9.0 on vserver

Patches

There are some major problems concerning the installation of media wiki on SuSE 9.0 on a vserver:

1. Mysql is only version 4.0.15
2. PHP is per default limited in memory

You will get an error during installation.

Because of a bug in php you shoul do 2 things:

First edit /etc/php.ini an change the memory limit from 8 to 50MB:

memory_limit = 50M      ; Maximum amount of memory a script may consume (8MB)

Second due to a bug in older mysql versions you have to change two installation files of the media wiki.

At the end of the file

maintenance/mysql5/tables.sql

Change

KEY (job_cmd, job_namespace, job_title)
) TYPE=InnoDB, DEFAULT CHARSET=utf8;

to

KEY (job_cmd(255), job_namespace, job_title(255))
) TYPE=InnoDB, DEFAULT CHARSET=utf8;

(!) The same (!) you have to do in file

maintenance/archives/patch-job.sql

Database related

Alter user groups in the database

mysql -u root -p
mysql> use mediawiki
mysql>select * from user_groups;
+---------+------------+
| ug_user | ug_group   |
+---------+------------+
|       1 | bureaucrat |
|       1 | sysop      |
|       2 | sysop      |
+---------+------------+
3 rows in set (0.00 sec)
mysql> DELETE from  user_groups where  ug_group='aGroup' and ug_user='####';
mysql> INSERT INTO user_groups (ug_user, ug_group) VALUES ('####', 'aGroup');