Hi there,
here's the recipe:
1) Install postgre 8.3+, create a login role and database.
2) Extract ofbiz
3) Edit OFBIZ_HOME/framework/entity/config/entityengine.xml
4) Find the delegator tags and change all the datasource-name properties
to "localpostgres" as follows:
<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"
datasource-name="localpostgres"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localpostgres"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz"
datasource-name="localpostgres"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localpostgres"/>
</delegator>
5) Scroll down and locate the "localpostgres" datasource definition:
<datasource name="localpostgres"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
schema-name="public"
field-type-name="postgres"
check-on-start="true"
add-missing-on-start="true"
use-fk-initially-deferred="false"
alias-view-columns="false"
join-style="ansi"
use-binary-type-for-blob="true">
<!-- use this attribute to make the EntityListIterator more
effective for pgjdbc 7.5devel and later:
result-fetch-size="50"
-->
<read-data reader-name="seed"/>
<read-data reader-name="seed-initial"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
<inline-jdbc
jdbc-driver="org.postgresql.Driver"
jdbc-uri="jdbc:postgresql://127.0.0.1/ofbiz_db
jdbc-password="ofbiz"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"/>
jdbc-username="ofbiz"
</datasource>
Modify the inline-jdbc tag props. Should you don't want the demo data
just comment the tag: <read-data reader-name="demo"/>
However it would be kind of a tough task to research ofbiz without demo
data :)
6) Copy postgre jdbc driver -> OFBIZ_HOME/framework/entity/lib/jdbc
7) go to OFBIZ_HOME dir and execute:
ant run-install > install.log
That command will produce a huge log as it is going to create all the db
tables.
8) Open install.log with a text editor. Although it says "BUILD
SUCCESSFUL" in the end of the file it still does not mean that no
errors have occurred during DB creation. Scroll through the file and
search for some errors. If you are installing OFBiz without any changes
than it should work.
9) ./startofbiz.sh
10) http://localhost:8080/partymgr
as there is no root web application.
Good luck :)
Deyan
On Sun, 2009-07-12 at 10:04 +0200, cyber trade wrote:
> Meanwhile I tried to install it on my another PC and everything goes OK
> and everything works fine so far. I need now only instructions for
> connecting with postgre, does anybody have it maybe?
> -
> Srdačan pozdrav,
> Best regards,
> Mit besten Grüßen,
> Saludos cordiales,
> Cordialement,
> www.extraretail.com
>
>
> On Sat, 2009-07-11 at 17:46 -0700, BJ Freeman wrote:
> > Ofbiz has all the support for default OOTB system.
> > it uses embedded tomcat, Derby, and ant. They are built in.
> > the only thing that is necessary is the JDK 1.5 or better.
> > if you follow the configuration sheets it should come up when you run
> > the ant run-install
> > then
> > startofbiz.sh
> >
> > I have installed on Ubuntu and had ofbiz running in 15 min.
> > takes about another 45 to setup and run postgresql.
> >
> >
> > cyber trade sent the following on 7/11/2009 2:59 PM:
> > > I do have still problem with installation! I have install Ubuntu 8.04
> > > again from the start and also sun Java JDK 1.6, ANt 1.7, Tomcat 5.5,
> > > Derby DB but I have no some other problem like this:
> > > Exception in thread "main" java.lang.InternalError: One of the
> > > management beans is not compliant.
> > > at
> > > java.lang.management.ManagementFactory.getPlatformMBeanServer(libgcj.so.81)
> > > at org.apache.derby.impl.services.jmx.JMXManagementService
> > > $1.run(Unknown Source)
> > > at org.apache.derby.impl.services.jmx.JMXManagementService
> > > $1.run(Unknown Source)
> > > at java.security.AccessController.doPrivileged(libgcj.so.81)
> > > at
> > > org.apache.derby.impl.services.jmx.JMXManagementService.findServer(Unknown
> > > Source)
> > > at
> > > org.apache.derby.impl.services.jmx.JMXManagementService.boot(Unknown
> > > Source)
> > > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> > > Source)
> > > at
> > > org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
> > > Source)
> > > at
> > > org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
> > > Source)
> > > at
> > > org.apache.derby.iapi.services.monitor.Monitor.startSystemModule(Unknown
> > > Source)
> > > at
> > > org.apache.derby.impl.services.monitor.BaseMonitor.runWithState(Unknown
> > > Source)
> > > at org.apache.derby.impl.services.monitor.FileMonitor.<init>(Unknown
> > > Source)
> > > at
> > > org.apache.derby.iapi.services.monitor.Monitor.startMonitor(Unknown
> > > Source)
> > > at org.apache.derby.iapi.jdbc.JDBCBoot.boot(Unknown Source)
> > > at org.apache.derby.jdbc.EmbeddedDriver.boot(Unknown Source)
> > > at org.apache.derby.jdbc.EmbeddedDriver.<clinit>(Unknown Source)
> > > at java.lang.Class.initializeClass(libgcj.so.81)
> > > at java.lang.Class.forName(libgcj.so.81)
> > > at
> > > org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:77)
> > > at
> > > org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
> > > at
> > > org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
> > > at
> > > org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
> > > at
> > > org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
> > > at
> > > org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:98)
> > > at
> > > org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:1056)
> > > at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:136)
> > > at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:125)
> > > at
> > > org.ofbiz.entity.datasource.GenericDAO.checkDb(GenericDAO.java:1090)
> > > at
> > > org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:195)
> > > at
> > > org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:288)
> > > at
> > > org.ofbiz.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:141)
> > > at
> > > org.ofbiz.catalina.container.CatalinaContainer.init(CatalinaContainer.java:171)
> > > at
> > > org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:190)
> > > at
> > > org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:66)
> > > at org.ofbiz.base.start.Start.initStartLoaders(Start.java:250)
> > > at org.ofbiz.base.start.Start.init(Start.java:89)
> > > at org.ofbiz.base.start.Start.main(Start.java:398)
> > > Caused by: javax.management.NotCompliantMBeanException: MBean is not
> > > compliant
> > > at mx4j.server.MX4JMBeanServer.registerImpl(MX4JMBeanServer.java:818)
> > > at
> > > mx4j.server.MX4JMBeanServer.registerMBeanImpl(MX4JMBeanServer.java:769)
> > > at
> > > mx4j.server.MX4JMBeanServer.registerMBean(MX4JMBeanServer.java:753)
> > > at
> > > java.lang.management.ManagementFactory.getPlatformMBeanServer(libgcj.so.81)
> > > ...36 more
> > >
> > > Before I install Tomcat and Derby I had same problem like now. Does
> > > anybody can help or I will go crazy...
> > > -
> > > Srdačan pozdrav,
> > > Best regards,
> > > Mit besten Grüßen,
> > > Saludos cordiales,
> > > Cordialement,
> > > www.extraretail.com
> > >
> > >
> > > On Fri, 2009-07-10 at 17:01 -0700, BJ Freeman wrote:
> > >> http://www.postgresql.org/support/
> > >> also hook up with unbuntu forum
> > >> google for them
> > >>
> > >> cyber trade sent the following on 7/10/2009 4:29 PM:
> > >>> thanks, I will try there, is any procedure for registration in that
> > >>> group?
> > >>> -
> > >>> Srdačan pozdrav,
> > >>> Best regards,
> > >>> Mit besten Grüßen,
> > >>> Saludos cordiales,
> > >>> Cordialement,
> > >>> www.extraretail.com
> > >>>
> > >>>
> > >>> On Fri, 2009-07-10 at 15:49 -0700, BJ Freeman wrote:
> > >>>> outside the entityengine.xml which is covered in those links I sent.
> > >>>> you need to talk to the postgresql group
> > >>>> [email protected]
> > >>>>
> > >>>> cyber trade sent the following on 7/10/2009 3:16 PM:
> > >>>>> thanks, but I couldn't get access throw web browser... also does
> > >>>>> somebody have instruction how to use postgresql 8.3?
> > >>>>> -
> > >>>>> Srdačan pozdrav,
> > >>>>> Best regards,
> > >>>>> Mit besten Grüßen,
> > >>>>> Saludos cordiales,
> > >>>>> Cordialement,
> > >>>>> www.extraretail.com
> > >>>>>
> > >>>>>
> > >>>>> On Fri, 2009-07-10 at 12:19 -0700, BJ Freeman wrote:
> > >>>>>> look under configuration documents
> > >>>>>> http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Documentation+Index
> > >>>>>> the log shows no errors so it is running as far as I can tell.
> > >>>>>>
> > >>>>>> cyber trade sent the following on 7/10/2009 9:05 AM:
> > >>>>>>> HI guys,
> > >>>>>>> I am new with ofbiz and I tried to install that in ubuntu 8.04 ( it
> > >>>>>>> is
> > >>>>>>> not server edition ). So far I didn't do it. Can some one help me
> > >>>>>>> with
> > >>>>>>> step-by-step manual. Can it work with JDK 1.6? IS there any hardware
> > >>>>>>> requirements ( I am using laptop 2 X 1.6 GHz intel and 1GB OF RAM )
> > >>>>>>> and
> > >>>>>>> maybe some additional software requirements? Down there is messages
> > >>>>>>> from
> > >>>>>>> console I get when I try to install it. How does it work with ubuntu
> > >>>>>>> 8.04 server edition?
> > >>>>>>> Can anyone help about this questions?
> > >>>>>>>
> > >>>>>>> "2009-07-10 02:06:10,441
> > >>>>>>> (ContainerBackgroundProcessor[StandardEngine[default-server]])
> > >>>>>>> [ControlEventListener.java:101:INFO ] Destroying session:
> > >>>>>>> A6482C537C8BD3D5B9D0336EA7515C29.jvm1
> > >>>>>>> 2009-07-10 02:06:26,301 (org.ofbiz.service.job.jobpol...@1a28842) [
> > >>>>>>> GenericDAO.java:755:INFO ] Ran query in 1669 milli-seconds: SELECT
> > >>>>>>> JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
> > >>>>>>> PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
> > >>>>>>> AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
> > >>>>>>> RECURRENCE_INFO_ID,
> > >>>>>>> TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT,
> > >>>>>>> RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME,
> > >>>>>>> CANCEL_DATE_TIME,
> > >>>>>>> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> > >>>>>>> CREATED_TX_STAMP FROM OFBIZ.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID =
> > >>>>>>> ?
> > >>>>>>> AND STATUS_ID = ?) ORDER BY RUN_TIME ASC
> > >>>>>>> 2009-07-10 02:07:46,742 (default-invoker-Thread-11) [
> > >>>>>>> JobInvoker.java:231:INFO ] Invoker [default-invoker-Thread-11]
> > >>>>>>> received
> > >>>>>>> job [Send Email] from poller
> > >>>>>>> [org.ofbiz.service.job.jobpol...@1a28842]
> > >>>>>>> 2009-07-10 02:07:46,742 (default-invoker-Thread-10) [
> > >>>>>>> JobInvoker.java:231:INFO ] Invoker [default-invoker-Thread-10]
> > >>>>>>> received
> > >>>>>>> job [Auto-create Fixed Asset Maintenances] from poller
> > >>>>>>> [org.ofbiz.service.job.jobpol...@1a28842]
> > >>>>>>> 2009-07-10 02:07:46,798 (default-invoker-Thread-10)
> > >>>>>>> [PersistedServiceJob.java:176:INFO ]
> > >>>>>>> org.ofbiz.service.job.persistedservice...@10cf661[10217] -- Next
> > >>>>>>> runtime: Fri Jul 10 02:12:46 CEST 2009
> > >>>>>>> 2009-07-10 02:07:46,805 (default-invoker-Thread-11)
> > >>>>>>> [PersistedServiceJob.java:176:INFO ]
> > >>>>>>> org.ofbiz.service.job.persistedservice...@138218[10216] -- Next
> > >>>>>>> runtime:
> > >>>>>>> Fri Jul 10 02:12:46 CEST 2009
> > >>>>>>> 2009-07-10 02:07:47,820 (default-invoker-Thread-11) [
> > >>>>>>> ServiceDispatcher.java:584:INFO ] Sync service
> > >>>>>>> [JobDispatcher/sendEmailDated] finished in [992] milliseconds
> > >>>>>>> 2009-07-10 02:07:49,670 (default-invoker-Thread-10) [
> > >>>>>>> Log.java:110:INFO ]
> > >>>>>>> [CommonPermissionServices.xml#genericBasePermissionCheck] Checking
> > >>>>>>> for
> > >>>>>>> primary permission ACCOUNTING_CREATE
> > >>>>>>> 2009-07-10 02:07:49,673 (default-invoker-Thread-10) [
> > >>>>>>> ServiceEcaRule.java:133:INFO ] For Service ECA
> > >>>>>>> [fixedAssetPermissionCheck] on [return] got false for condition:
> > >>>>>>> [hasPermission][equals][false][true][Boolean]
> > >>>>>>> 2009-07-10 02:07:49,674 (default-invoker-Thread-10) [
> > >>>>>>> ServiceDispatcher.java:584:INFO ] Sync service
> > >>>>>>> [JobDispatcher/fixedAssetPermissionCheck] finished in [2849]
> > >>>>>>> milliseconds
> > >>>>>>> 2009-07-10 02:07:50,685 (default-invoker-Thread-10) [
> > >>>>>>> ServiceDispatcher.java:584:INFO ] Sync service
> > >>>>>>> [JobDispatcher/createMaintsFromTimeInterval] finished in [3860]
> > >>>>>>> milliseconds
> > >>>>>>> 2009-07-10 02:12:50,023 (default-invoker-Thread-9) [
> > >>>>>>> JobInvoker.java:231:INFO ] Invoker [default-invoker-Thread-9]
> > >>>>>>> received
> > >>>>>>> job [Send Email] from poller
> > >>>>>>> [org.ofbiz.service.job.jobpol...@1a28842]
> > >>>>>>> 2009-07-10 02:12:50,023 (default-invoker-Thread-7) [
> > >>>>>>> JobInvoker.java:231:INFO ] Invoker [default-invoker-Thread-7]
> > >>>>>>> received
> > >>>>>>> job [Auto-create Fixed Asset Maintenances] from poller
> > >>>>>>> [org.ofbiz.service.job.jobpol...@1a28842]
> > >>>>>>> 2009-07-10 02:12:56,605 (default-invoker-Thread-9)
> > >>>>>>> [PersistedServiceJob.java:176:INFO ]
> > >>>>>>> org.ofbiz.service.job.persistedservice...@3c1606[10219] -- Next
> > >>>>>>> runtime:
> > >>>>>>> Fri Jul 10 02:17:56 CEST 2009
> > >>>>>>> 2009-07-10 02:12:56,605 (default-invoker-Thread-7)
> > >>>>>>> [PersistedServiceJob.java:176:INFO ]
> > >>>>>>> org.ofbiz.service.job.persistedservice...@c9e408[10218] -- Next
> > >>>>>>> runtime:
> > >>>>>>> Fri Jul 10 02:17:56 CEST 2009
> > >>>>>>> 2009-07-10 02:12:58,334 (default-invoker-Thread-9) [
> > >>>>>>> ServiceDispatcher.java:584:INFO ] Sync service
> > >>>>>>> [JobDispatcher/sendEmailDated] finished in [1715] milliseconds
> > >>>>>>> 2009-07-10 02:12:59,316 (default-invoker-Thread-7) [
> > >>>>>>> Log.java:110:INFO ]
> > >>>>>>> [CommonPermissionServices.xml#genericBasePermissionCheck] Checking
> > >>>>>>> for
> > >>>>>>> primary permission ACCOUNTING_CREATE
> > >>>>>>> 2009-07-10 02:12:59,320 (default-invoker-Thread-7) [
> > >>>>>>> ServiceEcaRule.java:133:INFO ] For Service ECA
> > >>>>>>> [fixedAssetPermissionCheck] on [return] got false for condition:
> > >>>>>>> [hasPermission][equals][false][true][Boolean]
> > >>>>>>> 2009-07-10 02:12:59,321 (default-invoker-Thread-7) [
> > >>>>>>> ServiceDispatcher.java:584:INFO ] Sync service
> > >>>>>>> [JobDispatcher/fixedAssetPermissionCheck] finished in [2697]
> > >>>>>>> milliseconds
> > >>>>>>> 2009-07-10 02:13:00,288 (default-invoker-Thread-7) [
> > >>>>>>> ServiceDispatcher.java:584:INFO ] Sync service
> > >>>>>>> [JobDispatcher/createMaintsFromTimeInterval] finished in [3665]
> > >>>>>>> milliseconds"
> > >>>>>>> -
> > >>>>>>> Srdačan pozdrav,
> > >>>>>>> Best regards,
> > >>>>>>> Mit besten Grüßen,
> > >>>>>>> Saludos cordiales,
> > >>>>>>> Cordialement,
> > >>>>>>> www.extraretail.com
> > >>>>>>>
> > >>>>>>>
> > >>>>>>> On Fri, 2009-07-10 at 08:31 -0700, su2 wrote:
> > >>>>>>>> I have a form which has following tag.
> > >>>>>>>>
> > >>>>>>>> <!-- automatically display all fields from HelloPerson-->
> > >>>>>>>> <auto-fields-entity entity-name="HelloPerson"
> > >>>>>>>> default-field-type="display"/>
> > >>>>>>>>
> > >>>>>>>> According to this it should show all the fields of HelloPerson
> > >>>>>>>> Entity. But I
> > >>>>>>>> do not see any fields on my screen.
> > >>>>>>>>
> > >>>>>>>> I appreciate your help.
> > >>>>>>>>
> > >>>>>>>> Thank you in advance.
> > >>>
> > >
> > >
> >
>
