Thank you Michael. Will check it out. CheersPhoon Sent from Yahoo Mail on Android On Fri, 17 Jul 2020 at 21:09, Michael Brohl<[email protected]> 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 [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 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 <[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 >>>>
