Hi

My setup is: 4 sites (main, site1, site2, site3), single data base, shared users. Sites were set up with sym-links and shared user tables. Everything worked well so far. I could log in to all of the sites with the same login.

Problems started when installing the multisite_login module. Sites1,2,3 displayed warning/error (respectively for each site) when 'multisite_login' => 'shared_', table was added.

The warning/error was:
user warning: Table 'shared_multisite_login' already exists query: CREATE TABLE shared_multisite_login ( uid INT(11) UNSIGNED NOT NULL DEFAULT 0, pass_hash VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, UNIQUE uid_index (uid) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in /home/main/public_html/site1/includes/database.mysql.inc on line 174.

Refreshing the browser has removed the warning but the multisite_login didn’t work. There were no control images visible in the admin panels and the user still had to login separately to each of the sites.

Log entries for that session were:
error php date….. time….. Table 'shared_multisite_login' ...administrator
multisite_login date….. time….. user logged in successfully .. administrator
warning multisite_login date….. time….. sid has already been used for a multisite_login Anonymous
warning access denied date….. time….. admin Anonymous

I have repeated module's install few times with the same result each time and can't see what is wrong.

Shared tables for the each respective site are as in the example:
$db_prefix = array(
'default' => 'site1_',
'multisite_login' => 'shared_',
'users' => 'shared_',
'sessions' => 'shared_',
'role' => 'shared_',
'authmap' => 'shared_',
'sequences' => 'shared_',
'profile_fields' => 'shared_',
'profile_values' => 'shared_',
'users_roles' => 'shared_',
);

I’d appreciate any help with this matter.
Thank you
jrskyg

Comments

dalin’s picture

I'll try to take a look at this on the weekend. Until then can you install simpletest, run all the multisite related tests (just on one of the sites), and report your findings here.

dalin’s picture

Status: Active » Closed (fixed)

without more info there's not much that I can. You can try the latest version which should be a lot easier to setup.