Unable to connect tenant component with tenant database

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

Unable to connect tenant component with tenant database

Anchit Jindal
Hi All

I am trying to create tenant by using 'create-tenant-on-PostgreSQL' command. I have created database for tenant and this command create tables and load seed data in tables and also create admin user for tenant and i am also able to connect to the backend  of this tenant. But the main issue is my tenant component is not connected to tenant databases for this i do following changes in my tenant component's web.xml
<context-param>
        <param-name>entityDelegatorName</param-name>
        <param-value>default#tenantId</param-value>
        <description>The Name of the Entity Delegator to use, defined in entityengine.xml</description>
    </context-param>

can any one tell me what i need to do to make it work currently i am using the latest ofbiz from trunk. Thanks.
Reply | Threaded
Open this post in threaded view
|

Re: Unable to connect tenant component with tenant database

Pierre Smits
Hi Anchit,

This is the second posting regarding multi-tenancy within one week. See
http://ofbiz.markmail.org/message/22bmphzfhkprhrcm?q=multi+root

If you feel there is something serious wrong with multi-tenancy, as we had
some changes recently, please create a JIRA 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 Tue, Jan 27, 2015 at 12:09 PM, Anchit Jindal <[hidden email]>
wrote:

> Hi All
>
> I am trying to create tenant by using *'create-tenant-on-PostgreSQL'*
> command. I have created database for tenant and this command create tables
> and load seed data in tables and also create admin user for tenant and i am
> also able to connect to the backend  of this tenant. But the main issue is
> my tenant component is not connected to tenant databases for this i do
> following changes in my tenant component's web.xml
> <context-param>
>         <param-name>entityDelegatorName</param-name>
>         <param-value>default#tenantId</param-value>
>         <description>The Name of the Entity Delegator to use, defined in
> entityengine.xml</description>
>     </context-param>
>
> can any one tell me what i need to do to make it work currently i am using
> the latest ofbiz from trunk. Thanks.
>
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

Re: Unable to connect tenant component with tenant database

Pierre Smits
This is the change I am referring to:
http://ofbiz.markmail.org/message/5raxnkzm5rp7gsjr?q=r1643510+list:org%2Eapache%2Eofbiz%2Ecommits+order:date-backward

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 Tue, Jan 27, 2015 at 10:36 PM, Pierre Smits <[hidden email]>
wrote:

> Hi Anchit,
>
> This is the second posting regarding multi-tenancy within one week. See
> http://ofbiz.markmail.org/message/22bmphzfhkprhrcm?q=multi+root
>
> If you feel there is something serious wrong with multi-tenancy, as we had
> some changes recently, please create a JIRA 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 Tue, Jan 27, 2015 at 12:09 PM, Anchit Jindal <[hidden email]>
> wrote:
>
>> Hi All
>>
>> I am trying to create tenant by using *'create-tenant-on-PostgreSQL'*
>> command. I have created database for tenant and this command create tables
>> and load seed data in tables and also create admin user for tenant and i
>> am
>> also able to connect to the backend  of this tenant. But the main issue is
>> my tenant component is not connected to tenant databases for this i do
>> following changes in my tenant component's web.xml
>> <context-param>
>>         <param-name>entityDelegatorName</param-name>
>>         <param-value>default#tenantId</param-value>
>>         <description>The Name of the Entity Delegator to use, defined in
>> entityengine.xml</description>
>>     </context-param>
>>
>> can any one tell me what i need to do to make it work currently i am using
>> the latest ofbiz from trunk. Thanks.
>>
>>
>>
>>
>> --
>> View this message in context:
>> http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Unable to connect tenant component with tenant database

Anchit Jindal
Hi Pierre

Thanks for the reply issue resolved by reading the link you provide. I have domain name issue. After reading this post i create its proper data for domain and it works fine. I have a question i check while creating new tenant, domain name is optional field and to create delegator for tenant it check for the domainName in TenantDomainName entity in ContextFilter.java if found the valid domainName delegator is created for tenant and if not found it gives tenant not found error. So now my question is why domin name field is optional during creating tenant because tenant site does not work if domain name is not configured properly. i thing it should be mandatory. what you think?   

On Wed, Jan 28, 2015 at 4:06 AM, Pierre Smits [via OFBiz] <[hidden email]> wrote:
This is the change I am referring to:
http://ofbiz.markmail.org/message/5raxnkzm5rp7gsjr?q=r1643510+list:org%2Eapache%2Eofbiz%2Ecommits+order:date-backward

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 Tue, Jan 27, 2015 at 10:36 PM, Pierre Smits <[hidden email]>
wrote:

> Hi Anchit,
>
> This is the second posting regarding multi-tenancy within one week. See
> http://ofbiz.markmail.org/message/22bmphzfhkprhrcm?q=multi+root
>
> If you feel there is something serious wrong with multi-tenancy, as we had
> some changes recently, please create a JIRA 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 Tue, Jan 27, 2015 at 12:09 PM, Anchit Jindal <[hidden email]>
> wrote:
>
>> Hi All
>>
>> I am trying to create tenant by using *'create-tenant-on-PostgreSQL'*
>> command. I have created database for tenant and this command create tables
>> and load seed data in tables and also create admin user for tenant and i
>> am
>> also able to connect to the backend  of this tenant. But the main issue is
>> my tenant component is not connected to tenant databases for this i do
>> following changes in my tenant component's web.xml
>> <context-param>
>>         <param-name>entityDelegatorName</param-name>
>>         <param-value>default#tenantId</param-value>
>>         <description>The Name of the Entity Delegator to use, defined in
>> entityengine.xml</description>
>>     </context-param>
>>
>> can any one tell me what i need to do to make it work currently i am using
>> the latest ofbiz from trunk. Thanks.
>>
>>
>>
>>
>> --
>> View this message in context:
>> http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>



If you reply to this email, your message will be added to the discussion below:
http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327p4662338.html
To unsubscribe from Unable to connect tenant component with tenant database, click here.
NAML

Reply | Threaded
Open this post in threaded view
|

Re: Unable to connect tenant component with tenant database

Arun Patidar
Hello Anchit,

Domain name field is optional to make back-end application accessible by
passing tenantId from login screen.

I think patch attached on OFBIZ-5986
<https://issues.apache.org/jira/browse/OFBIZ-5986> should work for you.
Its not committed yet so you can try it by applying that patch from
task. In this patch there is a support for identifying tenantId from
domain name, request parameter or request attribute.



Thanks & Regards
---
Arun Patidar
Manager,Enterprise Software Development
HotWax Media
www.hotwaxsystems.com

On Wednesday 28 January 2015 10:12 AM, Anchit Jindal wrote:

> Hi Pierre
>
> Thanks for the reply issue resolved by reading the link you provide. I have
> domain name issue. After reading this post i create its proper data for
> domain and it works fine. I have a question i check while creating new
> tenant, domain name is optional field and to create delegator for tenant it
> check for the domainName in TenantDomainName entity in ContextFilter.java
> if found the valid domainName delegator is created for tenant and if not
> found it gives tenant not found error. So now my question is why domin name
> field is optional during creating tenant because tenant site does not work
> if domain name is not configured properly. i thing it should be mandatory.
> what you think?
>
> On Wed, Jan 28, 2015 at 4:06 AM, Pierre Smits [via OFBiz] <
> [hidden email]> wrote:
>
>> This is the change I am referring to:
>>
>> http://ofbiz.markmail.org/message/5raxnkzm5rp7gsjr?q=r1643510+list:org%2Eapache%2Eofbiz%2Ecommits+order:date-backward
>>
>> 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 Tue, Jan 27, 2015 at 10:36 PM, Pierre Smits <[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=4662338&i=0>>
>> wrote:
>>
>>> Hi Anchit,
>>>
>>> This is the second posting regarding multi-tenancy within one week. See
>>> http://ofbiz.markmail.org/message/22bmphzfhkprhrcm?q=multi+root
>>>
>>> If you feel there is something serious wrong with multi-tenancy, as we
>> had
>>> some changes recently, please create a JIRA 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 Tue, Jan 27, 2015 at 12:09 PM, Anchit Jindal <[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=4662338&i=1>>
>>> wrote:
>>>
>>>> Hi All
>>>>
>>>> I am trying to create tenant by using *'create-tenant-on-PostgreSQL'*
>>>> command. I have created database for tenant and this command create
>> tables
>>>> and load seed data in tables and also create admin user for tenant and
>> i
>>>> am
>>>> also able to connect to the backend  of this tenant. But the main issue
>> is
>>>> my tenant component is not connected to tenant databases for this i do
>>>> following changes in my tenant component's web.xml
>>>> <context-param>
>>>>          <param-name>entityDelegatorName</param-name>
>>>>          <param-value>default#tenantId</param-value>
>>>>          <description>The Name of the Entity Delegator to use, defined
>> in
>>>> entityengine.xml</description>
>>>>      </context-param>
>>>>
>>>> can any one tell me what i need to do to make it work currently i am
>> using
>>>> the latest ofbiz from trunk. Thanks.
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> View this message in context:
>>>>
>> http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327.html
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>>
>>
>> ------------------------------
>>   If you reply to this email, your message will be added to the discussion
>> below:
>>
>> http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327p4662338.html
>>   To unsubscribe from Unable to connect tenant component with tenant
>> database, click here
>> <
>> .
>> NAML
>> <
http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>>
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327p4662339.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

Reply | Threaded
Open this post in threaded view
|

Re: Unable to connect tenant component with tenant database

Pierre Smits
This seems to be related to https://issues.apache.org/jira/browse/OFBIZ-5447

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 Wed, Jan 28, 2015 at 7:37 AM, Arun Patidar <[hidden email]>
wrote:

> Hello Anchit,
>
> Domain name field is optional to make back-end application accessible by
> passing tenantId from login screen.
>
> I think patch attached on OFBIZ-5986 <https://issues.apache.org/
> jira/browse/OFBIZ-5986> should work for you. Its not committed yet so you
> can try it by applying that patch from task. In this patch there is a
> support for identifying tenantId from domain name, request parameter or
> request attribute.
>
>
>
> Thanks & Regards
> ---
> Arun Patidar
> Manager,Enterprise Software Development
> HotWax Media
> www.hotwaxsystems.com
>
>
> On Wednesday 28 January 2015 10:12 AM, Anchit Jindal wrote:
>
>> Hi Pierre
>>
>> Thanks for the reply issue resolved by reading the link you provide. I
>> have
>> domain name issue. After reading this post i create its proper data for
>> domain and it works fine. I have a question i check while creating new
>> tenant, domain name is optional field and to create delegator for tenant
>> it
>> check for the domainName in TenantDomainName entity in ContextFilter.java
>> if found the valid domainName delegator is created for tenant and if not
>> found it gives tenant not found error. So now my question is why domin
>> name
>> field is optional during creating tenant because tenant site does not work
>> if domain name is not configured properly. i thing it should be mandatory.
>> what you think?
>>
>> On Wed, Jan 28, 2015 at 4:06 AM, Pierre Smits [via OFBiz] <
>> [hidden email]> wrote:
>>
>>  This is the change I am referring to:
>>>
>>> http://ofbiz.markmail.org/message/5raxnkzm5rp7gsjr?q=
>>> r1643510+list:org%2Eapache%2Eofbiz%2Ecommits+order:date-backward
>>>
>>> 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 Tue, Jan 27, 2015 at 10:36 PM, Pierre Smits <[hidden email]
>>> <http:///user/SendEmail.jtp?type=node&node=4662338&i=0>>
>>> wrote:
>>>
>>>  Hi Anchit,
>>>>
>>>> This is the second posting regarding multi-tenancy within one week. See
>>>> http://ofbiz.markmail.org/message/22bmphzfhkprhrcm?q=multi+root
>>>>
>>>> If you feel there is something serious wrong with multi-tenancy, as we
>>>>
>>> had
>>>
>>>> some changes recently, please create a JIRA 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 Tue, Jan 27, 2015 at 12:09 PM, Anchit Jindal <[hidden email]
>>>>
>>> <http:///user/SendEmail.jtp?type=node&node=4662338&i=1>>
>>>
>>>> wrote:
>>>>
>>>>  Hi All
>>>>>
>>>>> I am trying to create tenant by using *'create-tenant-on-PostgreSQL'*
>>>>> command. I have created database for tenant and this command create
>>>>>
>>>> tables
>>>
>>>> and load seed data in tables and also create admin user for tenant and
>>>>>
>>>> i
>>>
>>>> am
>>>>> also able to connect to the backend  of this tenant. But the main issue
>>>>>
>>>> is
>>>
>>>> my tenant component is not connected to tenant databases for this i do
>>>>> following changes in my tenant component's web.xml
>>>>> <context-param>
>>>>>          <param-name>entityDelegatorName</param-name>
>>>>>          <param-value>default#tenantId</param-value>
>>>>>          <description>The Name of the Entity Delegator to use, defined
>>>>>
>>>> in
>>>
>>>> entityengine.xml</description>
>>>>>      </context-param>
>>>>>
>>>>> can any one tell me what i need to do to make it work currently i am
>>>>>
>>>> using
>>>
>>>> the latest ofbiz from trunk. Thanks.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> View this message in context:
>>>>>
>>>>>  http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-
>>> component-with-tenant-database-tp4662327.html
>>>
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>>
>>>>
>>> ------------------------------
>>>   If you reply to this email, your message will be added to the
>>> discussion
>>> below:
>>>
>>> http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-
>>> component-with-tenant-database-tp4662327p4662338.html
>>>   To unsubscribe from Unable to connect tenant component with tenant
>>> database, click here
>>> <http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=
>>> unsubscribe_by_code&node=4662327&code=YW5jaGl0amluZGFsOTFAZ21haWwuY2
>>> 9tfDQ2NjIzMjd8LTEzODUxNzYwNDI=>
>>> .
>>> NAML
>>> <http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_
>>> viewer&id=instant_html%21nabble%3Aemail.naml&base=
>>> nabble.naml.namespaces.BasicNamespace-nabble.view.
>>> web.template.NabbleNamespace-nabble.view.web.template.
>>> NodeNamespace&breadcrumbs=notify_subscribers%21nabble%
>>> 3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_
>>> instant_email%21nabble%3Aemail.naml>
>>>
>>>
>>
>>
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.
>> com/Unable-to-connect-tenant-component-with-tenant-
>> database-tp4662327p4662339.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Unable to connect tenant component with tenant database

Jacques Le Roux
Administrator

Le 28/01/2015 12:21, Pierre Smits a écrit :
> This seems to be related to https://issues.apache.org/jira/browse/OFBIZ-5447

Pierre, is this resolved on your side?

Ashish, what about https://issues.apache.org/jira/browse/OFBIZ-5986 ?

Thanks

Jacques

>
> 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 Wed, Jan 28, 2015 at 7:37 AM, Arun Patidar <[hidden email]>
> wrote:
>
>> Hello Anchit,
>>
>> Domain name field is optional to make back-end application accessible by
>> passing tenantId from login screen.
>>
>> I think patch attached on OFBIZ-5986 <https://issues.apache.org/
>> jira/browse/OFBIZ-5986> should work for you. Its not committed yet so you
>> can try it by applying that patch from task. In this patch there is a
>> support for identifying tenantId from domain name, request parameter or
>> request attribute.
>>
>>
>>
>> Thanks & Regards
>> ---
>> Arun Patidar
>> Manager,Enterprise Software Development
>> HotWax Media
>> www.hotwaxsystems.com
>>
>>
>> On Wednesday 28 January 2015 10:12 AM, Anchit Jindal wrote:
>>
>>> Hi Pierre
>>>
>>> Thanks for the reply issue resolved by reading the link you provide. I
>>> have
>>> domain name issue. After reading this post i create its proper data for
>>> domain and it works fine. I have a question i check while creating new
>>> tenant, domain name is optional field and to create delegator for tenant
>>> it
>>> check for the domainName in TenantDomainName entity in ContextFilter.java
>>> if found the valid domainName delegator is created for tenant and if not
>>> found it gives tenant not found error. So now my question is why domin
>>> name
>>> field is optional during creating tenant because tenant site does not work
>>> if domain name is not configured properly. i thing it should be mandatory.
>>> what you think?
>>>
>>> On Wed, Jan 28, 2015 at 4:06 AM, Pierre Smits [via OFBiz] <
>>> [hidden email]> wrote:
>>>
>>>   This is the change I am referring to:
>>>> http://ofbiz.markmail.org/message/5raxnkzm5rp7gsjr?q=
>>>> r1643510+list:org%2Eapache%2Eofbiz%2Ecommits+order:date-backward
>>>>
>>>> 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 Tue, Jan 27, 2015 at 10:36 PM, Pierre Smits <[hidden email]
>>>> <http:///user/SendEmail.jtp?type=node&node=4662338&i=0>>
>>>> wrote:
>>>>
>>>>   Hi Anchit,
>>>>> This is the second posting regarding multi-tenancy within one week. See
>>>>> http://ofbiz.markmail.org/message/22bmphzfhkprhrcm?q=multi+root
>>>>>
>>>>> If you feel there is something serious wrong with multi-tenancy, as we
>>>>>
>>>> had
>>>>
>>>>> some changes recently, please create a JIRA 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 Tue, Jan 27, 2015 at 12:09 PM, Anchit Jindal <[hidden email]
>>>>>
>>>> <http:///user/SendEmail.jtp?type=node&node=4662338&i=1>>
>>>>
>>>>> wrote:
>>>>>
>>>>>   Hi All
>>>>>> I am trying to create tenant by using *'create-tenant-on-PostgreSQL'*
>>>>>> command. I have created database for tenant and this command create
>>>>>>
>>>>> tables
>>>>> and load seed data in tables and also create admin user for tenant and
>>>>> i
>>>>> am
>>>>>> also able to connect to the backend  of this tenant. But the main issue
>>>>>>
>>>>> is
>>>>> my tenant component is not connected to tenant databases for this i do
>>>>>> following changes in my tenant component's web.xml
>>>>>> <context-param>
>>>>>>           <param-name>entityDelegatorName</param-name>
>>>>>>           <param-value>default#tenantId</param-value>
>>>>>>           <description>The Name of the Entity Delegator to use, defined
>>>>>>
>>>>> in
>>>>> entityengine.xml</description>
>>>>>>       </context-param>
>>>>>>
>>>>>> can any one tell me what i need to do to make it work currently i am
>>>>>>
>>>>> using
>>>>> the latest ofbiz from trunk. Thanks.
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> View this message in context:
>>>>>>
>>>>>>   http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-
>>>> component-with-tenant-database-tp4662327.html
>>>>
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>>
>>>> ------------------------------
>>>>    If you reply to this email, your message will be added to the
>>>> discussion
>>>> below:
>>>>
>>>> http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-
>>>> component-with-tenant-database-tp4662327p4662338.html
>>>>    To unsubscribe from Unable to connect tenant component with tenant
>>>> database, click here
>>>> <http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=
>>>> unsubscribe_by_code&node=4662327&code=YW5jaGl0amluZGFsOTFAZ21haWwuY2
>>>> 9tfDQ2NjIzMjd8LTEzODUxNzYwNDI=>
>>>> .
>>>> NAML
>>>> <http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_
>>>> viewer&id=instant_html%21nabble%3Aemail.naml&base=
>>>> nabble.naml.namespaces.BasicNamespace-nabble.view.
>>>> web.template.NabbleNamespace-nabble.view.web.template.
>>>> NodeNamespace&breadcrumbs=notify_subscribers%21nabble%
>>>> 3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_
>>>> instant_email%21nabble%3Aemail.naml>
>>>>
>>>>
>>>
>>> --
>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>> com/Unable-to-connect-tenant-component-with-tenant-
>>> database-tp4662327p4662339.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
Reply | Threaded
Open this post in threaded view
|

Re: Unable to connect tenant component with tenant database

Pierre Smits
Jacques,

I had not had the change yet, but I will test recent changes and the patch
provided in 5896 shortly.

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 Wed, Jan 28, 2015 at 1:59 PM, Jacques Le Roux <
[hidden email]> wrote:

>
> Le 28/01/2015 12:21, Pierre Smits a écrit :
>
>> This seems to be related to https://issues.apache.org/
>> jira/browse/OFBIZ-5447
>>
>
> Pierre, is this resolved on your side?
>
> Ashish, what about https://issues.apache.org/jira/browse/OFBIZ-5986 ?
>
> Thanks
>
> Jacques
>
>
>> 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 Wed, Jan 28, 2015 at 7:37 AM, Arun Patidar <
>> [hidden email]>
>> wrote:
>>
>>  Hello Anchit,
>>>
>>> Domain name field is optional to make back-end application accessible by
>>> passing tenantId from login screen.
>>>
>>> I think patch attached on OFBIZ-5986 <https://issues.apache.org/
>>> jira/browse/OFBIZ-5986> should work for you. Its not committed yet so you
>>> can try it by applying that patch from task. In this patch there is a
>>> support for identifying tenantId from domain name, request parameter or
>>> request attribute.
>>>
>>>
>>>
>>> Thanks & Regards
>>> ---
>>> Arun Patidar
>>> Manager,Enterprise Software Development
>>> HotWax Media
>>> www.hotwaxsystems.com
>>>
>>>
>>> On Wednesday 28 January 2015 10:12 AM, Anchit Jindal wrote:
>>>
>>>  Hi Pierre
>>>>
>>>> Thanks for the reply issue resolved by reading the link you provide. I
>>>> have
>>>> domain name issue. After reading this post i create its proper data for
>>>> domain and it works fine. I have a question i check while creating new
>>>> tenant, domain name is optional field and to create delegator for tenant
>>>> it
>>>> check for the domainName in TenantDomainName entity in
>>>> ContextFilter.java
>>>> if found the valid domainName delegator is created for tenant and if not
>>>> found it gives tenant not found error. So now my question is why domin
>>>> name
>>>> field is optional during creating tenant because tenant site does not
>>>> work
>>>> if domain name is not configured properly. i thing it should be
>>>> mandatory.
>>>> what you think?
>>>>
>>>> On Wed, Jan 28, 2015 at 4:06 AM, Pierre Smits [via OFBiz] <
>>>> [hidden email]> wrote:
>>>>
>>>>   This is the change I am referring to:
>>>>
>>>>> http://ofbiz.markmail.org/message/5raxnkzm5rp7gsjr?q=
>>>>> r1643510+list:org%2Eapache%2Eofbiz%2Ecommits+order:date-backward
>>>>>
>>>>> 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 Tue, Jan 27, 2015 at 10:36 PM, Pierre Smits <[hidden email]
>>>>> <http:///user/SendEmail.jtp?type=node&node=4662338&i=0>>
>>>>> wrote:
>>>>>
>>>>>   Hi Anchit,
>>>>>
>>>>>> This is the second posting regarding multi-tenancy within one week.
>>>>>> See
>>>>>> http://ofbiz.markmail.org/message/22bmphzfhkprhrcm?q=multi+root
>>>>>>
>>>>>> If you feel there is something serious wrong with multi-tenancy, as we
>>>>>>
>>>>>>  had
>>>>>
>>>>>  some changes recently, please create a JIRA 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 Tue, Jan 27, 2015 at 12:09 PM, Anchit Jindal <[hidden email]
>>>>>>
>>>>>>  <http:///user/SendEmail.jtp?type=node&node=4662338&i=1>>
>>>>>
>>>>>  wrote:
>>>>>>
>>>>>>   Hi All
>>>>>>
>>>>>>> I am trying to create tenant by using *'create-tenant-on-PostgreSQL'
>>>>>>> *
>>>>>>> command. I have created database for tenant and this command create
>>>>>>>
>>>>>>>  tables
>>>>>> and load seed data in tables and also create admin user for tenant and
>>>>>> i
>>>>>> am
>>>>>>
>>>>>>> also able to connect to the backend  of this tenant. But the main
>>>>>>> issue
>>>>>>>
>>>>>>>  is
>>>>>> my tenant component is not connected to tenant databases for this i do
>>>>>>
>>>>>>> following changes in my tenant component's web.xml
>>>>>>> <context-param>
>>>>>>>           <param-name>entityDelegatorName</param-name>
>>>>>>>           <param-value>default#tenantId</param-value>
>>>>>>>           <description>The Name of the Entity Delegator to use,
>>>>>>> defined
>>>>>>>
>>>>>>>  in
>>>>>> entityengine.xml</description>
>>>>>>
>>>>>>>       </context-param>
>>>>>>>
>>>>>>> can any one tell me what i need to do to make it work currently i am
>>>>>>>
>>>>>>>  using
>>>>>> the latest ofbiz from trunk. Thanks.
>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> View this message in context:
>>>>>>>
>>>>>>>   http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-
>>>>>>>
>>>>>> component-with-tenant-database-tp4662327.html
>>>>>
>>>>>  Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>>
>>>>>>>
>>>>>>>  ------------------------------
>>>>>    If you reply to this email, your message will be added to the
>>>>> discussion
>>>>> below:
>>>>>
>>>>> http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-
>>>>> component-with-tenant-database-tp4662327p4662338.html
>>>>>    To unsubscribe from Unable to connect tenant component with tenant
>>>>> database, click here
>>>>> <http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=
>>>>> unsubscribe_by_code&node=4662327&code=YW5jaGl0amluZGFsOTFAZ21haWwuY2
>>>>> 9tfDQ2NjIzMjd8LTEzODUxNzYwNDI=>
>>>>> .
>>>>> NAML
>>>>> <http://ofbiz.135035.n4.nabble.com/template/
>>>>> NamlServlet.jtp?macro=macro_
>>>>> viewer&id=instant_html%21nabble%3Aemail.naml&base=
>>>>> nabble.naml.namespaces.BasicNamespace-nabble.view.
>>>>> web.template.NabbleNamespace-nabble.view.web.template.
>>>>> NodeNamespace&breadcrumbs=notify_subscribers%21nabble%
>>>>> 3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_
>>>>> instant_email%21nabble%3Aemail.naml>
>>>>>
>>>>>
>>>>>
>>>> --
>>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>>> com/Unable-to-connect-tenant-component-with-tenant-
>>>> database-tp4662327p4662339.html
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>>>
>>>
Reply | Threaded
Open this post in threaded view
|

Re: Unable to connect tenant component with tenant database

Pierre Smits
As it has now become a review of a committed change, I will report my
findings in dev@

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 Wed, Jan 28, 2015 at 2:25 PM, Pierre Smits <[hidden email]>
wrote:

> Jacques,
>
> I had not had the change yet, but I will test recent changes and the patch
> provided in 5896 shortly.
>
> 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 Wed, Jan 28, 2015 at 1:59 PM, Jacques Le Roux <
> [hidden email]> wrote:
>
>>
>> Le 28/01/2015 12:21, Pierre Smits a écrit :
>>
>>> This seems to be related to https://issues.apache.org/
>>> jira/browse/OFBIZ-5447
>>>
>>
>> Pierre, is this resolved on your side?
>>
>> Ashish, what about https://issues.apache.org/jira/browse/OFBIZ-5986 ?
>>
>> Thanks
>>
>> Jacques
>>
>>
>>> 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 Wed, Jan 28, 2015 at 7:37 AM, Arun Patidar <
>>> [hidden email]>
>>> wrote:
>>>
>>>  Hello Anchit,
>>>>
>>>> Domain name field is optional to make back-end application accessible by
>>>> passing tenantId from login screen.
>>>>
>>>> I think patch attached on OFBIZ-5986 <https://issues.apache.org/
>>>> jira/browse/OFBIZ-5986> should work for you. Its not committed yet so
>>>> you
>>>> can try it by applying that patch from task. In this patch there is a
>>>> support for identifying tenantId from domain name, request parameter or
>>>> request attribute.
>>>>
>>>>
>>>>
>>>> Thanks & Regards
>>>> ---
>>>> Arun Patidar
>>>> Manager,Enterprise Software Development
>>>> HotWax Media
>>>> www.hotwaxsystems.com
>>>>
>>>>
>>>> On Wednesday 28 January 2015 10:12 AM, Anchit Jindal wrote:
>>>>
>>>>  Hi Pierre
>>>>>
>>>>> Thanks for the reply issue resolved by reading the link you provide. I
>>>>> have
>>>>> domain name issue. After reading this post i create its proper data for
>>>>> domain and it works fine. I have a question i check while creating new
>>>>> tenant, domain name is optional field and to create delegator for
>>>>> tenant
>>>>> it
>>>>> check for the domainName in TenantDomainName entity in
>>>>> ContextFilter.java
>>>>> if found the valid domainName delegator is created for tenant and if
>>>>> not
>>>>> found it gives tenant not found error. So now my question is why domin
>>>>> name
>>>>> field is optional during creating tenant because tenant site does not
>>>>> work
>>>>> if domain name is not configured properly. i thing it should be
>>>>> mandatory.
>>>>> what you think?
>>>>>
>>>>> On Wed, Jan 28, 2015 at 4:06 AM, Pierre Smits [via OFBiz] <
>>>>> [hidden email]> wrote:
>>>>>
>>>>>   This is the change I am referring to:
>>>>>
>>>>>> http://ofbiz.markmail.org/message/5raxnkzm5rp7gsjr?q=
>>>>>> r1643510+list:org%2Eapache%2Eofbiz%2Ecommits+order:date-backward
>>>>>>
>>>>>> 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 Tue, Jan 27, 2015 at 10:36 PM, Pierre Smits <[hidden email]
>>>>>> <http:///user/SendEmail.jtp?type=node&node=4662338&i=0>>
>>>>>> wrote:
>>>>>>
>>>>>>   Hi Anchit,
>>>>>>
>>>>>>> This is the second posting regarding multi-tenancy within one week.
>>>>>>> See
>>>>>>> http://ofbiz.markmail.org/message/22bmphzfhkprhrcm?q=multi+root
>>>>>>>
>>>>>>> If you feel there is something serious wrong with multi-tenancy, as
>>>>>>> we
>>>>>>>
>>>>>>>  had
>>>>>>
>>>>>>  some changes recently, please create a JIRA 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 Tue, Jan 27, 2015 at 12:09 PM, Anchit Jindal <[hidden email]
>>>>>>>
>>>>>>>  <http:///user/SendEmail.jtp?type=node&node=4662338&i=1>>
>>>>>>
>>>>>>  wrote:
>>>>>>>
>>>>>>>   Hi All
>>>>>>>
>>>>>>>> I am trying to create tenant by using *'create-tenant-on-PostgreSQL'
>>>>>>>> *
>>>>>>>> command. I have created database for tenant and this command create
>>>>>>>>
>>>>>>>>  tables
>>>>>>> and load seed data in tables and also create admin user for tenant
>>>>>>> and
>>>>>>> i
>>>>>>> am
>>>>>>>
>>>>>>>> also able to connect to the backend  of this tenant. But the main
>>>>>>>> issue
>>>>>>>>
>>>>>>>>  is
>>>>>>> my tenant component is not connected to tenant databases for this i
>>>>>>> do
>>>>>>>
>>>>>>>> following changes in my tenant component's web.xml
>>>>>>>> <context-param>
>>>>>>>>           <param-name>entityDelegatorName</param-name>
>>>>>>>>           <param-value>default#tenantId</param-value>
>>>>>>>>           <description>The Name of the Entity Delegator to use,
>>>>>>>> defined
>>>>>>>>
>>>>>>>>  in
>>>>>>> entityengine.xml</description>
>>>>>>>
>>>>>>>>       </context-param>
>>>>>>>>
>>>>>>>> can any one tell me what i need to do to make it work currently i am
>>>>>>>>
>>>>>>>>  using
>>>>>>> the latest ofbiz from trunk. Thanks.
>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> View this message in context:
>>>>>>>>
>>>>>>>>   http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-
>>>>>>>>
>>>>>>> component-with-tenant-database-tp4662327.html
>>>>>>
>>>>>>  Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>>>
>>>>>>>>
>>>>>>>>  ------------------------------
>>>>>>    If you reply to this email, your message will be added to the
>>>>>> discussion
>>>>>> below:
>>>>>>
>>>>>> http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-
>>>>>> component-with-tenant-database-tp4662327p4662338.html
>>>>>>    To unsubscribe from Unable to connect tenant component with tenant
>>>>>> database, click here
>>>>>> <http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=
>>>>>> unsubscribe_by_code&node=4662327&code=YW5jaGl0amluZGFsOTFAZ21haWwuY2
>>>>>> 9tfDQ2NjIzMjd8LTEzODUxNzYwNDI=>
>>>>>> .
>>>>>> NAML
>>>>>> <http://ofbiz.135035.n4.nabble.com/template/
>>>>>> NamlServlet.jtp?macro=macro_
>>>>>> viewer&id=instant_html%21nabble%3Aemail.naml&base=
>>>>>> nabble.naml.namespaces.BasicNamespace-nabble.view.
>>>>>> web.template.NabbleNamespace-nabble.view.web.template.
>>>>>> NodeNamespace&breadcrumbs=notify_subscribers%21nabble%
>>>>>> 3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_
>>>>>> instant_email%21nabble%3Aemail.naml>
>>>>>>
>>>>>>
>>>>>>
>>>>> --
>>>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>>>> com/Unable-to-connect-tenant-component-with-tenant-
>>>>> database-tp4662327p4662339.html
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>>
>>>>
>
Reply | Threaded
Open this post in threaded view
|

Re: Unable to connect tenant component with tenant database

Anchit Jindal
Hi Arun

Thanks for the reply i have tested this patch and by using this i found that it returns null for tenant id for the following code
               if(UtilValidate.isEmpty(tenantId)) {
                    tenantId = (String) httpRequest.getAttribute("tenantId");
                }
                if(UtilValidate.isEmpty(tenantId)) {
                    tenantId = (String) httpRequest.getParameter("tenantId");
                }
 so if tenantDomainName is null it is not able to get tenantId and delegator for tenant is not set. I also find that in this patch  tenantId has not been set in requestAtteribute or request parameters before getting it so i want to know is it complete patch? i check in the latest ofbiz  tenantId is set is request Attribute after getting it from TenantDomainName entity if it is not null. Also for domain name field i found there is no need for tenant domain name to access backend application because we use same backend application for tenant except it has different user login details and tenantid for login. i have tested it many times domain name is used to create delegator for tenant component and to get tenant id. Have you test it with the latest ofbiz or i miss some thing?

Thanks

Anchit Jindal



On Wed, Jan 28, 2015 at 7:04 PM, Pierre Smits [via OFBiz] <[hidden email]> wrote:
As it has now become a review of a committed change, I will report my
findings in dev@

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 Wed, Jan 28, 2015 at 2:25 PM, Pierre Smits <[hidden email]>
wrote:

> Jacques,
>
> I had not had the change yet, but I will test recent changes and the patch
> provided in 5896 shortly.
>
> 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 Wed, Jan 28, 2015 at 1:59 PM, Jacques Le Roux <
> [hidden email]> wrote:
>
>>
>> Le 28/01/2015 12:21, Pierre Smits a écrit :
>>
>>> This seems to be related to https://issues.apache.org/
>>> jira/browse/OFBIZ-5447
>>>
>>
>> Pierre, is this resolved on your side?
>>
>> Ashish, what about https://issues.apache.org/jira/browse/OFBIZ-5986 ?
>>
>> Thanks
>>
>> Jacques
>>
>>
>>> 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 Wed, Jan 28, 2015 at 7:37 AM, Arun Patidar <
>>> [hidden email]>
>>> wrote:
>>>
>>>  Hello Anchit,
>>>>
>>>> Domain name field is optional to make back-end application accessible by
>>>> passing tenantId from login screen.
>>>>
>>>> I think patch attached on OFBIZ-5986 <https://issues.apache.org/
>>>> jira/browse/OFBIZ-5986> should work for you. Its not committed yet so
>>>> you
>>>> can try it by applying that patch from task. In this patch there is a
>>>> support for identifying tenantId from domain name, request parameter or
>>>> request attribute.
>>>>
>>>>
>>>>
>>>> Thanks & Regards
>>>> ---
>>>> Arun Patidar
>>>> Manager,Enterprise Software Development
>>>> HotWax Media
>>>> www.hotwaxsystems.com
>>>>
>>>>
>>>> On Wednesday 28 January 2015 10:12 AM, Anchit Jindal wrote:
>>>>
>>>>  Hi Pierre
>>>>>
>>>>> Thanks for the reply issue resolved by reading the link you provide. I
>>>>> have
>>>>> domain name issue. After reading this post i create its proper data for
>>>>> domain and it works fine. I have a question i check while creating new
>>>>> tenant, domain name is optional field and to create delegator for
>>>>> tenant
>>>>> it
>>>>> check for the domainName in TenantDomainName entity in
>>>>> ContextFilter.java
>>>>> if found the valid domainName delegator is created for tenant and if
>>>>> not
>>>>> found it gives tenant not found error. So now my question is why domin
>>>>> name
>>>>> field is optional during creating tenant because tenant site does not
>>>>> work
>>>>> if domain name is not configured properly. i thing it should be
>>>>> mandatory.
>>>>> what you think?
>>>>>
>>>>> On Wed, Jan 28, 2015 at 4:06 AM, Pierre Smits [via OFBiz] <
>>>>> [hidden email]> wrote:
>>>>>
>>>>>   This is the change I am referring to:
>>>>>
>>>>>> http://ofbiz.markmail.org/message/5raxnkzm5rp7gsjr?q=
>>>>>> r1643510+list:org%2Eapache%2Eofbiz%2Ecommits+order:date-backward
>>>>>>
>>>>>> 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 Tue, Jan 27, 2015 at 10:36 PM, Pierre Smits <[hidden email]
>>>>>> <http:///user/SendEmail.jtp?type=node&node=4662338&i=0>>
>>>>>> wrote:
>>>>>>
>>>>>>   Hi Anchit,
>>>>>>
>>>>>>> This is the second posting regarding multi-tenancy within one week.
>>>>>>> See
>>>>>>> http://ofbiz.markmail.org/message/22bmphzfhkprhrcm?q=multi+root
>>>>>>>
>>>>>>> If you feel there is something serious wrong with multi-tenancy, as
>>>>>>> we
>>>>>>>
>>>>>>>  had
>>>>>>
>>>>>>  some changes recently, please create a JIRA 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 Tue, Jan 27, 2015 at 12:09 PM, Anchit Jindal <[hidden email]
>>>>>>>
>>>>>>>  <http:///user/SendEmail.jtp?type=node&node=4662338&i=1>>
>>>>>>
>>>>>>  wrote:
>>>>>>>
>>>>>>>   Hi All
>>>>>>>
>>>>>>>> I am trying to create tenant by using *'create-tenant-on-PostgreSQL'
>>>>>>>> *
>>>>>>>> command. I have created database for tenant and this command create
>>>>>>>>
>>>>>>>>  tables
>>>>>>> and load seed data in tables and also create admin user for tenant
>>>>>>> and
>>>>>>> i
>>>>>>> am
>>>>>>>
>>>>>>>> also able to connect to the backend  of this tenant. But the main
>>>>>>>> issue
>>>>>>>>
>>>>>>>>  is
>>>>>>> my tenant component is not connected to tenant databases for this i
>>>>>>> do
>>>>>>>
>>>>>>>> following changes in my tenant component's web.xml
>>>>>>>> <context-param>
>>>>>>>>           <param-name>entityDelegatorName</param-name>
>>>>>>>>           <param-value>default#tenantId</param-value>
>>>>>>>>           <description>The Name of the Entity Delegator to use,
>>>>>>>> defined
>>>>>>>>
>>>>>>>>  in
>>>>>>> entityengine.xml</description>
>>>>>>>
>>>>>>>>       </context-param>
>>>>>>>>
>>>>>>>> can any one tell me what i need to do to make it work currently i am
>>>>>>>>
>>>>>>>>  using
>>>>>>> the latest ofbiz from trunk. Thanks.
>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> View this message in context:
>>>>>>>>
>>>>>>>>   http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-
>>>>>>>>
>>>>>>> component-with-tenant-database-tp4662327.html
>>>>>>
>>>>>>  Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>>>
>>>>>>>>
>>>>>>>>  ------------------------------
>>>>>>    If you reply to this email, your message will be added to the
>>>>>> discussion
>>>>>> below:
>>>>>>
>>>>>> http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-
>>>>>> component-with-tenant-database-tp4662327p4662338.html
>>>>>>    To unsubscribe from Unable to connect tenant component with tenant
>>>>>> database, click here
>>>>>> <http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=
>>>>>> unsubscribe_by_code&node=4662327&code=YW5jaGl0amluZGFsOTFAZ21haWwuY2
>>>>>> 9tfDQ2NjIzMjd8LTEzODUxNzYwNDI=>
>>>>>> .
>>>>>> NAML
>>>>>> <http://ofbiz.135035.n4.nabble.com/template/
>>>>>> NamlServlet.jtp?macro=macro_
>>>>>> viewer&id=instant_html%21nabble%3Aemail.naml&base=
>>>>>> nabble.naml.namespaces.BasicNamespace-nabble.view.
>>>>>> web.template.NabbleNamespace-nabble.view.web.template.
>>>>>> NodeNamespace&breadcrumbs=notify_subscribers%21nabble%
>>>>>> 3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_
>>>>>> instant_email%21nabble%3Aemail.naml>
>>>>>>
>>>>>>
>>>>>>
>>>>> --
>>>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>>>> com/Unable-to-connect-tenant-component-with-tenant-
>>>>> database-tp4662327p4662339.html
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>>
>>>>
>



If you reply to this email, your message will be added to the discussion below:
http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327p4662355.html
To unsubscribe from Unable to connect tenant component with tenant database, click here.
NAML

Reply | Threaded
Open this post in threaded view
|

Re: Unable to connect tenant component with tenant database

Pierre Smits
Hi all,

I did an in dept review of OFBIZ-5898, the patch and subsequent commit
r1643510 and resulting issue OFBIZ-5986 in a posting in the dev@.

See: http://ofbiz.markmail.org/message/xsvyscpoup7nqsqk

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
Reply | Threaded
Open this post in threaded view
|

Re: Unable to connect tenant component with tenant database

Arun Patidar
In reply to this post by Anchit Jindal
Hi Anchit,

Thanks for testing it. We assume that front store application for a
tenant will run using specific domain name, alternatively you will need
to pass tenantId as parameter in each anonymous request and also need to
add/pass tenantId on login screen.

There is code to get tenantId from request just to support above
alternate way with front store application.


Thanks & Regards
---
Arun Patidar
Manager,Enterprise Software Development
HotWax Media
www.hotwaxsystems.com

On Wednesday 28 January 2015 07:31 PM, Anchit Jindal wrote:

> Hi Arun
>
> Thanks for the reply i have tested this patch and by using this i found
> that it returns null for tenant id for the following code
>                 if(UtilValidate.isEmpty(tenantId)) {
>                      tenantId = (String)
> httpRequest.getAttribute("tenantId");
>                  }
>                  if(UtilValidate.isEmpty(tenantId)) {
>                      tenantId = (String)
> httpRequest.getParameter("tenantId");
>                  }
>   so if tenantDomainName is null it is not able to get tenantId and
> delegator for tenant is not set. I also find that in this patch  tenantId
> has not been set in requestAtteribute or request parameters before getting
> it so i want to know is it complete patch? i check in the latest ofbiz
> tenantId is set is request Attribute after getting it from TenantDomainName
> entity if it is not null. Also for domain name field i found there is no
> need for tenant domain name to access backend application because we use
> same backend application for tenant except it has different user login
> details and tenantid for login. i have tested it many times domain name is
> used to create delegator for tenant component and to get tenant id. Have
> you test it with the latest ofbiz or i miss some thing?
>
> Thanks
>
> Anchit Jindal
>
>
>
> On Wed, Jan 28, 2015 at 7:04 PM, Pierre Smits [via OFBiz] <
> [hidden email]> wrote:
>
>> As it has now become a review of a committed change, I will report my
>> findings in dev@
>>
>> 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 Wed, Jan 28, 2015 at 2:25 PM, Pierre Smits <[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=4662355&i=0>>
>> wrote:
>>
>>> Jacques,
>>>
>>> I had not had the change yet, but I will test recent changes and the
>> patch
>>> provided in 5896 shortly.
>>>
>>> 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 Wed, Jan 28, 2015 at 1:59 PM, Jacques Le Roux <
>>> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4662355&i=1>>
>> wrote:
>>>> Le 28/01/2015 12:21, Pierre Smits a écrit :
>>>>
>>>>> This seems to be related to https://issues.apache.org/
>>>>> jira/browse/OFBIZ-5447
>>>>>
>>>> Pierre, is this resolved on your side?
>>>>
>>>> Ashish, what about https://issues.apache.org/jira/browse/OFBIZ-5986 ?
>>>>
>>>> Thanks
>>>>
>>>> Jacques
>>>>
>>>>
>>>>> 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 Wed, Jan 28, 2015 at 7:37 AM, Arun Patidar <
>>>>> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4662355&i=2>>
>>>>> wrote:
>>>>>
>>>>>   Hello Anchit,
>>>>>> Domain name field is optional to make back-end application accessible
>> by
>>>>>> passing tenantId from login screen.
>>>>>>
>>>>>> I think patch attached on OFBIZ-5986 <https://issues.apache.org/
>>>>>> jira/browse/OFBIZ-5986> should work for you. Its not committed yet so
>>>>>> you
>>>>>> can try it by applying that patch from task. In this patch there is a
>>>>>> support for identifying tenantId from domain name, request parameter
>> or
>>>>>> request attribute.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Thanks & Regards
>>>>>> ---
>>>>>> Arun Patidar
>>>>>> Manager,Enterprise Software Development
>>>>>> HotWax Media
>>>>>> www.hotwaxsystems.com
>>>>>>
>>>>>>
>>>>>> On Wednesday 28 January 2015 10:12 AM, Anchit Jindal wrote:
>>>>>>
>>>>>>   Hi Pierre
>>>>>>> Thanks for the reply issue resolved by reading the link you provide.
>> I
>>>>>>> have
>>>>>>> domain name issue. After reading this post i create its proper data
>> for
>>>>>>> domain and it works fine. I have a question i check while creating
>> new
>>>>>>> tenant, domain name is optional field and to create delegator for
>>>>>>> tenant
>>>>>>> it
>>>>>>> check for the domainName in TenantDomainName entity in
>>>>>>> ContextFilter.java
>>>>>>> if found the valid domainName delegator is created for tenant and if
>>>>>>> not
>>>>>>> found it gives tenant not found error. So now my question is why
>> domin
>>>>>>> name
>>>>>>> field is optional during creating tenant because tenant site does
>> not
>>>>>>> work
>>>>>>> if domain name is not configured properly. i thing it should be
>>>>>>> mandatory.
>>>>>>> what you think?
>>>>>>>
>>>>>>> On Wed, Jan 28, 2015 at 4:06 AM, Pierre Smits [via OFBiz] <
>>>>>>> [hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=4662355&i=3>> wrote:
>>>>>>>    This is the change I am referring to:
>>>>>>>
>>>>>>>> http://ofbiz.markmail.org/message/5raxnkzm5rp7gsjr?q=
>>>>>>>> r1643510+list:org%2Eapache%2Eofbiz%2Ecommits+order:date-backward
>>>>>>>>
>>>>>>>> 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 Tue, Jan 27, 2015 at 10:36 PM, Pierre Smits <[hidden email]
>>>>>>>> <http:///user/SendEmail.jtp?type=node&node=4662338&i=0>>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>    Hi Anchit,
>>>>>>>>
>>>>>>>>> This is the second posting regarding multi-tenancy within one
>> week.
>>>>>>>>> See
>>>>>>>>> http://ofbiz.markmail.org/message/22bmphzfhkprhrcm?q=multi+root
>>>>>>>>>
>>>>>>>>> If you feel there is something serious wrong with multi-tenancy,
>> as
>>>>>>>>> we
>>>>>>>>>
>>>>>>>>>   had
>>>>>>>>   some changes recently, please create a JIRA 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 Tue, Jan 27, 2015 at 12:09 PM, Anchit Jindal <[hidden email]
>>>>>>>>>
>>>>>>>>>   <http:///user/SendEmail.jtp?type=node&node=4662338&i=1>>
>>>>>>>>   wrote:
>>>>>>>>>    Hi All
>>>>>>>>>
>>>>>>>>>> I am trying to create tenant by using
>> *'create-tenant-on-PostgreSQL'
>>>>>>>>>> *
>>>>>>>>>> command. I have created database for tenant and this command
>> create
>>>>>>>>>>   tables
>>>>>>>>> and load seed data in tables and also create admin user for tenant
>>>>>>>>> and
>>>>>>>>> i
>>>>>>>>> am
>>>>>>>>>
>>>>>>>>>> also able to connect to the backend  of this tenant. But the main
>>>>>>>>>> issue
>>>>>>>>>>
>>>>>>>>>>   is
>>>>>>>>> my tenant component is not connected to tenant databases for this
>> i
>>>>>>>>> do
>>>>>>>>>
>>>>>>>>>> following changes in my tenant component's web.xml
>>>>>>>>>> <context-param>
>>>>>>>>>>            <param-name>entityDelegatorName</param-name>
>>>>>>>>>>            <param-value>default#tenantId</param-value>
>>>>>>>>>>            <description>The Name of the Entity Delegator to use,
>>>>>>>>>> defined
>>>>>>>>>>
>>>>>>>>>>   in
>>>>>>>>> entityengine.xml</description>
>>>>>>>>>
>>>>>>>>>>        </context-param>
>>>>>>>>>>
>>>>>>>>>> can any one tell me what i need to do to make it work currently i
>> am
>>>>>>>>>>   using
>>>>>>>>> the latest ofbiz from trunk. Thanks.
>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> View this message in context:
>>>>>>>>>>
>>>>>>>>>>    http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-
>>>>>>>>>>
>>>>>>>>> component-with-tenant-database-tp4662327.html
>>>>>>>>   Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>>>>>>   ------------------------------
>>>>>>>>     If you reply to this email, your message will be added to the
>>>>>>>> discussion
>>>>>>>> below:
>>>>>>>>
>>>>>>>> http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-
>>>>>>>> component-with-tenant-database-tp4662327p4662338.html
>>>>>>>>     To unsubscribe from Unable to connect tenant component with
>> tenant
>>>>>>>> database, click here
>>>>>>>> <http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=
>>>>>>>>
>> unsubscribe_by_code&node=4662327&code=YW5jaGl0amluZGFsOTFAZ21haWwuY2
>>>>>>>> 9tfDQ2NjIzMjd8LTEzODUxNzYwNDI=>
>>>>>>>> .
>>>>>>>> NAML
>>>>>>>> <http://ofbiz.135035.n4.nabble.com/template/
>>>>>>>> NamlServlet.jtp?macro=macro_
>>>>>>>> viewer&id=instant_html%21nabble%3Aemail.naml&base=
>>>>>>>> nabble.naml.namespaces.BasicNamespace-nabble.view.
>>>>>>>> web.template.NabbleNamespace-nabble.view.web.template.
>>>>>>>> NodeNamespace&breadcrumbs=notify_subscribers%21nabble%
>>>>>>>> 3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_
>>>>>>>> instant_email%21nabble%3Aemail.naml>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>> --
>>>>>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>>>>>> com/Unable-to-connect-tenant-component-with-tenant-
>>>>>>> database-tp4662327p4662339.html
>>>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>>>
>>>>>>>
>>
>> ------------------------------
>>   If you reply to this email, your message will be added to the discussion
>> below:
>>
>> http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327p4662355.html
>>   To unsubscribe from Unable to connect tenant component with tenant
>> database, click here
>> <
>> .
>> NAML
>> <
http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>>
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327p4662356.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.