OFBiz › OFBiz - User

Re: Need help/direction getting started with OFBIZ ERP

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

13 messages Options

Tuck Seng Phoon

Re: Need help/direction getting started with OFBIZ ERP

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 <[hidden email]> 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

Jacques Le Roux

Re: Need help/direction getting started with OFBIZ ERP

Administrator

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 <[hidden email]> 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
>

joefrancois

Re: Need help/direction getting started with OFBIZ ERP

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 <[hidden email]>
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+Setup+Guide%5Btechnical>
> 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 <[hidden email]> 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
> >
>

Tuck Seng Phoon

Re: Need help/direction getting started with OFBIZ ERP

In reply to this post by Jacques Le Roux

Thank you so much Jacques 😊
CheersPhoon

On Friday, July 10, 2020, 03:06:34 PM GMT+8, Jacques Le Roux <[hidden email]> 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 :

Tuck Seng Phoon

Re: Need help/direction getting started with OFBIZ ERP

In reply to this post by joefrancois

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 <[hidden email]> 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 <[hidden email]>
wrote:

joefrancois

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 <[hidden email]>
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 <
> [hidden email]> 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 <
> [hidden email]>
> 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+Setup+Guide%5Btechnical>
> > <
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide%5Btechnical
> >
> > 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 <[hidden email]> 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
> > >
> >

Tuck Seng Phoon

RE: Need help/direction getting started with OFBIZ ERP

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 <[hidden email]>
Sent: Monday, 13 July 2020 9:09 pm
To: [hidden email]
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 <[hidden email]>
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 <
> [hidden email]> 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 <
> [hidden email]>
> 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+Technic
> al+Production+Setup+Guide[technical
> <https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Techni
> cal+Production+Setup+Guide%5Btechnical>
> > <
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technic
> al+Production+Setup+Guide%5Btechnical
> >
> > 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 <[hidden email]> 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
> > >
> >

joefrancois

Re: Need help/direction getting started with OFBIZ ERP

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, <[hidden email]> 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 <[hidden email]>
> Sent: Monday, 13 July 2020 9:09 pm
> To: [hidden email]
> 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 <[hidden email]>
> 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 <
> > [hidden email]> 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 <
> > [hidden email]>
> > 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+Technic
> > al+Production+Setup+Guide[technical
> > <https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Techni
> > cal+Production+Setup+Guide%5Btechnical>
> > > <
> > https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technic
> > al+Production+Setup+Guide%5Btechnical
> > >
> > > 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 <[hidden email]> 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
> > > >
> > >
>
>

Tuck Seng Phoon

Re: Need help/direction getting started with OFBIZ ERP

In reply to this post by joefrancois

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 <[hidden email]> 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 <[hidden email]>
wrote:

joefrancois

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 <[hidden email]>
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 <
> [hidden email]> 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 <
> [hidden email]>
> 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+Setup+Guide%5Btechnical>
> > <
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide%5Btechnical
> >
> > 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 <[hidden email]> 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
> > >
> >

Tuck Seng Phoon

RE: Need help/direction getting started with OFBIZ ERP

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 <[hidden email]>
Sent: Friday, 17 July 2020 3:55 pm
To: [hidden email]
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 <[hidden email]>
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 <
> [hidden email]> 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 <
> [hidden email]>
> 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+Technic
> al+Production+Setup+Guide[technical
> <https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Techni
> cal+Production+Setup+Guide%5Btechnical>
> > <
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technic
> al+Production+Setup+Guide%5Btechnical
> >
> > 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 <[hidden email]> 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
> > >
> >

Michael Brohl-3

Re: Need help/direction getting started with OFBIZ ERP

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 [hidden email]:

> 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 <[hidden email]>
> Sent: Friday, 17 July 2020 3:55 pm
> To: [hidden email]
> 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 <[hidden email]>
> 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 <
>> [hidden email]> 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 <
>> [hidden email]>
>> 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+Technic
>> al+Production+Setup+Guide[technical
>> <https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Techni
>> cal+Production+Setup+Guide%5Btechnical>
>>> <
>> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technic
>> al+Production+Setup+Guide%5Btechnical
>>> 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 <[hidden email]> 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
>>>>

smime.p7s (5K) Download Attachment

Tuck Seng Phoon

Re: Need help/direction getting started with OFBIZ ERP

Thank you Michael.
Will check it out.
CheersPhoon

Sent from Yahoo Mail on Android

On Fri, 17 Jul 2020 at 21:09, Michael Brohl<[hidden email]> 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 [hidden email]: