Thread:Project:Support desk/How to make single registration for 2 wikis?/reply (5)

I have the same problem and really wish I knew the solutions that was used.

I have setup the $wgSharedDB (etc) for the French wiki to used the English wiki's user table. I believe my code is correct because on the User List special page, the French wiki now lists the same users are the English wiki. I can log in to the English wiki without any problems, but when I attempt to log in with the French wiki, it does not work. I do not even get an error message).

Not only would I love a solution for the above, but I wonder: even with a database user having all permissions in my mySQL cPanel database settings, how can the French wiki dbuser right in the shared DB without even including a second $wgDBpassword in the localsettings.php?

Code from my English wiki (wiki.mydomain.ca)
$wgDBtype = "mysql"; $wgDBserver = "localhost"; $wgDBname = "myusername_ccctwik"; $wgDBuser = "myusername_ccctwik"; $wgDBpassword = "mypassword-A";
 * 1) Database settings

$wgSharedDB = 'myusername_ccctwik'; $wgSharedTables = array( 'user', 'user_groups'); # I use an interwiki extension so no need to add 'interwiki' $wgSharedPrefix = 'wiki_';
 * 1) Interwiki shared user database

Code from my French wiki (notice the different domain wiki.mondomaine.ca)
$wgDBtype = "mysql"; $wgDBserver = "localhost"; $wgDBname = "myusername_ccctwfr";     <---different from above $wgDBuser = "myusername_ccctwfr";     <---different from above $wgDBpassword = "mypassword-B";       <---different from above
 * 1) Database settings

$wgSharedDB = 'myusername_ccctwik'; $wgSharedTables = array( 'user', 'user_groups'); $wgSharedPrefix = 'wiki_';
 * 1) Interwiki shared user database

Thanks!