OFBiz › OFBiz - User

running ofbiz on a separate machine than db

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

running ofbiz on a separate machine than db

Pierre Smits
Hi all,

I trying to setup ofbiz on server a (an ubuntu applicance under esxi) with
the database (postgresql on another ubuntu appliance under esxi). But that
doesn't seem to work. I see tables and indexes created on postgresql, but
when I access ofbiz in the browser it returns error messages.

Does anybody have the same experience and how did it get resolved?

Regards,

Pierre
Jacques Le Roux
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: running ofbiz on a separate machine than db

Jacques Le Roux
Administrator
Did you set the path to your DB machine in entityengine.xml  ?
ie change jdbc-uri="jdbc:postgresql://127.0.0.1/ofbiz" accordingly

Jacques

From: "Pierre Smits" <[hidden email]>

> Hi all,
>
> I trying to setup ofbiz on server a (an ubuntu applicance under esxi) with
> the database (postgresql on another ubuntu appliance under esxi). But that
> doesn't seem to work. I see tables and indexes created on postgresql, but
> when I access ofbiz in the browser it returns error messages.
>
> Does anybody have the same experience and how did it get resolved?
>
> Regards,
>
> Pierre
>

Pierre Smits
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: running ofbiz on a separate machine than db

Pierre Smits
Hi Jacques,

Thanks for the prompt reply.

I did change the path for the db engine to the ip addres of the postgresql
server prior to starting up ofbiz.

Regards,

Pierre


2009/10/9 Jacques Le Roux <[hidden email]>

> Did you set the path to your DB machine in entityengine.xml  ?
> ie change jdbc-uri="jdbc:postgresql://127.0.0.1/ofbiz" accordingly
>
> Jacques
>
> From: "Pierre Smits" <[hidden email]>
>
>  Hi all,
>>
>> I trying to setup ofbiz on server a (an ubuntu applicance under esxi) with
>> the database (postgresql on another ubuntu appliance under esxi). But that
>> doesn't seem to work. I see tables and indexes created on postgresql, but
>> when I access ofbiz in the browser it returns error messages.
>>
>> Does anybody have the same experience and how did it get resolved?
>>
>> Regards,
>>
>> Pierre
>>
>>
>
Pierre Smits
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: running ofbiz on a separate machine than db

Pierre Smits
It seems that it has something to do with the entity group org.ofbiz.olap.

After seeing that reference in my log files I get:
2009-10-09 15:04:22,550 (main) [ DatabaseUtil.java:368:WARN ] Table named
[public.ACCOMMODATION_CLASS] exists in the database but has no corresponding
entity
2009-10-09 15:04:22,551 (main) [ DatabaseUtil.java:368:WARN ] Table named
[public.ACCOMMODATION_MAP] exists in the database but has no corresponding
entity
2009-10-09 15:04:22,551 (main) [ DatabaseUtil.java:368:WARN ] Table named
[public.ACCOMMODATION_MAP_TYPE] exists in the database but has no
corresponding entity
2009-10-09 15:04:22,551 (main) [ DatabaseUtil.java:368:WARN ] Table named
[public.ACCOMMODATION_SPOT] exists in the database but has no corresponding
entity
2009-10-09 15:04:22,551 (main) [ DatabaseUtil.java:368:WARN ] Table named
[public.ACCTG_TRANS] exists in the database but has no corresponding entity


When the startup sequence has completed it's run, and I try to login via the
browser I get:

2009-10-09 15:05:06,606 (http-0.0.0.0-8443-1) [ LoginWorker.java:228:INFO ]
User does not have permission or is flagged as logged out
2009-10-09 15:05:06,607 (http-0.0.0.0-8443-1) [
TransactionUtil.java:406:WARN ] No transaction in place, so not suspending.
2009-10-09 15:05:06,609 (http-0.0.0.0-8443-1) [ LoginWorker.java:174:ERROR]
Could not find UserLogin record for setLoggedOut with userLoginId [s0001]
2009-10-09 15:05:06,616 (http-0.0.0.0-8443-1) [
GenericDelegator.java:1311:ERROR] ---- exception report
---------------------------------------------------------- Failure in store
operation for entity [Visit]:
org.ofbiz.entity.GenericEntityNotFoundException: Tried to update an entity
that does not exist.. Rolling back transaction. Exception:
org.ofbiz.entity.GenericEntityNotFoundException Message: Tried to update an
entity that does not exist. ---- stack trace
---------------------------------------------------------------
org.ofbiz.entity.GenericEntityNotFoundException: Tried to update an entity
that does not exist.
org.ofbiz.entity.datasource.GenericDAO.singleUpdate(GenericDAO.java:279)
org.ofbiz.entity.datasource.GenericDAO.customUpdate(GenericDAO.java:211)
org.ofbiz.entity.datasource.GenericDAO.update(GenericDAO.java:205)
org.ofbiz.entity.datasource.GenericHelperDAO.store(GenericHelperDAO.java:172)
org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1296)
org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1259)
org.ofbiz.entity.GenericValue.store(GenericValue.java:129)
org.ofbiz.webapp.control.ControlEventListener.sessionDestroyed(ControlEventListener.java:78)
org.apache.catalina.session.StandardSession.expire(StandardSession.java:702)
org.apache.catalina.session.StandardSession.expire(StandardSession.java:660)
org.apache.catalina.session.StandardSession.invalidate(StandardSession.java:1111)
org.apache.catalina.session.StandardSessionFacade.invalidate(StandardSessionFacade.java:150)
org.ofbiz.webapp.control.LoginWorker.doBasicLogout(LoginWorker.java:505)
org.ofbiz.webapp.control.LoginWorker.checkLogin(LoginWorker.java:229)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:92)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:78)
org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:611)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:341)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:221)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:265)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
java.lang.Thread.run(Thread.java:619)


Can you help?

Thanks,

Pierre


2009/10/9 Pierre Smits <[hidden email]>

> Hi Jacques,
>
> Thanks for the prompt reply.
>
> I did change the path for the db engine to the ip addres of the postgresql
> server prior to starting up ofbiz.
>
> Regards,
>
> Pierre
>
>
> 2009/10/9 Jacques Le Roux <[hidden email]>
>
> Did you set the path to your DB machine in entityengine.xml  ?
>> ie change jdbc-uri="jdbc:postgresql://127.0.0.1/ofbiz" accordingly
>>
>> Jacques
>>
>> From: "Pierre Smits" <[hidden email]>
>>
>>  Hi all,
>>>
>>> I trying to setup ofbiz on server a (an ubuntu applicance under esxi)
>>> with
>>> the database (postgresql on another ubuntu appliance under esxi). But
>>> that
>>> doesn't seem to work. I see tables and indexes created on postgresql, but
>>> when I access ofbiz in the browser it returns error messages.
>>>
>>> Does anybody have the same experience and how did it get resolved?
>>>
>>> Regards,
>>>
>>> Pierre
>>>
>>>
>>
>
Pierre Smits
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: running ofbiz on a separate machine than db

Pierre Smits
Dear all,

Attached you'll find the error log generated when I restart the ofbiz
engine.

Can you help me?

Regards,

Pierre

2009/10/9 Pierre Smits <[hidden email]>

> It seems that it has something to do with the entity group org.ofbiz.olap.
>
> After seeing that reference in my log files I get:
> 2009-10-09 15:04:22,550 (main) [ DatabaseUtil.java:368:WARN ] Table named
> [public.ACCOMMODATION_CLASS] exists in the database but has no corresponding
> entity
> 2009-10-09 15:04:22,551 (main) [ DatabaseUtil.java:368:WARN ] Table named
> [public.ACCOMMODATION_MAP] exists in the database but has no corresponding
> entity
> 2009-10-09 15:04:22,551 (main) [ DatabaseUtil.java:368:WARN ] Table named
> [public.ACCOMMODATION_MAP_TYPE] exists in the database but has no
> corresponding entity
> 2009-10-09 15:04:22,551 (main) [ DatabaseUtil.java:368:WARN ] Table named
> [public.ACCOMMODATION_SPOT] exists in the database but has no corresponding
> entity
> 2009-10-09 15:04:22,551 (main) [ DatabaseUtil.java:368:WARN ] Table named
> [public.ACCTG_TRANS] exists in the database but has no corresponding entity
>
>
> When the startup sequence has completed it's run, and I try to login via
> the browser I get:
>
> 2009-10-09 15:05:06,606 (http-0.0.0.0-8443-1) [ LoginWorker.java:228:INFO ]
> User does not have permission or is flagged as logged out
> 2009-10-09 15:05:06,607 (http-0.0.0.0-8443-1) [
> TransactionUtil.java:406:WARN ] No transaction in place, so not suspending.
> 2009-10-09 15:05:06,609 (http-0.0.0.0-8443-1) [ LoginWorker.java:174:ERROR]
> Could not find UserLogin record for setLoggedOut with userLoginId [s0001]
> 2009-10-09 15:05:06,616 (http-0.0.0.0-8443-1) [
> GenericDelegator.java:1311:ERROR] ---- exception report
> ---------------------------------------------------------- Failure in store
> operation for entity [Visit]:
> org.ofbiz.entity.GenericEntityNotFoundException: Tried to update an entity
> that does not exist.. Rolling back transaction. Exception:
> org.ofbiz.entity.GenericEntityNotFoundException Message: Tried to update an
> entity that does not exist. ---- stack trace
> ---------------------------------------------------------------
> org.ofbiz.entity.GenericEntityNotFoundException: Tried to update an entity
> that does not exist.
> org.ofbiz.entity.datasource.GenericDAO.singleUpdate(GenericDAO.java:279)
> org.ofbiz.entity.datasource.GenericDAO.customUpdate(GenericDAO.java:211)
> org.ofbiz.entity.datasource.GenericDAO.update(GenericDAO.java:205)
> org.ofbiz.entity.datasource.GenericHelperDAO.store(GenericHelperDAO.java:172)
> org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1296)
> org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1259)
> org.ofbiz.entity.GenericValue.store(GenericValue.java:129)
> org.ofbiz.webapp.control.ControlEventListener.sessionDestroyed(ControlEventListener.java:78)
> org.apache.catalina.session.StandardSession.expire(StandardSession.java:702)
> org.apache.catalina.session.StandardSession.expire(StandardSession.java:660)
> org.apache.catalina.session.StandardSession.invalidate(StandardSession.java:1111)
> org.apache.catalina.session.StandardSessionFacade.invalidate(StandardSessionFacade.java:150)
> org.ofbiz.webapp.control.LoginWorker.doBasicLogout(LoginWorker.java:505)
> org.ofbiz.webapp.control.LoginWorker.checkLogin(LoginWorker.java:229)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> java.lang.reflect.Method.invoke(Method.java:597)
> org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:92)
> org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:78)
> org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:611)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:341)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:221)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:265)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> java.lang.Thread.run(Thread.java:619)
>
>
> Can you help?
>
> Thanks,
>
> Pierre
>
>
> 2009/10/9 Pierre Smits <[hidden email]>
>
> Hi Jacques,
>>
>> Thanks for the prompt reply.
>>
>> I did change the path for the db engine to the ip addres of the postgresql
>> server prior to starting up ofbiz.
>>
>> Regards,
>>
>> Pierre
>>
>>
>> 2009/10/9 Jacques Le Roux <[hidden email]>
>>
>> Did you set the path to your DB machine in entityengine.xml  ?
>>> ie change jdbc-uri="jdbc:postgresql://127.0.0.1/ofbiz" accordingly
>>>
>>> Jacques
>>>
>>> From: "Pierre Smits" <[hidden email]>
>>>
>>>  Hi all,
>>>>
>>>> I trying to setup ofbiz on server a (an ubuntu applicance under esxi)
>>>> with
>>>> the database (postgresql on another ubuntu appliance under esxi). But
>>>> that
>>>> doesn't seem to work. I see tables and indexes created on postgresql,
>>>> but
>>>> when I access ofbiz in the browser it returns error messages.
>>>>
>>>> Does anybody have the same experience and how did it get resolved?
>>>>
>>>> Regards,
>>>>
>>>> Pierre
>>>>
>>>>
>>>
>>
>
Pierre Smits
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: running ofbiz on a separate machine than db

Pierre Smits
Here is the error log.
Jacques Le Roux
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: running ofbiz on a separate machine than db

Jacques Le Roux
Administrator
Pierre,

You can't attach on this ML, please use Nabble or create a Jira issue.

All,

BTW, we should "soon" migrate to Nabble 2. http://n2.nabble.com/Nabble-Releases-Distributed-Architecture-td3791274.html
I'm not quite sure since I have asked what this will imply
I had asked to migrate already a year ago but for some reasons it would be only now

Jacques

  From: Pierre Smits
  To: [hidden email]
  Sent: Friday, October 09, 2009 3:25 PM
  Subject: Re: running ofbiz on a separate machine than db


  Here is the error log.
Pierre Smits
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: running ofbiz on a separate machine than db

Pierre Smits
Jacques,

Do you have experience setting up ofbiz in a multi-tier setup. It seems that
I have the same issue running the db in mysql on a different vmware
appliance.

Regards,

Pierre

2009/10/9 Jacques Le Roux <[hidden email]>

> Pierre,
>
> You can't attach on this ML, please use Nabble or create a Jira issue.
>
> All,
>
> BTW, we should "soon" migrate to Nabble 2.
> http://n2.nabble.com/Nabble-Releases-Distributed-Architecture-td3791274.html
> I'm not quite sure since I have asked what this will imply
> I had asked to migrate already a year ago but for some reasons it would be
> only now
>
> Jacques
>
>  From: Pierre Smits
>  To: [hidden email]
>  Sent: Friday, October 09, 2009 3:25 PM
>  Subject: Re: running ofbiz on a separate machine than db
>
>
>  Here is the error log.
>
Jacques Le Roux
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: running ofbiz on a separate machine than db

Jacques Le Roux
Administrator
Do you mean it's not OFBiz stock but a modified version ?

Jacques

From: "Pierre Smits" <[hidden email]>

> Jacques,
>
> Do you have experience setting up ofbiz in a multi-tier setup. It seems that
> I have the same issue running the db in mysql on a different vmware
> appliance.
>
> Regards,
>
> Pierre
>
> 2009/10/9 Jacques Le Roux <[hidden email]>
>
>> Pierre,
>>
>> You can't attach on this ML, please use Nabble or create a Jira issue.
>>
>> All,
>>
>> BTW, we should "soon" migrate to Nabble 2.
>> http://n2.nabble.com/Nabble-Releases-Distributed-Architecture-td3791274.html
>> I'm not quite sure since I have asked what this will imply
>> I had asked to migrate already a year ago but for some reasons it would be
>> only now
>>
>> Jacques
>>
>>  From: Pierre Smits
>>  To: [hidden email]
>>  Sent: Friday, October 09, 2009 3:25 PM
>>  Subject: Re: running ofbiz on a separate machine than db
>>
>>
>>  Here is the error log.
>>
>

Pierre Smits
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: running ofbiz on a separate machine than db

Pierre Smits
Hi Jacques,

No, it is a standard ofbiz (download from a few days ago) intended to be
setup in a multi-tier environment and to run against a postgresql database.
Everything is running on separata ubuntu vmware instances.

When running the same ofbiz download on a Windows laptop against a local
postgresql db it runs like a breeze. So I went through the configuration
parameters of both setup, and the only difference is that I changed the name
of the database and its password in the multi-tier environment.

Regards,

Pierre




2009/10/9 Jacques Le Roux <[hidden email]>

> Do you mean it's not OFBiz stock but a modified version ?
>
> Jacques
>
> From: "Pierre Smits" <[hidden email]>
>
>> Jacques,
>>
>>
>> Do you have experience setting up ofbiz in a multi-tier setup. It seems
>> that
>> I have the same issue running the db in mysql on a different vmware
>> appliance.
>>
>> Regards,
>>
>> Pierre
>>
>> 2009/10/9 Jacques Le Roux <[hidden email]>
>>
>> Pierre,
>>>
>>> You can't attach on this ML, please use Nabble or create a Jira issue.
>>>
>>> All,
>>>
>>> BTW, we should "soon" migrate to Nabble 2.
>>>
>>> http://n2.nabble.com/Nabble-Releases-Distributed-Architecture-td3791274.html
>>> I'm not quite sure since I have asked what this will imply
>>> I had asked to migrate already a year ago but for some reasons it would
>>> be
>>> only now
>>>
>>> Jacques
>>>
>>>  From: Pierre Smits
>>>  To: [hidden email]
>>>  Sent: Friday, October 09, 2009 3:25 PM
>>>  Subject: Re: running ofbiz on a separate machine than db
>>>
>>>
>>>  Here is the error log.
>>>
>>>
>>
>
Free forum by Nabble Edit this page