OFBiz › OFBiz - User

Tenant datasource helper missing

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 5 messages Options
iwolf
Reply | Threaded
Open this post in threaded view
♦
♦
|

Tenant datasource helper missing

iwolf
Hi,

I am running a multi tenant environment with three tenants. When I go to "webtools/control/ConnectionPoolStatus" I can only see 3 lines

Helper name: ofbizolap_demo1
Helper name: ofbiz_demo1
Helper name: demotenant (tenant data source)

The helpers for the two other tenants are missing. The log shows lots of:
"There is no datasource (Helper) configured for the entity-group [org.ofbiz.tenant];"

All tenants seem to work fine. Data stored in the right database, no problems in the front end...
On Start-Up: Delegator "default#demo2" NOT initializing helper for entity group "org.ofbiz.tenant" because the group is not associated to this delegator.

Entity setup of all tenants is identical:

<delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false">
        <group-map group-name="org.ofbiz.tenant" datasource-name="demotenant"/> 
        <group-map group-name="org.ofbiz" datasource-name="ofbiz_demo1"/>
        <group-map group-name="org.ofbiz.olap" datasource-name="ofbizolap_demo1"/>
        <group-map group-name="org.ofbiz" datasource-name="ofbiz_demo2"/>
        <group-map group-name="org.ofbiz.olap" datasource-name="ofbizolap_demo2"/>
        <group-map group-name="org.ofbiz" datasource-name="ofbiz_demo3"/>
        <group-map group-name="org.ofbiz.olap" datasource-name="ofbizolap_demo3"/>
</delegator>

Using 13.07., MySQL

Thanks for any hint,
Ingo
Pierre Smits
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Tenant datasource helper missing

Pierre Smits
Ingo,

This might be related to an issue already registered in JIRA. Have a look
at: https://issues.apache.org/jira/browse/OFBIZ-5729

Best regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com


On Sat, Sep 6, 2014 at 11:43 PM, iwolf <[hidden email]> wrote:

> Hi,
>
> I am running a multi tenant environment with three tenants. When I go to
> "webtools/control/ConnectionPoolStatus" I can only see 3 lines
>
> Helper name: ofbizolap_demo1
> Helper name: ofbiz_demo1
> Helper name: demotenant (tenant data source)
>
> The helpers for the two other tenants are missing. The log shows lots of:
> "There is no datasource (Helper) configured for the entity-group
> [org.ofbiz.tenant];"
>
> All tenants seem to work fine. Data stored in the right database, no
> problems in the front end...
> On Start-Up: Delegator "default#demo2" NOT initializing helper for entity
> group "org.ofbiz.tenant" because the group is not associated to this
> delegator.
>
> Entity setup of all tenants is identical:
>
> <delegator name="default" entity-model-reader="main"
> entity-group-reader="main" entity-eca-reader="main"
> distributed-cache-clear-enabled="false">
>         <group-map group-name="org.ofbiz.tenant"
> datasource-name="demotenant"/>
>         <group-map group-name="org.ofbiz" datasource-name="ofbiz_demo1"/>
>         <group-map group-name="org.ofbiz.olap"
> datasource-name="ofbizolap_demo1"/>
>         <group-map group-name="org.ofbiz" datasource-name="ofbiz_demo2"/>
>         <group-map group-name="org.ofbiz.olap"
> datasource-name="ofbizolap_demo2"/>
>         <group-map group-name="org.ofbiz" datasource-name="ofbiz_demo3"/>
>         <group-map group-name="org.ofbiz.olap"
> datasource-name="ofbizolap_demo3"/>
> </delegator>
>
> Using 13.07., MySQL
>
> Thanks for any hint,
> Ingo
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Tenant-datasource-helper-missing-tp4654914.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
iwolf
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Tenant datasource helper missing

iwolf
Hi Pierre,

thanks for the fast reply. I checked with the registred issue but I think my problem will not be solved with the patch.

Maybe someone can help me understand the following lines when ofbiz is started (picket all "helper initializing" infos in order of their appearance):

Delegator "default" initializing helper "ofbizolap_demo" for entity group "org.ofbiz.olap".
Delegator "default" initializing helper "demotenant" for entity group "org.ofbiz.tenant".
Delegator "default" initializing helper "ofbiz_demo" for entity group "org.ofbiz".
--> ok until here
Delegator "default#demo1" NOT initializing helper for entity group "org.ofbiz.tenant" because the group is not associated to this delegator.
--> where do I associate the delegator

Delegator "default#demo1" initializing helper "ofbizolap_demo" for entity group "org.ofbiz.olap".
--> why is a helper initialized  for tenant demo1 that should be used for tenant demo.

Delegator "default#demo1" initializing helper "ofbiz_demo" for entity group "org.ofbiz".
Delegator "default#demo1" initializing helper "ofbizolap_demo" for entity group "org.ofbiz.olap".
Delegator "default#demo1" NOT initializing helper for entity group "org.ofbiz.tenant" because the group is not associated to this delegator
Delegator "default#demo1" initializing helper "ofbiz_demo" for entity group "org.ofbiz".
Delegator "default#demo" initializing helper "ofbizolap_demo" for entity group "org.ofbiz.olap".
Delegator "default#demo" NOT initializing helper for entity group "org.ofbiz.tenant" because the group is not associated to this delegator.
Delegator "default#demo" initializing helper "ofbiz_demo" for entity group "org.ofbiz".
...

Kind regards,
Ingo
Pierre Smits
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Tenant datasource helper missing

Pierre Smits
Hi Ingo,

Can you recall the steps you took that lead to the mishap and list them
here, so that I and others can understand this issue?

Best regards,


Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

On Sun, Sep 7, 2014 at 9:01 PM, iwolf <[hidden email]> wrote:

> Hi Pierre,
>
> thanks for the fast reply. I checked with the registred issue but I think
> my
> problem will not be solved with the patch.
>
> Maybe someone can help me understand the following lines when ofbiz is
> started (picket all "helper initializing" infos in order of their
> appearance):
>
> Delegator "default" initializing helper "ofbizolap_demo" for entity group
> "org.ofbiz.olap".
> Delegator "default" initializing helper "demotenant" for entity group
> "org.ofbiz.tenant".
> Delegator "default" initializing helper "ofbiz_demo" for entity group
> "org.ofbiz".
> --> ok until here
> Delegator "default#demo1" NOT initializing helper for entity group
> "org.ofbiz.tenant" because the group is not associated to this delegator.
> --> where do I associate the delegator
>
> Delegator "default#demo1" initializing helper "ofbizolap_demo" for entity
> group "org.ofbiz.olap".
> --> why is a helper initialized  for tenant demo1 that should be used for
> tenant demo.
>
> Delegator "default#demo1" initializing helper "ofbiz_demo" for entity group
> "org.ofbiz".
> Delegator "default#demo1" initializing helper "ofbizolap_demo" for entity
> group "org.ofbiz.olap".
> Delegator "default#demo1" NOT initializing helper for entity group
> "org.ofbiz.tenant" because the group is not associated to this delegator
> Delegator "default#demo1" initializing helper "ofbiz_demo" for entity group
> "org.ofbiz".
> Delegator "default#demo" initializing helper "ofbizolap_demo" for entity
> group "org.ofbiz.olap".
> Delegator "default#demo" NOT initializing helper for entity group
> "org.ofbiz.tenant" because the group is not associated to this delegator.
> Delegator "default#demo" initializing helper "ofbiz_demo" for entity group
> "org.ofbiz".
> ...
>
> Kind regards,
> Ingo
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Tenant-datasource-helper-missing-tp4654914p4654937.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
iwolf
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Tenant datasource helper missing

iwolf
Hi Pierre,

sure, I reinstalled and here is what I did:

Clean 13.07 via SVN
Create Mysql DB
        - ofbiz_demo1
    - ofbiz_demo2
         - ofbiz_demo3
  - ofbizolap_demo1
        - ofbizolap_demo2
        - ofbizolap_demo3
        - ofbiztenant
       
- framework/entity/config/entityengine.xml (see attachment) entityengine.xml
- framework/common/general.properties --> multitenant = Y

Eclipse:
- download-mySQL-JDBC
- build[default]
- create-tenant
        (id: demo1)
        (name: demo1)
        (data: seed,seed-initial,ext)
        (DB: M)
        (IP: 127.0.0.1)
        (dbuser: ofbiz)
        (pass: ofbiz)
        (continue:Y)
       
        -->      [echo] database for tenant data will be 'ofbiz_demo1'
                   [echo] database for tenant olap data will be 'ofbizolap_demo1
                       
                        =-=-=-=-=-=-= Finished the data load with 8898 rows changed.
        --> same for demo2 and demo3

- load-seed

shell:
./ant load-tenant-admin-user-login -DdelegatorId=default#demo1 -DuserLoginId=admin-demo1
...

/specialpurpose/ecommerce/webapp/ecomclone/WEB-INF/web.xml

<context-param>
        <param-name>entityDelegatorName</param-name>
        <param-value>default#demo1</param-value>
        <description>The Name of the Entity Delegator to use, defined in entityengine.xml</description>
    </context-param>

- start
- http://.../ofbizsetup (filling in some demo data)
- http://.../ecomclone

Kind regards,
Ingo
Free forum by Nabble Edit this page