[MediaWiki-l] Shared user database

Ad Strack van Schijndel ad.strackvanschijndel at gmail.com
Mon Dec 14 09:25:03 UTC 2015

Thanks James! 

User names are indeed unique because they were created with the same rule. 
What does your script do? Isn't this enough:
1 Create all users from wiki B in wiki A
2 change Local Settings of wiki B to share the users of wiki A


Op 11 dec. 2015, om 16:25 heeft James Montalvo <jamesmontalvo3 at gmail.com> het volgende geschreven:

My understanding is the best solution is to pick one wiki to have the
`user` table, and have all other wikis point to that one. So if you have
Wiki A and Wiki B with corresponding databases called `wiki_a` and
`wiki_b`, and you want your Wiki A to be your primary wiki, then in your
LocalSettings.php for Wiki B you'd include the following:

// Wiki B is going to share aspects of the Wiki A database
$wgSharedDB = 'wiki_a';

// These are the aspects that will be shared
$wgSharedTables = array(
'user',            // you definitely want to share the table of users
'user_properties', // you also probably want the users' preferences to be
the same across wikis
'interwiki',       // while you're at it, you may also want interwiki
tables to be the same

This will work great if you're starting brand new wikis, but since you
already have existing entries for Wiki B you need to merge those into Wiki
A. How you do this depends on your situation. If you only have a small
number of users you may be able to make the changes manually. If you have
all unique usernames then you can possibly use the script I'm working on
[1]. This will only work if your usernames on Wiki A are not on Wiki B, or
if they do exist on both wikis they are guaranteed to represent the same
person. This works, for example in a corporate environment where user
accounts are automatically generated based on the persons corporate
username. This script is very much a work-in-progress, so test it first. I
have not yet used it for my production environment because I got
side-tracked from working on it.

[1] https://gist.github.com/jamesmontalvo3/cb51eb8c6b64a7e58735


On Fri, Dec 11, 2015 at 6:23 AM, Agnese Camellini <
agnese.camellini at gmail.com> wrote:

> I really don't get:
> 1) what you want to do, cause if there are two database it doesn't have any
> sense to make a new one with all the data in the other two, it would be
> better to have the tables shared on both db for the same use in the wiki.
> But i don't have any idea if this can be done in mediawiki,
> 2) As far as i've seen there is an extension to share the users on more
> than one wiki, https://www.mediawiki.org/wiki/Extension:CentralAuth but i
> don't have any idea of how does it work and how can you use it for your
> project so.
> Maybe there will be someone more veteran than me that can help you better.
> On 11 December 2015 at 12:28, Ad Strack van Schijndel <
> ad.strackvanschijndel at gmail.com> wrote:
>> Hi,
>> We have one wiki A with thousands of users and one wiki B with a few
> users.
>> We want to have a shared database for the user, preferably the easy way
> as
>> described on https://www.mediawiki.org/wiki/Manual:Shared_database.
>> What would be the appropriate way to go here:
>> - Create a separate database, copy the user table from wiki A to that
>> database, do something with the wiki B users, and configure both wiki's
> to
>> use that shared database.
>> - Use database of wiki A as shared database and explain that to wiki B
>> - Think of something else because it is not possible to have shared
>> database with existing wiki's
>> The first scenario would be the preferred one and I would like to
>> understand if and how that could work.
>> Thanks! Ad
>> _______________________________________________
>> MediaWiki-l mailing list
>> To unsubscribe, go to:
>> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> _______________________________________________
> MediaWiki-l mailing list
> To unsubscribe, go to:
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list
To unsubscribe, go to:

More information about the MediaWiki-l mailing list