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