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 <phoo...@yahoo.com.invalid>
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+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 <j...@gmail.com> 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
> > >
> >
