Difference between revisions of "MediaWiki"

From Blue-IT.org Wiki

(/srv/www/PathToMediaWiki/Localsettings.php)
(Alter user groups in the database)
Line 40: Line 40:
 
See the MediaWiki Manual pages: [http://meta.wikimedia.org/wiki/Help:User_rights User_rights]
 
See the MediaWiki Manual pages: [http://meta.wikimedia.org/wiki/Help:User_rights User_rights]
  
Edit your mysql database
+
Edit your mysql database:
 
  mysql -u root -p
 
  mysql -u root -p
 
  mysql> use YourMediawikiDBName
 
  mysql> use YourMediawikiDBName
  
Show the actual user settings
+
Show the actual user settings:
 
  mysql> select user_id,user_name from user;
 
  mysql> select user_id,user_name from user;
 
  +---------+-----------+
 
  +---------+-----------+
Line 54: Line 54:
 
  2 rows in set (0.00 sec)
 
  2 rows in set (0.00 sec)
  
Show the actual usergoups assigned to what users
+
Show the actual usergoups assigned to what users:
 
  mysql> select * from user_groups;
 
  mysql> select * from user_groups;
 
  +---------+------------+
 
  +---------+------------+
Line 65: Line 65:
 
  3 rows in set (0.00 sec)
 
  3 rows in set (0.00 sec)
  
Delete a row
+
Delete a row:
 
  mysql> DELETE from  user_groups where  ug_group='aGroup' and ug_user='####';
 
  mysql> DELETE from  user_groups where  ug_group='aGroup' and ug_user='####';
  
Insert a new user / group
+
Assign a user to a group:
 
  mysql> INSERT INTO user_groups (ug_user, ug_group) VALUES ('####', 'aGroup');
 
  mysql> INSERT INTO user_groups (ug_user, ug_group) VALUES ('####', 'aGroup');
  

Revision as of 15:55, 9 June 2006

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

See the MediaWiki Manual pages: User_rights

Edit your mysql database:

mysql -u root -p
mysql> use YourMediawikiDBName

Show the actual user settings:

mysql> select user_id,user_name from user;
+---------+-----------+
| user_id | user_name |
+---------+-----------+
|       1 | aUsername |
|       2 | WikiSysOp |
+---------+-----------+
2 rows in set (0.00 sec)

Show the actual usergoups assigned to what users:

mysql> select * from user_groups;
+---------+------------+
| ug_user | ug_group   |
+---------+------------+
|       1 | bureaucrat |
|       1 | sysop      |
|       2 | sysop      |
+---------+------------+
3 rows in set (0.00 sec)

Delete a row:

mysql> DELETE from  user_groups where  ug_group='aGroup' and ug_user='####';

Assign a user to a group:

mysql> INSERT INTO user_groups (ug_user, ug_group) VALUES ('####', 'aGroup');

... where '####' is the user_id of the appropriate user.

Localsettings.php

in /srv/www/PathToMediaWiki/. .

## PERMISSIONS
# This snippet prevents new registrations from anonymous users
# (Sysops can still create user accounts)
#$wgGroupPermissions['*']['createaccount'] = false;
## USERS
## see: http://meta.wikimedia.org/wiki/Help:User_rights
# This snippet prevents editing from anonymous users
$wgGroupPermissions['*']['edit'] = false;
# This will still allow logged in users to edit
$wgGroupPermissions['user']['edit'] = true;
# No Pin header for non-logged in users
$wgShowIPinHeader = false;
# This snippet prevents new registrations from anonymous users
# (Sysops can still create user accounts)
#$wgGroupPermissions['*']['createaccount'] = false;