Multiple Site Shared Users Problem?

Question

I can't seem to get this to work.  I'm trying to get a number of installations to use the same users.  I already have one functioning Q2A and I've attempted to install another by altering the config file on install to this ...

    define('QA_MYSQL_TABLE_PREFIX', 'qa_music_');
    define('QA_MYSQL_USERS_PREFIX', 'qa_user_');

The tables are created and the new install fires up but it doesn't refer to the qa_user tables.  Should I being doing something else?

Answer 1

The QA_MYSQL_USERS_PREFIX should be set to the same as the QA_MYSQL_TABLE_PREFIX from the other site.

Presumably your first table uses 'qa_' as the prefix so you should use that instead of 'qa_user_'

Comments

Yes.  The instructions in the config file are a bit misleading.  Took me a while to work it out but the default setting should be 'qa_' (as you mentioned) - in the config file and not 'qa_users'.  It would be a simple matter then to just make the line active in subsequent forum additions.

Got it working a treat now.

Thanks

---

This is very misleading in the config, it should be indicated like "sharedusers_" instead of "qa_user_" (which lets us think of the same "qa_" db which must not be the case).

I did some clarification in github: https://github.com/q2a/question2answer/pull/596