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 [email protected]:
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 <[email protected]> Sent: Friday, 17 July 2020 3:55 pm To: [email protected] 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 <[email protected]> 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 < [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; 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 < [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 thehttps://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%5Btechnicalsetup 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 MySQLdatabase. 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 toinstances>against an external MySQL database. I also played around and createda>plugin suing the Getting Started guide.> Along the way, I am documenting all my steps so that later on, I canshare>my experience with the community for newbies like myself.> Now I am at the point to start where I want to start putting in dataand>setup the System for my company. However, I am having some problemgetting>started, from setting up a COA, Bank and credit card accounts, MainCompany,>etc.. I am not sure how things hands together. All documents I foundsofar>are incomplete, and some are outdated. > As I said, I am documenting everything I do, to put together acomplete>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
Description: S/MIME Cryptographic Signature
