Need help with multisite installation sharing user and session data through MySQL views

Hi all,

I need the help of a "guru"... ;-)

I have a Drupal 6.3 configuration using multisite. Each site has it's own database, defined in settings.php, and each one shares (via MySQL views) the following tables to allow sharing of users:

That works fine, in so far as all my sites have the same user, role and profile data. They are also all using the same sessions table correctly (e.g. if I login on all sites, I can see all the different sessions in the sessions table). So, the final step is to share that session data so that if someone logs in at www.foo.com and goes to www.bar.com they remain logged in. I thought this would be straightforward, but sadly it is not. Others working around the same problem never seemed to manage to solve it.

I have tried to use the Shared Sign-On module, went to two of my instances and set the base site to the same. I can see singlesignon session data appearing in the database, but the other sites don't seem to be sharing it (e.g. I'm still asked to login).

Has anyone achieved what I'm describing in the past? Anyone already know why this doesn't work with the Shared Sign-On module, so you can save me some time banging my head against the wall! =(

Greg

--
http://www.drupaler.co.uk