ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Taher Alkhateeb <slidingfilame...@gmail.com>
Subject Re: Tenant Login Issue in OFBiz 16.11
Date Fri, 29 Sep 2017 15:49:24 GMT
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 <vmvivek208@gmail.com> 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.

Mime
View raw message