[
https://issues.apache.org/jira/browse/OFBIZ-12342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17436060#comment-17436060
]
Joe Nicke commented on OFBIZ-12342:
-----------------------------------
I decided to reinstall from scratch. Everything works, including Multi-Tenant
so long as the tenant database already has tables loaded from a dump.
I executed the following command on a blank ofbiz_tenant003 /
ofbizolap_tenant003:
gradlew createTenant -PtenantId=tenant003 -PtenantName="Corent Demo3"
-PdomainName=tenant03.example -PtenantReaders=seed,seed-initial,ext
-PdbPlatform=M -PdbIp=127.0.0.1 -PdbUser=ofbiz -PdbPassword=ofbiz
*Error:*
Caused by: java.sql.SQLSyntaxErrorException: +Table
'ofbiz_tenant003.security_permission' doesn't exist+
The error is correct, no tables exist. If I add the security_permission table
manually, the error moves to the next table that does not exist.
Shouldn't createTenant or loadTenant create the tables as required?
> createTenant / loadTenant fails
> -------------------------------
>
> Key: OFBIZ-12342
> URL: https://issues.apache.org/jira/browse/OFBIZ-12342
> Project: OFBiz
> Issue Type: Bug
> Components: ALL APPLICATIONS
> Affects Versions: 17.12.08
> Environment: Azure Windows Server 2019, MySQL v8.0.25.0, Gradle
> v4.5.1, OFBiz v 17.12.08
> 4 CPU, 8gb RAM.
> Reporter: Joe Nicke
> Priority: Minor
>
> I am looking for some guidance with multi-tenancy using Gradle (gradlew).
> createTenant and loadTenant *fails* even when the ofbiz_tenant /
> ofbizolap_tenant are created in MySQL.
> When I preload the db's, the exact same gradlew arguments *succeed*.
> gradlew loadTenant -PtenantId=tenant003
> gradlew createTenant -PtenantId=tenant003 -PtenantName="My Name"
> -PdomainName=tenant002.ofbiz.opensaas.live.com
> -PtenantReaders=seed,seed-initial,ext -PdbPlatform=M
> In the "succeed" workflow, the ofbiztenant tables are filled as expected. I
> am able to select and login with this tenant. It seems this would elimininate
> entity and other settings.
> Why do I have to preload the db's with schemas?
> Thanks!
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
