Hm. losing nids, does it matter? (happy to ignore problems that
are not problems! :) Also, what happens if you share roles, but
not permissions? What if I didn't want to share roles?<br>
<br>
Does anyone have a multi install and can share their working config, as well as why they did it that way?<br>
<br>
Anisa.<br><br><div><span class="gmail_quote">On 9/27/06, <b class="gmail_sendername">Jeremy Epstein</b> <<a href="mailto:jazepstein@gmail.com">jazepstein@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Be very careful about sharing the 'sequences' table. If you share this<br>table, then you are sharing the generation of IDs of ALL types (for<br>many, but not all, drupal entities) across all your sites. That is, if<br>you share the sequences table but not your node tables, then you will
<br>be 'losing' a lot of nids (I guess this could be regarded as a good<br>thing or a bad thing - either way, it's probably not a major thing).<br><br>The trouble is, if you DON'T share the 'sequences' table, then you<br>
will only be able to create users on one site, and not on any of the<br>others. That is, you will have to disable user registration on all<br>sites but one. If you don't, then you will get SQL 'duplicate entry'<br>errors, and you will have UID conflicts, and there will be user
<br>accounts that never actually get created.<br><br>IMO, the solution to all of this is to ditch the 'sequences' table<br>altogether, and to just rely on database generation of IDs (i.e.<br>auto_increment or equivalent).
<br><br>Cheers,<br>Jeremy.<br><br>On 9/27/06, Anisa <<a href="mailto:mystavash@animecards.org">mystavash@animecards.org</a>> wrote:<br>> OK. Let's say you only want to share users across a multisite installation.
<br>> In a plain Drupal installation, are these the only tables you need to<br>> share? (copied from the single signon module)<br>><br>> * 'default' => 'somesitename_',<br>> * 'authmap' => 'shared_',
<br>> * 'profile_fields' => 'shared_',<br>> * 'profile_values' => 'shared_',<br>> * 'role' => 'shared_',<br>> * 'sequences' => 'shared_',<br>> * 'sessions' => 'shared_',<br>> * 'users' => 'shared_',
<br>> * 'users_roles' => 'shared_',<br>> * 'users_uid_seq' => 'shared_', // for pgsql<br>> Anisa.<br>><br>><br>--<br>[ Drupal support list | <a href="http://lists.drupal.org/">http://lists.drupal.org/
</a> ]<br></blockquote></div><br><br clear="all"><br>-- <br>*********************************<br><a href="http://www.AnimeCards.Org">www.AnimeCards.Org</a><br><br>16,000 scans and counting!<br>*********************************