Need help/direction getting started with OFBIZ ERP

[joefrancois]

Hello All,

I am new to OFBIZ and would like to implement the ERP/MRP system for my
business. This is a long email, but I am basically looking for guidance, for
examples, document to read, etc.. 

Here is an overview of our business.
- We purchase the retail packaging for the product and send them to the
manufacturer. 
- We outsource the manufacturing and the packaging for the product to a 3rd
party.
- We exclusively sales our product on our website (Shopify) and Amazon.

I downloaded and installed OFBIZ, however, I am having a hard time finding
the information needed to get started. On a high-level, here is what I am
trying to accomplish.

- Understand the full procurement cycle. From PO - to receiving the goods
and payments. Including on how to account for shipping costs
- Set up manufacturing to take account of labour costs provided by our 3rd
party manufacturer. This would include the system to calculate the per
product costing. 
- Understand the full sale cycle from SO to shipping to customers and
receiving payments.
- I would like to understand how to do bulk import of historical data
- Is there a plugin already developed to synchronize with Amazon?

Any guidance will be highly appreciated.

Regards,





--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html

Re: Need help/direction getting started with OFBIZ ERP

[Jacques Le Roux]

Hi joefrancois,

Your message has been moderated, else it would not have reach the user ML.

Please subscribe to the user ML for such questions and then use your email 
client.
See why here http://ofbiz.apache.org/mailing-lists.html.

You will get a better support, people can answer you on the ML.
The wider the audience the better the answers you might get.

Also it's more work for moderators who have to accept your messages as long as 
you have not subscribed.
I'll personally no longer accept them (other moderators still could).

Thanks

This said there is no plugin to synchronize with Amazon.

Sorry, I have not more time at the moment to answer you more. Hopefully you 
will get some help before I can...

Jacques

Le 29/04/2020 à 10:48, joefrancois a écrit :

Hello All,

I am new to OFBIZ and would like to implement the ERP/MRP system for my
business. This is a long email, but I am basically looking for guidance, for
examples, document to read, etc..

Here is an overview of our business.
- We purchase the retail packaging for the product and send them to the
manufacturer.
- We outsource the manufacturing and the packaging for the product to a 3rd
party.
- We exclusively sales our product on our website (Shopify) and Amazon.

I downloaded and installed OFBIZ, however, I am having a hard time finding
the information needed to get started. On a high-level, here is what I am
trying to accomplish.

- Understand the full procurement cycle. From PO - to receiving the goods
and payments. Including on how to account for shipping costs
- Set up manufacturing to take account of labour costs provided by our 3rd
party manufacturer. This would include the system to calculate the per
product costing.
- Understand the full sale cycle from SO to shipping to customers and
receiving payments.
- I would like to understand how to do bulk import of historical data
- Is there a plugin already developed to synchronize with Amazon?

Any guidance will be highly appreciated.

Regards,





--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html

Re: Need help/direction getting started with OFBIZ ERP

[Ankush Upadhyay]

Hello  joefrancois,

I am not sure if we have Amazon integration with Ofbiz or something like
that to sync data from Amazon to Ofbiz.

Regarding
>>>
 Understand the full procurement cycle. From PO - to receiving the goods
and payments. Including on how to account for shipping costs
- Set up manufacturing to take account of labour costs provided by our 3rd
party manufacturer. This would include the system to calculate the per
product costing.

see if these links helps to understand:
https://cwiki.apache.org/confluence/display/OFBENDUSER/Purchase+Order
https://cwiki.apache.org/confluence/display/OFBENDUSER/Create+a+Purchase+Order
https://cwiki.apache.org/confluence/display/OFBIZ/Buyer+Places+Purchase+Order
https://cwiki.apache.org/confluence/display/OFBENDUSER/Receive+Purchase+Order
https://cwiki.apache.org/confluence/display/OFBIZ/Manufacturing+Process+Stories+and+Diagrams




Kind Regards,
Ankush Upadhyay
Senior Technical Consultant

*HotWax Systems*
*Enterprise open source experts*
cell: +91-8109201285
office: 0731-409-3684
http://www.hotwaxsystems.com


On Wed, Apr 29, 2020 at 4:48 PM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi joefrancois,
>
> Your message has been moderated, else it would not have reach the user ML.
>
> Please subscribe to the user ML for such questions and then use your email
> client.
> See why here http://ofbiz.apache.org/mailing-lists.html.
>
> You will get a better support, people can answer you on the ML.
> The wider the audience the better the answers you might get.
>
> Also it's more work for moderators who have to accept your messages as
> long as you have not subscribed.
> I'll personally no longer accept them (other moderators still could).
>
> Thanks
>
> This said there is no plugin to synchronize with Amazon.
>
> Sorry, I have not more time at the moment to answer you more. Hopefully
> you will get some help before I can...
>
> Jacques
>
> Le 29/04/2020 à 10:48, joefrancois a écrit :
> > Hello All,
> >
> > I am new to OFBIZ and would like to implement the ERP/MRP system for my
> > business. This is a long email, but I am basically looking for guidance,
> for
> > examples, document to read, etc..
> >
> > Here is an overview of our business.
> > - We purchase the retail packaging for the product and send them to the
> > manufacturer.
> > - We outsource the manufacturing and the packaging for the product to a
> 3rd
> > party.
> > - We exclusively sales our product on our website (Shopify) and Amazon.
> >
> > I downloaded and installed OFBIZ, however, I am having a hard time
> finding
> > the information needed to get started. On a high-level, here is what I am
> > trying to accomplish.
> >
> > - Understand the full procurement cycle. From PO - to receiving the goods
> > and payments. Including on how to account for shipping costs
> > - Set up manufacturing to take account of labour costs provided by our
> 3rd
> > party manufacturer. This would include the system to calculate the per
> > product costing.
> > - Understand the full sale cycle from SO to shipping to customers and
> > receiving payments.
> > - I would like to understand how to do bulk import of historical data
> > - Is there a plugin already developed to synchronize with Amazon?
> >
> > Any guidance will be highly appreciated.
> >
> > Regards,
> >
> >
> >
> >
> >
> > --
> > Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
>
>

Re: Need help/direction getting started with OFBIZ ERP

[joefrancois]

Thank you, Ankush for your direction.

To All:

I am now an expert at installing OFBIZ , I currently running to instances
against an external MySQL database. I also played around and created a
plugin suing the Getting Started guide.

Along the way, I am documenting all my steps so that later on, I can share
my experience with the community for newbies like myself.

Now I am at the point to start where I want to start putting in data and
setup the System for my company. However, I am having some problem getting
started, from setting up a COA, Bank and credit card accounts, Main Company,
etc.. I am not sure how things hands together. All documents I found so far
are incomplete, and some are outdated. 

As I said, I am documenting everything I do, to put together a complete
tutorial. I can certainly use some help to come up to speed and would
appreciate some help and guidance.  

Regards,
Joseph 




--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html

Re: Need help/direction getting started with OFBIZ ERP

[Eugen Stan]

Hi,

Thank you for taking the time to document your steps.

I am one of the newbies who would use them.

Please share sooner than later :).

Do you upload to a public git repository?

Thanks,

La 29.06.2020 21:48, joefrancois a scris:
> Thank you, Ankush for your direction.
>
> To All:
>
> I am now an expert at installing OFBIZ , I currently running to instances
> against an external MySQL database. I also played around and created a
> plugin suing the Getting Started guide.
>
> Along the way, I am documenting all my steps so that later on, I can share
> my experience with the community for newbies like myself.
>
> Now I am at the point to start where I want to start putting in data and
> setup the System for my company. However, I am having some problem getting
> started, from setting up a COA, Bank and credit card accounts, Main Company,
> etc.. I am not sure how things hands together. All documents I found so far
> are incomplete, and some are outdated. 
>
> As I said, I am documenting everything I do, to put together a complete
> tutorial. I can certainly use some help to come up to speed and would
> appreciate some help and guidance.  
>
> Regards,
> Joseph 
>
>
>
>
> --
> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html

-- 
Eugen Stan
+40720 898 747 / netdava.com

<>

signature.asc
Description: OpenPGP digital signature

Re: Need help/direction getting started with OFBIZ ERP

[Jacques Le Roux]

Hi joefrancois,

Your message has been moderated (again), else it would not have reach the user 
ML.
Using the Nabble forum is not enough to reach all the community...

Please subscribe to the user ML for such questions and then use your email 
client.
See why here http://ofbiz.apache.org/mailing-lists.html.

You will get a better support, people can answer you on the ML.
The wider the audience the better the answers you might get.

Thanks

Jacques

Le 29/06/2020 à 20:48, joefrancois a écrit :

Thank you, Ankush for your direction.

To All:

I am now an expert at installing OFBIZ , I currently running to instances
against an external MySQL database. I also played around and created a
plugin suing the Getting Started guide.

Along the way, I am documenting all my steps so that later on, I can share
my experience with the community for newbies like myself.

Now I am at the point to start where I want to start putting in data and
setup the System for my company. However, I am having some problem getting
started, from setting up a COA, Bank and credit card accounts, Main Company,
etc.. I am not sure how things hands together. All documents I found so far
are incomplete, and some are outdated.

As I said, I am documenting everything I do, to put together a complete
tutorial. I can certainly use some help to come up to speed and would
appreciate some help and guidance.

Regards,
Joseph




--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html

Re: Need help/direction getting started with OFBIZ ERP

[joefrancois]

Hello,

So far my notes are just on my computer, however, I could clean it up and
post what  I did to make it work on Ubuntu if you are interested. 

Regards,
Joseph



--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html

Re: Need help/direction getting started with OFBIZ ERP

[Pierre Smits]

Hi Joe François,

Welcome to the project.

We have (some) implementation pages in our wiki.

Feel free to browse through them and improve where necessary.

Your help (contributions) will surely be appreciated.

Mvg

Pierre

Op di 30 jun. 2020 17:55 schreef joefrancois :

> Hello,
>
> So far my notes are just on my computer, however, I could clean it up and
> post what  I did to make it work on Ubuntu if you are interested.
>
> Regards,
> Joseph
>
>
>
> --
> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
>

Re: Need help/direction getting started with OFBIZ ERP

[Jacques Le Roux]

Hi Joseph,

Sorry, I just checked, you are still no subscribed to user@ofbiz.apache.org, at least 
as Joseph Francois 
Just follow https://ofbiz.apache.org/mailing-lists.html for that, ie send an 
email to user-subscr...@ofbiz.apache.org
You can also do that at https://lists.apache.org/list.html?user@ofbiz.apache.org

You can also share in

 * the OFBiz Slack channel 
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days#OFBizCommunityDays-OFBizChat,
 * using GitHub https://github.com/apache/ofbiz-framework 
https://github.com/apache/ofbiz-plugins,
 * or Jira if you need https://issues.apache.org/jira/projects/OFBIZ/summary

In your case though, you may want to be a contributor, then follow 
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Contributors

HTH

Jacques


Le 30/06/2020 à 17:43, Joseph Francois a écrit :

Hello Jacques,

I thought I was following the guideline, I am really confused. Sorry about that. I have subscribed to the User ML. should I only send email to this 
mailing list?


Sorry for being a pain.

Regards,
Joseph

On Tue, 30 Jun 2020 at 17:39, Jacques Le Roux mailto:jacques.le.r...@les7arts.com>> wrote:

Hi joefrancois,

Your message has been moderated (again), else it would not have reach the 
user ML.
Using the Nabble forum is not enough to reach all the community...

Please subscribe to the user ML for such questions and then use your email 
client.
See why here http://ofbiz.apache.org/mailing-lists.html.

You will get a better support, people can answer you on the ML.
The wider the audience the better the answers you might get.

Thanks

Jacques

Le 29/06/2020 à 20:48, joefrancois a écrit :

Thank you, Ankush for your direction.

To All:

I am now an expert at installing OFBIZ , I currently running to instances
against an external MySQL database. I also played around and created a
plugin suing the Getting Started guide.

Along the way, I am documenting all my steps so that later on, I can share
my experience with the community for newbies like myself.

Now I am at the point to start where I want to start putting in data and
setup the System for my company. However, I am having some problem getting
started, from setting up a COA, Bank and credit card accounts, Main Company,
etc.. I am not sure how things hands together. All documents I found so far
are incomplete, and some are outdated.

As I said, I am documenting everything I do, to put together a complete
tutorial. I can certainly use some help to come up to speed and would
appreciate some help and guidance.

Regards,
Joseph




--
Sent from:http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html

Re: Need help/direction getting started with OFBIZ ERP

[Joseph Francois]

Hello Jacques,

I believe I should be subscribed now.

Regards,
Joseph

On Tue, 30 Jun 2020 at 18:19, Jacques Le Roux 
wrote:

> Hi Joseph,
>
> Sorry, I just checked, you are still no subscribed to
> user@ofbiz.apache.org, at least as Joseph Francois 
> 
> Just follow https://ofbiz.apache.org/mailing-lists.html for that, ie send
> an email to user-subscr...@ofbiz.apache.org
> You can also do that at
> https://lists.apache.org/list.html?user@ofbiz.apache.org
>
> You can also share in
>
>- the OFBiz Slack channel
>
> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days#OFBizCommunityDays-OFBizChat
>,
>- using GitHub https://github.com/apache/ofbiz-framework
>https://github.com/apache/ofbiz-plugins,
>- or Jira if you need
>https://issues.apache.org/jira/projects/OFBIZ/summary
>
> In your case though, you may want to be a contributor, then follow
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Contributors
>
> HTH
>
> Jacques
>
>
> Le 30/06/2020 à 17:43, Joseph Francois a écrit :
>
> Hello Jacques,
>
> I thought I was following the guideline, I am really confused. Sorry about
> that. I have subscribed to the User ML. should I only send email to this
> mailing list?
>
> Sorry for being a pain.
>
> Regards,
> Joseph
>
> On Tue, 30 Jun 2020 at 17:39, Jacques Le Roux <
> jacques.le.r...@les7arts.com> wrote:
>
>> Hi joefrancois,
>>
>> Your message has been moderated (again), else it would not have reach the
>> user ML.
>> Using the Nabble forum is not enough to reach all the community...
>>
>> Please subscribe to the user ML for such questions and then use your
>> email client.
>> See why here http://ofbiz.apache.org/mailing-lists.html.
>>
>> You will get a better support, people can answer you on the ML.
>> The wider the audience the better the answers you might get.
>>
>> Thanks
>>
>> Jacques
>> Le 29/06/2020 à 20:48, joefrancois a écrit :
>>
>> Thank you, Ankush for your direction.
>>
>> To All:
>>
>> I am now an expert at installing OFBIZ , I currently running to instances
>> against an external MySQL database. I also played around and created a
>> plugin suing the Getting Started guide.
>>
>> Along the way, I am documenting all my steps so that later on, I can share
>> my experience with the community for newbies like myself.
>>
>> Now I am at the point to start where I want to start putting in data and
>> setup the System for my company. However, I am having some problem getting
>> started, from setting up a COA, Bank and credit card accounts, Main Company,
>> etc.. I am not sure how things hands together. All documents I found so far
>> are incomplete, and some are outdated.
>>
>> As I said, I am documenting everything I do, to put together a complete
>> tutorial. I can certainly use some help to come up to speed and would
>> appreciate some help and guidance.
>>
>> Regards,
>> Joseph
>>
>>
>>
>>
>> --
>> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
>>
>>

Re: Need help/direction getting started with OFBIZ ERP

[Jacques Le Roux]

\o/ yes!

Le 02/07/2020 à 08:44, Joseph Francois a écrit :

Hello Jacques,

I believe I should be subscribed now.

Regards,
Joseph

On Tue, 30 Jun 2020 at 18:19, Jacques Le Roux mailto:jacques.le.r...@les7arts.com>> wrote:

Hi Joseph,

Sorry, I just checked, you are still no subscribed to user@ofbiz.apache.org 
, at least as Joseph Francois
 
Just follow https://ofbiz.apache.org/mailing-lists.html for that, ie send 
an email to user-subscr...@ofbiz.apache.org

You can also do that at 
https://lists.apache.org/list.html?user@ofbiz.apache.org

You can also share in

  * the OFBiz Slack channel 
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days#OFBizCommunityDays-OFBizChat,
  * using GitHub https://github.com/apache/ofbiz-framework 
https://github.com/apache/ofbiz-plugins,
  * or Jira if you need 
https://issues.apache.org/jira/projects/OFBIZ/summary

In your case though, you may want to be a contributor, then follow 
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Contributors

HTH

Jacques


Le 30/06/2020 à 17:43, Joseph Francois a écrit :

Hello Jacques,

I thought I was following the guideline, I am really confused. Sorry about 
that. I have subscribed to the User ML. should I only send email to
this mailing list?

Sorry for being a pain.

Regards,
Joseph

On Tue, 30 Jun 2020 at 17:39, Jacques Le Roux mailto:jacques.le.r...@les7arts.com>> wrote:

Hi joefrancois,

Your message has been moderated (again), else it would not have reach 
the user ML.
Using the Nabble forum is not enough to reach all the community...

Please subscribe to the user ML for such questions and then use your 
email client.
See why here http://ofbiz.apache.org/mailing-lists.html.

You will get a better support, people can answer you on the ML.
The wider the audience the better the answers you might get.

Thanks

Jacques

Le 29/06/2020 à 20:48, joefrancois a écrit :

Thank you, Ankush for your direction.

To All:

I am now an expert at installing OFBIZ , I currently running to 
instances
against an external MySQL database. I also played around and created a
plugin suing the Getting Started guide.

Along the way, I am documenting all my steps so that later on, I can 
share
my experience with the community for newbies like myself.

Now I am at the point to start where I want to start putting in data and
setup the System for my company. However, I am having some problem 
getting
started, from setting up a COA, Bank and credit card accounts, Main 
Company,
etc.. I am not sure how things hands together. All documents I found so 
far
are incomplete, and some are outdated.

As I said, I am documenting everything I do, to put together a complete
tutorial. I can certainly use some help to come up to speed and would
appreciate some help and guidance.

Regards,
Joseph




--
Sent from:http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html

Re: Need help/direction getting started with OFBIZ ERP

[Tuck Seng Phoon]

Hi Joseph,

I’m running Ofbiz version 17.12.03 and would like to set up MySQL database. 
Which version of MySQL I should install? Where can I get the steps to set up 
MySQL?

Thanks

Cheers
Phoon

On 2020/06/29 18:48:55, joefrancois  wrote: 
> Thank you, Ankush for your direction.> 
> 
> To All:> 
> 
> I am now an expert at installing OFBIZ , I currently running to instances> 
> against an external MySQL database. I also played around and created a> 
> plugin suing the Getting Started guide.> 
> 
> Along the way, I am documenting all my steps so that later on, I can share> 
> my experience with the community for newbies like myself.> 
> 
> Now I am at the point to start where I want to start putting in data and> 
> setup the System for my company. However, I am having some problem getting> 
> started, from setting up a COA, Bank and credit card accounts, Main Company,> 
> etc.. I am not sure how things hands together. All documents I found so far> 
> are incomplete, and some are outdated. > 
> 
> As I said, I am documenting everything I do, to put together a complete> 
> tutorial. I can certainly use some help to come up to speed and would> 
> appreciate some help and guidance.  > 
> 
> Regards,> 
> Joseph > 
> 
> 
> 
> 
> --> 
> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html> 
> 
Sent from Mail for Windows 10

Re: Need help/direction getting started with OFBIZ ERP

[Jacques Le Roux]

Hi Phoon,

You should refer to the README.adoc file. At section "Setup an external database 
like MySQL, PostgreSQL, etc" it says:

To setup an external database instead of the default embedded Apache Derby, you
will need to follow the following instructions:

1.  Find the JDBC driver suitable for your database using one of the following
options:

* Search for the JDBC driver in https://bintray.com/bintray/jcenter[jcenter] and
place it in build.gradle dependencies e.g.
`runtime 'mysql:mysql-connector-java:5.1.36'`
+
OR
* Download the JDBC driver jar and place it in $OFBIZ_HOME/lib or the lib
sub-directory of any component

2.  Modify the entityengine.xml file located in
$OFBIZ_HOME/framework/entity/config to switch the default database to the one
you selected. For more details you can read the relevant section in the
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide[technical
setup guide]

HTH

Jacques

Le 10/07/2020 à 04:57, Tuck Seng Phoon a écrit :

Hi Joseph,

I’m running Ofbiz version 17.12.03 and would like to set up MySQL database. 
Which version of MySQL I should install? Where can I get the steps to set up 
MySQL?

Thanks

Cheers
Phoon

On 2020/06/29 18:48:55, joefrancois  wrote:

Thank you, Ankush for your direction.>

To All:>

I am now an expert at installing OFBIZ , I currently running to instances>
against an external MySQL database. I also played around and created a>
plugin suing the Getting Started guide.>

Along the way, I am documenting all my steps so that later on, I can share>
my experience with the community for newbies like myself.>

Now I am at the point to start where I want to start putting in data and>
setup the System for my company. However, I am having some problem getting>
started, from setting up a COA, Bank and credit card accounts, Main Company,>
etc.. I am not sure how things hands together. All documents I found so far>
are incomplete, and some are outdated. >

As I said, I am documenting everything I do, to put together a complete>
tutorial. I can certainly use some help to come up to speed and would>
appreciate some help and guidance.  >

Regards,>
Joseph >




-->
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html>


Sent from Mail for Windows 10

Re: Need help/direction getting started with OFBIZ ERP

[Joseph Francois]

Hello Phoon,

You should follow Jacques' advice. Here are a few gotcha that I faced.

*Mysql configuration*
I installed the latest MariaDB 10.5 and it worked well. You also can
install MySQL, it should work as well. However, make sure that you change
MySQL configurations to that utf8 is your default character set as shown in
the instructions

mysql.conf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8


After just create the databases and users as required. As an example, I
copy-paste from the instruction.

mysql>create database ofbiz;
mysql>create database ofbizolap;
mysql>create database ofbiztenant;
mysql>use mysql;
mysql>select database();
mysql>create user ofbiz@localhost;
mysql>create user ofbizolap@localhost;
mysql>create user ofbiztenant@localhost;
mysql>update user set password=PASSWORD("ofbiz") where User='ofbiz';
mysql>update user set password=PASSWORD("ofbizolap") where User='ofbizolap';
mysql>update user set password=PASSWORD("ofbiztenant") where
User='ofbiztenant';
mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
'ofbiz';
mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified by
'ofbizolap';
mysql>grant all privileges on *.* to 'ofbiztenant'@localhost identified by
'ofbiztenant';

That would be it for MySQL.

*Gradle configurations*

You need to make sure that you have the right JDBC driver (MySQL in this
case). The easiest I found was to just let the Gradle script download it
from JCenter, as mention by Jacques.
- Using your favourite editor (vi, nano, etc..)  open
$OFBIZ_HOME/build.gradle
- Starting from line 164 add the following line (Use the other lines as an
example of the syntax).
runtime 'mysql:mysql-connector-java:5.1.36'
- So now OFBIZ will be capable of reading and writing data in MySQL.

*OFBIZ configurations*
Now you need to tell OFBIZ to use MySQL and give the server, database to
use and how to authenticate. All this is done in entityengine.xml. *(This
is where my knowledge decreases, I will just tell you what I understand.)*
- The"delegator" records tell what OFBIZ where to look for the
configuration to connect to the database. So basically what database to
use.  There are 3 delegators you need to change so that they point to your
MYSQL records.
  1. Default
   2. default-no-eca
  3. test
-  Since there are three databases, you will need to have a configuration
for each of them. The three databases are:
1. ofbiz
 2. olap
 3 tenant
- In practice, you should just modify the records
for localmysql/ localmysqlolap/localmysql to have them reflect your MySQL
setup. and update the delegators
with  localmysql/ localmysqlolap/localmysql respectively.


*Conclusion*
if your ofbiz server has access to the Internet to download the driver
and it can connect, authenticate to the database server and the DB exists,
all should work as normal.


Hope that was of help.

Regards,
Josep


On Fri, 10 Jul 2020 at 09:06, Jacques Le Roux 
wrote:

> Hi Phoon,
>
> You should refer to the README.adoc file. At section "Setup an external
> database like MySQL, PostgreSQL, etc" it says:
>
> To setup an external database instead of the default embedded Apache
> Derby, you
> will need to follow the following instructions:
>
> 1.  Find the JDBC driver suitable for your database using one of the
> following
> options:
>
> * Search for the JDBC driver in
> https://bintray.com/bintray/jcenter[jcenter] and
> place it in build.gradle dependencies e.g.
> `runtime 'mysql:mysql-connector-java:5.1.36'`
> +
> OR
> * Download the JDBC driver jar and place it in $OFBIZ_HOME/lib or the lib
> sub-directory of any component
>
> 2.  Modify the entityengine.xml file located in
> $OFBIZ_HOME/framework/entity/config to switch the default database to the
> one
> you selected. For more details you can read the relevant section in the
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide[technical
> 
> setup guide]
>
> HTH
>
> Jacques
>
> Le 10/07/2020 à 04:57, Tuck Seng Phoon a écrit :
> > Hi Joseph,
> >
> > I’m running Ofbiz version 17.12.03 and would like to set up MySQL
> database. Which version of MySQL I should install? Where can I get the
> steps to set up MySQL?
> >
> > Thanks
> >
> > Cheers
> > Phoon
> >
> > On 2020/06/29 18:48:55, joefrancois  wrote:
> >> Thank you, Ankush for your direction.>
> >>
> >> To All:>
> >>
> >> I am now an expert at installing OFBIZ , I currently running to
> instances>
> >> against an external MySQL database. I also played around and created a>
> >> plugin suing the Getting Started guide.>
> >>
> >> Along the way, I am documenting all my steps so that later on, I can
> share>
> >> my experience with the community for newbies like myself.>
> >>
> >> No

Re: Need help/direction getting started with OFBIZ ERP

[Tuck Seng Phoon]

Thank you so much Jacques 😊
CheersPhoon 

On Friday, July 10, 2020, 03:06:34 PM GMT+8, Jacques Le Roux 
 wrote:  
 
 Hi Phoon,

You should refer to the README.adoc file. At section "Setup an external 
database like MySQL, PostgreSQL, etc" it says:

To setup an external database instead of the default embedded Apache Derby, you
will need to follow the following instructions:

1.  Find the JDBC driver suitable for your database using one of the following
options:

* Search for the JDBC driver in https://bintray.com/bintray/jcenter[jcenter] and
place it in build.gradle dependencies e.g.
`runtime 'mysql:mysql-connector-java:5.1.36'`
+
OR
* Download the JDBC driver jar and place it in $OFBIZ_HOME/lib or the lib
sub-directory of any component

2.  Modify the entityengine.xml file located in
$OFBIZ_HOME/framework/entity/config to switch the default database to the one
you selected. For more details you can read the relevant section in the
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide[technical
setup guide]

HTH

Jacques

Le 10/07/2020 à 04:57, Tuck Seng Phoon a écrit :
> Hi Joseph,
>
> I’m running Ofbiz version 17.12.03 and would like to set up MySQL database. 
> Which version of MySQL I should install? Where can I get the steps to set up 
> MySQL?
>
> Thanks
>
> Cheers
> Phoon
>
> On 2020/06/29 18:48:55, joefrancois  wrote:
>> Thank you, Ankush for your direction.>
>>
>> To All:>
>>
>> I am now an expert at installing OFBIZ , I currently running to instances>
>> against an external MySQL database. I also played around and created a>
>> plugin suing the Getting Started guide.>
>>
>> Along the way, I am documenting all my steps so that later on, I can share>
>> my experience with the community for newbies like myself.>
>>
>> Now I am at the point to start where I want to start putting in data and>
>> setup the System for my company. However, I am having some problem getting>
>> started, from setting up a COA, Bank and credit card accounts, Main Company,>
>> etc.. I am not sure how things hands together. All documents I found so far>
>> are incomplete, and some are outdated. >
>>
>> As I said, I am documenting everything I do, to put together a complete>
>> tutorial. I can certainly use some help to come up to speed and would>
>> appreciate some help and guidance.  >
>>
>> Regards,>
>> Joseph >
>>
>>
>>
>>
>> -->
>> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html>
>>
> Sent from Mail for Windows 10
>
  

Re: Need help/direction getting started with OFBIZ ERP

[Tuck Seng Phoon]

Thank you so much Joseph. 
What's the reason to use MariaDB vs MsSQL may I ask?I want to be sure I made 
the right decision.
TIA
CheersPhoon 

On Friday, July 10, 2020, 04:08:41 PM GMT+8, Joseph Francois 
 wrote:  
 
 Hello Phoon,

You should follow Jacques' advice. Here are a few gotcha that I faced.

*Mysql configuration*
I installed the latest MariaDB 10.5 and it worked well. You also can
install MySQL, it should work as well. However, make sure that you change
MySQL configurations to that utf8 is your default character set as shown in
the instructions

mysql.conf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8


After just create the databases and users as required. As an example, I
copy-paste from the instruction.

mysql>create database ofbiz;
mysql>create database ofbizolap;
mysql>create database ofbiztenant;
mysql>use mysql;
mysql>select database();
mysql>create user ofbiz@localhost;
mysql>create user ofbizolap@localhost;
mysql>create user ofbiztenant@localhost;
mysql>update user set password=PASSWORD("ofbiz") where User='ofbiz';
mysql>update user set password=PASSWORD("ofbizolap") where User='ofbizolap';
mysql>update user set password=PASSWORD("ofbiztenant") where
User='ofbiztenant';
mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
'ofbiz';
mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified by
'ofbizolap';
mysql>grant all privileges on *.* to 'ofbiztenant'@localhost identified by
'ofbiztenant';

That would be it for MySQL.

*Gradle configurations*

You need to make sure that you have the right JDBC driver (MySQL in this
case). The easiest I found was to just let the Gradle script download it
from JCenter, as mention by Jacques.
- Using your favourite editor (vi, nano, etc..)  open
$OFBIZ_HOME/build.gradle
- Starting from line 164 add the following line (Use the other lines as an
example of the syntax).
            runtime 'mysql:mysql-connector-java:5.1.36'
- So now OFBIZ will be capable of reading and writing data in MySQL.

*OFBIZ configurations*
Now you need to tell OFBIZ to use MySQL and give the server, database to
use and how to authenticate. All this is done in entityengine.xml. *(This
is where my knowledge decreases, I will just tell you what I understand.)*
- The"delegator" records tell what OFBIZ where to look for the
configuration to connect to the database. So basically what database to
use.  There are 3 delegators you need to change so that they point to your
MYSQL records.
      1. Default
      2. default-no-eca
      3. test
-  Since there are three databases, you will need to have a configuration
for each of them. The three databases are:
    1. ofbiz
    2. olap
    3 tenant
- In practice, you should just modify the records
for localmysql/ localmysqlolap/localmysql to have them reflect your MySQL
setup. and update the delegators
with  localmysql/ localmysqlolap/localmysql respectively.


*Conclusion*
if your ofbiz server has access to the Internet to download the driver
and it can connect, authenticate to the database server and the DB exists,
all should work as normal.


Hope that was of help.

Regards,
Josep


On Fri, 10 Jul 2020 at 09:06, Jacques Le Roux 
wrote:

> Hi Phoon,
>
> You should refer to the README.adoc file. At section "Setup an external
> database like MySQL, PostgreSQL, etc" it says:
>
> To setup an external database instead of the default embedded Apache
> Derby, you
> will need to follow the following instructions:
>
> 1.  Find the JDBC driver suitable for your database using one of the
> following
> options:
>
> * Search for the JDBC driver in
> https://bintray.com/bintray/jcenter[jcenter] and
> place it in build.gradle dependencies e.g.
> `runtime 'mysql:mysql-connector-java:5.1.36'`
> +
> OR
> * Download the JDBC driver jar and place it in $OFBIZ_HOME/lib or the lib
> sub-directory of any component
>
> 2.  Modify the entityengine.xml file located in
> $OFBIZ_HOME/framework/entity/config to switch the default database to the
> one
> you selected. For more details you can read the relevant section in the
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide[technical
> 
> setup guide]
>
> HTH
>
> Jacques
>
> Le 10/07/2020 à 04:57, Tuck Seng Phoon a écrit :
> > Hi Joseph,
> >
> > I’m running Ofbiz version 17.12.03 and would like to set up MySQL
> database. Which version of MySQL I should install? Where can I get the
> steps to set up MySQL?
> >
> > Thanks
> >
> > Cheers
> > Phoon
> >
> > On 2020/06/29 18:48:55, joefrancois  wrote:
> >> Thank you, Ankush for your direction.>
> >>
> >> To All:>
> >>
> >> I am now an expert at installing OFBIZ , I currently running to
> instances>
> >> against an external MySQL database. I also played around and cr

Re: Need help/direction getting started with OFBIZ ERP

[Joseph Francois]

Hello Phoon,

Mariadb is a fork of MySQL, really there are little differences if any in
usage.  The developer of MySQL decided to fork Mariadb after SUN
Microsystem and later Oracle acquired MySQL. For test purposes, you can
choose either. For production, just do your research. Bother have a great
number of follower.

Overall, choose a DB that you know and can easily manage.


Regards,
Joseph

On Sun, 12 Jul 2020 at 09:37, Tuck Seng Phoon 
wrote:

> Thank you so much Joseph.
> What's the reason to use MariaDB vs MsSQL may I ask?I want to be sure I
> made the right decision.
> TIA
> CheersPhoon
>
> On Friday, July 10, 2020, 04:08:41 PM GMT+8, Joseph Francois <
> joefranc...@gmail.com> wrote:
>
>  Hello Phoon,
>
> You should follow Jacques' advice. Here are a few gotcha that I faced.
>
> *Mysql configuration*
> I installed the latest MariaDB 10.5 and it worked well. You also can
> install MySQL, it should work as well. However, make sure that you change
> MySQL configurations to that utf8 is your default character set as shown in
> the instructions
>
> mysql.conf
> [client]
> default-character-set=utf8
> [mysql]
> default-character-set=utf8
> [mysqld]
> collation-server = utf8_unicode_ci
> init-connect='SET NAMES utf8'
> character-set-server = utf8
>
>
> After just create the databases and users as required. As an example, I
> copy-paste from the instruction.
>
> mysql>create database ofbiz;
> mysql>create database ofbizolap;
> mysql>create database ofbiztenant;
> mysql>use mysql;
> mysql>select database();
> mysql>create user ofbiz@localhost;
> mysql>create user ofbizolap@localhost;
> mysql>create user ofbiztenant@localhost;
> mysql>update user set password=PASSWORD("ofbiz") where User='ofbiz';
> mysql>update user set password=PASSWORD("ofbizolap") where
> User='ofbizolap';
> mysql>update user set password=PASSWORD("ofbiztenant") where
> User='ofbiztenant';
> mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
> 'ofbiz';
> mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified by
> 'ofbizolap';
> mysql>grant all privileges on *.* to 'ofbiztenant'@localhost identified by
> 'ofbiztenant';
>
> That would be it for MySQL.
>
> *Gradle configurations*
>
> You need to make sure that you have the right JDBC driver (MySQL in this
> case). The easiest I found was to just let the Gradle script download it
> from JCenter, as mention by Jacques.
> - Using your favourite editor (vi, nano, etc..)  open
> $OFBIZ_HOME/build.gradle
> - Starting from line 164 add the following line (Use the other lines as an
> example of the syntax).
> runtime 'mysql:mysql-connector-java:5.1.36'
> - So now OFBIZ will be capable of reading and writing data in MySQL.
>
> *OFBIZ configurations*
> Now you need to tell OFBIZ to use MySQL and give the server, database to
> use and how to authenticate. All this is done in entityengine.xml. *(This
> is where my knowledge decreases, I will just tell you what I understand.)*
> - The"delegator" records tell what OFBIZ where to look for the
> configuration to connect to the database. So basically what database to
> use.  There are 3 delegators you need to change so that they point to your
> MYSQL records.
>   1. Default
>   2. default-no-eca
>   3. test
> -  Since there are three databases, you will need to have a configuration
> for each of them. The three databases are:
> 1. ofbiz
> 2. olap
> 3 tenant
> - In practice, you should just modify the records
> for localmysql/ localmysqlolap/localmysql to have them reflect your MySQL
> setup. and update the delegators
> with  localmysql/ localmysqlolap/localmysql respectively.
>
>
> *Conclusion*
> if your ofbiz server has access to the Internet to download the driver
> and it can connect, authenticate to the database server and the DB exists,
> all should work as normal.
>
>
> Hope that was of help.
>
> Regards,
> Josep
>
>
> On Fri, 10 Jul 2020 at 09:06, Jacques Le Roux <
> jacques.le.r...@les7arts.com>
> wrote:
>
> > Hi Phoon,
> >
> > You should refer to the README.adoc file. At section "Setup an external
> > database like MySQL, PostgreSQL, etc" it says:
> >
> > To setup an external database instead of the default embedded Apache
> > Derby, you
> > will need to follow the following instructions:
> >
> > 1.  Find the JDBC driver suitable for your database using one of the
> > following
> > options:
> >
> > * Search for the JDBC driver in
> > https://bintray.com/bintray/jcenter[jcenter] and
> > place it in build.gradle dependencies e.g.
> > `runtime 'mysql:mysql-connector-java:5.1.36'`
> > +
> > OR
> > * Download the JDBC driver jar and place it in $OFBIZ_HOME/lib or the lib
> > sub-directory of any component
> >
> > 2.  Modify the entityengine.xml file located in
> > $OFBIZ_HOME/framework/entity/config to switch the default database to the
> > one
> > you selected. For more details you can read the relevant section in the
> >
> >
> https://cwiki.apache.org/confluence/display/OFBIZ/Apach

RE: Need help/direction getting started with OFBIZ ERP

[phoonts]

Thank Joseph!

It's really good that you shared about using MariaDB. After reading MariaDB vs 
MySQL on this link, it would be better off to use MariaDB. 
I'm learning everything from scratch. No nothing about database administration. 
Lots of thing to pickup but short of time.

https://www.guru99.com/mariadb-vs-mysql.html#:~:text=MariaDB%20has%20a%20larger%20connection,code%20in%20its%20Enterprise%20Edition.

Thanks again.

Cheers
Phoon

-Original Message-
From: Joseph Francois  
Sent: Monday, 13 July 2020 9:09 pm
To: user@ofbiz.apache.org
Subject: Re: Need help/direction getting started with OFBIZ ERP

Hello Phoon,

Mariadb is a fork of MySQL, really there are little differences if any in 
usage.  The developer of MySQL decided to fork Mariadb after SUN Microsystem 
and later Oracle acquired MySQL. For test purposes, you can choose either. For 
production, just do your research. Bother have a great number of follower.

Overall, choose a DB that you know and can easily manage.


Regards,
Joseph

On Sun, 12 Jul 2020 at 09:37, Tuck Seng Phoon 
wrote:

> Thank you so much Joseph.
> What's the reason to use MariaDB vs MsSQL may I ask?I want to be sure 
> I made the right decision.
> TIA
> CheersPhoon
>
> On Friday, July 10, 2020, 04:08:41 PM GMT+8, Joseph Francois < 
> joefranc...@gmail.com> wrote:
>
>  Hello Phoon,
>
> You should follow Jacques' advice. Here are a few gotcha that I faced.
>
> *Mysql configuration*
> I installed the latest MariaDB 10.5 and it worked well. You also can 
> install MySQL, it should work as well. However, make sure that you 
> change MySQL configurations to that utf8 is your default character set 
> as shown in the instructions
>
> mysql.conf
> [client]
> default-character-set=utf8
> [mysql]
> default-character-set=utf8
> [mysqld]
> collation-server = utf8_unicode_ci
> init-connect='SET NAMES utf8'
> character-set-server = utf8
>
>
> After just create the databases and users as required. As an example, 
> I copy-paste from the instruction.
>
> mysql>create database ofbiz;
> mysql>create database ofbizolap;
> mysql>create database ofbiztenant;
> mysql>use mysql;
> mysql>select database();
> mysql>create user ofbiz@localhost;
> mysql>create user ofbizolap@localhost; create user 
> mysql>ofbiztenant@localhost; update user set 
> mysql>password=PASSWORD("ofbiz") where User='ofbiz'; update user set 
> mysql>password=PASSWORD("ofbizolap") where
> User='ofbizolap';
> mysql>update user set password=PASSWORD("ofbiztenant") where
> User='ofbiztenant';
> mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
> 'ofbiz';
> mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified 
> mysql>by
> 'ofbizolap';
> mysql>grant all privileges on *.* to 'ofbiztenant'@localhost 
> mysql>identified by
> 'ofbiztenant';
>
> That would be it for MySQL.
>
> *Gradle configurations*
>
> You need to make sure that you have the right JDBC driver (MySQL in 
> this case). The easiest I found was to just let the Gradle script 
> download it from JCenter, as mention by Jacques.
> - Using your favourite editor (vi, nano, etc..)  open 
> $OFBIZ_HOME/build.gradle
> - Starting from line 164 add the following line (Use the other lines 
> as an example of the syntax).
> runtime 'mysql:mysql-connector-java:5.1.36'
> - So now OFBIZ will be capable of reading and writing data in MySQL.
>
> *OFBIZ configurations*
> Now you need to tell OFBIZ to use MySQL and give the server, database 
> to use and how to authenticate. All this is done in entityengine.xml. 
> *(This is where my knowledge decreases, I will just tell you what I 
> understand.)*
> - The"delegator" records tell what OFBIZ where to look for the 
> configuration to connect to the database. So basically what database 
> to use.  There are 3 delegators you need to change so that they point 
> to your MYSQL records.
>   1. Default
>   2. default-no-eca
>   3. test
> -  Since there are three databases, you will need to have a 
> configuration for each of them. The three databases are:
> 1. ofbiz
> 2. olap
> 3 tenant
> - In practice, you should just modify the records for localmysql/ 
> localmysqlolap/localmysql to have them reflect your MySQL setup. and 
> update the delegators with  localmysql/ localmysqlolap/localmysql 
> respectively.
>
>
> *Conclusion*
> if your ofbiz server has access to the Internet to download the driver 
> and it can connect, authenticate to the database server and the

Re: Need help/direction getting started with OFBIZ ERP

[Joseph Francois]

Hello Phoon,
Thank you for the article. I am a newbie as well, so it helps to share
notes.

On Tue, 14 Jul 2020 at 05:35,  wrote:

> Thank Joseph!
>
> It's really good that you shared about using MariaDB. After reading
> MariaDB vs MySQL on this link, it would be better off to use MariaDB.
> I'm learning everything from scratch. No nothing about database
> administration. Lots of thing to pickup but short of time.
>
>
> https://www.guru99.com/mariadb-vs-mysql.html#:~:text=MariaDB%20has%20a%20larger%20connection,code%20in%20its%20Enterprise%20Edition
> .
>
> Thanks again.
>
> Cheers
> Phoon
>
> -Original Message-
> From: Joseph Francois 
> Sent: Monday, 13 July 2020 9:09 pm
> To: user@ofbiz.apache.org
> Subject: Re: Need help/direction getting started with OFBIZ ERP
>
> Hello Phoon,
>
> Mariadb is a fork of MySQL, really there are little differences if any in
> usage.  The developer of MySQL decided to fork Mariadb after SUN
> Microsystem and later Oracle acquired MySQL. For test purposes, you can
> choose either. For production, just do your research. Bother have a great
> number of follower.
>
> Overall, choose a DB that you know and can easily manage.
>
>
> Regards,
> Joseph
>
> On Sun, 12 Jul 2020 at 09:37, Tuck Seng Phoon 
> wrote:
>
> > Thank you so much Joseph.
> > What's the reason to use MariaDB vs MsSQL may I ask?I want to be sure
> > I made the right decision.
> > TIA
> > CheersPhoon
> >
> > On Friday, July 10, 2020, 04:08:41 PM GMT+8, Joseph Francois <
> > joefranc...@gmail.com> wrote:
> >
> >  Hello Phoon,
> >
> > You should follow Jacques' advice. Here are a few gotcha that I faced.
> >
> > *Mysql configuration*
> > I installed the latest MariaDB 10.5 and it worked well. You also can
> > install MySQL, it should work as well. However, make sure that you
> > change MySQL configurations to that utf8 is your default character set
> > as shown in the instructions
> >
> > mysql.conf
> > [client]
> > default-character-set=utf8
> > [mysql]
> > default-character-set=utf8
> > [mysqld]
> > collation-server = utf8_unicode_ci
> > init-connect='SET NAMES utf8'
> > character-set-server = utf8
> >
> >
> > After just create the databases and users as required. As an example,
> > I copy-paste from the instruction.
> >
> > mysql>create database ofbiz;
> > mysql>create database ofbizolap;
> > mysql>create database ofbiztenant;
> > mysql>use mysql;
> > mysql>select database();
> > mysql>create user ofbiz@localhost;
> > mysql>create user ofbizolap@localhost; create user
> > mysql>ofbiztenant@localhost; update user set
> > mysql>password=PASSWORD("ofbiz") where User='ofbiz'; update user set
> > mysql>password=PASSWORD("ofbizolap") where
> > User='ofbizolap';
> > mysql>update user set password=PASSWORD("ofbiztenant") where
> > User='ofbiztenant';
> > mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
> > 'ofbiz';
> > mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified
> > mysql>by
> > 'ofbizolap';
> > mysql>grant all privileges on *.* to 'ofbiztenant'@localhost
> > mysql>identified by
> > 'ofbiztenant';
> >
> > That would be it for MySQL.
> >
> > *Gradle configurations*
> >
> > You need to make sure that you have the right JDBC driver (MySQL in
> > this case). The easiest I found was to just let the Gradle script
> > download it from JCenter, as mention by Jacques.
> > - Using your favourite editor (vi, nano, etc..)  open
> > $OFBIZ_HOME/build.gradle
> > - Starting from line 164 add the following line (Use the other lines
> > as an example of the syntax).
> > runtime 'mysql:mysql-connector-java:5.1.36'
> > - So now OFBIZ will be capable of reading and writing data in MySQL.
> >
> > *OFBIZ configurations*
> > Now you need to tell OFBIZ to use MySQL and give the server, database
> > to use and how to authenticate. All this is done in entityengine.xml.
> > *(This is where my knowledge decreases, I will just tell you what I
> > understand.)*
> > - The"delegator" records tell what OFBIZ where to look for the
> > configuration to connect to the database. So basically what database
> > to use.  There are 3 delegators you need to change so that they point
> > to your MYS

Re: Need help/direction getting started with OFBIZ ERP

[Tuck Seng Phoon]

Hi Joseph,
Do you have the steps to install MariaDB?
Thanks
CheersPhoon 

On Friday, July 10, 2020, 04:08:41 PM GMT+8, Joseph Francois 
 wrote:  
 
 Hello Phoon,

You should follow Jacques' advice. Here are a few gotcha that I faced.

*Mysql configuration*
I installed the latest MariaDB 10.5 and it worked well. You also can
install MySQL, it should work as well. However, make sure that you change
MySQL configurations to that utf8 is your default character set as shown in
the instructions

mysql.conf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8


After just create the databases and users as required. As an example, I
copy-paste from the instruction.

mysql>create database ofbiz;
mysql>create database ofbizolap;
mysql>create database ofbiztenant;
mysql>use mysql;
mysql>select database();
mysql>create user ofbiz@localhost;
mysql>create user ofbizolap@localhost;
mysql>create user ofbiztenant@localhost;
mysql>update user set password=PASSWORD("ofbiz") where User='ofbiz';
mysql>update user set password=PASSWORD("ofbizolap") where User='ofbizolap';
mysql>update user set password=PASSWORD("ofbiztenant") where
User='ofbiztenant';
mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
'ofbiz';
mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified by
'ofbizolap';
mysql>grant all privileges on *.* to 'ofbiztenant'@localhost identified by
'ofbiztenant';

That would be it for MySQL.

*Gradle configurations*

You need to make sure that you have the right JDBC driver (MySQL in this
case). The easiest I found was to just let the Gradle script download it
from JCenter, as mention by Jacques.
- Using your favourite editor (vi, nano, etc..)  open
$OFBIZ_HOME/build.gradle
- Starting from line 164 add the following line (Use the other lines as an
example of the syntax).
            runtime 'mysql:mysql-connector-java:5.1.36'
- So now OFBIZ will be capable of reading and writing data in MySQL.

*OFBIZ configurations*
Now you need to tell OFBIZ to use MySQL and give the server, database to
use and how to authenticate. All this is done in entityengine.xml. *(This
is where my knowledge decreases, I will just tell you what I understand.)*
- The"delegator" records tell what OFBIZ where to look for the
configuration to connect to the database. So basically what database to
use.  There are 3 delegators you need to change so that they point to your
MYSQL records.
      1. Default
      2. default-no-eca
      3. test
-  Since there are three databases, you will need to have a configuration
for each of them. The three databases are:
    1. ofbiz
    2. olap
    3 tenant
- In practice, you should just modify the records
for localmysql/ localmysqlolap/localmysql to have them reflect your MySQL
setup. and update the delegators
with  localmysql/ localmysqlolap/localmysql respectively.


*Conclusion*
if your ofbiz server has access to the Internet to download the driver
and it can connect, authenticate to the database server and the DB exists,
all should work as normal.


Hope that was of help.

Regards,
Josep


On Fri, 10 Jul 2020 at 09:06, Jacques Le Roux 
wrote:

> Hi Phoon,
>
> You should refer to the README.adoc file. At section "Setup an external
> database like MySQL, PostgreSQL, etc" it says:
>
> To setup an external database instead of the default embedded Apache
> Derby, you
> will need to follow the following instructions:
>
> 1.  Find the JDBC driver suitable for your database using one of the
> following
> options:
>
> * Search for the JDBC driver in
> https://bintray.com/bintray/jcenter[jcenter] and
> place it in build.gradle dependencies e.g.
> `runtime 'mysql:mysql-connector-java:5.1.36'`
> +
> OR
> * Download the JDBC driver jar and place it in $OFBIZ_HOME/lib or the lib
> sub-directory of any component
>
> 2.  Modify the entityengine.xml file located in
> $OFBIZ_HOME/framework/entity/config to switch the default database to the
> one
> you selected. For more details you can read the relevant section in the
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide[technical
> 
> setup guide]
>
> HTH
>
> Jacques
>
> Le 10/07/2020 à 04:57, Tuck Seng Phoon a écrit :
> > Hi Joseph,
> >
> > I’m running Ofbiz version 17.12.03 and would like to set up MySQL
> database. Which version of MySQL I should install? Where can I get the
> steps to set up MySQL?
> >
> > Thanks
> >
> > Cheers
> > Phoon
> >
> > On 2020/06/29 18:48:55, joefrancois  wrote:
> >> Thank you, Ankush for your direction.>
> >>
> >> To All:>
> >>
> >> I am now an expert at installing OFBIZ , I currently running to
> instances>
> >> against an external MySQL database. I also played around and created a>
> >> plugin suing the Getting Started guide.>
> >>
> >> Alon

Re: Need help/direction getting started with OFBIZ ERP

[Joseph Francois]

Hell Phoon,

It doesn't matter how you install the DB, just use your Linux distribution
package management. However, this is an OFBIZ user forum, so we really
should stick to OFBIZ topics.

Regards,
Joseph

On Fri, 17 Jul 2020 at 05:18, Tuck Seng Phoon 
wrote:

> Hi Joseph,
> Do you have the steps to install MariaDB?
> Thanks
> CheersPhoon
>
> On Friday, July 10, 2020, 04:08:41 PM GMT+8, Joseph Francois <
> joefranc...@gmail.com> wrote:
>
>  Hello Phoon,
>
> You should follow Jacques' advice. Here are a few gotcha that I faced.
>
> *Mysql configuration*
> I installed the latest MariaDB 10.5 and it worked well. You also can
> install MySQL, it should work as well. However, make sure that you change
> MySQL configurations to that utf8 is your default character set as shown in
> the instructions
>
> mysql.conf
> [client]
> default-character-set=utf8
> [mysql]
> default-character-set=utf8
> [mysqld]
> collation-server = utf8_unicode_ci
> init-connect='SET NAMES utf8'
> character-set-server = utf8
>
>
> After just create the databases and users as required. As an example, I
> copy-paste from the instruction.
>
> mysql>create database ofbiz;
> mysql>create database ofbizolap;
> mysql>create database ofbiztenant;
> mysql>use mysql;
> mysql>select database();
> mysql>create user ofbiz@localhost;
> mysql>create user ofbizolap@localhost;
> mysql>create user ofbiztenant@localhost;
> mysql>update user set password=PASSWORD("ofbiz") where User='ofbiz';
> mysql>update user set password=PASSWORD("ofbizolap") where
> User='ofbizolap';
> mysql>update user set password=PASSWORD("ofbiztenant") where
> User='ofbiztenant';
> mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
> 'ofbiz';
> mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified by
> 'ofbizolap';
> mysql>grant all privileges on *.* to 'ofbiztenant'@localhost identified by
> 'ofbiztenant';
>
> That would be it for MySQL.
>
> *Gradle configurations*
>
> You need to make sure that you have the right JDBC driver (MySQL in this
> case). The easiest I found was to just let the Gradle script download it
> from JCenter, as mention by Jacques.
> - Using your favourite editor (vi, nano, etc..)  open
> $OFBIZ_HOME/build.gradle
> - Starting from line 164 add the following line (Use the other lines as an
> example of the syntax).
> runtime 'mysql:mysql-connector-java:5.1.36'
> - So now OFBIZ will be capable of reading and writing data in MySQL.
>
> *OFBIZ configurations*
> Now you need to tell OFBIZ to use MySQL and give the server, database to
> use and how to authenticate. All this is done in entityengine.xml. *(This
> is where my knowledge decreases, I will just tell you what I understand.)*
> - The"delegator" records tell what OFBIZ where to look for the
> configuration to connect to the database. So basically what database to
> use.  There are 3 delegators you need to change so that they point to your
> MYSQL records.
>   1. Default
>   2. default-no-eca
>   3. test
> -  Since there are three databases, you will need to have a configuration
> for each of them. The three databases are:
> 1. ofbiz
> 2. olap
> 3 tenant
> - In practice, you should just modify the records
> for localmysql/ localmysqlolap/localmysql to have them reflect your MySQL
> setup. and update the delegators
> with  localmysql/ localmysqlolap/localmysql respectively.
>
>
> *Conclusion*
> if your ofbiz server has access to the Internet to download the driver
> and it can connect, authenticate to the database server and the DB exists,
> all should work as normal.
>
>
> Hope that was of help.
>
> Regards,
> Josep
>
>
> On Fri, 10 Jul 2020 at 09:06, Jacques Le Roux <
> jacques.le.r...@les7arts.com>
> wrote:
>
> > Hi Phoon,
> >
> > You should refer to the README.adoc file. At section "Setup an external
> > database like MySQL, PostgreSQL, etc" it says:
> >
> > To setup an external database instead of the default embedded Apache
> > Derby, you
> > will need to follow the following instructions:
> >
> > 1.  Find the JDBC driver suitable for your database using one of the
> > following
> > options:
> >
> > * Search for the JDBC driver in
> > https://bintray.com/bintray/jcenter[jcenter] and
> > place it in build.gradle dependencies e.g.
> > `runtime 'mysql:mysql-connector-java:5.1.36'`
> > +
> > OR
> > * Download the JDBC driver jar and place it in $OFBIZ_HOME/lib or the lib
> > sub-directory of any component
> >
> > 2.  Modify the entityengine.xml file located in
> > $OFBIZ_HOME/framework/entity/config to switch the default database to the
> > one
> > you selected. For more details you can read the relevant section in the
> >
> >
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide[technical
> 
> > <
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setu

RE: Need help/direction getting started with OFBIZ ERP

[phoonts]

Thanks Joseph,

I'm just asking how you install MariaDB on OFBiz since you did it successfully. 
It would definitely help to speed up and probably lesser problem on my end.

Cheers
Phoon

-Original Message-
From: Joseph Francois  
Sent: Friday, 17 July 2020 3:55 pm
To: user@ofbiz.apache.org
Subject: Re: Need help/direction getting started with OFBIZ ERP

Hell Phoon,

It doesn't matter how you install the DB, just use your Linux distribution 
package management. However, this is an OFBIZ user forum, so we really should 
stick to OFBIZ topics.

Regards,
Joseph

On Fri, 17 Jul 2020 at 05:18, Tuck Seng Phoon 
wrote:

> Hi Joseph,
> Do you have the steps to install MariaDB?
> Thanks
> CheersPhoon
>
> On Friday, July 10, 2020, 04:08:41 PM GMT+8, Joseph Francois < 
> joefranc...@gmail.com> wrote:
>
>  Hello Phoon,
>
> You should follow Jacques' advice. Here are a few gotcha that I faced.
>
> *Mysql configuration*
> I installed the latest MariaDB 10.5 and it worked well. You also can 
> install MySQL, it should work as well. However, make sure that you 
> change MySQL configurations to that utf8 is your default character set 
> as shown in the instructions
>
> mysql.conf
> [client]
> default-character-set=utf8
> [mysql]
> default-character-set=utf8
> [mysqld]
> collation-server = utf8_unicode_ci
> init-connect='SET NAMES utf8'
> character-set-server = utf8
>
>
> After just create the databases and users as required. As an example, 
> I copy-paste from the instruction.
>
> mysql>create database ofbiz;
> mysql>create database ofbizolap;
> mysql>create database ofbiztenant;
> mysql>use mysql;
> mysql>select database();
> mysql>create user ofbiz@localhost;
> mysql>create user ofbizolap@localhost; create user 
> mysql>ofbiztenant@localhost; update user set 
> mysql>password=PASSWORD("ofbiz") where User='ofbiz'; update user set 
> mysql>password=PASSWORD("ofbizolap") where
> User='ofbizolap';
> mysql>update user set password=PASSWORD("ofbiztenant") where
> User='ofbiztenant';
> mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
> 'ofbiz';
> mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified 
> mysql>by
> 'ofbizolap';
> mysql>grant all privileges on *.* to 'ofbiztenant'@localhost 
> mysql>identified by
> 'ofbiztenant';
>
> That would be it for MySQL.
>
> *Gradle configurations*
>
> You need to make sure that you have the right JDBC driver (MySQL in 
> this case). The easiest I found was to just let the Gradle script 
> download it from JCenter, as mention by Jacques.
> - Using your favourite editor (vi, nano, etc..)  open 
> $OFBIZ_HOME/build.gradle
> - Starting from line 164 add the following line (Use the other lines 
> as an example of the syntax).
> runtime 'mysql:mysql-connector-java:5.1.36'
> - So now OFBIZ will be capable of reading and writing data in MySQL.
>
> *OFBIZ configurations*
> Now you need to tell OFBIZ to use MySQL and give the server, database 
> to use and how to authenticate. All this is done in entityengine.xml. 
> *(This is where my knowledge decreases, I will just tell you what I 
> understand.)*
> - The"delegator" records tell what OFBIZ where to look for the 
> configuration to connect to the database. So basically what database 
> to use.  There are 3 delegators you need to change so that they point 
> to your MYSQL records.
>   1. Default
>   2. default-no-eca
>   3. test
> -  Since there are three databases, you will need to have a 
> configuration for each of them. The three databases are:
> 1. ofbiz
> 2. olap
> 3 tenant
> - In practice, you should just modify the records for localmysql/ 
> localmysqlolap/localmysql to have them reflect your MySQL setup. and 
> update the delegators with  localmysql/ localmysqlolap/localmysql 
> respectively.
>
>
> *Conclusion*
> if your ofbiz server has access to the Internet to download the driver 
> and it can connect, authenticate to the database server and the DB 
> exists, all should work as normal.
>
>
> Hope that was of help.
>
> Regards,
> Josep
>
>
> On Fri, 10 Jul 2020 at 09:06, Jacques Le Roux < 
> jacques.le.r...@les7arts.com>
> wrote:
>
> > Hi Phoon,
> >
> > You should refer to the README.adoc file. At section "Setup an 
> > external database like MySQL, PostgreSQL, etc" it says:
> >
> > To setup an external database instead of the default embedded Apache 
> > Derby, you 

Re: Need help/direction getting started with OFBIZ ERP

[Michael Brohl]

Hi Phoon,

see here: https://www.youtube.com/watch?v=Lzmv0DCC5N4

Should be very similar to the MariaDB configuration.

For MariaDB installation: 
https://vitux.com/how-to-install-and-configure-mysql-in-ubuntu-18-04-lts/


hth,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 17.07.20 um 10:22 schrieb phoo...@yahoo.com.INVALID:

Thanks Joseph,

I'm just asking how you install MariaDB on OFBiz since you did it successfully. 
It would definitely help to speed up and probably lesser problem on my end.

Cheers
Phoon

-Original Message-
From: Joseph Francois 
Sent: Friday, 17 July 2020 3:55 pm
To: user@ofbiz.apache.org
Subject: Re: Need help/direction getting started with OFBIZ ERP

Hell Phoon,

It doesn't matter how you install the DB, just use your Linux distribution 
package management. However, this is an OFBIZ user forum, so we really should 
stick to OFBIZ topics.

Regards,
Joseph

On Fri, 17 Jul 2020 at 05:18, Tuck Seng Phoon 
wrote:


Hi Joseph,
Do you have the steps to install MariaDB?
Thanks
CheersPhoon

 On Friday, July 10, 2020, 04:08:41 PM GMT+8, Joseph Francois <
joefranc...@gmail.com> wrote:

  Hello Phoon,

You should follow Jacques' advice. Here are a few gotcha that I faced.

*Mysql configuration*
I installed the latest MariaDB 10.5 and it worked well. You also can
install MySQL, it should work as well. However, make sure that you
change MySQL configurations to that utf8 is your default character set
as shown in the instructions

mysql.conf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8


After just create the databases and users as required. As an example,
I copy-paste from the instruction.

mysql>create database ofbiz;
mysql>create database ofbizolap;
mysql>create database ofbiztenant;
mysql>use mysql;
mysql>select database();
mysql>create user ofbiz@localhost;
mysql>create user ofbizolap@localhost; create user
mysql>ofbiztenant@localhost; update user set
mysql>password=PASSWORD("ofbiz") where User='ofbiz'; update user set
mysql>password=PASSWORD("ofbizolap") where
User='ofbizolap';
mysql>update user set password=PASSWORD("ofbiztenant") where
User='ofbiztenant';
mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
'ofbiz';
mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified
mysql>by
'ofbizolap';
mysql>grant all privileges on *.* to 'ofbiztenant'@localhost
mysql>identified by
'ofbiztenant';

That would be it for MySQL.

*Gradle configurations*

You need to make sure that you have the right JDBC driver (MySQL in
this case). The easiest I found was to just let the Gradle script
download it from JCenter, as mention by Jacques.
- Using your favourite editor (vi, nano, etc..)  open
$OFBIZ_HOME/build.gradle
- Starting from line 164 add the following line (Use the other lines
as an example of the syntax).
 runtime 'mysql:mysql-connector-java:5.1.36'
- So now OFBIZ will be capable of reading and writing data in MySQL.

*OFBIZ configurations*
Now you need to tell OFBIZ to use MySQL and give the server, database
to use and how to authenticate. All this is done in entityengine.xml.
*(This is where my knowledge decreases, I will just tell you what I
understand.)*
- The"delegator" records tell what OFBIZ where to look for the
configuration to connect to the database. So basically what database
to use.  There are 3 delegators you need to change so that they point
to your MYSQL records.
   1. Default
   2. default-no-eca
   3. test
-  Since there are three databases, you will need to have a
configuration for each of them. The three databases are:
 1. ofbiz
 2. olap
 3 tenant
- In practice, you should just modify the records for localmysql/
localmysqlolap/localmysql to have them reflect your MySQL setup. and
update the delegators with  localmysql/ localmysqlolap/localmysql
respectively.


*Conclusion*
if your ofbiz server has access to the Internet to download the driver
and it can connect, authenticate to the database server and the DB
exists, all should work as normal.


Hope that was of help.

Regards,
Josep


On Fri, 10 Jul 2020 at 09:06, Jacques Le Roux <
jacques.le.r...@les7arts.com>
wrote:


Hi Phoon,

You should refer to the README.adoc file. At section "Setup an
external database like MySQL, PostgreSQL, etc" it says:

To setup an external database instead of the default embedded Apache
Derby, you will need to follow the following instructions:

1.  Find the JDBC driver suitable for your database using one of the
following
options:

* Search for the JDBC driver in
https://bintray.com/bintray/jcenter[jcenter] and place it in
build.gradle dependencies e.g.
`runt

Re: Need help/direction getting started with OFBIZ ERP

[Tuck Seng Phoon]

Thank you Michael.
Will check it out.
CheersPhoon

Sent from Yahoo Mail on Android 
 
  On Fri, 17 Jul 2020 at 21:09, Michael Brohl wrote:  
 Hi Phoon,

see here: https://www.youtube.com/watch?v=Lzmv0DCC5N4

Should be very similar to the MariaDB configuration.

For MariaDB installation: 
https://vitux.com/how-to-install-and-configure-mysql-in-ubuntu-18-04-lts/

hth,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 17.07.20 um 10:22 schrieb phoo...@yahoo.com.INVALID:
> Thanks Joseph,
>
> I'm just asking how you install MariaDB on OFBiz since you did it 
> successfully. It would definitely help to speed up and probably lesser 
> problem on my end.
>
> Cheers
> Phoon
>
> -Original Message-
> From: Joseph Francois 
> Sent: Friday, 17 July 2020 3:55 pm
> To: user@ofbiz.apache.org
> Subject: Re: Need help/direction getting started with OFBIZ ERP
>
> Hell Phoon,
>
> It doesn't matter how you install the DB, just use your Linux distribution 
> package management. However, this is an OFBIZ user forum, so we really should 
> stick to OFBIZ topics.
>
> Regards,
> Joseph
>
> On Fri, 17 Jul 2020 at 05:18, Tuck Seng Phoon 
> wrote:
>
>> Hi Joseph,
>> Do you have the steps to install MariaDB?
>> Thanks
>> CheersPhoon
>>
>>      On Friday, July 10, 2020, 04:08:41 PM GMT+8, Joseph Francois <
>> joefranc...@gmail.com> wrote:
>>
>>  Hello Phoon,
>>
>> You should follow Jacques' advice. Here are a few gotcha that I faced.
>>
>> *Mysql configuration*
>> I installed the latest MariaDB 10.5 and it worked well. You also can
>> install MySQL, it should work as well. However, make sure that you
>> change MySQL configurations to that utf8 is your default character set
>> as shown in the instructions
>>
>> mysql.conf
>> [client]
>> default-character-set=utf8
>> [mysql]
>> default-character-set=utf8
>> [mysqld]
>> collation-server = utf8_unicode_ci
>> init-connect='SET NAMES utf8'
>> character-set-server = utf8
>>
>>
>> After just create the databases and users as required. As an example,
>> I copy-paste from the instruction.
>>
>> mysql>create database ofbiz;
>> mysql>create database ofbizolap;
>> mysql>create database ofbiztenant;
>> mysql>use mysql;
>> mysql>select database();
>> mysql>create user ofbiz@localhost;
>> mysql>create user ofbizolap@localhost; create user
>> mysql>ofbiztenant@localhost; update user set
>> mysql>password=PASSWORD("ofbiz") where User='ofbiz'; update user set
>> mysql>password=PASSWORD("ofbizolap") where
>> User='ofbizolap';
>> mysql>update user set password=PASSWORD("ofbiztenant") where
>> User='ofbiztenant';
>> mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
>> 'ofbiz';
>> mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified
>> mysql>by
>> 'ofbizolap';
>> mysql>grant all privileges on *.* to 'ofbiztenant'@localhost
>> mysql>identified by
>> 'ofbiztenant';
>>
>> That would be it for MySQL.
>>
>> *Gradle configurations*
>>
>> You need to make sure that you have the right JDBC driver (MySQL in
>> this case). The easiest I found was to just let the Gradle script
>> download it from JCenter, as mention by Jacques.
>> - Using your favourite editor (vi, nano, etc..)  open
>> $OFBIZ_HOME/build.gradle
>> - Starting from line 164 add the following line (Use the other lines
>> as an example of the syntax).
>>              runtime 'mysql:mysql-connector-java:5.1.36'
>> - So now OFBIZ will be capable of reading and writing data in MySQL.
>>
>> *OFBIZ configurations*
>> Now you need to tell OFBIZ to use MySQL and give the server, database
>> to use and how to authenticate. All this is done in entityengine.xml.
>> *(This is where my knowledge decreases, I will just tell you what I
>> understand.)*
>> - The"delegator" records tell what OFBIZ where to look for the
>> configuration to connect to the database. So basically what database
>> to use.  There are 3 delegators you need to change so that they point
>> to your MYSQL records.
>>        1. Default
>>        2. default-no-eca
>>        3. test
>> -  Since there are three databases, you will need to have a
>> configuration for each of them. The three databases are:
>>      1. ofbiz
>>      2. olap
>>      3 tenant
>> -