topic how to implement Multi-Schema Multi-Tenancy in alfresco ? in Alfresco Forum

how to implement Multi-Schema Multi-Tenancy in alfresco ?

medhedhili — Fri, 09 Mar 2018 09:57:02 GMT

I need to implement Multi-Schema Multi-Tenancy in alfresco Any guidance will be helpful !

Re: how to implement Multi-Schema Multi-Tenancy in alfresco ?

ryandawson — Fri, 09 Mar 2018 12:54:36 GMT

I guess you mean Alfresco Process Services? If so have you looked at Multi-schema multi-tenancy (MS-MT) | Alfresco Documentation and the links at the bottom of that page?

Re: how to implement Multi-Schema Multi-Tenancy in alfresco ?

medhedhili — Fri, 09 Mar 2018 16:12:39 GMT

The official documentation is not detailed I would like to have an example of installation multi-tenant license and also I want to know how to launch a requette Rest to create a tenant

Re: how to implement Multi-Schema Multi-Tenancy in alfresco ?

ryandawson — Fri, 09 Mar 2018 16:25:44 GMT

Have you looked at the getting started link at the bottom (it is a bit hidden) - Getting started with MS-MT | Alfresco Documentation ?

I take it you are an enterprise customer? I don't have more detailed documentation to hand but as an enterprise customer you can raise an official support request.

Re: how to implement Multi-Schema Multi-Tenancy in alfresco ?

medhedhili — Fri, 09 Mar 2018 16:33:55 GMT

No, I am a student engineer as part of my end of studies project I want to know how to implement the MS-MT in alfresco. Well I looked at the example of Getting started but for example the property tenancy.model = isolated one put it in which file and how to configure the primary database?

Re: how to implement Multi-Schema Multi-Tenancy in alfresco ?

ryandawson — Mon, 12 Mar 2018 10:07:20 GMT

Ok I can share some more detailed steps that I've been able to obtain.

The tenancy.model=isolated is in activiti-app.properties

You're going to want to connect directly to the database to do this so you're going to need a database tool and the right level of access. For mysql you can create a user using e.g.

CREATE USER 'alfresco'@'localhost' IDENTIFIED BY 'password';

To create a primary database:

CREATE DATABASE primary_db
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
GRANT ALL ON primary_db.* TO 'alfresco'@'localhost';

If you want to create two tenants, you need to create two secondary databases:

CREATE DATABASE db_tenant_a
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
GRANT ALL ON db_tenant_a.* TO 'alfresco'@'localhost';

CREATE DATABASE db_tenant_b
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
GRANT ALL ON db_tenant_b.* TO 'alfresco'@'localhost';

Then you can create the tenants via the API (this API will populate the tenant database with the corresponding tables)

a. POST http://localhost:9999/activiti-app/api/enterprise/admin/tenants
{
"name" : "db_tenant_a",
"configuration" : "tenant.admin.email=admin@db_tenant_a.com\n datasource.driver=com.mysql.jdbc.Driver\n datasource.url=jdbc:mysql://127.0.0.1:3306/db_tenant_a?characterEncoding=UTF-8\n datasource.username=alfresco\n datasource.password=password"
}
b. POST http://localhost:9999/activiti-app/api/enterprise/admin/tenants
{
"name" : "db_tenant_b",
"configuration" : "tenant.admin.email=admin@db_tenant_b.com\n datasource.driver=com.mysql.jdbc.Driver\n datasource.url=jdbc:mysql://127.0.0.1:3306/db_tenant_b?characterEncoding=UTF-8\n datasource.username=alfresco\n datasource.password=password"
}

Then you should be able to Log in with tenant admin for each tenant using admin@app.activiti.com and user's passord
db_tenant_b: admin@db_tenant_b.com
!Note: Do not use admin@app.activiti.com to create users inside the tenants, only tenant admins should create users

You can then create users using tenant admin and login with those users and create new models: processes, app and try running them

Re: how to implement Multi-Schema Multi-Tenancy in alfresco ?

medhedhili — Mon, 12 Mar 2018 16:10:59 GMT

I didn't find the file activiti-app.properties . is it me that will create the file, if yes. where do I want to create the file?

Re: how to implement Multi-Schema Multi-Tenancy in alfresco ?

ryandawson — Mon, 12 Mar 2018 16:33:30 GMT

There should be a file with default values on your server - see Configuring Alfresco Process Services | Alfresco Documentation

Re: how to implement Multi-Schema Multi-Tenancy in alfresco ?

medhedhili — Tue, 13 Mar 2018 13:59:27 GMT

if activiti-app.properties does not exist in the path specified in the official documentation then I will create the file and configure it or what?

Re: how to implement Multi-Schema Multi-Tenancy in alfresco ?

ryandawson — Tue, 13 Mar 2018 17:08:14 GMT

Are you definitely using the same product and version as that documentation page?

Re: how to implement Multi-Schema Multi-Tenancy in alfresco ?

medhedhili — Tue, 13 Mar 2018 23:30:09 GMT

i use alfresco community 5.0.d

Re: how to implement Multi-Schema Multi-Tenancy in alfresco ?

ryandawson — Wed, 14 Mar 2018 09:07:00 GMT

I'm afraid that is a different product - Alfresco Community Edition 5.0 | Alfresco Documentation and it has its own forum section