Multiple WP blogs sharing one user database = “cheatin, huh?”

  • LSmith

    (@lsmith)


    16 years, 4 months ago

    Hi and thanks for your time. Since WordPress MU is not what I’m after, I decided to run multiple blog installs on subdomains but I want to share the same set of users, for simplicity of postings etc. and to keep the thing as tight as I can under the circumstances.

    After browsing the forums I found this posting as a prospective solution:

    define(CUSTOM_USER_TABLE,'wp_users');
define(CUSTOM_USER_META_TABLE,'wp_usermeta');

    This seems to change things mostly in the sense that when I now attempt to access wp-admin/ of the secondary WP install (the one that is sharing the user data from the original WP install) I get locked out:

    “Cheatin’, huh?”

    “You do not have sufficient permissions to access this page.”

    I don’t even know where to begin. I appreciate any bones. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • doug wilson

    (@dgswilson)

    16 years, 3 months ago

    Did you ever get this figured out? I’m going through the same thing. I had/have a hacker messing with things. In an attempt to change admin passwords I am now given “You do not have sufficient permissions to access this page.” on one blog, but not another. Both blogs use the same database. I’m not good at messing with database stuff. There must be a well known reason for this. It can’t just be a rare and solitary incident.

    This blog works http://www.dgswilson.com/wpsite/ (can log in) this one gives error http://www.dgswilson.com/wp/

    I’m completely out of ideas…

    drhype

    (@drhype)

    16 years, 2 months ago

    This is just a guess because I haven’t tried it yet, but you may need to add new meta_keys to the usermeta table for each secondary WP install.

    Say a secondary WP install uses the prefix wp2_, add the meta_keys wp2_capabilities and wp2_user_level using the same user_id and meta_value values as the adminstrator for you primary WP install.

    Like I said, this is just speculation, but I will be trying it soon myself. Let me know if it works if you decide to give it a shot.

    ts230

    (@ts230)

    15 years, 10 months ago

    I don’t understand what you mean. I have that set up, but can you possibly provide an SQL query or something? The first prefix is wp_, the other srl_

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Multiple WP blogs sharing one user database = “cheatin, huh?”’ is closed to new replies.

Tags