Tenant Login Issue in OFBiz 16.11

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

Tenant Login Issue in OFBiz 16.11

vivek.mi
Hello All,

I have created two tenants in the application. When i am logging in, the first tenant is logging in successfully, but second one throwing error.

Can't access entity of entityGroup = org.apache.ofbiz.tenant using tenant delegator default#DDS, use base delegator instead
2017-07-17 15:05:27,143 |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 15:05:27,143 |OFBiz-batch-7        |GenericDelegator              |I| Delegator "default#DDS" initializing helper "localpostolap" for entity group "org.apache.ofbiz.olap".
2017-07-17 15:05:27,143 |OFBiz-batch-7        |GenericDelegator              |I| Doing database check as requested in entityengine.xml with addMissing=true
2017-07-17 15:05:27,144 |OFBiz-batch-8        |GenericDelegator              |I| Delegator "default#DDS" initializing helper "localpostgres" for entity group "org.apache.ofbiz".
2017-07-17 15:05:27,144 |OFBiz-batch-8        |GenericDelegator              |I| Doing database check as requested in entityengine.xml with addMissing=true
2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil                  |I| Database Product Name is PostgreSQL
2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil                  |I| Database Product Version is 9.3.17
2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil                  |I| Database Driver Name is PostgreSQL Native Driver
2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil                  |I| Database Driver Version is PostgreSQL 9.4 JDBC4.1 (build 1201)
2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil                  |I| Database Driver JDBC Version is 4.0
2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil                  |I| Database Setting/Support Information (those with a * should be true):
2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil                  |I| - supports transactions     [true]*
2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil                  |I| - isolation None            [false]
2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil                  |I| - isolation ReadCommitted   [true]
2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil                  |I| - isolation ReadUncommitted [true]
2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil                  |I| - isolation RepeatableRead  [true]
2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil                  |I| - isolation Serializable    [true]
2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil                  |I| - forward only type         [true]
2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil                  |I| - scroll sensitive type     [false]
2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil                  |I| - scroll insensitive type   [true]
2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil                  |I| - is case sensitive         [false]
2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil                  |I| - stores LowerCase          [true]
2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil                  |I| - stores MixedCase          [false]
2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil                  |I| - stores UpperCase          [false]
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| Database Product Name is PostgreSQL
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| Database Product Version is 9.3.17
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| Database Driver Name is PostgreSQL Native Driver
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| Database Driver Version is PostgreSQL 9.4 JDBC4.1 (build 1201)
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| Database Driver JDBC Version is 4.0
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| Database Setting/Support Information (those with a * should be true):
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - supports transactions     [true]*
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - isolation None            [false]
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - isolation ReadCommitted   [true]
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - isolation ReadUncommitted [true]
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - isolation RepeatableRead  [true]
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - isolation Serializable    [true]
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - forward only type         [true]
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - scroll sensitive type     [false]
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - scroll insensitive type   [true]
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - is case sensitive         [false]
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - stores LowerCase          [true]
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - stores MixedCase          [false]
2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil                  |I| - stores UpperCase          [false]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - max table name length     [63]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - max column name length    [63]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - concurrent connections    [8192]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - concurrent statements     [0]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - ANSI SQL92 Entry          [true]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - ANSI SQL92 Intermediate   [false]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - ANSI SQL92 Full           [false]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - ODBC SQL Grammar Core     [false]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - ODBC SQL Grammar Extended [false]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - ODBC SQL Grammar Minimum  [true]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - outer joins               [true]*
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - limited outer joins       [true]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - full outer joins          [true]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - group by                  [true]*
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - group by not in select    [true]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - column aliasing           [true]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - order by not in select    [true]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - alter table add column    [true]*
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - non-nullable column       [true]*
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - default fetchsize        [0]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| - named parameters         [ SKIPPED ]
2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| Getting Table Info From Database
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - max table name length     [63]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - max column name length    [63]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - concurrent connections    [8192]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - concurrent statements     [0]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - ANSI SQL92 Entry          [true]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - ANSI SQL92 Intermediate   [false]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - ANSI SQL92 Full           [false]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - ODBC SQL Grammar Core     [false]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - ODBC SQL Grammar Extended [false]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - ODBC SQL Grammar Minimum  [true]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - outer joins               [true]*
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - limited outer joins       [true]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - full outer joins          [true]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - group by                  [true]*
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - group by not in select    [true]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - column aliasing           [true]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - order by not in select    [true]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - alter table add column    [true]*
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - non-nullable column       [true]*
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - default fetchsize        [0]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| - named parameters         [ SKIPPED ]
2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| Getting Table Info From Database
2017-07-17 15:05:27,675 |OFBiz-batch-8        |DatabaseUtil                  |I| Getting Column Info From Database
2017-07-17 15:05:27,706 |OFBiz-batch-7        |DatabaseUtil                  |I| Getting Column Info From Database
2017-07-17 15:05:27,759 |OFBiz-batch-7        |DatabaseUtil                  |I| Reviewed 8 primary key fields from database.
2017-07-17 15:05:28,077 |OFBiz-batch-8        |DatabaseUtil                  |I| Reviewed 1704 primary key fields from database.
2017-07-17 15:05:28,089 |OFBiz-batch-7        |ServiceGroupReader            |I| Loaded [1] Group definitions from file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/groups_test.xml
2017-07-17 15:05:28,090 |http-nio-8445-exec-1 |ServiceGroupReader            |I| Loaded [1] Group definitions from file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/groups_test.xml
2017-07-17 15:05:28,092 |OFBiz-batch-7        |ServiceGroupReader            |I| Loaded [4] Group definitions from file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef/groups.xml
2017-07-17 15:05:28,092 |http-nio-8445-exec-1 |ServiceGroupReader            |I| Loaded [4] Group definitions from file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef/groups.xml
2017-07-17 15:05:28,095 |OFBiz-batch-7        |ServiceGroupReader            |I| Loaded [2] Group definitions from file:/home/nicsi/Ofbiz_tenant/applications/workeffort/servicedef/service_groups.xml
2017-07-17 15:05:28,095 |http-nio-8445-exec-1 |ServiceGroupReader            |I| Loaded [2] Group definitions from file:/home/nicsi/Ofbiz_tenant/applications/workeffort/servicedef/service_groups.xml
2017-07-17 15:05:28,098 |http-nio-8445-exec-1 |ServiceGroupReader            |I| Loaded [1] Group definitions from file:/home/nicsi/Ofbiz_tenant/applications/product/servicedef/groups.xml
2017-07-17 15:05:28,098 |OFBiz-batch-7        |ServiceGroupReader            |I| Loaded [1] Group definitions from file:/home/nicsi/Ofbiz_tenant/applications/product/servicedef/groups.xml
2017-07-17 15:05:28,101 |OFBiz-batch-7        |ServiceGroupReader            |I| Loaded [4] Group definitions from file:/home/nicsi/Ofbiz_tenant/applications/accounting/servicedef/groups.xml
2017-07-17 15:05:28,101 |http-nio-8445-exec-1 |ServiceGroupReader            |I| Loaded [4] Group definitions from file:/home/nicsi/Ofbiz_tenant/applications/accounting/servicedef/groups.xml
2017-07-17 15:05:28,215 |OFBiz-batch-7        |ServiceDispatcher             |I| Registering dispatcher: entity-default#DDS#DDS
2017-07-17 15:05:28,215 |OFBiz-batch-7        |ServiceContainer              |I| Created new dispatcher: entity-default#DDS#DDS
2017-07-17 15:05:28,215 |http-nio-8445-exec-1 |ServiceDispatcher             |I| Registering dispatcher: Humanres#DDS
2017-07-17 15:05:28,215 |http-nio-8445-exec-1 |ServiceContainer              |I| Created new dispatcher: Humanres#DDS
2017-07-17 15:05:28,215 |http-nio-8445-exec-1 |ControlServlet                |T| [[[login(Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2017-07-17 15:05:28,291 |http-nio-8445-exec-1 |UtilProperties                |I| ResourceBundle SecurityextUiLabels (en_US) created in 0.019s with 69 properties
2017-07-17 15:05:28,291 |http-nio-8445-exec-1 |LoginServices                 |I| [LoginServices.userLogin] Invalid User : 'DDS-admin'; User not found.
2017-07-17 15:05:28,292 |http-nio-8445-exec-1 |ServiceDispatcher             |W| Service Failure [userLogin]: User not found.
2017-07-17 15:05:28,292 |http-nio-8445-exec-1 |ServiceDispatcher             |T| Sync service [Humanres#CAD/userLogin] finished in [22] milliseconds

I tried to search for it, but not getting anything useful.
Please revert.

Regards,
Vivek Mishra

Vivek Mishra
Reply | Threaded
Open this post in threaded view
|

Re: Tenant Login Issue in OFBiz 16.11

taher
I think this issue is related to [1]. I requested some tests but the
user was busy, if you can help then perhaps we can resolve this issue

[1] https://issues.apache.org/jira/browse/OFBIZ-9278

On Mon, Jul 17, 2017 at 12:19 PM, vivek.mi <[hidden email]> wrote:

> Hello All,
>
> I have created two tenants in the application. When i am logging in, the
> first tenant is logging in successfully, but second one throwing error.
>
> *Can't access entity of entityGroup = org.apache.ofbiz.tenant using tenant
> delegator default#DDS, use base delegator instead*
> 2017-07-17 15:05:27,143 |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 15:05:27,143 |OFBiz-batch-7        |GenericDelegator
> |I| Delegator "default#DDS" initializing helper "localpostolap" for entity
> group "org.apache.ofbiz.olap".
> 2017-07-17 15:05:27,143 |OFBiz-batch-7        |GenericDelegator
> |I| Doing database check as requested in entityengine.xml with
> addMissing=true
> 2017-07-17 15:05:27,144 |OFBiz-batch-8        |GenericDelegator
> |I| Delegator "default#DDS" initializing helper "localpostgres" for entity
> group "org.apache.ofbiz".
> 2017-07-17 15:05:27,144 |OFBiz-batch-8        |GenericDelegator
> |I| Doing database check as requested in entityengine.xml with
> addMissing=true
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| Database Product Name is PostgreSQL
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| Database Product Version is 9.3.17
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| Database Driver Name is PostgreSQL Native Driver
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| Database Driver Version is PostgreSQL 9.4 JDBC4.1 (build 1201)
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| Database Driver JDBC Version is 4.0
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| Database Setting/Support Information (those with a * should be true):
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| - supports transactions     [true]*
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| - isolation None            [false]
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| - isolation ReadCommitted   [true]
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| - isolation ReadUncommitted [true]
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| - isolation RepeatableRead  [true]
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| - isolation Serializable    [true]
> 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> |I| - forward only type         [true]
> 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> |I| - scroll sensitive type     [false]
> 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> |I| - scroll insensitive type   [true]
> 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> |I| - is case sensitive         [false]
> 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> |I| - stores LowerCase          [true]
> 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> |I| - stores MixedCase          [false]
> 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> |I| - stores UpperCase          [false]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| Database Product Name is PostgreSQL
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| Database Product Version is 9.3.17
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| Database Driver Name is PostgreSQL Native Driver
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| Database Driver Version is PostgreSQL 9.4 JDBC4.1 (build 1201)
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| Database Driver JDBC Version is 4.0
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| Database Setting/Support Information (those with a * should be true):
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - supports transactions     [true]*
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - isolation None            [false]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - isolation ReadCommitted   [true]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - isolation ReadUncommitted [true]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - isolation RepeatableRead  [true]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - isolation Serializable    [true]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - forward only type         [true]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - scroll sensitive type     [false]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - scroll insensitive type   [true]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - is case sensitive         [false]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - stores LowerCase          [true]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - stores MixedCase          [false]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - stores UpperCase          [false]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - max table name length     [63]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - max column name length    [63]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - concurrent connections    [8192]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - concurrent statements     [0]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - ANSI SQL92 Entry          [true]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - ANSI SQL92 Intermediate   [false]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - ANSI SQL92 Full           [false]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - ODBC SQL Grammar Core     [false]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - ODBC SQL Grammar Extended [false]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - ODBC SQL Grammar Minimum  [true]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - outer joins               [true]*
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - limited outer joins       [true]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - full outer joins          [true]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - group by                  [true]*
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - group by not in select    [true]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - column aliasing           [true]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - order by not in select    [true]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - alter table add column    [true]*
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - non-nullable column       [true]*
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - default fetchsize        [0]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - named parameters         [ SKIPPED ]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| Getting Table Info From Database
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - max table name length     [63]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - max column name length    [63]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - concurrent connections    [8192]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - concurrent statements     [0]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - ANSI SQL92 Entry          [true]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - ANSI SQL92 Intermediate   [false]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - ANSI SQL92 Full           [false]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - ODBC SQL Grammar Core     [false]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - ODBC SQL Grammar Extended [false]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - ODBC SQL Grammar Minimum  [true]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - outer joins               [true]*
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - limited outer joins       [true]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - full outer joins          [true]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - group by                  [true]*
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - group by not in select    [true]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - column aliasing           [true]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - order by not in select    [true]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - alter table add column    [true]*
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - non-nullable column       [true]*
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - default fetchsize        [0]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - named parameters         [ SKIPPED ]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| Getting Table Info From Database
> 2017-07-17 15:05:27,675 |OFBiz-batch-8        |DatabaseUtil
> |I| Getting Column Info From Database
> 2017-07-17 15:05:27,706 |OFBiz-batch-7        |DatabaseUtil
> |I| Getting Column Info From Database
> 2017-07-17 15:05:27,759 |OFBiz-batch-7        |DatabaseUtil
> |I| Reviewed 8 primary key fields from database.
> 2017-07-17 15:05:28,077 |OFBiz-batch-8        |DatabaseUtil
> |I| Reviewed 1704 primary key fields from database.
> 2017-07-17 15:05:28,089 |OFBiz-batch-7        |ServiceGroupReader
> |I| Loaded [1] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/groups_test.xml
> 2017-07-17 15:05:28,090 |http-nio-8445-exec-1 |ServiceGroupReader
> |I| Loaded [1] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/groups_test.xml
> 2017-07-17 15:05:28,092 |OFBiz-batch-7        |ServiceGroupReader
> |I| Loaded [4] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef/groups.xml
> 2017-07-17 15:05:28,092 |http-nio-8445-exec-1 |ServiceGroupReader
> |I| Loaded [4] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef/groups.xml
> 2017-07-17 15:05:28,095 |OFBiz-batch-7        |ServiceGroupReader
> |I| Loaded [2] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/applications/workeffort/servicedef/service_groups.xml
> 2017-07-17 15:05:28,095 |http-nio-8445-exec-1 |ServiceGroupReader
> |I| Loaded [2] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/applications/workeffort/servicedef/service_groups.xml
> 2017-07-17 15:05:28,098 |http-nio-8445-exec-1 |ServiceGroupReader
> |I| Loaded [1] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/applications/product/servicedef/groups.xml
> 2017-07-17 15:05:28,098 |OFBiz-batch-7        |ServiceGroupReader
> |I| Loaded [1] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/applications/product/servicedef/groups.xml
> 2017-07-17 15:05:28,101 |OFBiz-batch-7        |ServiceGroupReader
> |I| Loaded [4] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/applications/accounting/servicedef/groups.xml
> 2017-07-17 15:05:28,101 |http-nio-8445-exec-1 |ServiceGroupReader
> |I| Loaded [4] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/applications/accounting/servicedef/groups.xml
> 2017-07-17 15:05:28,215 |OFBiz-batch-7        |ServiceDispatcher
> |I| Registering dispatcher: entity-default#DDS#DDS
> 2017-07-17 15:05:28,215 |OFBiz-batch-7        |ServiceContainer
> |I| Created new dispatcher: entity-default#DDS#DDS
> 2017-07-17 15:05:28,215 |http-nio-8445-exec-1 |ServiceDispatcher
> |I| Registering dispatcher: Humanres#DDS
> 2017-07-17 15:05:28,215 |http-nio-8445-exec-1 |ServiceContainer
> |I| Created new dispatcher: Humanres#DDS
> 2017-07-17 15:05:28,215 |http-nio-8445-exec-1 |ControlServlet
> |T| [[[login(Domain:https://localhost)] Request Begun, encoding=[UTF-8]-
> total:0.0,since last(Begin):0.0]]
> 2017-07-17 15:05:28,291 |http-nio-8445-exec-1 |UtilProperties
> |I| ResourceBundle SecurityextUiLabels (en_US) created in 0.019s with 69
> properties
> 2017-07-17 15:05:28,291 |http-nio-8445-exec-1 |LoginServices
> |I| *[LoginServices.userLogin] Invalid User : 'DDS-admin'; User not found*.
> 2017-07-17 15:05:28,292 |http-nio-8445-exec-1 |ServiceDispatcher
> |W| *Service Failure [userLogin]: User not found*.
> 2017-07-17 15:05:28,292 |http-nio-8445-exec-1 |ServiceDispatcher
> |T| Sync service *[Humanres#CAD/userLogin] *finished in [22] milliseconds
>
> I tried to search for it, but not getting anything useful.
> Please revert.
>
> Regards,
> Vivek Mishra
>
>
>
>
>
> -----
> Vivek Mishra
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Tenant-Login-Issue-in-OFBiz-16-11-tp4708208.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
Reply | Threaded
Open this post in threaded view
|

Re: Tenant Login Issue in OFBiz 16.11

vivek.mi
Thanks Taher for your reply. Yes we can go ahead with that.
Vivek Mishra
Reply | Threaded
Open this post in threaded view
|

Re: Tenant Login Issue in OFBiz 16.11

vivek.mi
In reply to this post by taher
Actually what is happening when i am stopping the application and using the command ./gradlew "ofbiz --load-data readers=seed" then the other tenant login will be successful, but first one again is not able to and the process continues.
Vivek Mishra
Reply | Threaded
Open this post in threaded view
|

Re: Tenant Login Issue in OFBiz 16.11

taher
Ahhh, I'm not sure but I think this means you might be overwriting the
tenant data. You need need to pass something like ./gradlew "ofbiz
--load-data readers=seed --load-data delegator=default#tenant_id_here"

Either way, if the JIRA is relevant then I suggest to continue the
discussion over there.

On Mon, Jul 17, 2017 at 2:15 PM, vivek.mi <[hidden email]> wrote:

> Actually what is happening when i am stopping the application and using the
> command *./gradlew "ofbiz --load-data readers=seed"* then the other tenant
> login will be successful, but first one again is not able to and the process
> continues.
>
>
>
> -----
> Vivek Mishra
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Tenant-Login-Issue-in-OFBiz-16-11-tp4708208p4708218.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
Reply | Threaded
Open this post in threaded view
|

Re: Tenant Login Issue in OFBiz 16.11

vivek.mi
I did try. I created two tenants with:

1. ./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]]


Vivek Mishra
Reply | Threaded
Open this post in threaded view
|

Re: Tenant Login Issue in OFBiz 16.11

taher
Very happy to note that I finally cracked the puzzle on this bug. It's
a simple case of readers=tenant that was missing in the build script.
This bug was always there since the introduction of gradle. So I will
fix it and backport to branch 16. You can check [1] for more.

However, given that this bug was discovered so late gives me an
indication that very few people are interested in the multi-tenancy
feature in OFBiz.

[1] https://issues.apache.org/jira/browse/OFBIZ-9278

On Mon, Jul 17, 2017 at 2:59 PM, vivek.mi <[hidden email]> wrote:

> I did try. I created two tenants with:
>
> 1. *./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]]
>
>
>
>
>
>
> -----
> Vivek Mishra
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Tenant-Login-Issue-in-OFBiz-16-11-tp4708208p4708222.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
Reply | Threaded
Open this post in threaded view
|

Re: Tenant Login Issue in OFBiz 16.11

Jacques Le Roux
Administrator
Le 29/09/2017 à 17:49, Taher Alkhateeb a écrit :
> Very happy to note that I finally cracked the puzzle on this bug. It's
> a simple case of readers=tenant that was missing in the build script.
> This bug was always there since the introduction of gradle. So I will
> fix it and backport to branch 16. You can check [1] for more.
>
> However, given that this bug was discovered so late gives me an
> indication that very few people are interested in the multi-tenancy
> feature in OFBiz.
That's a good news anyway, thanks Taher

Jacques

>
> [1] https://issues.apache.org/jira/browse/OFBIZ-9278
>
> On Mon, Jul 17, 2017 at 2:59 PM, vivek.mi <[hidden email]> wrote:
>> I did try. I created two tenants with:
>>
>> 1. *./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]]
>>
>>
>>
>>
>>
>>
>> -----
>> Vivek Mishra
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.com/Tenant-Login-Issue-in-OFBiz-16-11-tp4708208p4708222.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.

Reply | Threaded
Open this post in threaded view
|

Re: Tenant Login Issue in OFBiz 16.11

Arun Patidar-2
Hi Taher,

Thanks for fixing the issue. The issue of multi-tenant logins in the same
browser can be achieved by using sub-domain in URL for each tenant. In this
way, there will be a separate session and cookie management.

--
Thanks & Regards
---
Arun Patidar
Manager, Enterprise Software Development

HotWax Systems Pvt Ltd.

www.hotwaxsystems.com


On Fri, Sep 29, 2017 at 9:45 PM, Jacques Le Roux <
[hidden email]> wrote:

> Le 29/09/2017 à 17:49, Taher Alkhateeb a écrit :
>
>> Very happy to note that I finally cracked the puzzle on this bug. It's
>> a simple case of readers=tenant that was missing in the build script.
>> This bug was always there since the introduction of gradle. So I will
>> fix it and backport to branch 16. You can check [1] for more.
>>
>> However, given that this bug was discovered so late gives me an
>> indication that very few people are interested in the multi-tenancy
>> feature in OFBiz.
>>
> That's a good news anyway, thanks Taher
>
> Jacques
>
>
>
>> [1] https://issues.apache.org/jira/browse/OFBIZ-9278
>>
>> On Mon, Jul 17, 2017 at 2:59 PM, vivek.mi <[hidden email]> wrote:
>>
>>> I did try. I created two tenants with:
>>>
>>> 1. *./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/gr
>>> oups_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/gr
>>> oups_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/servic
>>> edef/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/servic
>>> edef/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/servic
>>> edef/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/servic
>>> edef/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/h
>>> umanres/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/part
>>> ymgr/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/co
>>> ntent/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/C
>>> ommonScreens.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/C
>>> ommonScreens.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]]
>>>
>>>
>>>
>>>
>>>
>>>
>>> -----
>>> Vivek Mishra
>>> --
>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>> com/Tenant-Login-Issue-in-OFBiz-16-11-tp4708208p4708222.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: Tenant Login Issue in OFBiz 16.11

taher
Hi Arun,

So does that work for developers on localhost? Is it an acceptable
compromise to ignore and close the JIRA?

On Oct 3, 2017 3:36 PM, "Arun Patidar" <[hidden email]>
wrote:

> Hi Taher,
>
> Thanks for fixing the issue. The issue of multi-tenant logins in the same
> browser can be achieved by using sub-domain in URL for each tenant. In this
> way, there will be a separate session and cookie management.
>
> --
> Thanks & Regards
> ---
> Arun Patidar
> Manager, Enterprise Software Development
>
> HotWax Systems Pvt Ltd.
>
> www.hotwaxsystems.com
>
>
> On Fri, Sep 29, 2017 at 9:45 PM, Jacques Le Roux <
> [hidden email]> wrote:
>
> > Le 29/09/2017 à 17:49, Taher Alkhateeb a écrit :
> >
> >> Very happy to note that I finally cracked the puzzle on this bug. It's
> >> a simple case of readers=tenant that was missing in the build script.
> >> This bug was always there since the introduction of gradle. So I will
> >> fix it and backport to branch 16. You can check [1] for more.
> >>
> >> However, given that this bug was discovered so late gives me an
> >> indication that very few people are interested in the multi-tenancy
> >> feature in OFBiz.
> >>
> > That's a good news anyway, thanks Taher
> >
> > Jacques
> >
> >
> >
> >> [1] https://issues.apache.org/jira/browse/OFBIZ-9278
> >>
> >> On Mon, Jul 17, 2017 at 2:59 PM, vivek.mi <[hidden email]> wrote:
> >>
> >>> I did try. I created two tenants with:
> >>>
> >>> 1. *./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/gr
> >>> oups_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/gr
> >>> oups_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/servic
> >>> edef/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/servic
> >>> edef/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/servic
> >>> edef/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/servic
> >>> edef/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/h
> >>> umanres/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/part
> >>> ymgr/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/co
> >>> ntent/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/C
> >>> ommonScreens.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/C
> >>> ommonScreens.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]]
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> -----
> >>> Vivek Mishra
> >>> --
> >>> View this message in context: http://ofbiz.135035.n4.nabble.
> >>> com/Tenant-Login-Issue-in-OFBiz-16-11-tp4708208p4708222.html
> >>> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>>
> >>
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: Tenant Login Issue in OFBiz 16.11

Arun Patidar-2
Hello Taher,

Yes, it is possible to run domain/sub-domain on localhost by making changes
in the file */etc/hosts* of Ubuntu environment. It requires putting the
domain name in front of local IP 127.0.0.1.

Also, there is a domain_name field in Tenant entity that can be used for
specifying a domain name for each tenant.

IMO, in real time environment of multi-tenant,  there should be a unique
domain/sub-domain for each tenant. So we are safe to close Jira ticket.


--
Thanks & Regards
---
Arun Patidar
Manager, Enterprise Software Development

HotWax Systems Pvt Ltd.

www.hotwaxsystems.com


On Tue, Oct 3, 2017 at 6:10 PM, Taher Alkhateeb <[hidden email]>
wrote:

> Hi Arun,
>
> So does that work for developers on localhost? Is it an acceptable
> compromise to ignore and close the JIRA?
>
> On Oct 3, 2017 3:36 PM, "Arun Patidar" <[hidden email]>
> wrote:
>
> > Hi Taher,
> >
> > Thanks for fixing the issue. The issue of multi-tenant logins in the same
> > browser can be achieved by using sub-domain in URL for each tenant. In
> this
> > way, there will be a separate session and cookie management.
> >
> > --
> > Thanks & Regards
> > ---
> > Arun Patidar
> > Manager, Enterprise Software Development
> >
> > HotWax Systems Pvt Ltd.
> >
> > www.hotwaxsystems.com
> >
> >
> > On Fri, Sep 29, 2017 at 9:45 PM, Jacques Le Roux <
> > [hidden email]> wrote:
> >
> > > Le 29/09/2017 à 17:49, Taher Alkhateeb a écrit :
> > >
> > >> Very happy to note that I finally cracked the puzzle on this bug. It's
> > >> a simple case of readers=tenant that was missing in the build script.
> > >> This bug was always there since the introduction of gradle. So I will
> > >> fix it and backport to branch 16. You can check [1] for more.
> > >>
> > >> However, given that this bug was discovered so late gives me an
> > >> indication that very few people are interested in the multi-tenancy
> > >> feature in OFBiz.
> > >>
> > > That's a good news anyway, thanks Taher
> > >
> > > Jacques
> > >
> > >
> > >
> > >> [1] https://issues.apache.org/jira/browse/OFBIZ-9278
> > >>
> > >> On Mon, Jul 17, 2017 at 2:59 PM, vivek.mi <[hidden email]>
> wrote:
> > >>
> > >>> I did try. I created two tenants with:
> > >>>
> > >>> 1. *./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/gr
> > >>> oups_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/gr
> > >>> oups_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/servic
> > >>> edef/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/servic
> > >>> edef/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/servic
> > >>> edef/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/servic
> > >>> edef/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/h
> > >>> umanres/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/part
> > >>> ymgr/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/co
> > >>> ntent/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/C
> > >>> ommonScreens.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/C
> > >>> ommonScreens.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]]
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>> -----
> > >>> Vivek Mishra
> > >>> --
> > >>> View this message in context: http://ofbiz.135035.n4.nabble.
> > >>> com/Tenant-Login-Issue-in-OFBiz-16-11-tp4708208p4708222.html
> > >>> Sent from the OFBiz - User mailing list archive at Nabble.com.
> > >>>
> > >>
> > >
> >
>