Posted 3 years ago #
I know I'm asking so many complicated questions, sorry.
So I have:
wp_ A main WordPress blog (news/pictures) + bbPress on same server
podcast_ A copy of that blog on another server (for podcast files)
bb_ And finally a bbPress used for an archive of clips that are searchable using tags
How would I get them so they all share the same wp_ user database (meaning people can login/logout/stay logged in throughout the three sites)?
Posted 3 years ago #
Would still love some help with this, thanks.
you dont. especially since sharing the same database across sites that exist on separate servers probably isnt an option -- unless youre going to tell me that you are not on shared hosting, or that you happen to have all the sites hosted with the same company, but on separate servers, and that they all use the same mysql server.
Shared hosts rarely, very rarely allow remote mysql connections, for obvious reasons.
Godaddy clusters and has dedicated mysql servers, so while 3 accounts on godaddy might be on different servers, they *might* also all use the same mysql server.
Follow?
No go.
Even IF you got over those hurdles you have the issue of cookies. Just having logged in doesnt matter. Disable your cookies after you have logged in and see what happens.
Posted 3 years ago #
No, no, they're able to connect. I"m on a bunxh of different resellers and stuff. I've got them to share the same database already, just want to get them to use the same "wp_" user list.
Posted 3 years ago #
There just HAS to be a way to do it.
Posted 3 years ago #
It's possible to share tables across databases under mysql. You hard link (not symlink) the files associated with the table you want to share, in this case, wp_users.frm, wp_users.MYD, and wp_users.MYI. Doing this requires root access on a linux server. It can't be done on a windoze box.
User access levels would be identical across all wordpress installs, so one rogue with admin access could do all kinds of damage across multiple blogs.
WARNING, this is not something to attempt if you are not highly competent with Linux and MySQL!!!
Posted 3 years ago #
How could I go about doing this?
Posted 3 years ago #
Still no luck.
Add these to your wp-config.php files, along with the other defines:
define('CUSTOM_USER_TABLE','wp_users');
define('CUSTOM_USER_META_TABLE','wp_usermeta');That will force the user and usermeta tables to all use the same tables. All the installs must be using the same database already, but with different prefixes.
However, this will not let you log in at one and then be logged in at the others as well. It only means that they will share usernames and passwords and such. The login cookie is specific to each site. There is no way around that.
Posted 3 years ago #
Otto's suggestion is much better than mucking about with hard linking mysql table files and doesn't require special access, so go with his suggestion and ignore mine.
Posted 3 years ago #
That doesn't appear to work in 2.6 -- that is, it's definitely looking at the other installation's user tables, but I get "You do not have sufficient permissions to access this page" when logging in as one of the other installation's (admin) users.
ETA: Does work if you alter wp-includes/wp-capabilities.php as described here.
Make sure you upgrade all the blogs at the same time. 2.6 adds some new capabilities to the administrator role. They might be interfering if all the installs don't understand them.
This topic has been closed to new replies.
