[
https://issues.apache.org/jira/browse/OFBIZ-3971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pierre Smits updated OFBIZ-3971:
--------------------------------
Attachment: OFBIZ-3971-multitenant-improvement-20110121.patch
This patch enables users to create new tenants via the ANT process.
Users can enter:
- Tenant ID
- Tenant Name
- Data to load on creation of the tenant db (e.g.seed, seed-ext, demo)
- Database Platform (Derby, MySQL, Oracle, PostgreSQL) remark: You can NOT mix
platforms)
- IP address of the database
- User-ID for the database
- Password for the database
Based on the data provided the process will:
- Create a new row in the Tenant table
- Create a new row in the TenantDataSource table
- Create new tables in the new tenant database and fill with initial data
(seed, seed-ext, demo)
- Create a new admin id for the tenant (based on Tenant ID followed by '-admin')
- Set the initial password for the tenant admin id (initial 'ofbiz', must be
changed on first login)
This patch has been tested against: Derby, MySQL, PostgreSQL. This has not been
tested against other db platforms.
Prior to running the ANT task the user
- has to modify 'general.properties' in framework/common/config te reflect
multi tenancy (multitenant=Y)
- has to have appropriate db driver(s) in place
- has to create the databases first (not for Derby, applicable for MySQL and
PostgreSQL.)
> enhancement to create new tenants easier
> ----------------------------------------
>
> Key: OFBIZ-3971
> URL: https://issues.apache.org/jira/browse/OFBIZ-3971
> Project: OFBiz
> Issue Type: Improvement
> Components: commonext/setup, framework
> Affects Versions: SVN trunk
> Environment: All
> Reporter: Pierre Smits
> Fix For: SVN trunk
>
> Attachments: OFBIZ-3971-multitenant-improvement-20110121.patch
>
>
> This modification enables backend admins to easier create new tenants.
> It first enters data about the tenant (tenantID and tenantName) in entity
> Tenant and TenantDataSource.
> Subsequently it creates the databases (derby only) for the new delegator. The
> backend-admin can state which datafiles must be loaded in the newly created
> databases (seed, seed-initial, ext, etc...)
> Finally it creates the tenant-admin and its password in the newly created
> database. The name of tenant-admin is based on the tenantId given (i.e.
> tenantId-admin). The password of the tenant-admin must be changed on first
> login.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
