[Mediawiki-l] 1.5Alpha2 WikiSysop problem

Thu Jun 9 12:36:49 UTC 2005

Rick DeNatale wrote:
>>>>The user/groups system is pretty broken right now, you may have to
>>>>fiddle with the tables manually.
>>>
>>>Thanks!
>>>Where can I find documentation on how to do this?
>
> I see that 1.5 has made major changes to the database schema regarding
> articles, but has it changed in regards to the user table?  Would the
> documentation in
> http://meta.wikimedia.org/wiki/Setting_user_rights_in_MediaWiki
> no longer be accurate?

Ok, I've made some more changes tonight to clean it up to where it
should be in a reasonably working state. Hopefully coherent info follows:

The old user_rights field (in 1.4, the ur_rights in the user_rights
table) was a comma-delimited list of group names. For instance it might
contain "sysop,bureaucrat" or "bot", or just "" for a regular account.

In 1.5 these are now each in a row in the user_groups table, which is
easier to track and manipulate programmatically. To manually mark an
account as a sysop+bureaucrat, look up its user_id number and insert the
group assignments like this:

INSERT INTO user_groups VALUES (1,'sysop'),(1,'bureaucrat');

The actual permissions conferred to a user in a given group are defined
in $wgGroupPermissions. DefaultSettings.php contains a default set
(which may slightly change yet before final release), but you could
customize these in LocalSettings.php.

A sysop+bureaucrat user can use Special:Userrights to set the group
assignments of other accounts; this replaces the old Special:Makesysop.

Interactions with $wgWhitelistEdit and $wgWhitelistRead are probably not
yet totally resolved.

For a while in 1.5 alpha code there was use of a groups table with
definitions, and the user_rights table was still sort of used, but it
was all pretty broken. Those are now no longer used and won't be
included in a fresh install.

An upgrade from 1.4 or earlier will convert the user_rights info to the
new user_groups table when you run the updater (update.php, or via the
web installer).

If you update an existing 1.5 alpha wiki to the latest code though it'll
give up on the broken intermediate tables and just ask you to manually
set up your sysops again.

-- brion vibber (brion @ pobox.com)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 253 bytes
Desc: OpenPGP digital signature
Url : http://lists.wikimedia.org/pipermail/mediawiki-l/attachments/20050609/44108b99/attachment.pgp 