[
https://issues.apache.org/jira/browse/OFBIZ-9278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16160928#comment-16160928
]
Vivek Mishra commented on OFBIZ-9278:
-------------------------------------
What I have till now is:
created two tenants:
./gradlew createTenant -PtenantId=mytenant -PtenantName="My Name"
-PdomainName=com.example -PtenantReaders=seed,seed-initial,ext -PdbPlatform=M
-PdbIp=127.0.0.1 -PdbUser=mydbuser -PdbPassword=mydbpass
Tenant1: CAD
Tenant 2: DDS
2. Used ./gradlew ofbiz
3. Login with CAD-admin (first tenant), login successful
4. Login with DDS-admin (second tenant), following error:
Can't access entity of entityGroup = org.apache.ofbiz.tenant using tenant
delegator default#DDS, use base delegator instead
2017-07-17 17:44:41,665 |OFBiz-batch-9 |GenericDelegator
|I| Delegator "default#DDS" NOT initializing helper for entity group
"org.apache.ofbiz.tenant" because the group is not associated to this delegator.
2017-07-17 17:44:41,666 |OFBiz-batch-8 |GenericDelegator
|I| Delegator "default#DDS" initializing helper "localpostgres" for entity
group "org.apache.ofbiz".
2017-07-17 17:44:41,666 |OFBiz-batch-7 |GenericDelegator
|I| Delegator "default#DDS" initializing helper "localpostolap" for entity
group "org.apache.ofbiz.olap".
2017-07-17 17:44:41,666 |OFBiz-batch-8 |GenericDelegator
|I| Doing database check as requested in entityengine.xml with addMissing=true
2017-07-17 17:44:41,666 |OFBiz-batch-7 |GenericDelegator
|I| Doing database check as requested in entityengine.xml with addMissing=true
2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil
|I| Database Product Name is PostgreSQL
2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil
|I| Database Product Version is 9.3.17
2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil
|I| Database Driver Name is PostgreSQL Native Driver
2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil
|I| Database Driver Version is PostgreSQL 9.4 JDBC4.1 (build 1201)
2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil
|I| Database Driver JDBC Version is 4.0
2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil
|I| Database Setting/Support Information (those with a * should be true):
2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil
|I| - supports transactions [true]*
2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil
|I| - isolation None [false]
2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil
|I| - isolation ReadCommitted [true]
2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil
|I| - isolation ReadUncommitted [true]
2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil
|I| - isolation RepeatableRead [true]
2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil
|I| - isolation Serializable [true]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - forward only type [true]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - scroll sensitive type [false]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - scroll insensitive type [true]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - is case sensitive [false]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - stores LowerCase [true]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - stores MixedCase [false]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - stores UpperCase [false]
2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil
|I| Database Product Name is PostgreSQL
2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil
|I| Database Product Version is 9.3.17
2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil
|I| Database Driver Name is PostgreSQL Native Driver
2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil
|I| Database Driver Version is PostgreSQL 9.4 JDBC4.1 (build 1201)
2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil
|I| Database Driver JDBC Version is 4.0
2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil
|I| Database Setting/Support Information (those with a * should be true):
2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil
|I| - supports transactions [true]*
2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil
|I| - isolation None [false]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - max table name length [63]
2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil
|I| - isolation ReadCommitted [true]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - max column name length [63]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - concurrent connections [8192]
2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil
|I| - isolation ReadUncommitted [true]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - concurrent statements [0]
2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil
|I| - isolation RepeatableRead [true]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - ANSI SQL92 Entry [true]
2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil
|I| - ANSI SQL92 Intermediate [false]
2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil
|I| - isolation Serializable [true]
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - ANSI SQL92 Full [false]
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - ODBC SQL Grammar Core [false]
2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil
|I| - forward only type [true]
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - ODBC SQL Grammar Extended [false]
2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil
|I| - scroll sensitive type [false]
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - ODBC SQL Grammar Minimum [true]
2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil
|I| - scroll insensitive type [true]
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - outer joins [true]*
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - limited outer joins [true]
2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil
|I| - is case sensitive [false]
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - full outer joins [true]
2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil
|I| - stores LowerCase [true]
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - group by [true]*
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - group by not in select [true]
2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil
|I| - stores MixedCase [false]
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - column aliasing [true]
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - order by not in select [true]
2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil
|I| - stores UpperCase [false]
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - alter table add column [true]*
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - non-nullable column [true]*
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - default fetchsize [0]
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| - named parameters [ SKIPPED ]
2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil
|I| Getting Table Info From Database
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - max table name length [63]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - max column name length [63]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - concurrent connections [8192]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - concurrent statements [0]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - ANSI SQL92 Entry [true]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - ANSI SQL92 Intermediate [false]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - ANSI SQL92 Full [false]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - ODBC SQL Grammar Core [false]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - ODBC SQL Grammar Extended [false]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - ODBC SQL Grammar Minimum [true]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - outer joins [true]*
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - limited outer joins [true]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - full outer joins [true]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - group by [true]*
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - group by not in select [true]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - column aliasing [true]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - order by not in select [true]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - alter table add column [true]*
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - non-nullable column [true]*
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - default fetchsize [0]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| - named parameters [ SKIPPED ]
2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil
|I| Getting Table Info From Database
2017-07-17 17:44:41,672 |OFBiz-batch-7 |DatabaseUtil
|I| Getting Column Info From Database
2017-07-17 17:44:41,678 |OFBiz-batch-7 |DatabaseUtil
|I| Reviewed 8 primary key fields from database.
2017-07-17 17:44:41,688 |OFBiz-batch-8 |DatabaseUtil
|I| Getting Column Info From Database
2017-07-17 17:44:41,878 |OFBiz-batch-8 |DatabaseUtil
|I| Reviewed 1704 primary key fields from database.
2017-07-17 17:44:41,890 |OFBiz-batch-9 |ServiceGroupReader
|I| Loaded [1] Group definitions from
file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/groups_test.xml
2017-07-17 17:44:41,892 |http-nio-8445-exec-6 |ServiceGroupReader
|I| Loaded [1] Group definitions from
file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/groups_test.xml
2017-07-17 17:44:41,892 |OFBiz-batch-9 |ServiceGroupReader
|I| Loaded [4] Group definitions from
file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef/groups.xml
2017-07-17 17:44:41,894 |OFBiz-batch-9 |ServiceGroupReader
|I| Loaded [2] Group definitions from
file:/home/nicsi/Ofbiz_tenant/applications/workeffort/servicedef/service_groups.xml
2017-07-17 17:44:41,894 |http-nio-8445-exec-6 |ServiceGroupReader
|I| Loaded [4] Group definitions from
file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef/groups.xml
2017-07-17 17:44:41,896 |OFBiz-batch-9 |ServiceGroupReader
|I| Loaded [1] Group definitions from
file:/home/nicsi/Ofbiz_tenant/applications/product/servicedef/groups.xml
2017-07-17 17:44:41,897 |http-nio-8445-exec-6 |ServiceGroupReader
|I| Loaded [2] Group definitions from
file:/home/nicsi/Ofbiz_tenant/applications/workeffort/servicedef/service_groups.xml
2017-07-17 17:44:41,899 |http-nio-8445-exec-6 |ServiceGroupReader
|I| Loaded [1] Group definitions from
file:/home/nicsi/Ofbiz_tenant/applications/product/servicedef/groups.xml
2017-07-17 17:44:41,899 |OFBiz-batch-9 |ServiceGroupReader
|I| Loaded [4] Group definitions from
file:/home/nicsi/Ofbiz_tenant/applications/accounting/servicedef/groups.xml
2017-07-17 17:44:41,901 |OFBiz-batch-9 |ServiceDispatcher
|I| Registering dispatcher: entity-default#DDS#DDS
2017-07-17 17:44:41,901 |OFBiz-batch-9 |ServiceContainer
|I| Created new dispatcher: entity-default#DDS#DDS
2017-07-17 17:44:41,903 |http-nio-8445-exec-6 |ServiceGroupReader
|I| Loaded [4] Group definitions from
file:/home/nicsi/Ofbiz_tenant/applications/accounting/servicedef/groups.xml
2017-07-17 17:44:41,903 |http-nio-8445-exec-6 |ServiceDispatcher
|I| Registering dispatcher: Humanres#DDS
2017-07-17 17:44:41,903 |http-nio-8445-exec-6 |ServiceContainer
|I| Created new dispatcher: Humanres#DDS
2017-07-17 17:44:41,904 |http-nio-8445-exec-6 |ControlServlet
|T| [[[login(Domain:https://localhost)] Request Begun, encoding=[UTF-8]-
total:0.0,since last(Begin):0.0]]
2017-07-17 17:44:41,991 |http-nio-8445-exec-6 |ConfigXMLReader
|I| controller loaded: 0.073s, 280 requests, 124 views in
file:/home/nicsi/Ofbiz_tenant/applications/humanres/webapp/humanres/WEB-INF/controller.xml
2017-07-17 17:44:42,010 |http-nio-8445-exec-6 |ConfigXMLReader
|I| controller loaded: 0.014s, 45 requests, 22 views in
file:/home/nicsi/Ofbiz_tenant/framework/common/webcommon/WEB-INF/common-controller.xml
2017-07-17 17:44:42,017 |http-nio-8445-exec-6 |ConfigXMLReader
|I| controller loaded: 0.0s, 0 requests, 0 views in
file:/home/nicsi/Ofbiz_tenant/framework/common/webcommon/WEB-INF/handlers-controller.xml
2017-07-17 17:44:42,088 |http-nio-8445-exec-6 |ConfigXMLReader
|I| controller loaded: 0.065s, 255 requests, 104 views in
file:/home/nicsi/Ofbiz_tenant/applications/party/webapp/partymgr/WEB-INF/controller.xml
2017-07-17 17:44:42,100 |http-nio-8445-exec-6 |ConfigXMLReader
|I| controller loaded: 0.007s, 30 requests, 13 views in
file:/home/nicsi/Ofbiz_tenant/framework/common/webcommon/WEB-INF/security-controller.xml
2017-07-17 17:44:42,105 |http-nio-8445-exec-6 |ConfigXMLReader
|I| controller loaded: 0.001s, 4 requests, 0 views in
file:/home/nicsi/Ofbiz_tenant/applications/commonext/webapp/WEB-INF/controller.xml
2017-07-17 17:44:42,210 |http-nio-8445-exec-6 |ConfigXMLReader
|I| controller loaded: 0.097s, 379 requests, 154 views in
file:/home/nicsi/Ofbiz_tenant/applications/content/webapp/content/WEB-INF/controller.xml
JJJJJJJJJJJDDS-admin
2017-07-17 17:44:42,218 |http-nio-8445-exec-6 |LoginServices
|I| [LoginServices.userLogin] Invalid User : 'DDS-admin'; User not found.
2017-07-17 17:44:42,218 |http-nio-8445-exec-6 |ServiceDispatcher
|W| Service Failure [userLogin]: User not found.
2017-07-17 17:44:42,219 |http-nio-8445-exec-6 |ServiceDispatcher
|T| Sync service [Humanres#CAD/userLogin] finished in [3] milliseconds
2017-07-17 17:44:42,219 |http-nio-8445-exec-6 |RequestHandler
|I| Ran Event [java:org.apache.ofbiz.webapp.control.LoginWorker#login] from
[request], result is [error]
2017-07-17 17:44:42,223 |http-nio-8445-exec-6 |RequestHandler
|E| Request login caused an error with the following message: following error
occurred during login: User not found.
2017-07-17 17:44:42,224 |http-nio-8445-exec-6 |RequestHandler
|I| Rendering View [login]. Hidden sessionId by default.
2017-07-17 17:44:42,227 |http-nio-8445-exec-6 |ServiceDispatcher
|T| Sync service [Humanres#CAD/getUserPreferenceGroup] finished in [1]
milliseconds
2017-07-17 17:44:42,263 |http-nio-8445-exec-6 |ServiceDispatcher
|T| Sync service [Humanres#CAD/getVisualThemeResources] finished in [34]
milliseconds
2017-07-17 17:44:42,271 |http-nio-8445-exec-6 |ScreenFactory
|I| Got 26 screens in 0.006s from:
file:/home/nicsi/Ofbiz_tenant/framework/common/widget/CommonScreens.xml
2017-07-17 17:44:42,277 |http-nio-8445-exec-6 |UtilXml
|E| XmlFileLoader: File
file:/home/nicsi/Ofbiz_tenant/applications/humanres/widget/CommonScreens.xml
process error. Line: 561. Error message: cvc-complex-type.2.3: Element
'screens' cannot have character [children], because the type's content type is
element-only.
2017-07-17 17:44:42,277 |http-nio-8445-exec-6 |ScreenFactory
|I| Got 14 screens in 0.005s from:
file:/home/nicsi/Ofbiz_tenant/applications/humanres/widget/CommonScreens.xml
2017-07-17 17:44:42,282 |http-nio-8445-exec-6 |ScreenFactory
|I| Got 1 screens in 0.004s from:
file:/home/nicsi/Ofbiz_tenant/applications/commonext/widget/CommonScreens.xml
2017-07-17 17:44:42,282 |http-nio-8445-exec-6 |PrimaryKeyFinder
|I| Returning null because found incomplete primary key in find:
[GenericEntity:PartyNameView][partyId,null()]
2017-07-17 17:44:42,352 |http-nio-8445-exec-6 |ServiceDispatcher
|T| Sync service [Humanres#CAD/getLastSystemInfoNote] finished in [18]
milliseconds
2017-07-17 17:44:42,356 |http-nio-8445-exec-6 |ServiceDispatcher
|T| Sync service [Humanres#CAD/getVisualThemeResources] finished in [1]
milliseconds
2017-07-17 17:44:42,392 |http-nio-8445-exec-6 |ServerHitBin
|I| The Visit GenericValue stored in the client session does not exist in the
database, not storing server hit.
2017-07-17 17:44:42,395 |http-nio-8445-exec-6 |ControlServlet
|T| [[[login(Domain:https://localhost)] Request Done- total:0.491,since
last([login(Domain:htt...):0.491]]
> Login after multitenant
> -----------------------
>
> Key: OFBIZ-9278
> URL: https://issues.apache.org/jira/browse/OFBIZ-9278
> Project: OFBiz
> Issue Type: Bug
> Affects Versions: Release Branch 16.11
> Environment: linux mint 17.1, MySql 5.5.54
> Reporter: Guillaume Fortin
> Priority: Minor
> Labels: multitenancy, multitenant
>
> I want to create two tenants named respectively e3 and psp. To create
> them, I use those command lines:
> ./gradlew createTenant -PtenantId=PSP -PtenantReaders=seed,seed-initial
> -PdbPlatform=M -PdbUser=XXXX -PdbPassword=XXXX
> ./gradlew createTenant -PtenantId=E3 -PtenantReaders=seed,seed-initial
> -PdbPlatform=M -PdbUser=XXXX -PdbPassword=XXXXX
> After creating the first tenant, I was able to connect with psp-admin
> user. After I created the second one, I was able to connect to the second
> database e3 with the e3-admin user but impossible to connect again on the
> PSP application.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
