----- Original Message ----- From: "Xavier Bestel" xavier.bestel@free.fr To: support@drupal.org Sent: Thursday, January 10, 2008 8:25 AM 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} ? --- sessions controls the users sessions! :) Just use good sense. sequences store the sequences (uh) of all tables, the primary keys...

Is there a place where I can quickly lear about them, in order to know which ones to unshare ? --- Good question, dunno. I analise tables content, and deduct for what use it is

For now, I have unshared {menu}, {panels_info} and {panels_area}, and I have special variables for site_name, site_slogan, theme and front_*. --- The special variables are stored at ... guess... variable table!! lol just add it to the settings.php array

you need to change only for siteB and C, the A will use default tables, naturaly

regards Feijó

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@free.fr To: support@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@free.fr To: support@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/ ]

Thanks guys ! Time to read the doc ...

Xav

On Thu, 2008-01-10 at 09:23 +0530, Shyamala wrote:

For multisite on windows: http://drupal.org/node/32715

Read 'settings.php', in the sites/default folder, to understand how drupal searches it's folder to locate the file storing a particular domain's settings.php.

Drupal by default reads the settings.php file in the default folder. You can configure the main portal settings in the default directory. The subdomains a.com and b.com can be configured by creating two new folders under the sites directory called yourdomain.a.com and yourdomain.b.com. Each of these folders should have it's own settings.php. In the settings.php of each site you have to name the database to be used.

If you want some settings to be shared between the sites you could go in for a shared database configuration.

refer: http://drupal.org/node/147828 for Multi-Site, Single Codebase, Shared Database, Shared Sign-on 5.x

Shyamala Netlink Technologies

----- Original Message ----- From: "Xavier Bestel" xavier.bestel@free.fr To: support@drupal.org Sent: Thursday, January 10, 2008 1:43 AM 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/ ]