Hello Mark,
I agree with Vince's both schemes, However it is also possible to have a
common Tomcat and different databases.
But this requires a lot of changes in many of the files importantly
beginning with
entityengine.xml. Here 1st and foremost you will have to:
1) Assign different delegators for different hosted entities
2) Assign different datasource-names
3) Different sequenced-id-prefix="" for each,
besides you will also have to change some other files related to job. Then
lot of ftl files will get changed {those that access the url}.
So in a way Mr. Vince is correct in saying that as it is - ofbiz does not
directly support multi-tenancy but it can be done with tweaks!!
Regards
On Wed, Feb 27, 2008 at 6:48 PM, Vince M. Clark <[EMAIL PROTECTED]>
wrote:
> Mark, what want to do is not possible. The database connection is
> initiated during startup based on the settings in entityengine.xml. In
> order to setup multiple instances each instance must have its own app server
> and database.
>
> You can accomplish this on the same physical server two ways:
> 1. Use virtualization technology such as vserver, Xen, or VMWare
> 2. Use different ports on each instance (8080,8443,etc.)
>
> The database is not a problem. Most DBMS support multiple databases
> (sometimes referred to as schemas or users) under the same installation of
> the DBMS.
>
> ----- Original Message -----
> From: "Mark Ellul" <[EMAIL PROTECTED]>
> To: [email protected]
> Sent: Wednesday, February 27, 2008 2:18:33 AM (GMT-0700) America/Denver
> Subject: Re: Multitenant via Host Name
>
> Hi Vijay,
>
> I guess it would be good to know if I could run it off the same
> tomcat/ofbiz
> instance....
>
> so in essence www.myerp.com and www.yourerp.com would both go
> https://x.y.z.m:PPPP/app/control/main. However the main would look at host
> headers and set the datasource name based on the host headers... and
> basically set the datasource name for the session.
>
> Is that possible?
>
> Our aim by doing this is to set up a sandbox and production site on the
> same
> server using the same codebase and just different databases.
>
> Your thoughts are appreciated
>
> Regards
>
> Mark
>
>
> On Wed, Feb 27, 2008 at 8:46 AM, Vijay <[EMAIL PROTECTED]> wrote:
>
> > You will have to change the datasource names.
> > Are you mapping the url's "www.myerp.com" and others to ofbiz specific
> > urls'
> > of https://x.y.z.m:PPPP/app/control/main ?
> >
> > The case you are trying out is perfectly possible.
> >
> > On Wed, Feb 27, 2008 at 12:54 AM, Mark Ellul <[EMAIL PROTECTED]>
> wrote:
> >
> > > Hi,
> > >
> > > I was just wondering if anyone can think of a way I could change the
> > > datasource on a user per user basis...
> > >
> > > Basically what I am trying to do is this... When User A goes to
> > > www.myerp.com they go to my ofbiz instance running on my server... but
> > > based
> > > on the url they are going to, their datasource is set to the myerp
> > > database.
> > >
> > > When user B goes to www.yourerp.com they go to the same ofbiz instance
> > > running on my server with the same code base but based on the URL
> their
> > > datasource is the yourerp database...
> > >
> > > My aim is to have one tomcat and one code base service many URLs each
> > with
> > > their own database, hopefully not having to change the datasource in
> > each
> > > service.
> > >
> > > Sorry if I am not making myself clear...
> > >
> > > Any thoughts would be appreciated
> > >
> > > Regards
> > >
> > > Mark
> > >
> >
>
