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, <[email protected]> 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 <[email protected]> > Sent: Monday, 13 July 2020 9:09 pm > To: [email protected] > 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 <[email protected]> > 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 < > > [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 > > > > > > > > >
