ofbiz configure with postgres database

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

ofbiz configure with postgres database

Tom Running
Greetings everyone,


I have been trying to configure ofbiz version 13 or 14 to work with
Postgre database.  No luck so far.  I have been looking and had tryied out
multiple way through what I had found via google.  But still running into
problem. Is there a details document some where that layout how to do this.

Especially, what to load for the initial database and ofbiz load??
I want a basic seed load with no test data.

What is the correct syntax and option to use?

Load the seed data with : ./ant run-install-extseed  or recently ./ant
load-extseed

Any help or suggestion?

Thanks,
Toom
Reply | Threaded
Open this post in threaded view
|

Re: ofbiz configure with postgres database

Deepak Dixit-3
Hi Tom,

Please refer:
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup



Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com

On Sat, Jun 25, 2016 at 12:44 AM, Tom Running <[hidden email]> wrote:

> Greetings everyone,
>
>
> I have been trying to configure ofbiz version 13 or 14 to work with
> Postgre database.  No luck so far.  I have been looking and had tryied out
> multiple way through what I had found via google.  But still running into
> problem. Is there a details document some where that layout how to do this.
>
> Especially, what to load for the initial database and ofbiz load??
> I want a basic seed load with no test data.
>
> What is the correct syntax and option to use?
>
> Load the seed data with : ./ant run-install-extseed  or recently ./ant
> load-extseed
>
> Any help or suggestion?
>
> Thanks,
> Toom
>
Reply | Threaded
Open this post in threaded view
|

Re: ofbiz configure with postgres database

Paul Piper
In reply to this post by Tom Running
We got a complete documentation over at Scipio ERP that could be of use to you:

http://www.scipioerp.com/community/developer/installation-configuration/configuration/ 

It also covers the database configuration in a few easy steps. Let me know what you think :)
Reply | Threaded
Open this post in threaded view
|

Re: ofbiz configure with postgres database

Jacques Le Roux
Administrator
In reply to this post by Tom Running
The syntax is (still) the same than in trunk

        ./ant load-extseed

You might want to use
        ./ant load-exttest
If you provide your own test data

By and large
        ./ant -p
is your friend

./ant run-install-extseed is deprecated (still used in R12.04)

HTH

Jacques:


Le 24/06/2016 à 21:14, Tom Running a écrit :

> Greetings everyone,
>
>
> I have been trying to configure ofbiz version 13 or 14 to work with
> Postgre database.  No luck so far.  I have been looking and had tryied out
> multiple way through what I had found via google.  But still running into
> problem. Is there a details document some where that layout how to do this.
>
> Especially, what to load for the initial database and ofbiz load??
> I want a basic seed load with no test data.
>
> What is the correct syntax and option to use?
>
> Load the seed data with : ./ant run-install-extseed  or recently ./ant
> load-extseed
>
> Any help or suggestion?
>
> Thanks,
> Toom
>

Reply | Threaded
Open this post in threaded view
|

Re: ofbiz configure with postgres database

taher
In reply to this post by Tom Running
Hi Tom,

This question might not be as simple as you think it is. I was also
confused the first time I started working with data type. So let me explain
things first.

OFBiz has the following types of data (defined in ofbiz-component.xml for
each component):

- seed: OFBiz and External Seed Data - to be maintained along with source
and updated whenever a system deployment is updated

- seed-initial: OFBiz and External Seed Data - to be maintained along with
source like other seed data, but only loaded initially and not updated when
a system is updated except manually reviewing each line

- demo: OFBiz Only Demo Data (also used for testing OFBiz)

- ext: External General Data (custom or yours)

- ext-test: External Test Data (custom or yours)

- ext-demo: External Demo Data (custom or yours)

Now this is the tricky part, to get a clean new system in OFBiz you need
seed, seed-initial and an admin user login which you can create with the
load-admin-user-login ant target. However, this is not a workable system,
you don't have a chart of accounts for example, and many basic
parameters like stuff in order and accounting have to be inserted manually
(I think this is what you are referring to as problems right?)

So unfortunately the data loading stuff in OFBiz is a bit complicated at
the moment. Creating a Clean system currently is more difficult than
building OFBiz with demo data and then deleting unwanted stuff. So here is
what I suggest that you do:

- First understand what data do you want from the data types mentioned
above. Go to the components where you are having problems and check what
data are you missing when you do not use load-demo (check
ofbiz-component.xml for related data that your are missing)
- Get familiar with ant load-readers to load exactly what you want
- Alternatively just use the demo data and clean it / shape it to your
requirements.

I hope I didn't go in the wrong direction and I understood your question
correctly. Otherwise nevemind :)

Taher Alkhateeb


On Friday, 24 June 2016, Tom Running <[hidden email]> wrote:

> Greetings everyone,
>
>
> I have been trying to configure ofbiz version 13 or 14 to work with
> Postgre database.  No luck so far.  I have been looking and had tryied out
> multiple way through what I had found via google.  But still running into
> problem. Is there a details document some where that layout how to do this.
>
> Especially, what to load for the initial database and ofbiz load??
> I want a basic seed load with no test data.
>
> What is the correct syntax and option to use?
>
> Load the seed data with : ./ant run-install-extseed  or recently ./ant
> load-extseed
>
> Any help or suggestion?
>
> Thanks,
> Toom
>
Reply | Threaded
Open this post in threaded view
|

Re: ofbiz configure with postgres database

Tom Running
In reply to this post by Deepak Dixit-3
Thanks Deepak.   I will take a look.

Tom

On Fri, Jun 24, 2016 at 3:29 PM, Deepak Dixit <
[hidden email]> wrote:

> Hi Tom,
>
> Please refer:
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup
>
>
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwaxsystems.com
>
> On Sat, Jun 25, 2016 at 12:44 AM, Tom Running <[hidden email]>
> wrote:
>
> > Greetings everyone,
> >
> >
> > I have been trying to configure ofbiz version 13 or 14 to work with
> > Postgre database.  No luck so far.  I have been looking and had tryied
> out
> > multiple way through what I had found via google.  But still running into
> > problem. Is there a details document some where that layout how to do
> this.
> >
> > Especially, what to load for the initial database and ofbiz load??
> > I want a basic seed load with no test data.
> >
> > What is the correct syntax and option to use?
> >
> > Load the seed data with : ./ant run-install-extseed  or recently ./ant
> > load-extseed
> >
> > Any help or suggestion?
> >
> > Thanks,
> > Toom
> >
>