Topic on Project:Support desk

Does anyone here know how to set up a shared user database?

I have one database acting as the master, and both wikis are creating users in there that work to log into themselves, but the users created in one of the wikis can not log into the other.

I'm using the same dbuser to access the database from both wikis.

if the password is correct, I get an error saying automatic user creation fails. If it is wrong, it tells me I have a bad username/password.

Both wikis list all users but only the ones created in that wiki can log onto it.

I'm so stumped.

What do you have in your LocalSettings.php to set up shared users? What version of MediaWiki are you using?

I'm using a shared database belonging to one of the wiki's.

Mediawiki 1.33 running on mariaDB 10.4

The users are created in the right place both wiki A and wiki B create users in the user table of wiki A

Displayed on the special:allusers page on either wiki will be all of the users regardless of where they were created, listed as users on both wiki.

The user table for wiki B has only the initial user in it (this user is common between both and has the same password set initially. it is the only one that works on both wikis)

The user table for wiki A contains all users created in either wiki: https://pasteboard.co/IG8OUXm.png

When a user created in wiki A tries to log into wiki B, they get one of two errors: https://pasteboard.co/IG8N4R5.png

What do you have in your LocalSettings.php to set up shared users?

This may be a bug, but it is hard to tell if you do not provide that information.

When did this problem occur? Is this a new installation or have you recently upgraded?

the local settings for the two wiki are here: https://pasteboard.co/IGgtKVr.png

I also have

$wgGroupPermissions['*']['autocreateaccount'] = true;

These are two brand new installations of media wiki specially for this new purpose. They are empty except for the users that have been created.

All users are created in the appropriate table but not accessible the a wiki other than the one that created them.

The default value for $wgSharedTables is [ 'user', 'user_properties' ], but you've set it to [ 'user', 'user_groups' ]. Is there a reason you removed user_properties? What happens if you add it back?

Im going to try this immediately!

Edit-- It doesnt seem to have helped. Now the whole wiki is really incredibly slow too. Im thinking I might want to just scrap it and start over. Maybe i screwed something up in the process of the set up.

This problem happens if a user tries to log on to a wiki other than one that created the user in the first place. It happens immediately. It has happened since i first set it all up. I have never gotten it right :/