[wp-hackers] Sharing Users/authentication

[Stephen Rider]

Potential bug report and further discussion....

Okay, I've discovered this much:

The problem appears to be the "wp_capabilities" and "wp_user_level"  
fields in the wp_usermeta table.  WordPress needs these field names  
to match the active table prefix.

So, when I use the define()s to point to the other blog's user and  
usermeta tables, it sees the wrong prefix in this field and hits an  
error.

This only appears to affect admin screens, not the main blog itself.

Has anybody ever actually gotten this to work or is it just theory  
that you can point one blog to another's user tables?

ALSO:  Should it be considered a bug that the field names have the  
prefix hard-coded into them?  This seems like unnecessary duplication  
of information to me, which is a database design no-no.

Stephen

On Aug 24, 2007, at 9:56 PM, Jacob Santos wrote:
>
> No idea. It could be any number of variables or problems. Write a  
> ticket to the forums and see if someone who is experienced knows  
> anything.
>
> Did you change the config of the second blog? Or third? Or Fourth?
>
> Is the second blog on the same database as the first blog?
>
> As I have had no need to attempt something like this, I have no  
> idea how to troubleshoot it. I might attempt it to see what the  
> requirements are beyond setting those two constants, but I really  
> don’t think I will have time.
>
> Good Luck,
>
> Jacob Santos
>
> Stephen Rider wrote:
>> That could be extremely useful for me.  However... when I do that  
>> I can’t get into the admin screen on the “secondary” blog.  All I  
>> see is:
>>
>> You do not have sufficient permissions to access this page.
>>
>> The main blog still works fine.  Any idea why???
>>
>> Stephen
>>
>>
>> On Aug 24, 2007, at 1:07 PM, jacobsantos at branson.com wrote:
>>>
>>> Yes. There are defines in the wp-settings.php file that can be  
>>> defined in the wp-config.php file.
>>>
>>> wp-config.php
>>> -----------------------
>>>
>>> // Underneath database config info
>>> define(’CUSTOM_USER_TABLE’, ’wp_users’);
>>> define(’CUSTOM_USER_META_TABLE’, ’wp_usermeta’);
>>>
>>> In this way, you only need to have one wordpress users table and  
>>> usermeta table. You will have to keep track of the prefix of the  
>>> wordpress installation you have all of the users in.
>>>
>>> Jacob Santos
>>>
>>> Chris Lott wrote:
>>>> Faculty members have discovered CommentPress and would like to use
>>>> CommentPress enabled blogs alongside their regular class  
>>>> blogs... is
>>>> there a simple way to share the usernames/logins between two WP
>>>> installations? All that really needs to be shared is the login name
>>>> and password...
>>>>
>>>> c