This is kind of a last resort after several days trying to get this module to work and searching the issue queue and forum threads.

I'm trying to use this module on a multi-site installation that has separate databases with shared user tables.

My client site settings.php file has the following:

$db_url = 'mysql://MyGlobalUsername:MyGlobalPassword@localhost/clientdb';

$sitedb = "clientdb";
$logindb = "controllerdb";

$db_prefix = array(
	'default'	=>	'',
	'users'		=>	$logindb.'.',
	'sessions'	=>	$logindb.'.',
	'role'		=>	$logindb.'.',
	'authmap'	=>	$logindb.'.',
	'sequences'	=>	$logindb.'.',
);

$conf['session_inc'] = 'sites/all/modules/sso/session.singlesignon.inc';
.
.
.
$cookie_domain = '.controllerdomain.com';

My controller domain site settings.php file has the following:

$db_url = 'mysql://MyGlobalUsername:MyGlobalPassword@localhost/controllerdb';
$db_prefix = '';

$conf['session_inc'] = 'sites/all/modules/sso/session.singlesignon.inc';
.
.
.
$cookie_domain = '.controllerdomain.com';

The Shared User table works find between controller and client website.

When I originally installed SSO, I had a problem with not being able to view the client site and being redirected to the controller website with a long url. This post fixed that issue though: http://drupal.org/node/606422#comment-2206222

I've tried moving the Controller settings.php file within /sites/controllerdomain.com, as well as, /sites/default/ . Flused cached, deleted SSO variables from above post link.

With this module, I'm under the understanding whether I log into either the client or controller website, I should be able to open either website into a new browser tab and be automatically logged in. Is this not the case?

Any suggestions on why this module is not working on my install?

Appreciate any input.

Comments

ejohnson’s picture

I tried several patches that were posted in various threads and could not get this module to work on my setup. Anyone having issues with this module like I had above might want to try:

Multi-site Login: http://drupal.org/project/multisite_login
Requires: http://drupal.org/project/multisite_api

Worked first try. Wish I had found this module earlier.