Drupal 7 Multisite Single Database and common login - site registration

[robbiemc]

Hi

I have a Drupal 7 multisite, single database common login set up consisting of a main site and 5 addon sites...but would like if possible individual site registration that allows a common login.

Initially the setup used the single database and allowed individual site registration through CiviContribute but this caused a problem in that having registered through Site_A you couldn't log in to Site_B without having to go through the (Drupal) registration process...this did not work as usernames etc had already been allocated.

Having followed guidelines, can't remember where, I use the following code in settings.php for the main site which is used simply to manage the database;


$databases = array (
  'default' =>
  array (
    'default' =>
    array (
      'database' => 'ehfap957_members',
      'username' => 'myusername',
      'password' => 'mypassword',
      'host' => 'localhost',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => 'ehfa_',
    ),
  ),
);

and for the addon domain;

$databases = array (
  'default' =>
  array (
    'default' =>
    array (
      'database' => 'ehfap957_members',
      'username' => 'myusername',
      'password' => 'mypassword',
      'host' => 'localhost',
      'port' => '',
      'driver' => 'mysql',
    'prefix' => array(
    'default'   => 'fitcon_',
    'users'     => 'ehfa_',
    'sessions'  => 'ehfa_',
    'role'      => 'ehfa_',
    'authmap'   => 'ehfa_',
  ),
    ),
  ),
);

This allows data to be common throughout all sites but registration only works if I force the user to to register through CiviContribute from the main site. The problem with this is that Drupal then sends out an email to the registrant with a link to confirm login which points back to the main site...and I am having problems trying to explain the process to registrants that they have to confirm password in one site, save, log out and then return to the original site. The email also is generic and I can not format it to say welcome to site A and all these wonderful benefits etc.

Ideally I would like a setup that allows a site registration process as follows;

- user registers on Site_A through CiviContribute
- Drupal (Site_A) sends out an email with link back to Site_A
- user confirms password and updates profile in Site_A
- user is then able to login to Site_B with the same username and password

All user data is available for profiles in ALL sites. Access to the individual sites is restricted by roles.

I am not a coder so if anyone can give me any pointers it would be most appreciated.

Cheers

Robbie
YNWA

[Donald Lobo]

Dont know if CiviCRM handles the below case properly.

An alternative might be to get users to register via the drupal user registration process and then send them to the CiviContribute form.

This is probably a good workaround and allows u to move forward with the site

lobo

[robbiemc]

Hi Lobo

Thanks for the quick reply.

Thought of that one but the problem is that if you are registering through Drupal you are selecting a user name and password which as far as I can tell will be site specific removing the ability for members to have access to more than one site using the same details.

Robbie

[Donald Lobo]

i dont think so. might want to check drupal docs on that.

if you are sharing the user table, the user name/password should be valid for all sites sharing it

lobo

[Eileen]

Terminology is a problem here but

1) If you are creating multiple drupal sites with one drupal DB using drupal domain (drupal.org/projects/domain) module then you will automatically have a shared user table

2) If you are using multiple drupal databases you can share just the user table or you can also share roles and / or permissions.