[support] Multisite on same database

[Xavier Bestel]

I want to share some content, based on taxonomy. I want a different
theme, different organisation, but same users, roles, etc.

For now I have only "unshared" {menu}, so I created another entry for
the prefixed table in {sequences} with the right index. All the rest is
shared, and it seems to work well.
I still have to install singlesignon (I wonder about {sessions}) to have
it working conveniently.

Thanks,
	Xav

On Fri, 2008-01-11 at 09:44 +0530, Shyamala wrote:
> The tables you want to share depends on what is the kind of information that 
> you want to share between the sites.  Is the content shared? Is the user 
> database and session shared?  Is the theme shared?
> Sequence table stores the unique ids created in user, menu, vocabulary,... 
> tables.
> 
>         name  id
>             users_uid 5
>             menu_mid 57
>             vocabulary_vid 1
>             term_data_tid 2
>             node_nid 11
>             node_revisions_vid 11
>             files_fid 4
> 
> Shyamala
> 
> 
> ----- Original Message ----- 
> From: "Xavier Bestel" <xavier.bestel at free.fr>
> To: <support at drupal.org>
> Sent: Thursday, January 10, 2008 3:55 PM
> Subject: Re: [support] Multisite on same database
> 
> 
> Hi,
> 
> ok, now I understand better how it works.
> However, I don't really know which tables will need to be separated.
> What's the purpose of {sessions} and {sequences} ?
> Is there a place where I can quickly lear about them, in order to know
> which ones to unshare ?
> 
> For now, I have unshared {menu}, {panels_info} and {panels_area}, and I
> have special variables for site_name, site_slogan, theme and front_*.
> 
> Thanks,
> Xav
> 
> On Wed, 2008-01-09 at 23:19 -0200, Alessandro Feijó wrote:
> > I think with Views & Taxonomy its possible, maybe you will wanna use 
> > Panels
> > module too
> >
> > You'll have a lot of config to do, several days, but when done, will be 
> > nice
> > :)
> >
> > Are you intimate with settings.php? You can chose with tables will be
> > generic or to each site.  Look at $db_prefix.
> >
> > i.e.
> >
> > $db_prefix = array(
> >     'sessions' => 'siteA_',
> >     'sequences' => 'siteA_',
> >     'menu' => 'siteA_',
> >     'url_alias' => 'siteA_',
> > );
> >
> > based on what you wrote, at least those 4 tables you will need to have one
> > for each site.
> >
> >
> > Feijó
> >
> >
> > ----- Original Message ----- 
> > From: "Xavier Bestel" <xavier.bestel at free.fr>
> > To: <support at drupal.org>
> > Sent: Wednesday, January 09, 2008 6:13 PM
> > Subject: [support] Multisite on same database
> >
> >
> > > Hi,
> > >
> > > I'd like to have a particular setup:
> > > - 3 sites called A.com, B.com and C.com
> > > - all running the same drupal 5 install, with the same nodes
> > > - all 3 with a different theme
> > > - all 3 with a different organisation (different primary links,
> > > frontpage, etc.)
> > > - a mean to "assign" nodes to one or the other site.
> > >
> > > I was thinking, maybe using taxonomy and have A.com have all the nodes,
> > > then B.com have only the node tagged "B-nodes" and C.com the sites
> > > tagged "C-nodes".
> > >
> > > Is something like that possible ?
> > >
> > > Thanks,
> > > Xav
> > >
> > >
> > > -- 
> > > [ Drupal support list | http://lists.drupal.org/ ]
> > >
> >
> 
> 
> -- 
> [ Drupal support list | http://lists.drupal.org/ ]